Master Budget
The comprehensive budget system.
Why This Matters
A single budget line is useless in isolation. Knowing that ABC Coffee Shop plans to sell 92,750 cups next year doesn't tell you whether the shop can afford the staffing to deliver them, whether it will generate enough cash to pay rent in January, or whether equipment needs to be replaced.
The master budget is the integrated system that connects every operational and financial piece of the plan into one coherent picture. It starts with sales, flows through production and operations, builds to financial statements, and ends with a cash budget that confirms whether the plan is executable.
The master budget is not a document — it is a system. Every component informs and constrains every other component. Change the sales forecast and the production plan changes, the labor budget changes, the cash budget changes, and the projected income statement and balance sheet change. It is the financial DNA of the business plan.
The Master Budget Structure
The master budget has two major components — operating budgets that build to the income statement, and financial budgets that prove cash feasibility and project the balance sheet:
MASTER BUDGET — TWO MAJOR COMPONENTS
OPERATING BUDGETS
Revenue and cost plan — builds to projected income statement
Sales Budget → Production Budget
→ DM Budget + DL Budget + MOH Budget + SG&A Budget
→ Budgeted Income Statement (COGM + COGS → Net Income)
↓
FINANCIAL BUDGETS
Cash and balance sheet — proves plan is executable
Capital Expenditure Budget → Cash Budget → Budgeted Balance Sheet
The flow is strictly top-down: the Sales Budget is always the starting point. Every downstream budget depends on it.
1. Sales Budget
The foundation of the entire master budget:
SALES BUDGET — ABC COFFEE SHOP (2027)
Goal: 15% revenue growth from 2026 ($170,000 → $195,500)
| Q1 | Q2 | Q3 | Q4 | Annual | |
|---|---|---|---|---|---|
| Units | 20,000 | 25,000 | 27,000 | 20,750 | 92,750 |
| Price | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 |
| Revenue | $40,000 | $50,000 | $54,000 | $41,500 | $185,500 |
2. Production Budget
How many units to produce, considering desired ending inventory:
PRODUCTION BUDGET — ABC COFFEE SHOP
Units to sell (from Sales Budget): 92,750
+ Desired ending inventory: 2,000
= Total units needed: 94,750
− Beginning inventory: (1,500)
= Units to produce: 93,250
Production Budget Calculator
92,750 + 2,000 − 1,500 = 93,250 units to produce
3–5. Direct Materials, Labor & Overhead Budgets
DM BUDGET
Units to produce: 93,250
× DM per unit: $0.79
= DM for production: $73,668
+ Desired ending RM: $4,000
− Beginning RM: ($3,500)
Purchases: $74,168
DL BUDGET
Units to produce: 93,250
× 0.025 hrs/unit
= 2,331 DL hours
× $9.20/hr
Total DL: $21,445
MOH BUDGET
Variable: 93,250 × $0.033
= $3,077
Fixed: Rent $12,800
Depreciation $2,000
Manager $18,000
Insurance $1,500
Total MOH: $37,377
Cash MOH: $35,377 (excl. depreciation)
6. SG&A Budget
SG&A BUDGET — ABC COFFEE SHOP
Variable: 92,750 units × $0.10 = $9,275
Fixed: Office/admin $7,200 · Marketing $8,500 · Misc. $3,400
Total Fixed: $19,100
Total SG&A: $28,375
7. Budgeted Income Statement
All operating budgets combine into the projected income statement:
ABC COFFEE SHOP — BUDGETED INCOME STATEMENT (2027)
Revenue: $185,500
Cost of Goods Sold: ($138,030)
Gross Profit: $47,470
SG&A Expenses: ($28,375)
Operating Income: $19,095
Interest Expense: ($1,200)
Income Tax (20%): ($3,579)
Budgeted Net Income: $14,316
COGS = DM + DL + MOH per unit sold × units sold. ($0.79 + $0.23 + $0.40) × 92,750 ≈ $1.42/unit, adjusted for inventory changes.
Financial Budgets
Capital Expenditure Budget
CAP EX BUDGET — ABC COFFEE SHOP (2027)
New espresso machine: $4,800 (Q1)
Display refrigerator: $2,200 (Q3)
Total CapEx: $7,000
Cash Budget
The cash budget takes all the above information and projects actual cash inflows and outflows, revealing whether the plan produces positive cash flow or requires financing.
Budgeted Balance Sheet
BUDGETED BALANCE SHEET — DEC 31, 2027
ASSETS
Cash: $18,200
Accounts Receivable: $8,500
Inventory (RM + FG): $5,500
Equipment (net): $23,600
Total Assets: $55,800
LIABILITIES + EQUITY
Accounts Payable: $4,200
Current portion of debt: $2,400
Total Liabilities: $6,600
Beginning equity: $36,500
+ Net Income: $14,316
− Owner draws: ($1,616)
Ending equity: $49,200
Total L + E: $55,800 ✓
How the Master Budget Integrates
The master budget's power is in integration: each budget feeds the next. A change to any one input ripples through the entire system.
THE INTEGRATION CHAIN
Sales Budget (92,750 units) →
Production Budget (93,250 units) →
DM Budget ($74,168) → Cash Budget → Balance Sheet (AP)
DL Budget ($21,445) → Cash Budget (payroll)
MOH Budget ($37,377) → COGM → Income Statement (COGS)
SG&A Budget ($28,375) → Cash + Income Statement
CapEx Budget ($7,000) → Cash Budget + Balance Sheet (equipment)
If sales fall 10%: production, materials, labor, cash, and income all shrink. If material costs rise 8%: DM, COGS, margin, and cash outflows all increase.
Interactive Tool
Explore the master budget dependency chain — click each component to reveal its role and what it feeds into.
Master Budget Dependency Explorer
Click each component to reveal its role in the integrated budget system. ABC Coffee Shop 2027 values shown. Trace how Sales flows through Production → DM/DL/MOH → Income Statement → Cash → Balance Sheet.
Operating Budgets
Financial Budgets
Sales Budget
ABC 2027: 92,750 units · $185,500 revenue
The foundation of the entire master budget. Sets expected units, price, and revenue by period. Every downstream budget depends on this forecast.
Feeds Into
INTEGRATION CHAIN
Sales (92,750) → Production (93,250) → DM ($74,168) + DL ($21,445) + MOH ($37,377) → Income Stmt ($14,316 NI) → Cash Budget → Balance Sheet ($55,800)
Change any input — the entire chain recalculates.
Budgeting Module Series
The master budget connects every departmental plan. Next: dive into the Sales Budget — the starting point that drives the entire system.
| Module | Core Concept | # |
|---|---|---|
| Budgeting Basics | Why and how companies budget | #88 |
| Master Budget | The comprehensive budget system | #89 |
| Sales Budget | The starting point for all budgets | #90 |
| Cash Budget | Projecting cash inflows and outflows | #91 |
Common Mistakes
Mistake 1: Building Budgets in Isolation
❌ Wrong
Sales sets its budget independently; operations plans production without knowing the sales forecast; finance builds cash from last year's patterns.
✅ Right
All budgets must link. Start with the Sales Budget. Every other budget is derived from it.
Mistake 2: Treating the Budget as a Contract, Not a Plan
❌ Wrong
Budget approved in December; by March the market has changed — but everyone still reports against the original budget without update.
✅ Right
Supplement the annual budget with rolling forecasts. Use flexible budgets for operational variance analysis.
Key Takeaway
The master budget is the complete, integrated financial plan of an organization. It begins with the Sales Budget and flows through production, materials, labor, overhead, and SG&A budgets into a Budgeted Income Statement, then continues to a Capital Expenditure Budget and Cash Budget, culminating in a Budgeted Balance Sheet. Every budget is linked — a change in any one propagates through the entire system. The master budget's value is in forcing coordination across departments, surfacing financial constraints before they become crises, and creating the benchmarks needed for meaningful variance analysis.
Test Your Understanding
Sales budget sequencing, production budget formula — check your answers below.
Question 1: In the master budget, which budget is always prepared first?
Question 2: Units to sell = 50,000. Desired ending inventory = 3,000. Beginning inventory = 2,000. How many units must be produced?
Ready to Practice?
Build integrated master budgets, trace dependencies from sales to balance sheet, and explore production budget calculations in the Practice Lab.
Try the Practice LabWhat's Next?
Sales Budget — A deep dive into the starting point of the master budget: how to build a credible revenue forecast, handle seasonality, and translate sales assumptions into volume and dollar projections.