Financial Laboratory · Cash and budgets

Budget variances

Where did the results differ from the budget, and was each difference good or bad for profit?

Back to 3.9 Budgets

  • 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.

Your budget
As it heads the budget, after “Budget for”.

Budgeted and actual figures

Budgeted and actual figures by line
LineBudgetedActualRemove a line
Revenue
Costs

Currency

The labels, workings and results use these words. Emberly Roasters’s figures are in dollars.

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

Budget for the three months to 30 September 2025 [F] means favourable, [A] means adverse.
All figures in $Budgeted figuresActual figuresVariance
Revenue
Sales to cafés168,000174,6006,600 [F]
Online subscriptions72,00066,3005,700 [A]
Total revenues240,000240,900900 [F]
Costs
Green beans96,000104,8008,800 [A]
Packaging10,80010,400400 [F]
Wages and salaries54,00055,5001,500 [A]
Rent and roaster lease21,00021,0000
Energy7,2006,350850 [F]
Delivery14,40015,100700 [A]
Marketing9,0007,2001,800 [F]
Total costs212,400220,3507,950 [A]
Excess of revenues over (under) costs27,60020,5507,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,800
A 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,600
Revenue 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,050
Revenue 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.

Budget variances by lineSales to cafés (revenue): 6,600 favourable; Online subscriptions (revenue): 5,700 adverse; Green beans (cost): 8,800 adverse; Packaging (cost): 400 favourable; Wages and salaries (cost): 1,500 adverse; Rent and roaster lease (cost): no variance; Energy (cost): 850 favourable; Delivery (cost): 700 adverse; Marketing (cost): 1,800 favourable. Overall, the excess of revenues over costs is 7,050 adverse.← Adverse [A]Favourable [F] →lowers profitraises profitSales to cafés revenueSales to cafés: budget 168,000, actual 174,600, variance 6,600 [F]6,600 [F]Online subscriptions revenueOnline subscriptions: budget 72,000, actual 66,300, variance 5,700 [A]5,700 [A]Green beans costGreen beans: budget 96,000, actual 104,800, variance 8,800 [A]8,800 [A]Packaging costPackaging: budget 10,800, actual 10,400, variance 400 [F]400 [F]Wages and salaries costWages and salaries: budget 54,000, actual 55,500, variance 1,500 [A]1,500 [A]Rent and roaster lease cost0Energy costEnergy: budget 7,200, actual 6,350, variance 850 [F]850 [F]Delivery costDelivery: budget 14,400, actual 15,100, variance 700 [A]700 [A]Marketing costMarketing: budget 9,000, actual 7,200, variance 1,800 [F]1,800 [F]Variance in $; the scale runs to 10,000 each side
Chart Each line’s variance: adverse to the left, favourable to the right, each labelled [A] or [F].
The chart’s figures as a table
Each line’s variance
LineKindBudgetedActualVarianceShare of budget
Sales to cafésRevenue168,000174,6006,600 [F]3.9%
Online subscriptionsRevenue72,00066,3005,700 [A]7.9%
Green beansCost96,000104,8008,800 [A]9.2%
PackagingCost10,80010,400400 [F]3.7%
Wages and salariesCost54,00055,5001,500 [A]2.8%
Rent and roaster leaseCost21,00021,00000.0%
EnergyCost7,2006,350850 [F]11.8%
DeliveryCost14,40015,100700 [A]4.9%
MarketingCost9,0007,2001,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.

Variances by size
LineKindVarianceShare of budgetEffect on profit
Green beansCost8,800 [A]9.2%adverse
Sales to cafésRevenue6,600 [F]3.9%favourable
Online subscriptionsRevenue5,700 [A]7.9%adverse
MarketingCost1,800 [F]20.0%favourable
Wages and salariesCost1,500 [A]2.8%adverse
EnergyCost850 [F]11.8%favourable
DeliveryCost700 [A]4.9%adverse
PackagingCost400 [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