Actual vs Budget

Computing variance and percent variance against the plan

Budgeting & FP&AVariance Analysis & BridgesFree preview
⏱️ About 14 min
Actual vs Budget — illustration

A budget is a promise; the variance is how far reality landed from it. Two numbers - the dollars and the percent - tell the whole story.

💡
The big idea: Variance is Actual minus Budget, and percent variance scales that gap by the budget so it is comparable across lines of any size. The sign says whether actual beat or missed the plan.
🎯 By the end, you'll be able to
  • Compute variance as Actual minus Budget.
  • Compute percent variance as Variance divided by Budget.
  • Interpret the sign and size of a variance against the plan.
📎 Helpful to know first

Comfort with basic arithmetic and percentages; no finance background required.

Two numbers that measure the gap

The variance is how far the actual result landed from the budget: $Variance = Actual - Budget$. To make that gap comparable across line items of very different sizes, percent variance scales it by the budget: $\%Var = \frac{Actual - Budget}{Budget}$. The sign says whether actual beat the plan (positive) or missed it (negative); the percent says how big the gap is relative to what was planned.

\[ Variance = Actual - Budget \qquad \%Var = \frac{Actual - Budget}{Budget} \]

Reading the formula

$Actual - Budget$ is the dollar gap, positive when actual exceeds the plan and negative when it falls short. Dividing by $Budget$ turns that dollar gap into a percent, so a $80,000 variance on a $1,000,000 budget (8%) can be compared with a $8,000 variance on a $100,000 budget (also 8%). Always divide by the budget - the plan you are measuring against - never by the actual.

⚠️ Divide by the budget, not the actual

Percent variance always divides by the Budget, because the budget is the plan you are measuring against. Dividing by Actual would shrink the gap as performance improves and hide misses; dividing by Budget keeps the comparison honest across periods and line items.

🎮 Actual vs Budget Variance LIVE
Predict first: Predict first: with a $1,000,000 budget and actual revenue of $1,080,000, what are the variance and the percent variance?
Set the budget and actual to watch the variance and percent variance update.
📝 Worked example: Northwind Tools budgeted revenue of $1,000,000 and earned actual revenue of $1,080,000. Compute the variance and the percent variance.
  1. 1. Variance = Actual - Budget = 1,080,000 - 1,000,000 = $80,000.
  2. 2. %Var = Variance / Budget = 80,000 / 1,000,000 = 0.08 = 8%.
✓ Variance = +$80,000; %Var = +8%
✏️ Practice: A budgeted expense of $600,000 comes in at an actual $648,000. Compute the variance and the percent variance.
💡 Hint
Variance = Actual - Budget = 648,000 - 600,000; %Var = variance / 600,000.
Answer
Variance = 648,000 - 600,000 = +$48,000; %Var = 48,000 / 600,000 = +8%

Check your understanding

1. What is the variance if actual revenue is $1,080,000 and the budget was $1,000,000?
Variance = Actual - Budget = 1,080,000 - 1,000,000 = +80,000.
2. How is percent variance defined?
Percent variance divides the variance by the budget.
✅ Key takeaways
  • Variance = Actual - Budget; percent variance = Variance / Budget.
  • A positive variance means actual exceeded the plan; read the sign first.
  • Percent variance sizes the gap relative to the budget, so it is comparable across line items.
➡️ We can measure a single variance against the budget. Next we decompose a total variance into a volume effect and a price effect with a bridge.
Ready for the next step? Back to the course outline →