Price / Volume / Mix Bridge
ReasoningRevenue or margin moved — but why? It splits the change into price, volume, and mix, ties to the penny, and does gross profit too. The one QuickBooks won't do.
Revenue change
+$41,100
+21.5% · $191,500 → $232,600
Gross profit change
+$19,790
+18.7% · $106,000 → $125,790
Gross margin change
−1.3 pts
55.4% → 54.1%
Best built on a bigger screen
This calculator is a wide, multi-column grid — open it on a laptop or desktop to fill it in comfortably. You can still download the Excel below and build it there.
What moved revenue
Revenue rose +$41,100, driven most by volume (+$16,852). volume added $16,852; price added $12,700; mix added $11,548. A positive mix means you sold more of your higher-value bags.
Your two periods
| Product / line | Last year | This year | Δ Rev | |||||
|---|---|---|---|---|---|---|---|---|
| Units | Price | Cost | Units | Price | Cost | |||
$ | $ | $ | $ | −$4,000 | ||||
$ | $ | $ | $ | +$27,000 | ||||
$ | $ | $ | $ | −$1,700 | ||||
new | $ | $ | $ | $ | +$19,800 | |||
| Total | 12,500 | $15 | 13,600 | $17 | +$41,100 | |||
How to read it. Enter what you sold in two periods — units, price, and (optionally) unit cost per line. Price is the price change on lines you sold in both periods. Volume is selling more or fewer total bags at your old average price. Mix is the rest — shifting toward higher- or lower-value bags, plus any new or dropped lines. The three always add up to the change exactly, and the download recomputes every effect as an Excel formula.
Want this on your real numbers? Wauvel builds it straight from your QuickBooks.
Meet your AI CFO →