
Managerial Accounting — Master Budgets and Flexible Budgets: From the Sales Budget to the Cash Budget

A budget turns the business plan into numbers. It works out in advance how much will be sold next year, how much must be made to do so, how much material must be bought and when cash will run short. A budget is a planning tool and also the benchmark for performance evaluation, compared later with actual results. Variance analysis was covered in Cost Accounting chapter 10.
1. The structure of the master budget
A master budget links several budgets like a chain. The starting point is always the sales budget, because the quantity to be made depends on the quantity to be sold.
| Step | Budget | Main inputs |
|---|---|---|
| 1 | Sales budget | Expected sales volume × selling price |
| 2 | Production budget | Sales volume + desired closing finished goods − opening finished goods |
| 3 | Raw materials purchases, labor and overhead budgets | Production × requirement per unit |
| 4 | Cost of sales and selling and administrative budgets | Product costs, selling-related costs |
| 5 | Cash budget | Timing of cash inflows and outflows from the budgets above |
| 6 | Budgeted financial statements | Budgeted income statement and statement of financial position |
2. The sales and production budgets
Company BP expects to sell 1,000 units in Q1, 1,200 in Q2 and 1,500 in Q3. The selling price is ₩100,000 per unit. Finished goods at each quarter-end are kept at 20% of the next quarter’s sales, and finished goods at the start of Q1 are 200 units.
3. The raw materials purchases budget
Each unit needs 2 kg of raw materials at ₩10,000 per kg. Raw materials at each quarter-end are kept at 10% of the next quarter’s production requirement, and raw materials at the start of Q1 are 200 kg.
| Item | Q1 | Q2 |
|---|---|---|
| Production requirement (production × 2 kg) | 2,080 kg | 2,520 kg |
| Desired closing raw materials | 252 kg (10% of Q2 requirement) | Set from Q3 production |
| Opening raw materials | (200 kg) | (252 kg) |
| Quantity purchased | 2,132 kg | — |
| Purchase cost (₩10,000 per kg) | ₩21.32 million | — |
4. The cash budget
The cash budget looks at the timing of cash, not profit. BP collects 60% of sales in the quarter of sale and 40% in the next quarter. Collections in Q1 of the previous year’s Q4 receivables are ₩35 million. Raw materials are paid 50% in the quarter of purchase and 50% in the next, and ₩10 million is still owed for the previous Q4’s purchases. Q1 cash payments for wages and expenses are ₩45 million, opening cash is ₩5 million and the minimum cash balance is ₩10 million.
| Item | Calculation | Amount |
|---|---|---|
| Opening cash | 500 | |
| Collections: current-quarter sales | 10,000 × 60% | 6,000 |
| Collections: prior-quarter sales | 3,500 | |
| Materials payments: current-quarter purchases | 2,132 × 50% | (1,066) |
| Materials payments: prior-quarter purchases | (1,000) | |
| Wages and expenses | (4,500) | |
| Closing cash before borrowing | 3,434 | |
| Excess over minimum cash balance | 3,434 − 1,000 | 2,434 |
In Q1 there is a surplus and no borrowing is needed. In the quarter just before sales rise, such as Q3, production and material purchases increase first and cash flows out ahead of collections, so even a profitable company may need short-term borrowing. The cash budget shows this timing in advance.
5. Static and flexible budgets
A static budget is prepared for one planned level of activity. A flexible budget recalculates the cost budget for the actual level of activity. If Q1 planned 1,000 units but 1,100 were actually sold, it is natural that variable costs exceed plan. When evaluating performance, compare with a flexible budget for 1,100 units to separate the volume effect from the effect of cost control.
6. Budgeting approaches and behavior
- Incremental budgeting: adds a percentage to last year’s budget. Simple, but inefficiencies carry forward.
- Zero-based budgeting: justifies every activity again from zero. Thorough, but time-consuming.
- Rolling budget: adds a new quarter each time one ends, so it always looks 12 months ahead.
- Participative budgeting: staff take part in preparing the budget. Acceptance is high, but slack creeps in easily.
Check your understanding
Company BQ expects to sell 2,000 units in April, 2,500 in May and 3,000 in June. Finished goods at each month-end are kept at 30% of next month’s sales, and inventory at the start of April is 500 units. What is production in April and May? If 70% of sales are collected in the month of sale and 30% the following month, and the selling price is ₩40,000 per unit, what are May’s collections?
April production is units and May production units. May collections are 70% of May’s ₩100 million of sales, ₩70 million, plus 30% of April’s ₩80 million, ₩24 million: ₩94 million in total.
References
- Charles Horngren, Srikant Datar and Madhav Rajan, Cost Accounting: A Managerial Emphasis, ch. 6
- Ray Garrison, Eric Noreen and Peter Brewer, Managerial Accounting, ch. 8
- Jeremy Hope and Robin Fraser, Beyond Budgeting
Oiyo
Editorial DeskThe OIYO editorial desk researches money, law, lifestyle, and self-understanding topics against primary sources and public statistics. Every piece carries source notes and is reviewed on a regular cycle for accuracy and usefulness.