Variance Analysis

Decompose financial variances into component drivers, quantify each driver, produce narrative explanations suitable for management, and format as waterfall analysis.

Workflow

Step 1: Define the Comparison

Establish the analysis framework:

• Base period: Budget, prior month, prior year, or forecast.
• Actual period: The period being analyzed.
• Scope: Full P&L, specific line items, a department, or a cost center.
• Materiality threshold: Dollar and percentage thresholds for flagging (e.g., >$25K and >5%).
• Sign convention: Favorable (F) increases income; Unfavorable (U) decreases income.

Step 2: Calculate Variances

For each line item in scope:

• Dollar variance: Actual minus base (or base minus actual for expenses where under-spend is favorable).
• Percentage variance: Dollar variance divided by base amount.
• Favorable/Unfavorable flag: Apply sign convention.
• Materiality flag: Mark items exceeding either threshold.

Step 3: Decompose into Drivers

Break material variances into their root causes:

Revenue Variances:

• Volume: Change in units sold multiplied by base price.
• Price/Mix: Change in average selling price multiplied by actual volume.
• New/Lost: Revenue from new customers vs. churned customers.
• Timing: Revenue pulled forward or pushed out vs. plan.

Expense Variances:

• Headcount: Change in FTE count multiplied by average cost per head.
• Rate: Change in cost per unit (salaries, vendor rates) multiplied by actual volume.
• Volume/Usage: Change in consumption (cloud spend, travel, materials).
• One-time: Non-recurring items (settlements, write-offs, project costs).
• Timing: Spend that shifted between periods.

Gross Margin Variances:

• COGS rate change: Impact of unit cost changes on margin.
• Revenue mix shift: Impact of product mix on blended margin.
• Volume leverage: Fixed cost absorption at different volume levels.

Step 4: Build the Waterfall

Create a waterfall (bridge) analysis from base to actual:

1. Start with the base amount.
2. Add each driver as a step (positive or negative).
3. Arrive at the actual amount.
4. Verify the drivers sum to the total variance.

Step 5: Draft Narrative Commentary

For each material variance, write a management-ready narrative:

• State the variance in dollars and percentage.
• Name the driver(s) with quantification.
• Explain the underlying business reason.
• Note whether the variance is expected to continue (run-rate) or is one-time.
• Recommend action if the variance is unfavorable and controllable.

Output Format

## Variance Analysis: [Scope] | [Actual Period] vs. [Base]

### Summary
| Metric             | Base       | Actual     | $ Variance | % Variance | F/U |
|--------------------|-----------|------------|------------|------------|-----|
| Net Revenue        | $10,000K  | $10,800K   | $800K      | 8.0%       | F   |
| Gross Profit       | $6,000K   | $6,200K    | $200K      | 3.3%       | F   |
| Operating Expenses | ($4,500K) | ($4,900K)  | ($400K)    | 8.9%       | U   |
| Operating Income   | $1,500K   | $1,300K    | ($200K)    | (13.3%)    | U   |

### Waterfall: Operating Income
Base (Budget):          $1,500K
  + Revenue volume:     +$500K
  + Revenue price/mix:  +$300K
  - COGS rate increase: -$100K
  - S&M headcount:      -$250K
  - R&D cloud spend:    -$100K
  - G&A one-time legal: -$50K
  - Other:              -$100K (net)
= Actual:               $1,300K

### Material Variance Detail

#### 1. Revenue: +$800K favorable (8.0%)
**Drivers**:
- Volume (+$500K): 12 new enterprise contracts closed vs. 8 planned...
- Price/Mix (+$300K): Higher proportion of premium tier subscriptions...
**Outlook**: Volume trend expected to moderate in Q2; price/mix sustainable.

#### 2. Operating Expenses: ($400K) unfavorable (8.9%)
**Drivers**:
- S&M headcount (-$250K): 3 AEs hired ahead of plan in January...
- R&D cloud infrastructure (-$100K): Migration to new platform...
- G&A legal fees (-$50K): One-time patent filing costs...
**Outlook**: Headcount is run-rate; cloud and legal are one-time.

### Action Items
| # | Item                            | Owner      | Due Date   |
|---|---------------------------------|------------|------------|
| 1 | Review cloud spend trajectory   | VP Eng     | 2026-04-15 |
| 2 | Update S&M headcount forecast   | VP Sales   | 2026-04-10 |

Examples

User: "Explain why we missed operating income by $200K vs. budget" Action: Pull actual vs. budget by line item, identify material variances, decompose into drivers, build the waterfall, and draft narratives.

User: "Revenue bridge from Q4 to Q1" Action: Decompose the quarter-over-quarter revenue change into volume, price/mix, new/lost customer, and timing drivers.

User: "Prepare variance commentary for the board deck" Action: Summarize the top 5 variances with concise driver explanations and forward-looking outlook.

Best Practices

• Always verify that decomposed drivers sum back to the total variance. If they do not, include a "rounding/other" line.
• Lead with the story, not the numbers. Management wants to know why, not just what.
• Distinguish between run-rate and one-time variances; this changes the forecast implications.
• Use consistent sign convention throughout (favorable = positive, unfavorable = negative, or vice versa).
• For board-level commentary, keep each variance explanation to 2-3 sentences maximum.
• When multiple drivers contribute to one line item variance, rank them by magnitude.
• Always include an outlook statement: "Is this variance expected to continue?"