Price / Volume / Mix Bridge
ReasoningRevenue or margin moved — but why? Enter what you sold in two periods, line by line, and it splits the change into the three things that actually cause it: price (you charged more or less), volume (you sold more or fewer units), and mix (you sold a different blend of products). Add unit costs and it does the same for gross profit, isolating a cost effect too. New and dropped lines are handled cleanly, the bridge always ties out to the penny, and the download recomputes every effect as a live Excel formula. The decomposition QuickBooks won't do for you.
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%
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.
Get my free report →