Charta is on Google Play: practise on the go. Get the app

How to explain a budget variance: price, volume and mix

23 October 2026 · 5 min read · Charta Learning

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?

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:

RangeBudget casesBudget priceActual casesActual price
Everyday40,00010.0038,0009.80
Premium10,00020.0014,00019.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.

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.

Price effect = minus 14,600 adverse. Both ranges sold below their budget price.

Does it add up?

Always check the bridge:

StepPounds
Budget revenue600,000
Volumeplus 24,000
Mixplus 36,000
Priceminus 14,600
Actual revenue645,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?

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

  1. Recompute the bridge above by hand, then in a spreadsheet, and confirm the check cell equals zero.
  2. Change the Premium actual price to 20.00 and predict how each effect moves before you calculate.
  3. Add a unit cost to each range and build the same bridge for margin.
  4. Explain the result aloud in thirty seconds to a friend, without numbers on the page.
  5. 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.

More guides

Practise with questions that explain every wrong answer, and a plan built from a short diagnostic.

Start free →

Charta Learning is independent. It is not affiliated with, sponsored by or endorsed by any bank, fund or consultancy. All questions, cases and notes are original, written for this product with invented companies and public information only; none is a real question from any firm's recruitment process. Feedback on written answers is AI-assisted and can be wrong. The legal and documentation topics are general education, not legal advice. We do not guarantee interviews, offers or results.