Accounting and FP&A · Explain performance
Budget vs. Actual Variance Analysis: Formulas, Examples, and Management Decisions
A variance report becomes useful when it explains what changed, why it changed, and what management should do next. Comparing actual results with a budget is the starting point. The analysis must distinguish volume, price, cost, timing, and measurement differences before drawing a conclusion about performance.
← Accounting · Month-End Close · Managerial Accounting
What is budget vs. actual variance analysis?
It is the comparison of recorded performance with an approved plan, followed by investigation of the important differences. The original budget supplies the accountability baseline. Actual results should come from a reviewed period with consistent account mapping, scope, and accounting basis.
Start after the monthly close, while keeping open reporting exceptions visible. An unrecorded bill can look like a favorable cost variance until the records are corrected. Updating a forecast is useful, but it does not erase the original budget comparison.
Choose a sign convention and keep it visible
| Line | Actual above budget | Actual below budget |
|---|---|---|
| Revenue | Usually favorable for revenue. | Usually unfavorable for revenue. |
| Expense, stated as a positive cost | Usually unfavorable for cost. | Usually favorable for cost. |
| Operating profit | Favorable for operating profit. | Unfavorable for operating profit. |
These labels describe the direction relative to plan, not whether the underlying decision was wise. Lower maintenance expense can reflect deferred repairs; higher revenue can come with discounts, poor collections, or unprofitable workload.
If a budget is zero, show the dollar difference and “not meaningful” for the percentage rather than dividing by zero. With negative budget values, use a clearly defined policy or emphasize the dollar bridge. Do not silently switch between actual-minus-budget and budget-minus-actual.
Worked monthly budget-to-actual report
Original hypothetical example: a single-product business budgeted 1,000 units at $100 each, variable cost of $60 per unit, and fixed operating cost of $25,000. Actual sales were 1,100 units at $98, variable cost was $62 per unit sold, and fixed cost was $26,000. Assume no inventory change or product mix, and that all costs are correctly classified within the relevant activity range.
| Line | Budget | Actual | Actual − budget | Variance % / label |
|---|---|---|---|---|
| Units sold | 1,000 | 1,100 | +100 | +10.0%; volume increase |
| Revenue | $100,000 | $107,800 | +$7,800 | +7.8%; F |
| Variable cost | $60,000 | $68,200 | +$8,200 | +13.7%; U for total cost |
| Contribution margin | $40,000 | $39,600 | −$400 | −1.0%; U |
| Fixed operating cost | $25,000 | $26,000 | +$1,000 | +4.0%; U |
| Operating profit | $15,000 | $13,600 | −$1,400 | −9.3%; U |
Revenue rose, yet operating profit fell. The $8,200 cost increase does not all represent overspending at the same activity level: the business sold 100 more units. A fairer cost diagnosis requires flexing the original assumptions to actual volume.
Separate volume from performance with a flexible budget
A static budget uses the planned activity level. A flexible budget recalculates the original rates at actual activity. Here, use 1,100 units with the budgeted $100 price, $60 variable cost, and $25,000 fixed cost. This preserves the original economics while changing the activity assumption.
| Line | Static budget | Flexible budget at 1,100 units | Actual |
|---|---|---|---|
| Revenue | $100,000 | $110,000 | $107,800 |
| Variable cost | $60,000 | $66,000 | $68,200 |
| Contribution margin | $40,000 | $44,000 | $39,600 |
| Fixed cost | $25,000 | $25,000 | $26,000 |
| Operating profit | $15,000 | $19,000 | $13,600 |
The additional volume would have added $4,000 of profit at the planned $40 unit contribution. Actual profit is $5,400 below the flexible budget. The combined effect is $4,000 favorable − $5,400 unfavorable = $1,400 unfavorable to the static budget.
Fixed cost stays unchanged in this flexible budget only because the example assumes the same relevant range and no additional step cost. Real businesses must model overtime, extra shifts, capacity limits, and other changes instead of forcing every account into a fixed or perfectly variable pattern.
Build a price, volume, and cost bridge
For this single-product example, the following bridge explains the entire change in operating profit. “F” increases profit relative to budget; “U” reduces it.
| Driver | Calculation | Profit effect |
|---|---|---|
| Volume at budgeted unit contribution | (1,100 − 1,000) × ($100 − $60) | +$4,000 F |
| Selling-price effect | ($98 − $100) × 1,100 | −$2,200 U |
| Variable cost per unit effect | −($62 − $60) × 1,100 | −$2,200 U |
| Fixed-cost spending effect | −($26,000 − $25,000) | −$1,000 U |
| Total profit variance | $4,000 − $2,200 − $2,200 − $1,000 | −$1,400 U |
Revenue alone bridges as $10,000 favorable volume at the budgeted price plus $2,200 unfavorable selling price = $7,800 favorable. Variable cost bridges as $6,000 higher expected cost for additional volume plus $2,200 above the flexible cost allowance = $8,200 higher total cost.
The $2 per-unit cost increase is an aggregate unit-cost effect. It does not establish whether purchasing price, labor rate, usage efficiency, waste, or mix caused the change. Detailed price/rate and quantity/efficiency analysis requires the relevant input quantities, hours, and standards. Do not label this entire difference “labor inefficiency” without that evidence.
Distinguish timing, recurring changes, and errors
- Timing: a planned campaign moved to next month. Verify the service period; an invoice arriving late for work already performed may require an accrual rather than a timing explanation.
- Recurring economics: a supplier raised unit prices or a new permanent position increased payroll. Assess the future run rate.
- One-time event: a supported repair or settlement may not recur, but its accounting and cash effects still matter.
- Volume or mix: workload changed, or the business sold a different combination of products. Normalize the comparison before assessing cost control.
- Data or accounting error: duplicates, missing accruals, wrong dates, and inconsistent mapping require correction, not an invented operating explanation.
Show monthly and year-to-date results together. A timing shift may reverse in the cumulative view; repeated “temporary” variances can reveal a more persistent problem.
Turn findings into management decisions
A useful explanation names the amount, driver, evidence, expected persistence, action, owner, and next review. Separate an observed fact from a hypothesis still being tested.
| Finding from the example | Evidence to obtain | Decision and accountability |
|---|---|---|
| Price is $2 below plan. | Invoices, discount approvals, customer and product mix. | Sales owner reviews discount causes and margin implications before the next pricing review. |
| Variable unit cost is $2 above plan. | Purchase rates, input quantities, labor hours, waste, and unit-cost mapping. | Operations and finance identify causes and revise the expected run rate if supported. |
| Fixed cost is $1,000 above plan. | Account detail and contract or invoice support. | Budget owner determines whether it is recurring, one-time, timing, or error and assigns the response. |
Do not assume that reversing every unfavorable variance is optimal. Extra spending may protect quality, meet demand, or build capacity. Compare expected benefits, cash timing, and risk before cutting the cost.
A reusable variance-analysis table
Set investigation thresholds before the review. Combining a dollar threshold with a percentage threshold can help prioritize, but significant control, ethics, liquidity, or compliance issues should still be escalated even if the amount is small.
After explaining performance, use Financial Ratios to assess broader financial relationships and Rolling Forecasts to update what comes next. Preserve the approved budget rather than overwriting it with the latest expectation.
Common mistakes
- Calling every positive number favorable.
- Comparing variable spending at different activity levels without flexing the budget.
- Calling missing accruals savings or treating all delayed invoices as future-period expenses.
- Explaining a difference with “higher costs” instead of identifying its cause.
- Adding bridge components that overlap or fail to reconcile to total profit variance.
- Using new forecast values as if they were the original approved budget.
Frequently asked questions
What is the budget variance formula?
This guide uses actual minus budget. Divide that difference by a meaningful positive budget base for the percentage, then interpret the sign according to whether the line is revenue, cost, or profit.
Is a favorable expense variance always good?
No. It can reflect lower activity, missing entries, delayed work, or a service or quality tradeoff. Investigate the cause and resulting consequences.
What is the difference between variance analysis and forecasting?
Variance analysis explains differences against a reference plan or prior forecast. Forecasting updates the expected future outcome. The explanation should inform the new assumptions without erasing the historical comparison.
Continue learning
Review Fixed vs. Variable Costs, Contribution Margin, and KPIs. Return to Accounting or explore Finance.
Sources and example notes
- OpenStax: Prepare Flexible Budgets — activity-adjusted budget comparisons.
- OpenStax: Budgets and Goal Evaluation — interpreting actual, static, and flexible results.
The business scenario, calculations, report, bridge, template, and management recommendations are original educational illustrations. Their assumptions are deliberately simplified and are not performance benchmarks.