Accounting › Section T · Budgeting › Topic T.4
Flexible budgets
A budget built for 10,000 units says little about costs when 12,000 units were made. A flexible budget restates revenue and costs for whatever activity level actually happens, so managers can plan for a range of outcomes and judge results fairly.
When activity differs from the plan
The master budget is prepared for one expected level of sales and production. Actual activity rarely matches it. If a factory makes 20% more units than planned, its materials and labour costs should also be higher, and comparing them with the original budget would make a busy, successful month look like overspending. If it makes fewer units, costs will look pleasingly low even if they were badly controlled. Managers need a budget that moves with activity, so that costs are judged against what they should have been at the level actually reached.
Static and flexible budgets
A static budget is prepared for a single planned level of activity; the master budget and its schedules are static. A flexible budget restates revenue and costs for other levels of activity, using what is known about how each item behaves. It is used in two ways. Before the period, it shows management a range of possible outcomes, such as low, expected and high volume. After the period, it is prepared for the actual level of activity, so that actual results can be compared with the costs that level should have produced. "Using budgets to evaluate goals" builds that comparison into a full performance report.
The cost formula
Each item in a flexible budget gets a formula:
where \(a\) is the fixed cost per period, \(b\) is the variable cost per unit of activity and \(x\) is the activity level. Revenue is price times units. Fixed costs stay the same at every level; variable costs move in proportion; mixed costs are first split into fixed and variable parts, as in "Estimating a cost equation". The formulas hold only within the relevant range, the band of activity over which the cost behaviour is expected to stay the same.
Quenby Ceramics' cost behaviour
Quenby Ceramics makes and sells stoneware mugs. Its static budget for March 2027 is 10,000 mugs at $14 each. Per mug, it budgets direct materials of $2.50, direct labour of $3.00, variable overhead of $1.00 and shipping and commissions of $0.50, a variable cost of $7.00. Fixed costs each month are $22,000 of manufacturing overhead and $18,000 of selling and administrative costs, $40,000 in all. At the static level, revenue is $140,000, variable costs $70,000 and operating income \(140{,}000 - 70{,}000 - 40{,}000 = 30{,}000\). Quenby makes to order, so units made equal units sold.
Worked example: three activity levels
Prepare Quenby's flexible budget at 8,000, 10,000 and 12,000 mugs. 1. Revenue: \(14 \times 8{,}000 = 112{,}000\), then 140,000 and 168,000. 2. Variable costs: \(7 \times 8{,}000 = 56{,}000\), then 70,000 and 84,000. 3. Fixed costs: 40,000 at every level. 4. Total costs and operating income:
5. Check: each extra 2,000 mugs adds \(2{,}000 \times 7 = 14{,}000\) of contribution margin, the $7 per mug from "Contribution margin", and operating income rises by exactly that amount.
Planning with a flexible budget
Before the month starts, the three columns show managers what to expect if demand is weak or strong. At 8,000 mugs income falls to $16,000, which tells them how much room there is before a loss: with $40,000 of fixed costs and $7 of contribution per mug, income stays positive from 5,715 mugs upwards (\(40{,}000 \div 7 \approx 5{,}714.3\)), as "The break-even point" explains. The same layout can test other changes, such as a lower price or a new supplier's material cost. A spreadsheet makes it easy to add as many activity levels as managers want.
Choosing the activity measure
A flexible budget is only as good as its activity measure, which should be what actually drives the costs. Manufacturing costs usually flex with units produced or machine hours; revenue and sales commissions with units sold; a hospital's laundry with patient-days; a hotel's housekeeping with occupied room-nights. When the budget is used to judge efficiency, flex it on the output achieved, not on inputs such as hours actually worked. Otherwise every wasted hour would raise the allowance and hide the waste.
Worked example: hotel housekeeping
Carrow Point Hotel budgets housekeeping at $9,000 a month fixed, for supervision and equipment, plus $18 per occupied room-night for cleaning labour, supplies and laundry. The static budget assumed 2,500 room-nights; 2,900 were actually occupied, and housekeeping cost $60,500. 1. Static budget: \(9{,}000 + 18 \times 2{,}500 = 54{,}000\). Actual cost is $6,500 above it. 2. Flexible budget at 2,900: \(9{,}000 + 18 \times 2{,}900 = 61{,}200\). 3. Actual cost is \(61{,}200 - 60{,}500 = 700\) below the flexible budget. 4. Conclusion: the apparent overspend came from a busier month. At the activity achieved, the department spent slightly less than allowed.
Relevant range and step costs
Some fixed costs jump when activity crosses a threshold. Carrow Point's single housekeeping supervisor can cover up to 3,200 room-nights a month; above that, a second supervisor costs another $3,000. 1. At 3,000 room-nights the formula holds: \(9{,}000 + 18 \times 3{,}000 = 63{,}000\). 2. At 3,400 room-nights the fixed part becomes 12,000: \(12{,}000 + 18 \times 3{,}400 = 73{,}200\). A flexible budget that ignored the step would allow only $70,200 and make the department look $3,000 over budget for a decision that was necessary.
Common mistakes to avoid
First, comparing actual costs with the static budget when activity changed. Second, flexing fixed costs as if they were variable, for example by dividing $40,000 by 10,000 mugs and charging $4 for every mug; fixed costs stay at $40,000 within the relevant range. Third, choosing an activity measure that does not drive the cost. Fourth, flexing on inputs used rather than output achieved, which builds inefficiency into the allowance. Fifth, ignoring step costs outside the relevant range.
Key takeaways
A static budget covers one planned activity level; a flexible budget restates revenue and costs for any level within the relevant range. Each item follows a formula, cost equals fixed cost plus variable rate times activity, with revenue equal to price times units. Prepared in advance, a flexible budget shows a range of outcomes for planning; prepared at actual activity, it gives a fair standard for judging results. The activity measure should be the one that drives the costs, based on output achieved, and step costs must be reflected when activity crosses their thresholds.
Flashcards
Flashcard
Budget prepared for one planned level of activity
Test your understanding
Question 1 of 5
Costs are budgeted at $15,000 fixed plus $4 per unit, and the static budget assumed 5,000 units. Actual output was 6,000 units. What is the flexible budget for costs?
Question 2 of 5
A static budget of $50,000 assumed 4,000 units, with fixed costs of $18,000 and $8 per unit. Actual output was 4,500 units costing $54,500. How did costs perform?
Question 3 of 5
Which activity measure is the best basis for a flexible budget for a hospital's laundry costs?
Question 4 of 5
Which statement about static and flexible budgets is correct?
Question 5 of 5
Housekeeping costs $9,000 a month fixed plus $18 per room-night, but above 3,200 room-nights a second supervisor adds $3,000. What is the flexible budget at 3,400 room-nights?
