Price, volume, mix: three numbers that have to tie to the penny

Your boss wants revenue growth broken into price, volume, and mix. The request sounds like three separate reports. It’s one identity, decomposed, and the test of whether you did it right is simple: the three pieces have to add back to the total revenue change exactly. Not approximately. To the penny.

That reconciliation is the whole discipline. If your price, volume, and mix don’t sum to the revenue variance you started with, you don’t have an analysis. You have three numbers that happen to be near the right size.

What the three pieces answer

Revenue moved by some amount between two periods. The decomposition answers one question three ways: how much of that move came from charging more for the same things (price), how much from selling more things overall (volume), and how much from selling a richer or poorer blend of what you offer (mix).

Mix only exists when you sell more than one thing at more than one price. A single-product business has price and volume and nothing else. The moment you sell a $50 product and a $110 product, the ratio between them starts moving revenue on its own, independent of how many total units you sold or what you charged for each.

Define them before touching a formula

Hold everything constant except the one thing you’re measuring.

• Price effect: same products, same blend, new prices. What did charging differently do?
• Volume effect: same prices, same blend, more or fewer total units. What did selling more do?
• Mix effect: same total units, same prices, a different split of what sold. What did the blend do?

Get those three sentences straight in plain English and the math is bookkeeping. Skip them and you’ll produce numbers you can’t explain to the person who asked.

Work it on two products

Say a company sells a basic product and a premium one. Two periods, same unit of measure throughout.

	Prior	Current
Basic: price × units	$50 × 300 = $15,000	$52 × 350 = $18,200
Premium: price × units	$100 × 100 = $10,000	$110 × 150 = $16,500
Total revenue	$25,000	$34,700
Total units	400	500

Revenue grew $9,700, up 38.8%. That’s the number the three effects have to explain.

Price. Take each product’s price change times its current units, then sum. Premium: ($110 − $100) × 150 = +$1,500. Basic: ($52 − $50) × 350 = +$700. Price effect = +$2,200.

Volume. First get the base average price, which is just prior revenue over prior units: $25,000 ÷ 400 = $62.50. Then value the change in total units at that blended rate: (500 − 400) × $62.50 = +$6,250. This is pure “we sold 100 more units” at last period’s average price.

Mix. Take what’s left: $9,700 − $2,200 − $6,250 = +$1,250.

That last move makes a lot of people nervous, so prove it from first principles. If those 500 current units had split in the old proportions (premium 25%, basic 75%), you’d have sold 125 premium and 375 basic. You actually sold 150 and 350. Value each deviation at prior prices: premium (150 − 125) × $100 = +$2,500; basic (350 − 375) × $50 = −$1,250. Net mix = +$1,250. Same number. The residual wasn’t a plug. It was the real economic effect of the premium product’s share rising from 25% to 30%, pulling the blended price up.

Price +$2,200, volume +$6,250, mix +$1,250 = +$9,700. Ties out.

The story for your boss is one sentence: growth was volume-led, but pricing discipline added $2,200 and a richer mix added another $1,250, because the premium line grew faster than the basic one.

Mix is where you lie to yourself

Here’s the part that separates a real analysis from a number that looks right.

I computed mix as the residual. That’s normal and fine. But it means every error in your price and volume math doesn’t disappear. It lands in mix.

A huge, unexplained mix line almost always means your price math is wrong.

So when mix comes out enormous and you can’t tell a story about which products shifted share, don’t ship it. Go back and prove mix from the share-deviation method above. If the two don’t match, the residual is hiding a mistake.

The deeper trap is convention. The formula I used values each price change at current volume, which folds the price-times-volume cross-term into the price line. Other sources value price at prior volume, or compute mix directly. None of these is wrong, but they hand you different-sized lines, and if you mix two conventions in one model, the cross-term gets counted twice or not at all and your three effects stop summing to the total. Pick one convention, write it down, and confirm it reconciles. Before you publish a formula as “the” formula, ask whoever owns the reporting standard which treatment the company uses.

A few more things that break the math: a single company-wide average price instead of per-product prices erases mix entirely, which defeats the exercise. Mismatched units of measure (some products in each, some in pounds) make per-unit price meaningless and the mix number nonsense. New and discontinued products have no comparable prior or current price, so they break the standard formula. Bucket those separately rather than jamming them into mix.

And know which question you’re answering. A positive price effect on revenue can be wiped out by rising costs, and “higher revenue” mix is not the same as “higher margin” mix. If your boss cares about margin, run the same decomposition on gross margin, not the top line.

Start with one quarter, two products

Don’t build the all-SKU (stock-keeping unit) version first. Take two products, two clean periods, and the convention above. Compute all three effects, then prove mix two ways. When the residual and the share-deviation method give you the same number, you understand the engine. Scale it after that.

Three numbers, one identity, tied to the penny. If they don’t sum, you’re not done.