Budget Variance Analysis: A Step-by-Step Method

Budget variance analysis is the process of comparing actual results with the budget, working out why they differ and deciding what to do about it. Done well, it takes a table of numbers and turns it into three things: an explanation of what happened, a view of whether it will continue and a decision. Done badly, it produces a spreadsheet with red and green cells and a comment that says "higher than expected". This guide gives a step-by-step method, including how to split a variance into price and volume effects, with a worked example. It is the foundation for the techniques in variance analysis formulas and price-volume-mix analysis, and part of budgeting and forecasting.

The method in nine steps

1. Fix the conventions. Decide how variances are signed and how they are labelled.
2. Compare like with like. Make sure the budget and actuals use the same accounts, periods and definitions.
3. Calculate the variances in dollars and percent, for the month and year to date.
4. Apply materiality to decide which variances need explanation.
5. Break material variances into components, such as volume, price, mix, rate and efficiency.
6. Find the cause by talking to the people closest to the activity.
7. Classify the variance as timing, permanent, one-off or error.
8. Decide the action and update the forecast.
9. Write the commentary and report.

Step 1: Fix the conventions

State once, at the top of every report, how you sign variances. Two common conventions:

The first is easier for managers because positive always means good. Use it unless your company has a strong reason not to, and label each variance "F" or "U" (favorable or unfavorable). See favorable vs. unfavorable variances.

Step 2: Compare like with like

Check that:

• The budget is loaded by month, and the actual period matches.
• Account groupings are identical.
• Any reclassifications during the year are applied to both.
• One-time items are identified, so they do not distort the underlying picture.

Many variances turn out to be mapping errors. Fix those first.

Step 3: Calculate the variances

For every line, compute:

Variance ($)  = Actual - Budget        (for revenue; reverse for cost to give favorable positive)
Variance (%)  = Variance ($) / Budget

Do this for the month, year to date and the full-year forecast versus budget.

Step 4: Apply materiality

Not every variance deserves a conversation. Set thresholds in dollars and percent.

Review the thresholds each year. They should be low enough to catch real issues and high enough to avoid noise.

Step 5: Break the variance into components

The total variance on a line often hides several effects. The most common split for revenue is price and volume. For costs, it is rate (price) and usage (efficiency).

Worked example: revenue

A hypothetical product line has a monthly budget of 4,000 units at $50, or $200,000. Actual sales were 3,800 units at an average price of $49.50, or $188,100.

Most of the shortfall comes from volume. The price effect is small, but worth asking about: did a discount creep in? If mix is involved (several products at different prices), a third component is needed. See price-volume-mix analysis.

Worked example: materials cost

The standard is 2 kg of material per unit at $8 per kg. Actual output was 3,800 units. Actual usage was 7,750 kg at $8.20 per kg.

Notice that the comparison uses the standard for the actual output (7,600 kg), not the original budget for 4,000 units (8,000 kg). Comparing actual cost for 3,800 units against a budget for 4,000 would show a favorable variance and hide the true overrun. This is why flexible budgets matter. See flexible budgets.

Step 6: Find the cause

The numbers show where to look. People tell you why. Ask:

• What happened, specifically?
• When did it start? Is it continuing?
• Is it within the department's control?
• What do customers, suppliers or the market say?
• Does the same issue show up in other lines?

Give managers a short list of questions, not a blank page.

Step 7: Classify the variance

Classification determines what happens to the full-year forecast. A timing variance does not change it; a permanent one does.

Step 8: Decide the action

Variance analysis is only useful if it leads to a decision. For each material variance, choose:

• Accept: the variance is explained and acceptable.
• Correct: take action to bring results back (renegotiate, change process, adjust staffing).
• Re-plan: update the forecast and, if needed, change the plan.
• Investigate: more information is needed.

Assign an owner and a date.

Step 9: Write the commentary

A good comment is short and structured.

Revenue: $11,900 unfavorable (-6.0%).
Cause: Volume 200 units below budget (-$10,000) as one distributor delayed an order
to next month; average price $0.50 below budget (-$1,900) due to two promotional deals.
Timing or permanent: Volume is timing (order confirmed for April); price is permanent
for the quarter.
Action: Sales to hold promotional pricing to a defined end date; forecast unchanged
for full year.

Comments should name the cause, the type and the action. Reject comments that restate the number.

A complete mini-report

Check: materials flexed budget 3,800 × 2 × $8 = $60,800. Labor flexed budget 3,800 × 0.5 × $24 = $45,600. Variances as shown: 63,550 - 60,800 = 2,750; 49,000 - 45,600 = 3,400.

Tools

A spreadsheet with a pivot table is enough for a start. Build a template that pulls budget and actuals into the same structure, calculates variances and flags those above threshold. See budget vs. actual report: template and commentary tips.

The link to forecasting and unit economics

Variances feed the forecast: a permanent price variance changes the full-year outlook. Variances also reveal the underlying economics, such as a gross margin that is slipping because of mix or cost. See unit economics.

Common mistakes

• Comparing actuals with an unflexed budget.
• Explaining every variance equally.
• Not distinguishing timing from permanent.
• Writing comments that restate the number.
• Looking only at the total, which hides offsetting variances.
• Failing to turn the analysis into actions.
• Changing the budget to remove the variance.

Related guides

For the formulas in more depth, see variance analysis formulas, and for a complete treatment of price, volume and mix, see price-volume-mix analysis.

FAQs

What is budget variance analysis?

Comparing actual results with the budget, explaining the differences and deciding what to do.

How do you calculate a budget variance?

Actual minus budget for revenue, budget minus actual for costs (favorable positive), expressed in dollars and percent.

What is a flexible budget?

A budget adjusted to the actual level of activity, which allows a fair comparison with actual costs. See flexible budgets.

Which variances should be investigated?

Those above defined materiality thresholds in dollars and percent, and any that point to a trend.

How often should variance analysis be done?

Monthly, with a quarterly review of trends and the forecast.