How to explain a budget variance: price, volume and mix
When actual revenue differs from budget, "sales were 45k ahead" is only the start. A finance partner is expected to say why: did we sell more, sell a richer mix, or charge different prices? This guide walks through a bridge from budget to actual, split into volume, mix and price effects, for an invented company with every figure worked out. Conventions differ between companies, so state yours when you present.
What is a variance and why split it?
A variance is the difference between actual and budget (or forecast). It is favourable if it raises profit and adverse if it lowers it. A single total can hide offsetting effects. Splitting it shows which part came from the market, which from the sales mix and which from pricing decisions, and each points to a different action.
What are the three effects?
- Volume: we sold more or fewer units in total. Measured at the budgeted average price.
- Mix: the share of each product changed. Selling more of a high-priced product raises average revenue per unit even if total units are flat.
- Price: we realised a different price per unit than budgeted, for example through discounts or list price changes.
The three add up exactly to the total revenue variance. This is the check you should always run.
What does the example look like?
Thornlea Foods Ltd is an invented company that sells two ranges of ready meals to retailers, by the case. The monthly budget and actual are:
| Range | Budget cases | Budget price | Actual cases | Actual price |
|---|---|---|---|---|
| Everyday | 40,000 | 10.00 | 38,000 | 9.80 |
| Premium | 10,000 | 20.00 | 14,000 | 19.50 |
Budget revenue is 40,000 times 10.00 plus 10,000 times 20.00, which is 400,000 plus 200,000, so 600,000 pounds. Actual revenue is 38,000 times 9.80 plus 14,000 times 19.50, which is 372,400 plus 273,000, so 645,400 pounds. The total variance is 645,400 minus 600,000, which is 45,400 favourable.
How do I calculate the volume effect?
Budget total cases are 50,000 and the budget average price is 600,000 divided by 50,000, so 12.00 per case. Actual total cases are 52,000, which is 2,000 more than budget.
Volume effect = (actual total cases minus budget total cases) times budget average price = 2,000 times 12.00 = 24,000 favourable.
This answers the question "what if we had sold the extra cases in the budgeted mix at budgeted prices?"
How do I calculate the mix effect?
First work out what actual total cases would have been in the budgeted mix. The budget mix is 80 percent Everyday and 20 percent Premium, so 52,000 cases would split into 41,600 Everyday and 10,400 Premium. Compare these with what was really sold, and value the difference at the budget price of each range.
- Everyday: (38,000 minus 41,600) times 10.00 = minus 36,000.
- Premium: (14,000 minus 10,400) times 20.00 = plus 72,000.
Mix effect = minus 36,000 plus 72,000 = 36,000 favourable. We sold fewer low-priced cases and more high-priced ones than the budget mix implied.
How do I calculate the price effect?
Take actual cases for each range and multiply by the difference between actual and budget price.
- Everyday: 38,000 times (9.80 minus 10.00) = minus 7,600.
- Premium: 14,000 times (19.50 minus 20.00) = minus 7,000.
Price effect = minus 14,600 adverse. Both ranges sold below their budget price.
Does it add up?
Always check the bridge:
| Step | Pounds |
|---|---|
| Budget revenue | 600,000 |
| Volume | plus 24,000 |
| Mix | plus 36,000 |
| Price | minus 14,600 |
| Actual revenue | 645,400 |
Because 24,000 plus 36,000 minus 14,600 is 45,400, the bridge reconciles to the total variance. If it does not, an input or formula is wrong. Many models use this as a built-in check cell.
How would I say it out loud?
"Revenue was 45k ahead of budget, 7.6 percent. Most of that is volume and mix: we sold 2,000 more cases, and the Premium range grew well above plan, which added 36k. Offsetting that, we realised lower prices in both ranges, costing about 15k, so I would want to know whether that is promotional discounting or a lasting change in what retailers pay." That is about fifteen seconds and ends with the question a business partner should follow up.
What should I be careful about?
- Revenue is not profit. Premium may carry higher costs, so a favourable revenue mix is not automatically a favourable margin. A full analysis repeats the bridge for contribution or gross margin using unit costs.
- Order and method matter. There are alternative methods, such as valuing mix at actual instead of budget prices, and the split between effects can change. Say which you used.
- Mix needs a sensible grouping. Products with very different characteristics should be separated, but too many lines make the story unreadable.
- Check the budget itself. If the budget was set on a poor assumption, the variance tells you about the budget, not the performance.
- Timing. A volume gain might be pulled forward from next month because of a promotion.
What questions should I ask next?
Ask what drove the price fall: promotions, a new retailer contract or competitor action. Ask whether the Premium gain is lasting, and whether capacity or stock allows it to continue. Ask what the margin bridge looks like. Then say what you would update in the forecast. A good variance explanation ends in a decision, not a table.
What should I take from this?
Split the total into volume, mix and price, check that the parts sum to the total, and describe each in plain words. In an interview, being able to talk through a small example like this, and to say what you would ask next, matters more than reciting a formula.
What to do this week
- Recompute the bridge above by hand, then in a spreadsheet, and confirm the check cell equals zero.
- Change the Premium actual price to 20.00 and predict how each effect moves before you calculate.
- Add a unit cost to each range and build the same bridge for margin.
- Explain the result aloud in thirty seconds to a friend, without numbers on the page.
- Find a company's published results and write a three-line price, volume and mix explanation of a revenue change, saying what you cannot tell from public data.
About this guide: it is original to Charta Learning and has not yet been reviewed by an experienced practitioner. Names in examples are invented. Companies define volume, mix and price effects slightly differently, so confirm the method your team uses before presenting a bridge.