Budget vs Actual Variance Analysis: Where the Money Actually Went

Over-budget isn’t one problem — it’s a stack of smaller problems wearing one number. A variance analysis splits that number into price, volume, and whether you even budgeted the right volume at all.

When a project comes in “10% over budget,” the first instinct is to ask why. But a single percentage hides the real story: did you pay more per hour, use more hours, or simply plan on a volume that never happened?Budget vs actual variance analysisis the structured way to answer that question. It takes the gap between your budget and your actual results and decomposes it into components you can act on — instead of one scary number you can’t.

In this guide, you’ll learn what variance analysis is, how to decompose a variance into price and volume, why aflexible budgetis the only honest comparison, and how to set thresholds so you investigate what matters and ignore the noise. You’ll build the full analysis in a spreadsheet that flags each variance as favorable or unfavorable and tells you where to look first.

Quick Answer: What Is Variance Analysis?

Variance analysiscompares actual financial results to a benchmark (budget or forecast) and quantifies the deviation. The total difference is decomposed into components — most commonlyprice varianceandvolume (quantity) variance— so management can seewhatdrove the gap and whether that driver was controllable.

The three-way check is simple:Total Variance = Price Variance + Volume Variance + Mix Variance. If those parts don’t sum to the total difference, your calculation is wrong and you shouldn’t present it until it reconciles.

A variance itself is neither good nor bad — it’s the size and direction of the flag:

Favorable (F):actual revenue is higher than budget, or actual costs are lower than budget.
Unfavorable (U):actual revenue is lower than budget, or actual costs are higher than budget.

The critical rule of thumb:for cost items, favorable and unfavorable flip versus revenue. Actual cost above budget is unfavorable; actual cost below budget is favorable. Apply the rule once and you’ll stop misreading half the column.

L2 — How Variance Analysis Works

Variance analysis works because it separates “we did less/more work than planned” from “we paid a different price for the work we did.” Those two causes demand completely different responses — you can’t fix a pricing problem by adding labor, or fix an efficiency problem by renegotiating rates.

The core decomposition uses two standard formulas:

Price Variance = (Actual Price − Budget Price) × Actual Quantity

Volume Variance = (Actual Volume − Budget Volume) × Budget Price

A worked example makes the logic clear. Suppose you budgeted 1,000 units at $50 each, and you actually sold 1,000 units at $53 each:

Price Variance = ($53 − $50) × 1,000 =$3,000 favorable(for revenue)

Now suppose you actually sold 1,100 units at the budgeted $50:

Volume Variance = (1,100 − 1,000) × $50 =$5,000 favorable(for revenue)

When you have multiple products or cost types,mix varianceisolates the effect of selling or consuming a different proportion than planned:

Mix Variance = (Actual Mix% − Budget Mix%) × Actual Total Volume × Budget Margin

The decomposition gets more granular for inputs. Material cost, for example, splits into:

Material Price Variance (MPV):AQp × (AP − SP) — the purchasing driver, owned by the purchasing manager.
Material Quantity Variance (MQV):SP × (AQ − SQ) — the usage driver, owned by the production manager.

Labor splits the same way intolabor rate variance(paying a different hourly rate) andlabor efficiency variance(using more or fewer hours). Overhead splits intovariable overhead rateandvariable overhead efficiencyvariances. Each component has a named owner, which is what makes the analysis actionable — you’re not asking “why is cost high,” you’re asking “purchasing or production?”

L3 — Static vs Flexible Budget: The Comparision That Isn’t Cheating

The single most common error in any variance report is comparing actual results to astatic budget— the one you made at the start of the period for one planned level of activity. The problem: if your actual volume differs from planned for reasons that had nothing to do with efficiency, the static comparison blames cost control for a volume problem.

Aflexible budgetrebuilds your budget at the actual activity level. It shows the costs thatshould have been incurredat the level of work actually performed, which turns the comparison into an “apples to apples” cost check.

A flexible budget has two steps:

Variable cost line:scales with activity (e.g., materials, direct labor, fuel).
Fixed cost line:stays constant within the relevant range of activity (e.g., rent, supervision, depreciation).

A complete performance report then separates two questions:

Sales-activity variance— the part caused by hitting a different sales/work volume than planned (compare static budget vs flexible budget at actual level).
Flexible-budget variance— the part caused by non-volume effects like efficiency and price (compare actual results vs flexible budget at actual level).

Without a flexible budget, inefficiencies and volume changes are blended into one number and you can’t isolate either. This is the difference between “we were 10% over budget” and “volume was 3% of it, efficiency was 6% of it, and rates were 1% — a completely different set of actions follows.”

L4 — How to Run It in a Spreadsheet

Build the analysis in six columns and let formulas do the rest:

Budget line:for each line item, enter budget quantity, budget price/rate, and budget total.
Actual line:enter actual quantity, actual price/rate, and actual total.
Total variance:=Actual Total − Budget Total, with a note of F or U.
Price variance:=(Actual Price − Budget Price) × Actual Quantity.
Volume variance:=(Actual Quantity − Budget Quantity) × Budget Price.
Reconciliation row:confirm Price + Volume ( + Mix) = Total Variance; if not, a formula is wrong.

Setmateriality thresholdsso you report what matters. A common baseline for a mid-size project:

Revenue line item: flag at>5% or >$10Koff budget.
Expense line item: flag at>10% or >$5Koff budget.
Net-income impact: flag at>2%for CFO commentary.

Adjust these for the size of your project — a $50K project and a $5M project need different floors. The point of a threshold is to stop the report from screaming about a $300 variance and ignoring a $30,000 one.

Worked Example: A 3-Week Consulting Engagement

You budgeted 160 billable hours at $150/hour in the planning sheet. Here is what happened at the end of the month:

Line	Budget Qty	Budget Rate	Actual Qty	Actual Rate	Budget Total	Actual Total
Billable hours	160	$150	165	$155	$24,000	$25,575

Price variance:($155 − $150) × 165 =$825 unfavorable(revenue should have beenhigher, so the shortfall on the price side is unfavorable).
Volume variance:(165 − 160) × $150 =$750 favorable(you billed more hours).
Reconciliation:$750 F + $825 U =$75 unfavorable total, which matches $25,575 − $24,000 = $575… wait — that doesn’t reconcile.

That is exactly the trap. The correct reconciliation splits therevenueside: the total revenue variance is $25,575 − $24,000 =$1,575 favorable(you billed $1,575 more than planned). Price variance of $825 is favorable for revenue (you earned more per hour), and volume of $750 is also favorable. Together: $825 F + $750 F =$1,575 F. That reconciles.

The lesson:for revenue, price and volume above plan are both favorable; for costs, they flip direction.Label the column’s perspective (revenue vs cost) before you call anything F or U, and the reconciliation will always close.

L5 — Common Mistakes, Limitations & FAQ

Common Mistakes (and How to Catch Them)

Comparing to the static budget only.Isolate volume and flexibility before judging cost control — otherwise you punish the team for a volume change nobody controlled.
Labeling F/U without naming the perspective.A cost that’s favorable and a revenue item that’s favorable point in opposite directions. State “revenue” or “cost” on every flagged line.
Presenting unreconciled variances.If Price + Volume doesn’t equal Total, stop and fix the formula. An unclosed total signals a data or formula error, not a finding.
Investigating every nickel.Without materiality thresholds, the report buries the $30K overrun under twelve $300 flags. Threshold first, then investigate.

Limitations

Standards can be stale.Price and quantity standards come from BOMs and time studies; if the base inputs are outdated, the variances flag noise, not problems.
Volume variance isn’t always controllable.Sales-activity variance is often market-driven; attributing it to cost control misleads management.
Allocation methods distort.A shared overhead base can push variance onto projects that did not cause it — pair variance analysis with a sane allocation base (see overhead allocation).

FAQ

Is “favorable” always good?No. Favorable means “better than the benchmark” — for costs that’s lower spending, for revenue that’s higher sales. A favorable material price variance can hide a quality drop, so direction alone isn’t a verdict.

What’s the difference between a price variance and a quantity variance?Price variance isolates the rate you paid holding volume constant; quantity variance isolates the volume/usage holding price constant. They answer “did we pay too much?” versus “did we use too many?”

Why can’t I just compare actual to my original budget?Because a static budget can’t separate volume effects from efficiency effects. A flexible budget at the actual activity level gives the honest cost comparison.

Who owns a variance?The named owner by driver: purchasing owns material price variance, production owns material quantity and labor efficiency variance, HR/payroll owns labor rate variance. Naming the owner is what turns a number into an action item.

Should I analyze variances during or after the project?Both. Monthly variance analysis catches drift early enough to correct it; a final post-mortem variance explains the total. The method is identical — only the action window differs.

Conclusion

Budget vs actual variance analysisturns a scary one-line number into a stack of named, owned, fixable components. The discipline is threefold: decompose into price and volume, compare against a flexible budget at the actual activity level, and enforce materiality thresholds so the report tells you where to look. Build the six-column worksheet, keep the reconciliation honest, and you’ll spend your attention on the 30K overrun instead of the twelve $300 flags.

If you track revenue and cost in a single place, abudget planner templategives you the monthly structure to feed this analysis. Pair it with anexpense trackerso the “actual” side of the equation is clean before you ever compute a variance. Everything starts with data you trust —Use Office Toolkithas the sheets to get you there.