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.

What will you learn in this course?

• Managerial accounting overview
• Comparing managerial accounting
• Financial accounting
• Providing essential managerial accounting tools we will need in the budgeting process.
• Methods of budget timing and the pros and cons of each technique.
• Characteristics and functions of the budget committee.
• Components of a master budget and break it out into its parts, listing the order that those components need to be completed.
• How to put together a sales budget
• Step by step process using preformatted Excel worksheets for learners to follow along with.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.