Skip to content
Pricing & margin

Price volume mix calculator — revenue variance bridge

Split a revenue change into price, volume and mix effects across up to five product lines. The three effects reconcile exactly to the total variance.

Free · no signup · runs in your browserUpdated
Short answer

Price volume mix analysis splits a revenue change into three parts that sum to the total. Volume is the unit change valued at last period's average price, mix is the shift in each line's share of units valued at prior prices, and price is the per-unit price change on current volumes. Revenue rising $195,550 can be +$493,246 volume, −$359,746 mix and +$62,050 price.

Revenue moved and everyone has a theory. Price volume mix analysis settles it by splitting the change into three effects that add up to the total: how many units you sold, what you charged, and which products the units were.

Enter prior and current units and average price for two to five lines. You get each effect in dollars, the split line by line, average selling price for both periods, and a reconciliation check that must read zero.

Mix is the effect people miss, and it is usually the one that explains a quarter where revenue grew and margin did not.

Your numbers

Product lines
Line 1
$

Revenue ÷ units, after discounts. For a new line, enter its launch price so the revenue lands in volume and mix.

$
Line 2
$
$
Line 3
$
$
Line 4
$
$

Result

Revenue change, prior to current
+$195,550

7.9% on $2,469,000 · units 8,910 → 10,690 · avg price $277.10 → $249.26

Prior period revenue$2,469,000
Current period revenue$2,664,550
Volume effect+$493,246
Mix effect-$359,746
Price effect+$62,050
Reconciliation check$0.00
Volume+$493,246
Mix-$359,746
Price+$62,050
Each line's three effects sum to its own revenue change, so the bridge holds at line level too.
LineVolumeMixPriceΔ revenue
Industrial pumps+$206,168-$335,168+$36,750-$92,250
Pump spares+$115,071+$52,929-$12,400+$155,600
Service contracts+$148,633-$76,633+$40,800+$112,800
Accessories+$23,374-$874-$3,100+$19,400
Total+$493,246-$359,746+$62,050+$195,550
Prior: $2,469,000 over 8,910 units → avg price $277.1044
Current: $2,664,550 over 10,690 units → avg price $249.2563
Volume = (10,690 − 8,910) × $277.1044 = +$493,246
Mix = ΣQ₁×P₀ − Q₁×avgP₀ = $2,602,500 − $2,962,246 = -$359,746
Price = R₁ − ΣQ₁×P₀ = $2,664,550 − $2,602,500 = +$62,050
+$493,246 − $359,746 + $62,050 = +$195,550 = actual change (check $0.00)
Revenue grew +$195,550 (7.9%), and volume is the largest mover at +$493,246. The negative mix effect says the extra units came from lower-priced lines — average selling price moved from $277.10 to $249.26. The three effects reconcile to the total exactly.

Everything is computed in your browser. Nothing you type is sent anywhere or stored.

The formula

Volume = (Q₁ − Q₀) × share₀ × P₀ · Mix = Q₁ × (share₁ − share₀) × P₀ · Price = (P₁ − P₀) × Q₁ · Volume + Mix + Price = R₁ − R₀
Q₀, Q₁
Total units across all lines in the prior and current period.
share₀, share₁
A line's share of total units in the prior and current period.
P₀, P₁
That line's average selling price in the prior and current period.
R₀, R₁
Total revenue in each period. R = Σ (units × price) per line.

The convention matters, because published PVM splits differ. This calculator values the volume and mix effects at prior prices, and the price effect at current volumes. That means the price × volume interaction — the extra revenue from selling more units at a higher price — is reported inside the price effect. The three effects then reconcile exactly to the revenue change with no unexplained residual, both in total and line by line. Valuing price at prior volumes instead pushes the interaction into a fourth bucket; neither is wrong, but mixing the two between periods makes your bridge untrustworthy.

Worked example

Industrial pumps
1,200 → 1,050 units · $860 → $895
Pump spares
4,800 → 6,200 units · $120 → $118
Service contracts
310 → 340 units · $2,400 → $2,520
Accessories
2,600 → 3,100 units · $45 → $44
Result
Revenue +$195,550 = volume +$493,246, mix −$359,746, price +$62,050

Revenue rose from $2,469,000 to $2,664,550, up 7.9%. Units rose from 8,910 to 10,690, and at the prior average price of $277.10 that volume alone is worth +$493,246. But the extra units were mostly $118 spares and $44 accessories, so the mix effect is −$359,746. Price changes on current volumes add +$62,050. The three sum to $195,550 exactly. The story in one line: average selling price fell from $277.10 to $249.26, so growth cost you 10.0% of your realised price.

The three effects in this price volume mix calculator

Each effect isolates one variable and holds the others at a stated baseline. That baseline choice is the entire method — get it consistent and the bridge is defensible, change it between quarters and nobody will trust the chart again.

EffectCalculation per lineHeld atReads as
Volume(Q₁ − Q₀) × share₀ × P₀Prior prices, prior mixWhat growth would have been worth if nothing else moved
MixQ₁ × (share₁ − share₀) × P₀Prior prices, actual total unitsThe revenue gained or lost by selling a different blend
Price(P₁ − P₀) × Q₁Current volumesRealised price movement on what you actually shipped
TotalSum of the three—Exactly R₁ − R₀, with no residual
Volume and mix are valued at prior prices; price is valued at current volumes.

Reading the worked example

Revenue up 7.9% looks like a good quarter until the bridge is drawn. Volume contributed +$493,246 — units grew 20.0%. Mix gave back −$359,746 because 1,400 of the extra units were $120 spares and 500 were $45 accessories, while industrial pumps at $860 fell by 150 units. Price added +$62,050, mostly from the $120 increase on service contracts. Average selling price is the same story compressed: $277.10 down to $249.26. Nothing was mispriced; the blend changed. Pair this with the contribution margin calculator to see whether the cheaper lines were worth having — high-volume spares often carry the better contribution ratio.

The line-level check nobody runs

Because this decomposition is exact, it holds per line as well as in total. Industrial pumps fell $92,250: volume +$206,168, mix −$335,168, price +$36,750. Sum those and you get −$92,250 to the cent. If your spreadsheet does not tie at line level, the mix formula is usually the culprit — a share change multiplied by the wrong period's price.

Common mistakes

  • Leaving new lines with a zero prior price. The formula then credits their entire revenue to price, which is nonsense. Enter the launch price as the prior price so the revenue lands in volume and mix, or report new products in a separate labelled bucket. Discontinued lines need the same treatment in reverse.
  • Using list price instead of realised price. Average selling price must be revenue ÷ units, after discounts and credits. Otherwise your price effect measures your price list, not your business. The discount cascade calculator shows how far apart those two are.
  • Mixing units of measure across lines — eaches against cases, or hours against contracts. Shares of total volume become meaningless and the mix effect turns into noise.
  • Comparing periods of different length. A 13-week quarter against a 14-week one puts a phantom volume effect in the bridge.
  • Running PVM on gross revenue and margin on net. Pick one basis and hold it, or the two stories will contradict each other.
  • Aggregating too far. Two lines gives you almost no mix signal; forty makes the chart unreadable. Five to fifteen groups that share a price band is the useful range.

Getting four numbers per line without a week of work

The inputs are simple and the extraction is not: units and revenue by line for two periods, on the same calendar, net of credit memos, with returns booked back to the original line. That is where most PVM analysis dies — not in the arithmetic. takes the question instead: "units and net revenue by product line, this quarter against the same quarter last year, excluding intercompany". The SuiteQL is shown with the answer, so the definition is auditable before it reaches a board pack. Read price volume mix analysis for the narrative version.

Frequently asked questions

What is price volume mix analysis?

A decomposition of a revenue change into three causes: selling more or fewer units, charging different prices, and selling a different blend of products. The three effects are calculated so they sum to the total revenue change, which turns "revenue is up 8%" into an explanation you can act on.

How do you calculate the mix effect?

For each line, take its share of total units this period minus its share last period, multiply by total current units, then multiply by that line's prior price. Summed across lines it equals current units valued at prior prices, minus current units valued at the prior overall average price.

Do price, volume and mix have to add up to the revenue change?

Yes, and that reconciliation is the test of whether your model is sound. If the three effects leave a residual, either a line has no prior price, the price and volume effects are valued at inconsistent baselines, or units and revenue come from different periods. This calculator shows the check figure, which should read zero.

Why did revenue grow but average price fall?

Almost always mix. If growth comes from lower-priced lines, the average selling price drops even when no individual price was cut. That shows up as a positive volume effect and a negative mix effect. It is a portfolio outcome, not a pricing failure, and it needs a different response.

How do you handle new products in a PVM analysis?

A new line has no prior price, so the standard formula dumps all of its revenue into the price effect. Either enter its launch price as the prior price, which routes the revenue to volume and mix, or report new-product revenue as a separate labelled bucket. Handle discontinued lines the same way in reverse.

Can price volume mix be done on margin instead of revenue?

Yes, and it is often more useful. Replace price with contribution margin per unit and the same three effects explain a margin change instead of a revenue change. Keep the cost basis constant across both periods, or cost inflation will contaminate what you are calling a price effect.

Related calculators

Pricing & margin
Contribution margin calculator

Calculate contribution margin per unit and as a ratio, split contribution across product lines, and see which line to push against a capacity constraint.

Pricing & margin
Gross margin calculator

Calculate gross margin from revenue and COGS. Get gross profit, margin %, markup %, margin per unit, and the price you need for a target margin.

Pricing & margin
Discount cascade calculator

Chain up to four sequential discounts to see the net price, the effective single discount, and the gross margin left at every step of the cascade.

Pricing & margin
Break-even calculator

Calculate break-even units and revenue from fixed costs and contribution margin. Includes margin of safety and the volume needed for a target profit.

Read the background

Finance metrics
Price volume mix analysis: why you grew but margin fell

Price volume mix analysis with a fully worked example: an additive decomposition where price, volume and mix sum exactly to the revenue change.

Finance metrics
Budget vs actual variance analysis that survives a board meeting

Build a budget vs actual variance analysis that holds up: materiality thresholds, price/volume/mix drivers, and timing versus permanent.

Finance metrics
Margin vs markup: the difference, and the conversion table

Margin vs markup, settled: both formulas, a checked conversion table, and the pricing error that quietly costs you dollars per unit.

All 50 ERP & finance tools

Stop calculating it by hand. Just ask your ERP.

This calculator needs you to find the inputs first. ERPray pulls them from your own ERP account and computes the answer live — with the exact query shown so you can check it.

Get early access — freeBrowse all 50 tools