Price, Volume, and Mix in a Distribution Forecast Review
You are the FP&A lead at a specialty industrial distributor. For Q3, the board-approved budget assumed revenue of $12.0 million, 92,000 units, an average selling price (ASP) of $130.43, and a 26.0% gross margin. Actual Q3 revenue was $11.4 million on 96,000 units, an ASP of $118.75, and gross margin of 22.1%. The sales vice president argues that volume grew 4% and the shortfall is “just pricing.” Product mix has shifted: family A, the higher-margin line with a budget ASP of $160, was 45% of budgeted units but only 35% of actual units; family B, with a budget ASP of $105, rose from 55% to 65%. Two competitors cut prices 8–10%, and you approved targeted discounts for the top 10 customers to defend share. The Q4 forecast still assumes budget ASP and historical mix. The CFO wants a one-page variance story and a recommendation on whether to revise full-year guidance.
1. Decompose the $0.6 million revenue shortfall into volume, price, and mix effects. Show your calculations and identify which components management can influence in Q4.
Read the worked answer
Use budget ASP as the volume baseline.
- Volume effect = (96,000 − 92,000) × $130.43 = +$0.52M.
- Total price/mix effect = actual revenue − (96,000 × $130.43) = $11.40M − $12.52M = −$1.12M.
- Check: +$0.52M − $1.12M = −$0.60M.
Separate mix at budget family prices: actual mix weighted ASP = 0.35 × $160 + 0.65 × $105 = $124.25; budget mix weighted ASP = 0.45 × $160 + 0.55 × $105 = $129.75. Mix effect = 96,000 × ($124.25 − $129.75) = −$0.53M. Pure price effect ≈ −$1.12M − (−$0.53M) = −$0.59M.
Management can influence price through discount governance and mix through sales incentives, availability, and customer targeting. Volume is harder to move within one quarter, so the Q4 plan should not rely on further volume upside to offset price/mix.
2. Evaluate the sales VP's claim and recommend whether to revise Q4 ASP and mix assumptions. Quantify a specific adjustment and name two KPIs.
Read the worked answer
The claim is partly right and misleading. Volume rose 4.3% (96,000/92,000 − 1), adding about $0.52M, but price/mix destroyed $1.12M. Of that, roughly $0.53M is mix: family A fell from 45% to 35% of units, and A carries a $55 higher budget ASP than B. Calling the miss 'just pricing' hides a structural mix problem that also explains the gross-margin drop from 26.0% to 22.1%.
For Q4, do not hold budget ASP. If Q4 budget revenue is $12.0M, a 6% ASP reduction alone is about $0.72M; resetting mix to 38% A/62% B adds margin pressure. A defensible starting point is Q4 revenue of $11.3–11.5M and gross margin of 23–24%, with a downside case at 22%. Two KPIs: realized ASP by product family versus budget, and A-family share of units (or discount leakage: actual discount versus approved discount).
3. Write the headline and two supporting bullets for the CFO's one-page variance story, distinguishing timing from structural effects.
Read the worked answer
Headline: 'Q3 revenue miss is structural price/mix, not a volume shortfall; revise full-year guidance.'
- Volume added about $0.5M, but price/mix removed $1.1M; mix alone was about −$0.5M as family A fell 10 points. This is structural, not timing.
- Gross margin fell 390 bps to 22.1%, so the revenue miss understates the profit impact; Q4 still assumes budget ASP and historical mix, which is not supportable.
Add a timing note only for known items: if any large orders slipped into Q4, quantify them separately and exclude them from the structural reset. The one-pager should end with a decision request: approve revised Q4 ASP/mix assumptions and a guidance range, not a single point.