Business & Accounting

Budget Variance: Formula, Meaning & Example

Budget variance measures the difference between an actual financial result and the amount originally budgeted or forecast for the same period.

Suppose a business budgets $500,000 of revenue but actually earns $540,000.

Budget Variance = Actual − Budget

= $540,000 − $500,000

= +$40,000

Revenue exceeded budget by $40,000.

For an expense, however, a positive actual-minus-budget number can be unfavorable because the business spent more than planned.

The arithmetic is simple. Interpretation depends on what is being measured.

Budget Variance Formula

A general formula is:

Budget Variance = Actual Amount − Budgeted Amount

Variance percentage:

Budget Variance % = (Actual − Budget) ÷ Budget × 100

These formulas produce signed results.

Whether a positive or negative result is favorable depends on the account.

Revenue Variance Example

Suppose:

Budgeted Revenue = $500,000

Actual Revenue = $540,000

Dollar variance:

+$40,000

Percentage variance:

$40,000 ÷ $500,000 × 100

= +8%

Revenue is 8% above budget.

Assuming the additional sales are economically desirable, this would usually be considered favorable.

Expense Variance Example

Suppose:

Budgeted Expense = $200,000

Actual Expense = $218,000

Using actual minus budget:

Variance = +$18,000

Percentage:

$18,000 ÷ $200,000 × 100

= +9%

The mathematical variance is positive, but the operational interpretation is generally unfavorable because expenses exceeded budget.

This is why reports should clearly distinguish the sign convention from the favorable/unfavorable label.

Favorable Expense Variance

Suppose:

Budgeted Expense = $200,000

Actual Expense = $185,000

Variance:

$185,000 − $200,000

= −$15,000

Percentage:

−7.5%

The negative numerical variance is favorable if lower spending achieved the intended operating result without causing other problems.

Profit Variance

Suppose:

Budgeted Profit = $80,000

Actual Profit = $95,000

Variance:

$95,000 − $80,000

= +$15,000

Percentage:

$15,000 ÷ $80,000 × 100

= 18.75%

Actual profit exceeded budget by 18.75%.

Budget Variance Does Not Explain the Cause

Suppose revenue is $40,000 above plan.

That could result from:

higher selling prices, higher unit volume, different product mix, new customers, currency effects, or a timing shift.

The variance tells management where actual results differed.

Further analysis determines why.

Price and Volume Variance

Suppose a business budgets:

5,000 Units at $100

Revenue budget:

$500,000

Actual results are:

5,200 Units at $105

Actual revenue:

$546,000

Overall revenue variance:

+$46,000

Part of the difference comes from higher volume, while another part comes from higher price.

Separating those drivers makes the variance more useful operationally.

Simplified Volume Effect

Using the budgeted price:

Volume Effect = (Actual Units − Budget Units) × Budget Price

(5,200 − 5,000) × $100

= $20,000 Favorable

The remaining difference is associated with price and interaction effects depending on the chosen variance framework.

Simplified Price Effect

Using actual units:

Price Effect = (Actual Price − Budget Price) × Actual Units

($105 − $100) × 5,200

= $26,000 Favorable

Together:

$20,000 + $26,000 = $46,000

This specific decomposition assigns the interaction to the price effect.

Other variance-analysis conventions can allocate interaction differently.

Fixed-Cost Variance

Suppose fixed operating costs were budgeted at:

$150,000

but actual cost is:

$158,000

Variance:

+$8,000 Unfavorable

Potential causes might include higher rent, unplanned professional fees, additional management salaries, repairs, or misclassification.

The variance should be traced to specific accounts rather than accepted as one unexplained total.

Variable-Cost Variance

Suppose variable costs were budgeted at:

$60 per Unit

for:

5,000 Units

Budget:

$300,000

Actual volume is 5,200 units with actual variable cost of $62 per unit.

Actual:

5,200 × $62

= $322,400

Simple total variance against the original static budget:

$322,400 − $300,000

= +$22,400

But part of the variance arises because more units were produced or sold.

A flexible budget can provide a more useful comparison.

Flexible Budget

A flexible budget adjusts expected variable costs for actual activity.

Using:

Budgeted Variable Cost = $60 per Unit

and:

Actual Volume = 5,200

Flexible-budget cost:

5,200 × $60

= $312,000

Actual cost:

$322,400

Flexible-budget variance:

$10,400 Unfavorable

This isolates the cost-rate or efficiency difference from the $12,000 of additional expected cost associated with producing 200 extra units.

Budget Variance and Capacity Utilization

Capacity utilization can explain some operating variances.

Suppose the budget assumes 70% utilization but actual utilization reaches 90%.

Higher output can produce favorable sales volume but also higher variable costs, overtime, maintenance, or production inefficiency.

A cost variance should therefore be interpreted alongside activity levels.

Budget Variance and Cash Accounting

Under cash accounting, a cash budget comparison can be heavily influenced by payment and collection timing.

Suppose budgeted cash receipts are:

$300,000

but actual receipts are:

$250,000

Cash receipt variance:

−$50,000

This may reflect lower sales, slower collection, or customer payments shifting into the next period.

The same accounting period could show a smaller revenue variance under accrual accounting.

Budget Variance and Balance Sheet

A balance sheet budget can compare planned and actual assets, liabilities, and equity.

Suppose budgeted accounts receivable is:

$120,000

but actual AR is:

$175,000

Variance:

+$55,000

If sales are close to budget, the large receivable variance can indicate collection delays rather than strong performance.

Budget Variance and Break-Even Sales

Suppose the budget expects break-even sales of:

$500,000

but actual cost conditions raise break-even sales to:

$560,000

Variance in required break-even revenue:

+$60,000

If actual sales are only $540,000, the company can miss profitability even though it exceeded the original break-even plan.

Updating break-even assumptions can therefore be part of meaningful budget control.

Budget Variance and Amortization Expense

Suppose budgeted amortization expense is:

$20,000

but actual amortization is:

$24,000

Variance:

+$4,000 Unfavorable for Accounting Profit

The variance may result from acquiring additional amortizable assets, changing useful-life estimates, or beginning amortization earlier than budgeted.

Because amortization is noncash in the recognition period, its cash-flow implication differs from a $4,000 cash expense overrun.

Materiality

Not every variance deserves equal management attention.

Suppose:

Office expense:

$500 Over Budget

Revenue:

$200,000 Under Budget

Both are unfavorable, but the second is likely far more significant.

Variance analysis is most useful when management prioritizes deviations based on size, risk, recurrence, controllability, and strategic importance.

Dollar Variance vs Percentage Variance

Suppose Account A is:

$10,000 Over a $1,000,000 Budget

Percentage:

1%

Account B is:

$5,000 Over a $20,000 Budget

Percentage:

25%

Account A has the larger dollar variance.

Account B has the larger proportional variance.

Both perspectives can matter.

Zero Budget Problem

Suppose an unplanned expense of:

$10,000

occurs against a budget of:

$0

Dollar variance is:

+$10,000

But percentage variance:

$10,000 ÷ $0

is undefined.

When the budget denominator is zero, report the dollar variance and explain the unplanned activity rather than forcing a percentage.

Negative Budget Values

Certain accounting lines can be negative, such as planned losses or contra accounts.

Standard percentage-variance formulas can become difficult to interpret when the denominator is negative.

In such cases, dollar variance and clearly defined management conventions are often more useful than a raw percentage.

Monthly Variance

Suppose monthly marketing budget is:

$20,000

Actual spending:

$23,000

Monthly variance:

+$3,000 Unfavorable

If annual marketing budget is $240,000, a one-month $3,000 overrun may still be manageable if later months offset it.

Monthly analysis should therefore distinguish timing differences from permanent annual overspend.

Year-to-Date Variance

Suppose six-month budgeted expense is:

$120,000

Actual:

$126,000

YTD variance:

+$6,000

Percentage:

5% Unfavorable

If the annual budget is $240,000, management can revise the forecast based on whether the six-month overrun is expected to continue.

Forecast vs Budget

A budget usually represents the approved plan.

A forecast is an updated expectation based on newer information.

Suppose budgeted annual revenue is:

$1,000,000

but after six months the latest forecast is:

$900,000

Actual results should still be compared with the original budget for accountability, while the updated forecast helps management plan future decisions.

The two comparisons serve different purposes.

Common Budget Variance Mistakes

A common mistake is labeling every positive variance favorable.

Another is comparing actual variable costs with a static budget without adjusting for activity.

Businesses can also focus on percentages while ignoring material dollar amounts, treat timing differences as permanent performance issues, or report variances without identifying the operational drivers behind them.

Frequently Asked Questions

What is budget variance?

It is the difference between an actual result and the amount budgeted for the same measure and period.

What is the formula?

Budget Variance = Actual − Budget

How do I calculate variance percentage?

(Actual − Budget) ÷ Budget × 100

Is a positive variance always favorable?

No.

What is a favorable revenue variance?

Actual revenue above budget is generally favorable, assuming the revenue is economically desirable.

What is a favorable expense variance?

Actual expense below budget is generally favorable when service levels and operations are not harmed.

What is a flexible budget?

It adjusts budgeted variable amounts to the actual activity level before comparing them with actual results.

Why separate price and volume effects?

They identify different causes of a revenue or cost variance.

What happens when the budget amount is zero?

Percentage variance is undefined; use the dollar difference and explanatory context.

Should variance be measured monthly or annually?

Both can be useful. Monthly results show emerging changes, while year-to-date and annual analysis provide broader context.

Is a budget the same as a forecast?

No. A budget is generally an approved plan, while a forecast updates expectations based on newer information.

Why investigate the cause of a variance?

The number shows that performance differed from plan; the cause determines what management should do about it.

Mehran Khan

Mehran Khan is the primary author at The Logic Library and CEO & Founder of One Digit Media. With 10+ years of experience in software engineering, SEO, and digital publishing, he uses a research-led approach to Logics, Maths, Tech, Formulas, Science, and AI.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button