Price, volume and mix variance

Enter budget and actual units and price per product line. You get the revenue variance split into price, volume and mix, per line and in total, with the check column that proves the three reconcile. Favourable is positive throughout.

Product lines
LineBudget unitsBudget priceActual unitsActual price
Price can be an average realised price for the period. Use the same period for budget and actual, year to date or a single month.
The workbook: the whole budget cycle, not just the varianceFP&A Budget vs Actual and Rolling Forecast, $59: driver-based budget, actuals, this decomposition per line with the check column, a rolling forecast with scenario multipliers and a dashboard.
See the workbook

Method, per line: price effect = actual units x (actual price minus budget price); volume effect = budget price x (actual units minus budget units). Mix is a portfolio effect, computed as the sum of the line volume effects less the total unit change valued at the budget average revenue per unit, so that price, volume and mix reconcile to the total revenue variance. The check column is total variance less the three effects and should read zero. Same formulas as the Bindler FP&A workbook. Not financial advice.