Variance Analysis That Drives Decisions
Go beyond "we missed budget" to understand why and what to fix. A practical guide to variance analysis that leads to action, not just explanation.
Last Updated: January 2025 | 14 min read
Key Takeaways
- •Variance analysis is only useful if it leads to understanding and action
- •Always decompose variances into volume, price/rate, and mix components
- •Focus on material variances that exceed your threshold (typically 5-10% or $10K+)
- •Ask "why" until you reach an operational cause, not just an accounting explanation
- •Distinguish one-time variances from trends that will continue
What Is Variance Analysis?
Variance analysis compares actual financial results to what you expected—typically your budget or forecast—and investigates the differences. It sounds simple, but most variance analysis stops too early to be useful.
The Typical (Useless) Analysis
"Revenue was $850K vs $900K budget. We were $50K unfavorable due to lower sales."
This tells you nothing actionable. Of course lower sales caused lower revenue. Why were sales lower? What are you going to do about it?
Useful Analysis
"Revenue was $850K vs $900K budget, a $50K unfavorable variance. Volume was down $30K (Customer A delayed their Q1 order to February). Price was down $20K (we offered discounts to win two competitive deals). The Customer A order is confirmed for February. The discounting trend needs review—we have offered below-list pricing on 4 of our last 6 deals."
Now you know what happened, why, and what might need to change.
The Purpose of Variance Analysis
Good variance analysis answers three questions: What happened? Why did it happen? Will it continue? If you cannot answer all three, you have not finished the analysis.
The Variance Analysis Framework
1. Calculate
2. Investigate
3. Understand
4. Act
Follow this systematic approach to analyze any variance, whether it is revenue, costs, margin, or any other financial metric.
Calculate the Variance
Start with the math: Actual minus Budget equals Variance.
Revenue: $850K - $900K = ($50K) unfavorable
Express as both dollars and percentage: ($50K) / $900K = 5.6% below budget
Apply Materiality Threshold
Not every variance deserves investigation. Apply your threshold.
Threshold: Investigate variances >5% or >$25K
This $50K (5.6%) variance meets the threshold—proceed with analysis
Decompose Into Components
Break the variance into its drivers: volume, price/rate, and mix.
Volume impact: Sold fewer units = ($30K)
Price impact: Lower average price = ($20K)
Mix impact: Product mix unchanged = $0
Total: ($50K) ✓
Identify Root Cause
For each component, ask "why" until you reach an operational explanation.
Volume down ($30K): Why? Customer A delayed order. Why? Their procurement process took longer than expected.
Price down ($20K): Why? Discounts on two deals. Why? Competitive pressure—both were contested by Competitor X.
Assess Continuity
Determine if this is one-time or a trend that will continue.
Volume: One-time—Customer A order confirmed for February. Expected to recover.
Price: Potential trend—this is the 4th discounted deal in 6. Needs monitoring.
Document Your Analysis
Write down the full analysis: variance, components, root causes, and continuity assessment. This creates accountability and lets you check next month whether your assessment was correct.
Types of Variances
Different variance types require different analysis approaches. Here are the most common decompositions.
Revenue Variance
Revenue variances decompose into three components:
| Component | What It Measures | Calculation |
|---|---|---|
| Volume | Impact of selling more or fewer units than planned | (Actual units - Budget units) × Budget price |
| Price | Impact of selling at higher or lower prices than planned | (Actual price - Budget price) × Actual units |
| Mix | Impact of selling different product proportions than planned | Difference in product/customer mix × respective prices |
Cost Variance
Cost variances (particularly for direct costs) decompose similarly:
| Component | What It Measures | Example |
|---|---|---|
| Volume/Usage | Using more or fewer inputs than standard | Used 10% more materials than expected per unit |
| Rate/Price | Paying more or less per unit of input | Material prices increased 5% from supplier |
| Efficiency | Taking more or less time/effort than standard | Labor took 12 hours vs 10 hours budgeted |
Margin Variance
Gross margin variance is the combination of revenue and cost variances:
- Sales volume effect: How much margin was gained or lost from selling more or fewer units?
- Sales price effect: How much margin was gained or lost from price changes?
- Cost rate effect: How much margin was gained or lost from cost per unit changes?
- Mix effect: How much margin was gained or lost from selling different proportions of products?
Asking the Right Questions
The math identifies what happened. The questions identify why. Keep asking until you reach an operational cause that someone can address.
The Five Whys in Practice
Example: COGS Variance
Variance: COGS was $20K over budget
Why? Material costs were higher than planned
Why? We paid more per unit for Component X
Why? Our primary supplier raised prices
Why? Commodity prices increased industrywide
Why? Supply chain disruptions from [external event]
Root cause identified: Commodity price increase affecting entire industry.
Options: (A) Find alternative suppliers, (B) Negotiate volume commitments, (C) Pass through to customers, (D) Absorb temporarily
Questions by Variance Type
Revenue Under Budget
- Which customers or products drove the miss?
- Was it fewer deals or smaller deals?
- Were there deals expected that slipped?
- Did we lose deals to competitors?
- Were prices lower than expected?
Costs Over Budget
- Which line items drove the overage?
- Were costs per unit higher or did we use more?
- Was this expected spend that was not budgeted?
- Are vendor prices higher than planned?
- Did efficiency or productivity decline?
Margin Compression
- Is it revenue-side or cost-side driven?
- Did we discount more than usual?
- Is product mix shifting to lower-margin items?
- Are input costs rising faster than prices?
- Is labor productivity declining?
When Analysis Is Inconclusive
- Is the data accurate and complete?
- Was the budget realistic to begin with?
- Are there timing differences (accruals, cutoffs)?
- Do we need to drill into more detail?
- Should we talk to the operational team?
Common Variance Patterns
Certain variance patterns recur across businesses. Recognizing them speeds up your analysis and helps identify the likely root cause.
Pattern: Timing Variance
Revenue or expenses that shifted between months but will even out over the quarter or year. Does not require corrective action, just forecast adjustment.
Example: Customer delayed order from January to February. February will be over budget, January under. Full quarter on track.
Action: Note in commentary, adjust forecast, no operational change needed.
Pattern: Permanent Shift
A change that will persist—lost customer, price increase, new competitor. Requires action to address or forecast revision to reflect new reality.
Example: Key supplier raised prices 10%, effective immediately and permanently.
Action: Find alternative supplier, negotiate, or raise prices. Update forecast for ongoing impact.
Pattern: Budget Error
The budget itself was wrong—too aggressive, based on bad assumptions, or missing known costs. The variance is not performance; it is a planning gap.
Example: Budget assumed 20% growth; market research shows industry growing 5%. Every month will miss.
Action: Reforecast with realistic assumptions. Use for planning even if formal budget stays unchanged.
Pattern: Operational Issue
A process or execution problem causing unfavorable results. Requires investigation and operational correction.
Example: Labor costs over budget due to high overtime. Root cause: understaffing plus higher-than-expected demand.
Action: Hire additional staff, improve demand forecasting, or adjust service levels.
Pattern: Mix Shift
Total volume is on budget, but the mix of products or customers changed, affecting overall results.
Example: Revenue on target but margin down. Reason: sold more of Product B (35% margin) vs Product A (50% margin).
Action: Review sales incentives, pricing strategy, or accept lower margin if strategic.
Presenting Variance Analysis
How you present variance analysis affects whether it drives action. A good variance report is clear, concise, and action-oriented.
The Variance Commentary Template
For each material variance, include:
1. The Variance (2 sentences max)
"Revenue was $50K (5.6%) below budget, driven by volume ($30K) and pricing ($20K)."
2. The Root Cause (2-3 sentences)
"Customer A delayed their Q1 order to February (volume). We discounted two competitive deals to win against Competitor X (pricing)."
3. One-Time vs Continuing
"The Customer A order is confirmed for February—timing only. The discounting trend (4 of last 6 deals) needs review."
4. Recommended Action (if any)
"No action needed on Customer A. Sales leadership to review discounting authority and competitive response strategy by next week."
Visual Presentation
- Use color coding: Green for favorable, red for unfavorable, yellow for items requiring attention
- Show both $ and %: A $10K variance means different things at different scales
- Highlight material items: Bold or flag variances above threshold so readers know where to focus
- Include prior month: Trends matter more than single-month variances
The Executive Summary
Lead with a one-paragraph summary: "Total variance was X. The three main drivers were A, B, and C. Items A and B are one-time; C is a trend requiring action. Recommended next steps are..."
Related Guides
Management Reporting Guide
The complete framework for turning financials into decisions.
Translating Financials Into Action
Turn variance insights into specific, executable actions.
The Monthly Financial Review Meeting
How to discuss variances effectively in your leadership meeting.
Financial Reports for Leadership Teams
What to include in the monthly package alongside variance analysis.
Financial Review Cadence
How often to review financials and conduct variance analysis.
Frequently Asked Questions
What is variance analysis in simple terms?
Variance analysis compares actual results to what you expected (budget, forecast, or prior year). The "variance" is the difference. The analysis is understanding why that difference exists and whether it requires action.
How do you calculate variance?
Variance = Actual - Budget (or Forecast). A positive variance means actual exceeded budget; negative means it fell short. For revenue and profit, positive is typically good. For expenses, positive means overspending (typically bad).
What variance threshold should trigger investigation?
Common thresholds are 5-10% or a fixed dollar amount meaningful to your business (e.g., $10,000). The threshold should balance catching real issues without creating noise from normal fluctuations. Adjust based on business volatility.
What is the difference between favorable and unfavorable variance?
Favorable variance improves profit: higher revenue or lower costs than budget. Unfavorable variance hurts profit: lower revenue or higher costs. Note that "favorable" is not always good—underspending on marketing might be favorable but hurt growth.
How do I explain variance to non-financial people?
Focus on operational causes, not accounting terms. Instead of "we had an unfavorable revenue variance of $50K," say "we sold 200 fewer units than planned because our biggest customer delayed their order." Connect numbers to business reality.
What if I do not have a budget to compare against?
Compare to prior year, prior month, or industry benchmarks. Even without a formal budget, variance analysis provides value. Use the analysis process to build your first budget based on what you learn about normal performance.
How often should variance analysis be done?
Monthly is standard for most businesses. Weekly analysis may be appropriate for volatile metrics like cash or sales. The key is consistency—irregular analysis makes it hard to spot trends and patterns.
What is the most common mistake in variance analysis?
Stopping at "what" without getting to "why." Knowing revenue was $50K below budget is not useful until you understand the operational cause. And knowing the cause is not useful until you decide what to do about it.
Need Better Variance Analysis?
We help growing businesses implement variance analysis that goes beyond explanation to drive real operational improvement. Let's build a system that works.
Schedule a Consultation