Variance Analysis

Variance Analysis

name: variance-analysis description: Variance analysis — price, volume, mix, efficiency variances

When to Activate

• User needs to decompose budget vs actual variances into root causes
• Performing price, volume, and mix analysis on revenue or cost variances
• Building variance reporting for management or board presentations
• Setting materiality thresholds and action triggers
• Creating waterfall/bridge charts to visualize variance drivers

Core Concepts

Variance Decomposition Framework

Every financial variance can be decomposed into underlying drivers. The goal is to move beyond "we missed by $2M" to "we missed because volume was 5% below plan partially offset by 2% higher pricing."

Revenue Variance Decomposition

Price × Volume framework:

Total Revenue Variance = Actual Revenue - Budget Revenue

Price Variance  = (Actual Price - Budget Price) × Actual Volume
Volume Variance = (Actual Volume - Budget Volume) × Budget Price
Mix Variance    = Σ [(Actual Mix_i - Budget Mix_i) × Budget Margin_i × Actual Total Volume]

Three-way decomposition (price, volume, mix):

Example:
Budget:  1,000 units × $100 avg price = $100,000
Actual:  1,050 units × $97 avg price  = $101,850

Volume Variance:  (1,050 - 1,000) × $100 = +$5,000 (F)
Price Variance:   ($97 - $100) × 1,050   = -$3,150 (U)
Total Variance:   $101,850 - $100,000     = +$1,850 (F)

Revenue variance with mix effect (multi-product): When the product mix shifts toward higher or lower-margin products, the mix variance captures this impact separately from pure volume and price effects.

Cost Variance Decomposition

Direct materials:

Material Price Variance    = (Actual Price - Standard Price) × Actual Quantity
Material Quantity Variance = (Actual Quantity - Standard Quantity) × Standard Price

Direct labor:

Labor Rate Variance       = (Actual Rate - Standard Rate) × Actual Hours
Labor Efficiency Variance = (Actual Hours - Standard Hours) × Standard Rate

Overhead:

Spending Variance   = Actual Overhead - Budgeted Overhead (at actual activity level)
Volume Variance     = Budgeted OH (at actual activity) - Applied OH (standard rate × actual units)
Efficiency Variance = (Actual Hours - Standard Hours) × Standard OH Rate

Favorable vs Unfavorable

| Variance Type | Favorable (F) | Unfavorable (U) | |---------------|--------------|-----------------| | Revenue | Actual > Budget | Actual Budget | | Margin | Actual > Budget | Actual 5% or > $500k Opex: > 8% or > $200k

Level 4 — Board notification: Any variance impacting full-year EBITDA by > 10% or > $1M

Thresholds should be calibrated to the company's size and risk tolerance.

### Root Cause Analysis

For every material variance, document:
1. **What happened** — quantified variance with decomposition
2. **Why it happened** — operational root cause (not "we spent more")
3. **Is it recurring** — one-time or systemic issue
4. **Timing impact** — pulled forward / pushed back, or permanent change
5. **Full-year impact** — update forecast based on root cause
6. **Corrective action** — specific steps, owner, and timeline

**Common root causes by category:**

Revenue shortfall:

• Delayed deal closings (timing — may recover next quarter)
• Lower win rate (competitive pressure — systemic)
• Customer churn above forecast (product/service issue)
• Pricing pressure (market dynamics)
• FX impact (external)

Cost overrun:

• Unplanned hiring / consulting (scope creep)
• Higher input costs (inflation, supply chain)
• Project delays (cost escalation)
• Technology/infrastructure costs (usage-based overrun)
• Legal/regulatory costs (unforeseeable)

## Methodology

### Step-by-Step Variance Analysis Process

1. **Extract actuals** from ERP/accounting system for the closed period
2. **Align to budget** — ensure chart of accounts mapping is correct
3. **Calculate total variances** — actual minus budget for every line item
4. **Apply materiality filter** — focus analysis effort on material variances
5. **Decompose material variances** — into price, volume, mix, timing, FX, one-time
6. **Conduct root cause analysis** — interview budget owners, review operational data
7. **Assess full-year impact** — does the variance persist, reverse, or amplify?
8. **Update forecast** — incorporate learnings into the rolling forecast
9. **Prepare variance report** — executive summary with bridge chart
10. **Present to management** — focus on actions, not just explanations

### Bridge Chart (Waterfall) Construction

A bridge chart visually walks from budget to actual, showing each variance driver.

Budget Revenue: $10,000k

• Volume: +$500k ← green bar (favorable)
• Pricing: -$200k ← red bar (unfavorable)
• Mix: +$150k ← green bar
• FX: -$100k ← red bar
• One-time: -$50k ← gray bar

= Actual Revenue: $10,300k

**Rules for effective bridge charts:**
- Start with budget, end with actual
- Order drivers by magnitude (largest impact first) or logical flow
- Use consistent colors (green = favorable, red = unfavorable, gray = neutral/FX)
- Include both the dollar amount and percentage impact
- Maximum 6-8 bars between budget and actual (combine small items into "other")

### Management Action Triggers

Variance Situation | Required Action Revenue > 5% below budget | Sales pipeline deep dive, revised go-to-market, forecast update Gross margin > 200bp below | Pricing review, supplier renegotiation, product cost analysis Opex > 10% above budget | Spending freeze assessment, hiring pause evaluation Cash flow > 15% below budget | Working capital initiative, capex reprioritization Customer churn > 2x plan | Executive escalation, retention program, product review

## Templates

### Variance Report Template

=== VARIANCE ANALYSIS REPORT ===

Period: [Month/Quarter] [Year] Prepared by: [Name] Date: [Date]

--- Executive Summary --- [2-3 sentence narrative: key takeaways, largest variances, full-year implications]

--- P&L Variance Summary ($ thousands) --- | Budget | Actual | Variance | Var % | Status Revenue | _____ | _____ | _____ | ____% | F/U COGS | _____ | _____ | _____ | ____% | F/U Gross Profit | _____ | _____ | _____ | ____% | F/U Gross Margin % | ____% | ____% | ___ bp | | Sales & Marketing | _____ | _____ | _____ | ____% | F/U R&D | _____ | _____ | _____ | ____% | F/U G&A | _____ | _____ | _____ | ____% | F/U EBITDA | _____ | _____ | _____ | ____% | F/U EBITDA Margin % | ____% | ____% | ___ bp | |

--- Material Variance Detail ---

Variance #1: [Description] — $___k [F/U] Decomposition: Volume $___k + Price $___k + Mix $___k + Other $___k Root Cause: [Explanation] Recurring: [Yes/No] Full-Year Impact: $___k Action: [Corrective action, owner, deadline]

Variance #2: [Description] — $___k [F/U] [Same structure]

--- Revenue Bridge --- Budget → [+Volume] → [+/-Price] → [+/-Mix] → [+/-FX] → [+/-Other] → Actual

--- EBITDA Bridge --- Budget → [+/-Revenue impact] → [+/-COGS] → [+/-Opex] → [+/-Other] → Actual

--- Forecast Update --- Prior FY Forecast: $____k EBITDA Variance Impact: $____k Updated FY Forecast: $____k EBITDA vs Budget: ____%

### Departmental Variance Template

=== DEPARTMENT VARIANCE REPORT ===

Department: [Name] Budget Owner: [Name] Period: [Month/Quarter]

Line Item | Budget | Actual | Variance | Explanation | Action Required Salaries | _____ | _____ | _____ | [2 hires ahead of plan] | [None — in plan] Consulting | _____ | _____ | _____ | [Unplanned project] | [CFO approval needed] Travel | _____ | _____ | _____ | [Conference pulled fwd]| [Will reverse Q3] Software | _____ | _____ | _____ | [New tool added] | [Review Q3] Total | _____ | _____ | _____ | |

## Quality Gate

Before finalizing variance analysis, verify:

- [ ] Actuals are final (month/quarter is closed, no pending adjustments)
- [ ] Budget baseline is correct (approved budget, not a prior forecast)
- [ ] Variance decomposition is complete (price + volume + mix + other = total)
- [ ] Favorable/unfavorable labels are correct and consistent
- [ ] Materiality thresholds are applied consistently
- [ ] Root causes are operational, not circular (not "we spent more because we spent more")
- [ ] Timing variances are identified (will reverse in future periods)
- [ ] Full-year impact is assessed for each material variance
- [ ] Corrective actions have specific owners and deadlines
- [ ] Bridge chart mathematically reconciles from budget to actual
- [ ] FX impact is isolated if the business operates in multiple currencies
- [ ] Variance report is reviewed with budget owners before executive presentation
- [ ] Forecast is updated to reflect variance learnings

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [brainbytes-dev](https://github.com/brainbytes-dev)
- **Source:** [brainbytes-dev/everything-claude-finance](https://github.com/brainbytes-dev/everything-claude-finance)
- **License:** MIT

Install and usage instructions live in the source repository linked above.