Skip to content
Controllingblog

Home❧Operational Controlling❧Budget vs. actual analysis that reveals causes

Budget vs. actual analysis that reveals causes

“Revenue 3% above plan” is information. “More units, but worse prices” is insight. How to break down variances so you can actually do something with them.

Operational Controlling8 min readUpdated 14 Nov 2026
Illustration: report with charts and a tick

The budget vs. actual comparison is controlling's daily bread. Every month plan figures are set next to actuals, the difference calculated and coloured red or green. But a variance alone answers no question – it raises one. Only variance analysis turns it into an answer.

Basic terms: plan, flexible budget, actual

  • Plan: the originally budgeted value.
  • Flexible budget (target): the plan value adjusted to actual activity. If 10% more was produced, variable costs may also be 10% higher.
  • Actual: the value actually incurred.

This distinction matters more than it seems. Comparing actual costs with plan costs punishes production for higher sales. Comparing with the flexible budget shows true efficiency.

The breakdown: price and volume variance

Every revenue or cost variance can be split into two parts: did we sell (or use) more or less volume than planned? And at what price?

Volume variance = (actual quantity − plan quantity) × plan price
Price variance = (actual price − plan price) × actual quantity

An example

PlanActualVariance
Quantity (units)1,0001,100+100
Price (€)50.0047.00−3.00
Revenue (€)50,00051,700+1,700
  • Volume variance: (1,100 − 1,000) × 50 = +€5,000
  • Price variance: (47 − 50) × 1,100 = −€3,300
  • Total: +5,000 − 3,300 = +€1,700 ✓

Total revenue is slightly above plan – sounds good. But the breakdown shows: sales bought volume with discounts. The question for the next meeting is not “Why are we above plan?” but “Was the discount worth the extra volume?”.

Materiality: don't comment on every variance

A report that comments on every line won't be read. Set thresholds above which a variance must be explained – for example more than 5% and more than €10,000. Both conditions together prevent small items with large percentages or large items with small percentages from eating up attention.

Comments that lead to action

A good variance comment has three parts:

  1. What? Size and direction of the variance.
  2. Why? The cause – ideally broken down into price, volume, mix or one-off effect.
  3. So what? Whether the variance will persist or reverse, and what is being done.
Example of a good commentMaterial costs €42k above flexible budget. Cause: steel price +8% since April (price effect +€35k), extra consumption due to scrap on line 2 (+€7k). Price effect will persist until year-end; price adjustment clause in two key-account contracts will be applied from June. Scrap: tool replaced, back to normal since week 22.

Other types of variance

  • Mix variance: a different product mix was sold than planned – more of the low-margin, less of the high-margin products.
  • Usage variance: in cost centre accounting – more material or hours per unit than specified.
  • Capacity variance: fixed costs are spread over fewer units when utilisation falls.
  • Timing difference: costs occur in a different month than planned. Usually evens out – name it anyway, otherwise it gets discussed again every month.

Common mistakes

  • Plan instead of flexible budget as the basis for variable costs.
  • Only monthly values, no year-to-date figures – small monthly variances add up unnoticed.
  • Comments like “seasonal” or “being monitored”.
  • No follow-up: last month's action is never mentioned again.

Conclusion

A budget vs. actual comparison is only as good as the questions it answers. With the split into price and volume, sensible materiality thresholds and comments following “What – Why – So what”, a list of numbers becomes a steering tool.

Frequently asked questions

What is the difference between plan costs and flexible budget costs?

Plan costs are the originally budgeted costs. Flexible budget costs are plan costs converted to the activity actually achieved. They are the fair basis for comparing variable costs.

How do you calculate the price variance?

Price variance = (actual price − plan price) × actual quantity. It shows which part of the total variance is due to changed prices.

When should a variance be commented on?

Combined thresholds are common, e.g. more than 5% and at the same time more than a fixed euro amount. The exact values depend on company size.