Budget vs Actual Variance Narrator

What it does

It turns an actual-vs-budget table from "did the number hit?" into a narrative of why it hit/missed and who must act. The core discipline is Horngren flexible-budget variance decomposition: total static-budget variance is first split into (a) Sales-Volume Variance = (Actual volume − Budget volume) × budget unit contribution and (b) Flexible-Budget Variance = Actual − flexible budget; then (b) is broken into Price/Rate = (Actual price − Std price) × Actual qty and Efficiency/Quantity = (Actual qty − Std qty) × Std price. So "is it price, volume, or efficiency?" is answered with a number, not an opinion.

For multi-product / multi-currency revenue a Price-Volume-Mix (PVM) bridge isolates Price, Volume, Mix and FX effects and surfaces hidden stories like "revenue held but we shifted to a lower-margin product." Every driver is a step in a Variance Bridge / Waterfall, and the steps must tie out to net variance — any unexplained balance goes to gaps, never hidden.

When to use it

Post-close monthly/quarterly budget-actual reporting, forecast-revision justification, board-pack executive summaries, or cost-center variance reviews — whenever a total variance is visible but "is it truly favorable, driven by what, is it sustainable, how do I explain it to leadership?" is unanswered. Especially where strong volume can mask price erosion, or where a "+%" on an expense line can be misread on direction (F/U).

Method / frameworks

• Flexible-Budget Variance Decomposition (Horngren, Datar & Rajan, Ch. 7-8) — canonical volume/price/efficiency split.
• Price-Volume-Mix Bridge (CIMA / IMA) — Price+Volume+Mix+FX decomposition; under 25% of mid-market firms apply it systematically.
• Driver-Based FP&A (AFP / FP&A Guide) — explains variance at the operational driver, not the GL line.
• Materiality & Exception Filtering — typical rule |variance| ≥ 5% AND ≥ dollar floor; Management-by-Exception.
• 5 Whys + Permanent/Timing Triage (Beyond Budgeting / rolling forecast) — permanent variances revise the forecast; timing/phasing closes in YTD.
• Budget Variance Health Score (0-100) — weighted on net variance size, permanent-U load, tie-out explainability, forecast impact and data quality; reported with a confidence level.