Variance analysis compares actual results with a budget, a forecast or a prior period, line by line, and explains each material difference. A variance is favourable when it helps profit, such as revenue above plan or costs below it, and unfavourable when it hurts. The point is the explanation and the action, not the arithmetic.
What is variance analysis?
Every month, finance teams set actual figures against what was expected. The most common comparison is budget vs actual, but actuals can also be compared with the latest rolling forecast or the same month last year. Each comparison answers a different question: are we on plan, has our view changed, are we growing.
A useful analysis does not stop at the gap. It breaks the gap into causes, such as selling fewer units, selling at a different price, a different product mix, a cost that rose or a cost that simply landed in a different month, and says what will be done about each one.
How is a variance calculated?
| Measure | Formula |
|---|---|
| Variance | Actual less budget (or forecast, or prior period) |
| Variance % | Variance divided by budget |
| Volume variance | (Actual volume less budget volume) times budget price |
| Price variance | (Actual price less budget price) times actual volume |
| Favourable or unfavourable | Favourable if it raises profit: income above plan, costs below it |
- Pick the comparisonBudget for accountability, forecast for the latest view, prior period for trend.
- Set thresholdsExplain only what matters, for example any line that moves by more than a set amount and a set percentage.
- Find the driversSplit each material variance into volume, price, mix and timing, and trace it to the company, project, supplier or customer behind it.
- Act and updateAgree an owner and an action for each, and carry what you learn into the next forecast.
What does a variance analysis look like?
Why does variance analysis matter for finance teams in the GCC?
Groups with several companies and currencies need variances explained at company level before the group total means anything, and exchange rate movements should be separated from operating performance. Seasonal periods that follow the Hijri calendar, such as Ramadan, move against Gregorian months from year to year, so a prior-year comparison can shift for timing reasons alone. Boards also want the explanation in writing, which is where FP&A turns numbers into decisions.
Questions people ask
What is the difference between a favourable and an unfavourable variance?
A favourable variance improves profit compared with the plan: more revenue or lower costs. An unfavourable one reduces it. A favourable cost variance can still be bad news, for example if a campaign that was meant to drive sales did not run.
Should we compare with the budget or the forecast?
Both, for different reasons. The budget holds managers to what was agreed at the start of the year. The forecast shows whether the latest view is still right and where the year will land.
How much variance needs an explanation?
Set a threshold that combines an amount and a percentage, so large lines are not explained for small percentage moves and small lines are not explained for large ones. Apply it consistently every month.