01 / VOLUME
How many units?
See how selling more or fewer units moves revenue, with product-level detail.
Four revenue drivers
A variance is the start of the conversation.
Separate the change into factors your finance, sales and product teams can investigate and act on.
02 / PRICE
At what price?
Model price changes and test how much volume can shift before the increase stops paying for itself.
03 / MIX
Which products?
Understand how a different combination of products can change revenue even when total units hold steady.
04 / TIMING
Which period?
Separate a real sales loss from revenue that moved into another period, such as a delayed order.
How it works
Bring your own baseline. Ask a better what-if.
The workbook starts with example products and figures so you can follow the method. Replace them with your own inputs, then build scenarios one lever at a time.
The included figures are illustrative examples. Once you enter your company’s information, handle the workbook as confidential business data.
1
Set the baseline
Enter your products, baseline units, price per unit, company, period and baseline label.
2
Set the scenario
Change global or product-level volume and price, adjust mix, and enter timing units where revenue moves between periods.
3
Read the bridge
Review the dashboard’s baseline-to-scenario bridge, driver commentary and sensitivity grid. The calculation reconciles to the scenario total.
Revenue bridge summaryILLUSTRATIVE VIEW
| Driver | Question | Bridge |
|---|---|---|
| Baseline revenue | What was planned? | Start |
| Volume | Units sold | Change |
| Price | Price per unit | Change |
| Mix | Product share | Change |
| Timing | Period shift | Change |
| Scenario revenue | What-if result | Reconciled |
Workbook tabs: Inputs · What-If · Dashboard · Bridge
Inside the workbook
From one headline number to a useful explanation.
The model is designed for finance and FP&A teams to explore their own revenue movements without losing the line-by-line calculation.
- ✓Inputs for up to 25 products, with baseline units and price.
- ✓Optional global and product-level volume and price changes, plus mix and timing inputs.
- ✓A dashboard with revenue bridge, plain-language commentary and price/volume sensitivity grid.
- ✓A product-by-product bridge and reconciliation check behind the dashboard.
- ✓Example scenario for practicing the workflow; replace the sample values with your own.
Want to discuss the method?
Request a variance bridge walkthrough and suggest the days and times that suit you.
Next step
Request a Variance Bridge Walkthrough
Tell us your name, work email, country, and the days and times that work for you in your own time zone. Dan will follow up to confirm a time.
Read “Beyond 8% Behind Budget”