Master Budget Model

This fully automated Spreadsheet Application calculates 9 pro-forma budgets:

• Sales Budget

• Production Budget

• Direct Material Purchase Budget

• Direct Labor Budget

• Overhead Budget

• Ending Finished Goods Inventory Budget

• Cost of Goods Sold Budget

• Selling & Administrative Expenses Budget

• Pro-forma Budgeted Income Statement

Spreadsheet contains two, “Enter Model Parameters” and “Master Budget” Tabs. Just enter few inputs (like: expected first period unit sales; unit price, expected percentage growth/decline in unit sales per period, expected sales price inflation/deflation per period, etc.) on the first Tab and see how the whole “story” unfolds on the second Tab.

This model is a STRONG Planning, Forecasting, and Scenario Analysis Tool.

The model can project next 12 periods, where period length can be set to equal: 1 Year, 6 Months, 1 Quarter, 1 Month, & 1 Week.

***NOTE: xlsx format requires MS Office 2007!