Course description

Master budget construction, including demonstration problems, excel worksheets, practice test questions, discussion questions, and a comprehensive problem we work together using Excel in a step by step format.

The course will provide a managerial accounting overview, comparing managerial accounting and financial accounting, and providing essential managerial accounting tools we will need in the budgeting process.

We will discuss methods of budget timing and the pros and cons of each technique.

The course will discuss the characteristics and functions of the budget committee.

We will discuss the components of a master budget and break it out into its parts, listing the order that those components need to be completed in.

The course will discuss how to put together a sales budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a production budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a materials budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a direct labor budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a factory overhead budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a general and administrative budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a cash budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a budgeted cost of goods manufactured statement and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a budgeted cost of goods sold statement and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a budgeted income statement and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a budgeted balance sheet and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will also go over a comprehensive problem in Excel so we can see all the components of the master budget and work through them in one place.


Who this course is for:
  • Accounting students
  • Business owners
  • Anyone who whats to learn accounting


Requirements:

  • An understanding of basic accounting terms


What you'll learn:

  • Managerial accounting concepts
  • Budget timing methods
  • Characteristics and tasks of the budget committee
  • Order of operations for a master budget
  • How to construct a sales budget
  • How to build a production budget
  • How to make a materials budget
  • How to construct a direct labor budget
  • How to build a factory overhead budget
  • How to make a general and administrative budget
  • How to put together a cash budget
  • How to constructed a budgeted cost of goods manufactured statement
  • How to build a cost of goods sold budget
  • How to make a budgeted income statement
  • How to make a budgeted balance sheet

Course curriculum

  • 1
    Introduction
  • 2
    Managerial Accounting Overview
    • 2 Managerial Accounting Overview
    • 10 Managerial Accounting Introduction
    • 10 Managerial Accounting Introduction
    • 20 Cost Classifications
    • 20 Cost Classifications
    • 30 Product Costs & Period Costs
    • 30 Product Costs & Period Costs.ENCODING
    • 40 Direct Meterails Labor & Overhead
    • 40 Prime Costs & Conversion Costs
    • 50 Manufacturer's Balance Sheet
    • 50 Manufacturer's Balance Sheet
    • 60 Manufacturer's Income Statement
    • 60 Manufacturer's Income Statement
    • 70 Manufacturing Activities Flow
    • 70 Manufacturing Activities Flow
    • 80 Just In Time (JIT) Manufacturing
    • 80 Just In Time (JIT) Manufacturing
    • 90 Job Cost vs Process Cost
    • 90 Job Cost Vs Process Cost
    • Multiple choice 3
    • Accounting Comic
  • 3
    Budget Timing and Budget Committee
    • 3 Budget Timing and Budget Committee
    • 115 Budget Timing
    • 115 Budget Timing
    • 120 Budget Committee
    • 120 Budget Committee
    • Multiple choice 4
    • Accounting Comic
  • 4
    Sales Budget, Production Budget, & Materials Budget
    • 4 Sales Budget, Production Budget, & Materials Budget
    • 210 Master budget Sales, Production & Raw materials
    • 210 Master Budged Sales Budget, Production Budget, & Materials Budget
    • Excel Download
    • Worksheet - 210 Sales Budget, Production Budget, & Materials Budget
    • Excel Download
    • Worksheet - 210 Sales Budget, Production Budget, & Materials Budget
    • Multiple choice 5
    • Accounting Comic
  • 5
    Direct Labor, Factory Overhead, Selling, & General and Administrative Budgets
    • 5 Direct Labor, Factory Overhead, Selling, & General and Administrative Budgets
    • 220 Master budget - Direct Labor, Factory OH, Selling, G&A
    • 220 Master Budged 2 Direct Labor, Factory Overhead, Selling, General and Administrative
    • Excel Download
    • Worksheet - 220 Direct Labor & Factory Overhead
    • Excel Download
    • Worksheet - 225 Selling & Administrative Budget
    • Multiple choice 6
    • Accounting Comic
  • 6
    Cash Budget
    • 6 Cash Budget
    • 230 Master budget - Cash Budget
    • 230 Master Budged 3 Cash Budget
    • Excel Download
    • 230 Master budget, Cash Budget part 5
    • Multiple choice 7
    • Accounting Comic
  • 7
    Budgeted Cost of Goods Manufactured & Cost of Goods Sold
    • 7 Budgeted Cost of Goods Manufactured & Cost of Goods Sold
    • 240 Master budget - Cost of Goods Manufactured
    • 240 Master Budged 4 Budgeted Cost of Goods Manufactured & Cost of Goods Sold
    • Excel Download
    • Worksheet - 240 Budgeted Cost of Goods Manufactured & Cost of Goods Sold
    • Multiple choice 8
    • Accounting Comic
  • 8
    Budgeted Income Statement
    • 8 Budgeted Income Statement
    • 250 Master budget - Income Statement
    • 250 Master Budged 5 Budgeted Income Statement
    • Excel Download
    • Multiple choice 9
    • Accounting Comic
  • 9
    Budgeted Balance Sheet
    • 9 Budgeted Balance Sheet
    • 260 Master budget - Balance Sheet
    • 260 Master Budget 6 Budgeted Balance Sheet
    • Excel Download
    • Worksheet - 260 Budgeted Balance Sheet
    • Multiple choice 10
    • Accounting Comic
  • 10
    Verify The Budget
    • 10 Verify The Budget
    • Excel Download
    • Worksheet - 270 Verify The Budget
    • Excel Download
    • Multiple choice 11
    • Short Calculation Problems
    • Accounting Comic
  • 11
    Comprehensive Problem
    • 11 Comprehensive Problem
    • 210 Sales Budget, Production Budget, & Materials Budget
    • 215 Materials Budget
    • 220 Direct Labor & Factory Overhead
    • 225 Selling & Administrative Budget
    • 230 Master budget, Cash Budget part 5
    • 240 Budgeted Cost of Goods Manufactured & Cost of Goods Sold
    • 250 Budgeted Income Statement
    • 260 Budgeted Balance Sheet
    • 270 Verify The Budgets
    • Multiple choice 12
    • Accounting Comic

Meet your instructor!

Robert (Bob) Steele
CPA, CGMA, M.S. Tax, CPI


Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.  

Mr. Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curriculum since 2009. He has been a practicing CPA since 2005. Mr. Steele is a practicing CPA, has a Certified Post-Secondary Instructor (CPI) credential, a Master of Science in taxation from Golden Gate University, a Bachelor’s Degree in Business Economics with an emphasis in accounting from The University of California Santa Barbara, and a Global Management Accounting Designation (CGMA) from The American Institute of CPA (AICPA).  

Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.  

In addition to working as an accountant, teaching, and developing courses Mr. Steele has helped create an accounting website at accountinginstruction, a YouTube channel called Accounting Instruction, Help, and How Too, and has developed supplemental resources including a Facebook Page, Twitter Page, and Podcasts that can be found on I-tunes, Stitcher, or Soundcloud. Mr. Steele's teaching philosophy is to make content applicable, understandable, and accessible.  

Adult learners are looking for application when they learn new skills. In other words, learners want to be able to apply skills in the real world to help their lives. Mr. Steele’s formal accounting education, practical work experience, and substantial teaching experience allow him to create a curriculum that combines traditional accounting education with practical knowledge and application. He accomplishes the goals of making accounting useful and applicable by combining theory with real-world software like Excel and QuickBooks.  

Many courses teach QuickBooks data entry or Excel functions but are not providing the real value learners want. Real value is a result of learning technical skills like applications, in conjunction with specific goals, like accounting goals, including being able to interpret the performance of a business.  

Mr. Steele makes knowledge understandable by breaking down complex concepts into smaller units with specific objectives and using step by step learning processes to understand each unit. Many accounting textbooks cram way too much information into a course, making it impossible to understand any unit fully. By breaking the content down into digestible chunks, we can move forward much faster.  

Mr. Steele also makes use of color association in both presentations and Excel worksheets, a learning tool often overlooked in the accounting field, but one that can vastly improve the speed and comprehension of learning accounting concepts.  

The material is also made understandable through the application of concepts learned. Courses will typically demonstrate the accounting concepts and then provide an Excel worksheet or practice problems to work through the concepts covered. The practice problems will be accompanied by an instructional video to work through the problem in step by step format. Excel worksheets will be preformatted, usually including an answer tab that shows the completed problem, and a practice tab where learners can complete the problem along with a step by step presentation video.

Take this course today!

"Master Budgets – Managerial Accounting/Cost Accounting"

Bundle including this course!