Price Volume Mix Analysis: Formulas and a Revenue Bridge

Label each product i, and let P0 and Q0 be last period's price and units, and P1 and Q1 this period's. Then:

• Price effect: the sum across products of (P1 minus P0) times Q1. It asks what you gained or lost from charging different prices for the units you sold.
• Volume effect: total units this period minus total units last period, times last period's average price per unit. It asks what you gained from selling more units overall at the old average price.
• Mix effect: the change in revenue at old prices, minus the volume effect. It captures whether the extra units came from higher-priced or lower-priced products.

The three add up to this period's revenue minus last period's revenue. If your check does not tie to zero, a formula or a units row is wrong, so build the check before you interpret anything.

Say last period you sold 800 units of a Basic plan at $100 and 200 units of a Pro plan at $300, which is $140,000 of revenue. Suppose this period you sold 900 Basic at $105 and 220 Pro at $310, which is $162,700, so revenue rose by $22,700.

• Price effect: say you apply the formula to each plan: (105 minus 100) times 900 plus (310 minus 300) times 220, equals $6,700.
• Volume effect: total units rose from 1,000 to 1,120, and the prior average price was $140, so if you multiply the 120 extra units by $140 you get $16,800.
• Mix effect: suppose revenue at old prices rose by $16,000; subtracting the $16,800 volume effect leaves negative $800 for mix.

Check: if you add $6,700 and $16,800 and subtract $800, you get $22,700, which matches the revenue change. The mix effect is slightly negative because the lower-priced Basic plan grew faster than Pro. It is small here, but a large negative mix effect with rising revenue is a warning that growth is coming from your cheapest product.

For SaaS, treat each plan or segment as a product and customers or seats as units. Price then means average revenue per account within each plan, including discounts and usage charges. Volume means the number of customers, and mix means the shift between plans or segments.

Two limits matter. First, price, volume and mix do not capture churn and expansion the way an ARR bridge does, so use both views. Second, revenue mix is not margin mix. Median gross margin is 81 percent on subscription revenue and 30 percent on services¹, so a mix shift toward services can raise revenue and lower profit at the same time. Run the same bridge on gross profit to see it.

Use one tab for data and one for the bridge:

1. List products or segments in rows, with columns for prior price, prior units, current price and current units.
2. Add columns for prior revenue, current revenue and revenue at old prices (current units times prior price).
3. Compute the price effect per row, then sum it.
4. Compute total units in each period and the prior average price, then the volume effect.
5. Compute the mix effect as total change at old prices minus the volume effect.
6. Add a check row that compares the three effects to the total revenue change.
7. Chart the result as a waterfall from last period's revenue to this period's.

Add a line for new products and discontinued products, since they have no matching price in the other period. Keep them separate so they do not distort price effects. For the profit side of pricing decisions, see the price increase profit calculator, and for customer-level detail, the customer profitability worksheet.

Lead with the answer, such as "Revenue grew because volume rose while mix hurt us," and follow with the waterfall. Explain each bar in one sentence with the driver behind it: a list price increase, a promotion, a new plan launch or a shift in customer size.

Then state what you will do about it. If price is the main driver, ask whether it is repeatable. If volume is the driver, examine where the units came from. If mix is negative, decide whether to change packaging or sales incentives.

Keep the bridge in your regular reporting so trends show up. If you build these bridges often, compare tools in the planning software comparison.