The Master Budget: A Complete Guide From Sales Forecast to Pro Forma Financial Statements
The master budget is the cornerstone of business planning and control. It integrates every department's plans — from sales to production to cash management — into a single coordinated financial model that shows where the business is headed and what resources it needs to get there. Understanding how to build a master budget and how all its components connect is essential for managerial accounting students and for anyone who will work in finance, operations, or general management.
What the Master Budget Is
The master budget is a comprehensive set of financial plans for a coming period — typically one year, often broken into quarters or months. It consists of two major components: the operating budget (which plans revenues and operating costs, culminating in a budgeted income statement) and the financial budget (which plans cash flows, financing needs, and capital investments, culminating in a budgeted balance sheet and cash budget). Together they form a complete financial roadmap for the organisation.
The master budget serves multiple purposes: it forces managers to think ahead and identify resource requirements; it provides benchmarks for performance evaluation (actual vs budget variance analysis — see the variance analysis guide); it helps identify periods of cash surplus or shortfall in advance; and it coordinates the activities of all departments by making explicit how their plans interact.
We will build a simplified master budget for Lakewood Products, a manufacturer of a single product. All data is quarterly.
Step 1: Sales Budget
Everything starts with the sales forecast — the most critical and most uncertain input to the entire budget. All subsequent budgets depend on expected sales volume. The sales budget shows expected units and revenue.
| Q1 | Q2 | Q3 | Q4 | Year | |
|---|---|---|---|---|---|
| Budgeted unit sales | 5,000 | 6,000 | 7,500 | 6,500 | 25,000 |
| Selling price per unit | $80 | $80 | $80 | $80 | |
| Total sales revenue | $400K | $480K | $600K | $520K | $2,000K |
Step 2: Production Budget
The production budget determines how many units must be produced, accounting for desired ending inventory levels and the beginning inventory already on hand.
Lakewood policy: ending inventory = 20% of next quarter's sales. Q1 beginning inventory: 800 units.
| Q1 | Q2 | Q3 | Q4 | |
|---|---|---|---|---|
| Budgeted sales | 5,000 | 6,000 | 7,500 | 6,500 |
| + Desired ending inventory (20% of next Q sales) | 1,200 | 1,500 | 1,300 | 1,000* |
| − Beginning inventory | (800) | (1,200) | (1,500) | (1,300) |
| Units to produce | 5,400 | 6,300 | 7,300 | 6,200 |
Step 3: Direct Materials Budget
Given production requirements, the direct materials budget determines how much material must be purchased. Material policy: ending raw material inventory = 10% of next quarter's production needs. Each unit requires 3 kg of material at $4/kg.
| Production (units) | 5,400 |
| × Materials per unit (kg) | 3 |
| = Materials needed for production | 16,200 kg |
| + Desired ending raw materials (10% × Q2 needs: 6,300 × 3 = 18,900 → 10%) | 1,890 kg |
| − Beginning raw materials inventory | (1,620 kg) |
| Materials to purchase | 16,470 kg × $4 = $65,880 |
Step 4: Direct Labour Budget
Each unit requires 0.5 hours of direct labour at $18/hour.
| Units to produce | 5,400 |
| × DL hours per unit | 0.5 |
| = Total DL hours | 2,700 |
| DL cost (× $18) | $48,600 |
Step 5: Manufacturing Overhead Budget
Overhead is typically separated into variable (varies with production) and fixed (constant). Variable overhead: $6 per DL hour. Fixed overhead: $30,000 per quarter (includes depreciation of $8,000, which is non-cash).
Fixed: $30,000
Total overhead: $46,200
Cash overhead (for cash budget): $46,200 − $8,000 depreciation = $38,200
Step 6: Cost of Goods Sold Budget
Calculate the budgeted unit cost, then multiply by budgeted sales units.
Direct labour: 0.5 hrs × $18 = $9
Variable overhead: 0.5 hrs × $6 = $3
Fixed overhead per unit: $30,000 ÷ 5,400 (Q1 production) = $5.56
Total absorption cost per unit = $29.56
Step 7: Selling and Administrative Expense Budget
Variable S&A: $5 per unit sold. Fixed S&A: $25,000 per quarter (includes $3,000 depreciation). Q1: 5,000 units × $5 + $25,000 = $50,000 total; $47,000 cash.
Step 8: Cash Budget
The cash budget is arguably the most critical financial budget component — it shows whether the company will have enough cash to operate each period. It integrates all cash inflows (from the sales budget, adjusted for collection timing) and cash outflows (from all the operating budgets above, adjusted for payment timing), then shows the ending cash balance and any financing needed.
Lakewood collects 60% of sales in the quarter of sale and 40% in the following quarter. Q4 prior year AR outstanding: $80,000. All operating costs are paid in the quarter incurred except materials (paid 50% current quarter, 50% next quarter).
| Item | Amount |
|---|---|
| Collections from Q1 sales (60% × $400K) | $240,000 |
| Collections from prior year AR | $80,000 |
| Total cash receipts | $320,000 |
| Materials paid (50% of Q1 purchases) | ($32,940) |
| Direct labour paid | ($48,600) |
| Cash overhead paid | ($38,200) |
| Cash S&A paid | ($47,000) |
| Net cash from operations | $153,260 |
Step 9: Pro Forma Financial Statements
The operating and financial budgets culminate in pro forma (budgeted) financial statements: the budgeted income statement (revenue minus all operating costs), the budgeted balance sheet (opening balances adjusted for all budgeted transactions), and the budgeted cash flow statement (a summary of the cash budget). These pro forma statements allow management to see the projected financial position and performance before the period begins, identify problems early, and make adjustments.
Comparing actual results to these budgeted figures at the end of each period is the basis of variance analysis — the control phase of the planning-control cycle.
Master the Master Budget With Practice Questions
Budgeting problems are common in managerial accounting exams and on the BAR section of the CPA exam. PrepQBank's adaptive questions cover individual budget components and full integrated master budget scenarios. Upgrade for unlimited access.