Variance Bridges for FP&A: Price, Volume, Mix, FX & Cost Effects from Budget to Actual
Explain the gap between budget and actual: price, volume, mix, currency and cost effects that add up exactly, plus the bridge chart, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you explain a fictional kitchenware company's quarter from budget to actual, one checked formula at a time. You compute revenue variances and favourable flags with IFS, split them into price and volume effects that add up exactly and measure the interaction term. You separate pure volume from mix with the budget mix, bridge the gross margin with price, unit-cost, volume and mix effects, and restate revenue at budget rates to isolate the FX effect. You build a customer bridge with SUMIFS, flex the cost budget into volume and spending variances, flag material effects with ABS and IFS and finish with a waterfall chart.
Lessons
- Budget vs Actual by Product: Revenue Variance & Favourable Flags Pro
- Price & Volume Effects: Calculation Order and the Interaction Term Pro
- The Mix Effect: Budget Mix at Actual Volume, Pure Volume vs Mix Pro
- The Gross-Margin Bridge: Price, Volume, Mix & Unit-Cost Effects Pro
- The FX Effect: Constant-Currency Revenue and Underlying Growth Pro
- The Customer Bridge: New, Lost and Existing Customers Pro
- Flexed Budgets for Costs: Fixed vs Variable, Spending vs Volume Variances Pro
- The Bridge Chart: Waterfall, Materiality Flags & the Biggest Driver Pro