Financial Laboratory · Cash and budgets
Budget variances
Where did the results differ from the budget, and was each difference good or bad for profit?
- IB 3.9 Budgets
- HL only
- Layout of the guide’s financial statements
- Simulated data Example: Emberly Roasters, fictional
The layout of the guide’s budget (figure 11, p. 63), with each variance marked [F] favourable or [A] adverse. The guide gives no variance formula; the standard one is used.
The calculator
Example figures: Emberly Roasters, a fictional business. Simulated data.
The calculator could not start. The worked example below uses the example figures.
The figures
- Period
- the three months to 30 September 2025
- Sales to cafés (revenue)
- budget 168,000, actual 174,600
- Online subscriptions (revenue)
- budget 72,000, actual 66,300
- Green beans (cost)
- budget 96,000, actual 104,800
- Packaging (cost)
- budget 10,800, actual 10,400
- Wages and salaries (cost)
- budget 54,000, actual 55,500
- Rent and roaster lease (cost)
- budget 21,000, actual 21,000
- Energy (cost)
- budget 7,200, actual 6,350
- Delivery (cost)
- budget 14,400, actual 15,100
- Marketing (cost)
- budget 9,000, actual 7,200
Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the figures above.
Result
These results are for the last complete figures. Correct the figure marked in the inputs to update them.
Variance in the excess of revenues over costs
$7,050 [A]
adverse: profit below budget
- Total revenues
- 900 [F]budget 240,000, actual 240,900
- Total costs
- 7,950 [A]budget 212,400, actual 220,350
- Excess of revenues over (under) costs
- 7,050 [A]budget 27,600, actual 20,550
- Largest adverse variance
- Green beans: 8,800 [A]
- Largest favourable variance
- Sales to cafés: 6,600 [F]
- Favourable against adverse, all lines
- 9,650 [F] / 16,700 [A]
The budget
| All figures in $ | Budgeted figures | Actual figures | Variance |
|---|---|---|---|
| Revenue | |||
| Sales to cafés | 168,000 | 174,600 | 6,600 [F] |
| Online subscriptions | 72,000 | 66,300 | 5,700 [A] |
| Total revenues | 240,000 | 240,900 | 900 [F] |
| Costs | |||
| Green beans | 96,000 | 104,800 | 8,800 [A] |
| Packaging | 10,800 | 10,400 | 400 [F] |
| Wages and salaries | 54,000 | 55,500 | 1,500 [A] |
| Rent and roaster lease | 21,000 | 21,000 | 0 |
| Energy | 7,200 | 6,350 | 850 [F] |
| Delivery | 14,400 | 15,100 | 700 [A] |
| Marketing | 9,000 | 7,200 | 1,800 [F] |
| Total costs | 212,400 | 220,350 | 7,950 [A] |
| Excess of revenues over (under) costs | 27,600 | 20,550 | 7,050 [A] |
Section 01: The formula and the working
Each formula in the guide’s words, then the working with the figures above, step by step.
Variance = actual figure − budgeted figure
Shown as an amount marked [F] favourable or [A] adverse, by its effect on profit.
The largest adverse variance: Green beans
- Given
- Budgeted green beans: $96,000
- Actual green beans: $104,800
- Formula
- Variance = actual figure − budgeted figure, marked [F] or [A] by its effect on profit
- Substitution
- = $104,800 − $96,000
- Working
- 104,800 − 96,000 = 8,800A cost above budget lowers profit: adverse.
- Answer
- $8,800 [A]
- Unit
- $ for the period
- Interpretation
- Green beans ran above budget by $8,800, 9.2% of its budget.
- Business implication
- The first line to investigate: find the cause before judging the budget holder.
The largest favourable variance: Sales to cafés
- Given
- Budgeted sales to cafés: $168,000
- Actual sales to cafés: $174,600
- Formula
- Variance = actual figure − budgeted figure, marked [F] or [A] by its effect on profit
- Substitution
- = $174,600 − $168,000
- Working
- 174,600 − 168,000 = 6,600Revenue above budget raises profit: favourable.
- Answer
- $6,600 [F]
- Unit
- $ for the period
- Interpretation
- Sales to cafés came in above budget by $6,600.
- Business implication
- Good news is investigated too: a saving may store up a problem, and a revenue surplus may show the budget was set too low.
Excess of revenues over (under) costs
- Given
- Budgeted excess of revenues over costs: $27,600
- Actual excess of revenues over costs: $20,550
- Formula
- Variance = actual figure − budgeted figure, marked [F] or [A] by its effect on profit
- Substitution
- = $20,550 − $27,600
- Working
- 20,550 − 27,600 = −7,050Revenue below budget lowers profit: adverse.
- Answer
- $7,050 [A]
- Unit
- $ for the period
- Interpretation
- Overall, profit for the period was $7,050 below budget.
- Business implication
- The total can hide large variances that cancel out, so read the lines as well.
Section 02: The chart
Drawn from the figures above, with every value also in a table.
The chart’s figures as a table
| Line | Kind | Budgeted | Actual | Variance | Share of budget |
|---|---|---|---|---|---|
| Sales to cafés | Revenue | 168,000 | 174,600 | 6,600 [F] | 3.9% |
| Online subscriptions | Revenue | 72,000 | 66,300 | 5,700 [A] | 7.9% |
| Green beans | Cost | 96,000 | 104,800 | 8,800 [A] | 9.2% |
| Packaging | Cost | 10,800 | 10,400 | 400 [F] | 3.7% |
| Wages and salaries | Cost | 54,000 | 55,500 | 1,500 [A] | 2.8% |
| Rent and roaster lease | Cost | 21,000 | 21,000 | 0 | 0.0% |
| Energy | Cost | 7,200 | 6,350 | 850 [F] | 11.8% |
| Delivery | Cost | 14,400 | 15,100 | 700 [A] | 4.9% |
| Marketing | Cost | 9,000 | 7,200 | 1,800 [F] | 20.0% |
Section 03: Where to look first
The variances ranked by size, each with its share of the line’s budget. A large variance on a small budget can matter as much as a larger one on a big budget.
| Line | Kind | Variance | Share of budget | Effect on profit |
|---|---|---|---|---|
| Green beans | Cost | 8,800 [A] | 9.2% | adverse |
| Sales to cafés | Revenue | 6,600 [F] | 3.9% | favourable |
| Online subscriptions | Revenue | 5,700 [A] | 7.9% | adverse |
| Marketing | Cost | 1,800 [F] | 20.0% | favourable |
| Wages and salaries | Cost | 1,500 [A] | 2.8% | adverse |
| Energy | Cost | 850 [F] | 11.8% | favourable |
| Delivery | Cost | 700 [A] | 4.9% | adverse |
| Packaging | Cost | 400 [F] | 3.7% | favourable |
Reading. Green beans is the largest adverse variance, 9.2% over its budget; 3 other lines are adverse. 4 lines are favourable, together 9,650.
Section 04: What it means
For the figures above: the reading, the comparisons that give it meaning, and what a manager might do.
What the number means
Revenues were 900 [F] against budget and costs 7,950 [A], so the excess of revenues over costs was $7,050 worse than planned, driven most by green beans (8,800 [A]).
What to compare it with
Compare each variance with the size of its budget, with the same line in earlier periods, and with the lines around it: sales and the costs that rise with them should move together. Compare the causes with what the budget holder could control.
Why benchmarks vary
There is no universal threshold for a variance worth investigating; many businesses set one in money or as a percentage of the budget, and it depends on the size of the business and the line. A volatile cost such as energy or raw materials varies more from budget than rent does, and a budget set in a stable year can look badly wrong after a sudden rise in prices.
What a manager might do
Options for a manager, not IB requirements; each has a cost or a risk to weigh.
- Investigate green beans first: ask whether the cause was inside the budget holder’s control (waste, poor buying) or outside it (a supplier’s price rise, the weather, the economy).
- Read the lines together: the saving on marketing may explain part of the shortfall in online subscriptions, so a favourable variance is not always good news.
- Decide whether to act or to re-budget: a variance caused by a lasting change, such as higher input prices, may mean the budget itself needs revising.
- Look for patterns over several periods: one adverse variance may be noise, a run of them is a signal.
Section 05: Learn more
- Notes 3.9 Budgets The full notes for the subtopic.
- Formula sheet The formula sheet The formulae the examination provides, and the ones to learn, on one printable page.
- On a case Finance Desk The same idea worked on a fictional case at the Finance Desk.
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/finance-desk/lab/budget-variances/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.