Every budget is a forecast, and every forecast is wrong to some degree. Variance analysis is how finance teams measure exactly how wrong, and more importantly, why. Done well, it turns a spreadsheet of numbers into a clear story about what actually happened in the business this month, and what to do about it next month.
Quick Answer: What Is Variance Analysis?
Variance analysis compares actual financial results to budgeted or forecasted amounts to identify differences (variances) and understand their causes. The basic formula is:
Variance ($) = Actual − Budget
Variance (%) = (Actual − Budget) ÷ Budget
A variance is favorable if it improves profit (higher revenue or lower expenses) and unfavorable if it reduces profit (lower revenue or higher expenses).
On this page
The Basic Variance Formula
Variance ($) = Actual − Budget Variance (%) = (Actual − Budget) ÷ Budget
That is the entire mechanical calculation. The real skill in variance analysis is not the subtraction, it is correctly interpreting whether a given variance is good news or bad news, and digging into why it happened.
Favorable vs. Unfavorable Variance
A positive number is not automatically good news, and a negative number is not automatically bad news. It depends entirely on whether the line item is revenue or an expense.
| Line item type | Actual above budget | Actual below budget |
|---|---|---|
| Revenue | Favorable | Unfavorable |
| Expense (COGS, opex) | Unfavorable | Favorable |
Many spreadsheets simply show Actual minus Budget without flagging favorable or unfavorable, which leaves a reader to guess. Always label the direction explicitly, since a $50,000 expense overage and a $50,000 revenue shortfall look identical as a raw number but mean very different things operationally.
A Worked Example
| Line item | Budget | Actual | Variance ($) | Variance (%) | Favorable/Unfavorable |
|---|---|---|---|---|---|
| Revenue | $500,000 | $480,000 | -$20,000 | -4.0% | Unfavorable |
| Cost of goods sold | $300,000 | $276,000 | -$24,000 | -8.0% | Favorable |
| Gross profit | $200,000 | $204,000 | $4,000 | 2.0% | Favorable |
| Operating expenses | $150,000 | $162,000 | $12,000 | 8.0% | Unfavorable |
| Operating income | $50,000 | $42,000 | -$8,000 | -16.0% | Unfavorable |
Notice that revenue missed budget, yet gross profit actually beat budget, because cost of goods sold dropped even more than revenue did. Reading only the top line here would have led to the wrong conclusion. The real story only appears once every line is broken out.
Price Variance vs. Volume Variance
A single revenue or cost variance is really the combined effect of two separate things: how many units were involved, and what price or rate applied to each one. Splitting the total variance into these two pieces shows which one actually drove the miss.
Price Variance = (Actual Price − Budget Price) × Actual Volume Volume Variance = (Actual Volume − Budget Volume) × Budget Price
| Metric | Budget | Actual |
|---|---|---|
| Units sold | 10,000 | 9,600 |
| Price per unit | $50.00 | $50.00 |
Price Variance = ($50.00 − $50.00) × 9,600 = $0 Volume Variance = (9,600 − 10,000) × $50.00 = -$20,000
In this example, the entire $20,000 revenue shortfall came from selling fewer units, not from a pricing problem. That distinction changes the conversation completely, from "why did we discount too much" to "why did demand fall short."
Flexible Budget Variance
A static budget compares actual results to a single fixed plan set at the start of the year. A flexible budget instead adjusts the original plan to reflect the actual volume achieved, then compares actual results to that adjusted version. This isolates true cost control or efficiency performance from variance that is simply a byproduct of selling more or less than originally planned.
If a company sells 20% more units than budgeted, its costs of goods sold should naturally rise too. Comparing actual COGS to the original static budget would show a large unfavorable variance that has nothing to do with poor cost control, it is simply a function of higher volume. A flexible budget variance strips that effect out.
Writing Variance Commentary
A table of numbers is only half the job. Most finance teams are expected to write a short explanation alongside each material variance. Good variance commentary follows a consistent pattern:
- State the variance and its direction in one sentence.
- Identify the primary driver: price, volume, timing, or a one-time item.
- State whether the driver is expected to continue or was a one-time event.
- Recommend an action, if one is needed, or state that no action is required.
Example: "Revenue missed budget by $20,000 (-4.0%), driven entirely by lower unit volume rather than pricing. Order volume from the Northeast region was down due to a distributor's delayed reorder, now confirmed for early next month. No pricing action is recommended."
Setting Materiality Thresholds
Not every variance deserves equal attention. Most companies set a materiality threshold combining both a dollar amount and a percentage, such as investigating any variance over 10% and over $5,000. This prevents wasting time on immaterial line items while ensuring large dollar variances get examined even if their percentage is small.
Relying on percentage alone can cause small, immaterial line items to trigger unnecessary investigation while large dollar variances on big line items go unexamined. A combined threshold (e.g., "investigate if variance > 10% AND > $5,000") balances both concerns.
Common Mistakes to Avoid
| Mistake | The Fix |
|---|---|
| Reporting variance without labeling favorable or unfavorable | Always flag the direction explicitly, since the same raw number means different things for revenue vs. expenses. |
| Chasing percentage variances on immaterial line items | Set a combined dollar and percentage threshold for what actually gets investigated. |
| Ignoring large dollar variances that show a small percentage | A 3% variance on a $2 million revenue line is $60,000, often far more material than a 40% variance on a small line item. |
| Comparing actuals only to a static budget | Use a flexible budget view to strip out volume-driven cost variances that have nothing to do with cost control. |
| Writing commentary that restates the number | "Revenue was below budget" is not commentary. Name the driver and recommend an action, or state that no action is needed. |
Key Takeaways
- Variance equals actual minus budget, but whether that number is good or bad depends entirely on whether the line is revenue or an expense.
- Splitting a variance into price and volume components reveals whether a miss was caused by pricing decisions or by demand.
- A flexible budget removes the distortion caused by actual volume differing from the original plan.
- Set a combined dollar and percentage threshold for what variances actually warrant investigation.
- Good variance commentary names the driver and recommends an action, not just the number itself.
Frequently Asked Questions
What is the formula for variance analysis?
Variance equals actual results minus budgeted results. Variance percent equals the variance divided by the budgeted amount. Whether a positive or negative variance is good or bad depends on whether the line item is revenue or an expense.
What is the difference between a favorable and unfavorable variance?
A favorable variance improves profit, such as revenue coming in above budget or expenses coming in below budget. An unfavorable variance reduces profit, such as revenue below budget or expenses above budget.
What is the difference between price variance and volume variance?
Price variance measures the impact of a change in the rate or price per unit, holding volume constant. Volume variance measures the impact of a change in the number of units sold or produced, holding price constant. Splitting a total variance into these two components shows whether a miss was caused by pricing or by demand.
How large does a variance need to be before it is worth investigating?
Most companies set a materiality threshold combining both a dollar amount and a percentage, such as investigating any variance over 10 percent and over a specific dollar value. Relying on percentage alone can cause small, immaterial line items to trigger unnecessary investigation while large dollar variances on big line items go unexamined.
What is a flexible budget variance?
A flexible budget adjusts the original budget to reflect the actual volume achieved, then compares actual results to that adjusted budget. This isolates true cost or efficiency performance from variance that is simply caused by selling more or less than originally planned.
Who typically performs variance analysis in a company?
Variance analysis is a core responsibility of FP&A analysts and financial analysts, though department managers are often asked to explain variances specific to their own budget lines.
Related Articles
External References
- Corporate Finance Institute. "Variance Analysis Guide." corporatefinanceinstitute.com
0 Comments