Written by the Biznerdly Editorial Team. Technical review by Tanzila Tanjim Tusra, Researcher, a statistics graduate & partially qualified chartered accountant (ICAB) and data analyst. Published August 22, 2026. Last verified: August 2026, tested on Excel 365 and Excel 2021.
Price-volume-mix analysis breaks a single revenue or margin variance into three separate drivers: how much came from selling at a different price than planned (price variance), how much came from selling more or fewer total units (volume variance), and how much came from selling a different combination of products than planned (mix variance). Decomposing the number this way answers the question a plain variance report can't: was the miss actually a pricing problem, a demand problem, or a product-mix problem?
"Revenue was $4,500 favorable this month" tells a manager almost nothing useful on its own. Was that because you raised prices, sold more units, or shifted customers toward a richer product mix? Those three explanations call for three completely different management responses, and an aggregate variance number can't tell them apart. This article shows the decomposition, worked with real numbers, plus how to turn it into a waterfall chart that makes the story visual.
The three drivers, defined
| Driver | Formula | What it isolates |
|---|---|---|
| Volume Variance | (Actual Total Volume − Budgeted Total Volume) × Standard Price or Margin | The effect of selling more or fewer total units, holding price and mix constant |
| Price Variance | (Actual Price − Standard Price) × Actual Volume | The effect of charging more or less than the standard price, holding volume constant |
| Mix Variance | (Actual Mix % − Budgeted Mix %) × Actual Total Volume × Standard Margin per Unit, summed across products | The effect of shifting the proportion of higher- or lower-margin products sold |
Every finance team eventually needs this because a single blended average hides the story. A company can hit its total revenue target while its most profitable product line quietly loses share to a cheaper one, and a plain variance report will show a favorable number right up until the margin erosion becomes impossible to ignore.
Worked example: price and volume variance
Start with a single product to see the mechanics clearly, then extend to multiple products in the next section.
| Metric | Budget | Actual |
|---|---|---|
| Volume (units) | 10,000 | 11,000 |
| Price per unit | $10.00 (standard) | $9.50 |
| Revenue | $100,000 | $104,500 |
Total revenue variance is $4,500 favorable ($104,500 − $100,000). Decomposed:
- Volume Variance = (11,000 − 10,000) × $10.00 = +$10,000 favorable. Selling 1,000 more units than planned, at the standard price, added $10,000.
- Price Variance = ($9.50 − $10.00) × 11,000 = −$5,500 unfavorable. Selling at 50 cents below standard price cost $5,500 across all 11,000 units sold.
Check the math: $10,000 − $5,500 = $4,500, matching the total revenue variance exactly. That's the property that makes this decomposition trustworthy: the pieces always reconcile back to the whole, so there's nowhere for an error to hide unnoticed.
Worked example: adding mix variance
Now extend to two products, using standard contribution margin per unit instead of price, since mix shifts matter most for their effect on profitability, not just revenue.
| Product | Standard CM/unit | Budgeted volume | Budgeted mix % | Actual volume | Actual mix % |
|---|---|---|---|---|---|
| Product A | $4.00 | 6,000 | 60% | 5,500 | 50% |
| Product B | $7.00 | 4,000 | 40% | 5,500 | 50% |
| Total | - | 10,000 | 100% | 11,000 | 100% |
Volume Variance (using the budgeted weighted-average margin of $5.20 per unit): (11,000 − 10,000) × $5.20 = +$5,200 favorable.
Mix Variance, calculated per product and summed:
- Product A: (50% − 60%) × 11,000 × $4.00 = −$4,400
- Product B: (50% − 40%) × 11,000 × $7.00 = +$7,700
- Total Mix Variance = −$4,400 + $7,700 = +$3,300 favorable
Total Volume + Mix Variance = $5,200 + $3,300 = $8,500, which reconciles exactly against the direct calculation: actual-mix contribution margin ($60,500) minus budgeted-mix contribution margin ($52,000) also equals $8,500. The story this tells: overall unit volume was up, but the real driver of the favorable result was a mix shift toward Product B, the higher-margin line. A report that only showed "total margin up $8,500" would have missed that the company is quietly selling proportionally less of its lower-margin product, which is worth knowing even though the headline number looks good.
Building the waterfall chart
In Excel
- Insert a Waterfall chart directly (Insert → Charts → Waterfall, available in Excel 2016 and later) rather than the older stacked-bar workaround.
- Lay out your categories in order: Budgeted Revenue, Volume Variance, Mix Variance, Price Variance, Actual Revenue.
- Mark the first and last bars ("Budgeted Revenue" and "Actual Revenue") as totals by right-clicking each bar and selecting "Set as Total," so they anchor the bridge instead of floating.
In Power BI
- Use the built-in Waterfall visual, dragging your variance category field to Category and the variance amount to Y-axis.
- Set a Breakdown field if you want to drill into which products drove the Mix Variance bar specifically.
- Format increase/decrease colors to match your report's favorable/unfavorable convention from Article , so the visual language stays consistent across every report in the cluster.
Common mistakes
| Mistake | Why it happens | Fix |
|---|---|---|
| Using actual price instead of standard price in the volume variance formula | Mixing up which variable should be held constant in each component | Volume variance always uses the standard price/margin; only price variance uses the actual price |
| Skipping mix variance for a multi-product business | Assuming volume and price alone explain the full story | Any business selling more than one product or service line needs mix variance, or the margin story stays hidden |
| Components don't reconcile to the total variance | A formula was applied to the wrong volume base (budgeted vs actual) in one of the three components | Always check that Price + Volume + Mix sums exactly to the total variance; if it doesn't, one component's base is wrong |
| Reporting mix variance without naming which products drove it | Treating mix variance as a single number rather than a sum of per-product effects | Always show the per-product breakdown, not just the total, since that's where the actionable insight lives |
Downloadable calculator and starter file
- Price-Volume-Mix Calculator Template, pre-built with the two-product example above and space to paste in your own product list. [DOWNLOAD LINK]
Frequently asked questions
How do you calculate price variance vs volume variance?
Volume variance holds price constant and isolates the effect of selling a different number of units: (Actual Volume − Budgeted Volume) × Standard Price. Price variance holds volume constant and isolates the effect of charging a different price: (Actual Price − Standard Price) × Actual Volume. Calculated correctly, the two always sum to the total revenue variance.
What is mix variance in sales?
Mix variance measures the profit or revenue impact of selling a different proportion of products than planned, even when total volume matches the budget exactly. If a company sells more of its lower-margin products and less of its higher-margin products than planned, mix variance will be unfavorable even if total units sold are on target.
How do you build a variance bridge or waterfall chart?
List your variance components in sequence, starting and ending with totals (Budget and Actual), with each driver's variance as a floating bar in between. Excel's built-in Waterfall chart type and Power BI's Waterfall visual both support marking the first and last bars as totals so they anchor the bridge correctly.
Do I need mix variance if I only sell one product?
No. Mix variance only applies when a business sells more than one product or service line. A single-product business only needs the price and volume decomposition covered in the first worked example.
Where to go from here
- Variance Analysis in Excel and Power Pivot, the foundational budget-vs-actual framework this article builds on.
- Automating Variance Commentary with AI, for turning a price-volume-mix breakdown into written management commentary.
- Power BI vs Power Pivot, if the waterfall chart above is your first real reason to look at Power BI.
- Power Pivot DAX for Pivot Table Users, the DAX foundation this article builds on.
0 Comments