Variance Calculation

Please purchase the course before starting the lesson.

A common problem is how a percentage variance is calculated. For example

Variance

Notice that even though conceptually a decrease in fixed costs is a good thing, the normal maths of the percentage difference indicates a -7%.

Back to: Budgeting and Forecasting with Excel Course > Comparing Budgets and Forecasts to Actuals