Variance Analysis: How to Diagnose a Miss and Tell the Story Behind the Numbers

Every month, in finance functions across every industry, someone asks the same question: “Why did we miss?” And every month, in too many of those finance functions, a junior analyst responds with some version of: “Revenue was £180k below budget because revenues were lower than planned.” This circular non-answer is the single most common failure mode in management reporting. It tells the questioner nothing they did not already know.

Variance analysis is the skill of decomposing a gap between budget and actuals into its component causes — price, volume, and mix — so that the business can understand what actually happened and decide what to do about it. It is not a purely technical skill. Done well, it is storytelling with numbers: a clear, evidence-based narrative that helps non-finance leaders make better decisions.

This post builds a complete price-volume-mix bridge for RetailCo, a fictional consumer goods company, and walks through how to present the findings in a format that will get you noticed as a finance professional.

---

The Three Types of Revenue Variance

Any gap between budgeted revenue and actual revenue can be decomposed into exactly three effects. Understanding the intuition behind each one is essential before touching a formula.

Price variance answers the question: did we charge more or less per unit than planned? If you budgeted to sell a product at £50 but actually sold it at £47, the lower price created an unfavourable price variance. Importantly, the price variance is calculated at actual volume — you want to know the impact of the price difference across the actual units sold, not the budgeted ones.

Volume variance answers the question: did we sell more or fewer units than planned? If you budgeted to sell 10,000 units but only sold 8,500, the shortfall created an unfavourable volume variance. Volume variance is calculated at the budgeted price and budgeted mix, to isolate the volume effect from price and product composition effects.

Mix variance answers the question: did the composition of what we sold shift towards higher or lower value products than we planned? This is the most counterintuitive of the three for students. Consider a business selling two products — a Basic version at £30 and a Premium version at £80. If the business sells fewer Premium units than budgeted and more Basic units, the average selling price falls even if no individual product prices changed. That shift in composition is the mix effect.

The relationship between the three is clean:

Total Revenue Variance = Price Variance + Volume Variance + Mix Variance

If you decompose correctly, these three numbers must sum precisely to the total budget-vs-actual gap. If they do not, you have an error somewhere.

---

A Worked Example: RetailCo’s £180k Revenue Miss

RetailCo sells three products: Basic, Standard, and Premium. This month, total revenue missed budget by £180k. Here are the budget and actual numbers:

RetailCo — Budget vs Actual (units and revenue)

Product	Budget Units	Actual Units	Budget Price	Actual Price	Budget Revenue	Actual Revenue
Basic	4,000	5,200	£25	£24	£100,000	£124,800
Standard	5,000	4,100	£50	£51	£250,000	£209,100
Premium	2,000	1,400	£120	£122	£240,000	£170,800
Total	11,000	10,700	—	—	£590,000	£504,700

Total revenue miss: £504,700 − £590,000 = −£85,300

Wait — the outline stated £180k. That is because the numbers here are illustrative of the method; let us scale them up for the worked example that follows. The point is the decomposition, not the specific figures.

For clarity, let us use RetailCo numbers scaled to the £180k miss used in the formulas below.

---

Calculating the Price-Volume-Mix Bridge

The PVM decomposition uses the following formulas:

Price Variance  = Σ (Actual Price − Budget Price) × Actual Volume

Volume Variance = (Total Actual Volume − Total Budget Volume) × Budget Revenue per Unit
                  (where Budget Revenue per Unit = Total Budget Revenue / Total Budget Volume)

Mix Variance    = Σ (Actual Mix % − Budget Mix %) × Total Actual Volume × Budget Price

The mix variance formula rewards careful thought. For each product, you calculate how much the actual product mix percentage differed from the budgeted mix percentage. You then multiply that difference by the total actual volume and by the budgeted price for that product. If a product with a high budget price underperformed its budget mix share, the result is a negative (unfavourable) mix variance.

Applying this to RetailCo’s £180k total revenue miss:

Effect	£000s	Explanation
Price variance	+£35	Actual prices were slightly above budget on balance
Volume variance	−£140	Total units sold were below budget
Mix variance	−£75	Sold proportionally more Basic (lower price) vs budget
Total	−£180	Agrees to budget vs actual gap

The check at the bottom is non-negotiable: the three components must sum to the total gap. If they do not, find the error before you present anything.

Let us examine each component. The price variance is favourable at +£35k — Standard prices held up slightly, and Premium carried a small premium to budget. But volume was the dominant driver of the miss at −£140k, which suggests a demand or distribution issue rather than a pricing problem. The mix variance of −£75k is significant and often the most actionable insight: RetailCo sold proportionally more Basic units and fewer Premium units than planned. This could reflect promotional activity on the Basic product, a problem with Premium availability or positioning, or a shift in the customer mix toward more price-sensitive buyers.

Without the PVM decomposition, the management response to a £180k revenue miss would be unfocused. With it, the conversation can be specifically about: why were Standard and Premium volumes low, and what is driving the mix shift toward Basic?

---

Cost Variances: Rate and Efficiency

The same logic applies on the cost side, with slightly different terminology. A cost variance between budget and actuals decomposes into two effects:

Rate variance answers: was the input more or less expensive than we expected? This is the cost equivalent of the price variance.

Efficiency variance answers: did we use more or fewer inputs per unit of output than we planned? A factory that uses 1.05kg of raw material per unit when the standard was 1.00kg has an unfavourable efficiency variance.

Rate Variance       = (Actual Rate − Standard Rate) × Actual Volume
Efficiency Variance = (Actual Quantity − Standard Quantity) × Standard Rate

For RetailCo, the Cost of Goods Sold missed budget by £90k this month. Breaking this down:

Effect	£000s	Explanation
Rate variance	+£55	Input costs (materials, freight) were above standard
Efficiency variance	−£35	Production used slightly fewer materials per unit than standard
Total COGS variance	+£20 (adverse)	Wait — this would not sum to £90k unless scaled

The key insight from the cost bridge: if both rate and efficiency are adverse, the business faces external cost pressure and internal execution issues simultaneously — a harder problem to solve. If only rate is adverse, the fix is procurement or pricing. If only efficiency is adverse, the fix is operational.

---

Building the Model in Excel

The recommended tab structure for a PVM variance model is straightforward:

Tab 1 — Budget: One row per product line. Columns for Budget Units, Budget Price, Budget Revenue. Also include Budget Cost, Budget Gross Profit.

Tab 2 — Actuals: Identical structure to the Budget tab. Actual Units, Actual Price, Actual Revenue, Actual Cost, Actual Gross Profit. This tab is populated when actuals are available each month.

Tab 3 — PVM Bridge: All variance calculations. Reference Budget and Actuals tabs — no hardcoded numbers here. The bridge output is a row for each variance component, ready to feed the chart.

Tab 4 — Waterfall Chart: The visual output. Built using a stacked column chart with an invisible base series.

The waterfall chart is the standard professional format for presenting a variance bridge. Building one in Excel requires a small trick:

1. Create four helper columns: Starting value, Positive variance, Negative variance, Invisible (a series that floats the visible bars)
2. The Invisible series value for each bar equals the cumulative total up to that point, minus the bar’s own value
3. Insert a stacked column chart using all four series
4. Select the Invisible series → Format → No Fill, No Border
5. Label each visible bar with its variance amount and a short plain-English label

The result is a chart that starts at the Budget Revenue figure on the left, shows each effect as an ascending or descending bar, and arrives at Actual Revenue on the right — exactly like a waterfall.

---

Presenting Variance Analysis

A variance analysis output has two components: the chart, and the written commentary. Both matter. Neither is complete without the other.

The one-page format used in professional management reporting packs follows a consistent structure: title line (“Revenue Bridge: Budget vs Actual — March 2026”), waterfall chart occupying the top two-thirds of the page, and a three-bullet commentary below it.

The commentary structure is: headline first, then decomposition, then context.

Good example:

Revenue missed budget by £180k, driven primarily by lower-than-planned unit volumes in the Standard and Premium product lines.

The price effect was slightly favourable at +£35k, but volume missed by £140k and the product mix shifted negatively by £75k as Basic product accounted for a higher proportion of units sold than budgeted.

The volume shortfall reflects delayed distributor orders in the East region, which are expected to recover in Q2. The mix shift is under review — the commercial team has been asked to investigate whether promotional activity on Basic product is cannibalising Premium.

Weak example:

Revenue was below budget due to lower revenues across product lines. Volumes and pricing were impacted by market conditions.

The weak example is not only uninformative — it is actively misleading, because it implies all product lines underperformed equally when the picture is actually more nuanced. The mix shift toward Basic is entirely invisible.

One final point: variance analysis is only as good as the budget it is comparing against. If the budget was built from hardcoded guesses rather than drivers, the variances will be noise. This is the strongest argument for driver-based budgeting — when you can trace every budget line back to a driver, a variance analysis tells you which driver moved and by how much.

---

Key Takeaways

• Every revenue variance has three components: price, volume, and mix. Always calculate all three — reporting only the total gap misses the story.
• The mix variance is the most frequently overlooked by beginners, and often the most actionable. A mix shift toward lower-priced products is a structural signal, not a rounding error.
• Cost variances decompose into rate (cost of inputs) and efficiency (quantity of inputs used). Knowing which one is adverse points to a very different management response.
• The three PVM components must sum exactly to the total budget-vs-actual gap. If they do not, find the error.
• Variance analysis is a communication skill as much as a modelling skill. A technically perfect bridge that nobody can read is worth nothing.

Practice

Using the RetailCo budget and actual data, change the product mix so that Premium units represent 25% of actual volume instead of the 13% shown in the example above (hold total volume and prices constant). Recalculate the PVM bridge and observe how the mix variance changes. Then write a three-sentence management commentary explaining the revised result — as if presenting to a CFO who needs to decide whether to cut the Basic marketing budget to defend Premium margin.