variance-analysis
Decompose financial variances into drivers with narrative explanations and waterfall analysis. Use when analyzing budget vs. actual, period-over-period changes, revenue or expense variances, or preparing variance commentary for leadership.
sandbaseai · Static checks on file
Installation
Read the source and dependencies before running a command. Copying does not install or execute anything.
npx skills add sandbaseai/sandbase-skills --skill variance-analysisAbout this skill
name: variance-analysis description: Decompose financial variances into drivers with narrative explanations and waterfall analysis. Use when analyzing budget vs. actual, period-over-period changes, revenue or expense variances, or preparing variance commentary for leadership.
Variance Analysis
Important: This skill assists with variance analysis workflows but does not provide financial advice. All analyses should be reviewed by qualified financial professionals before use in reporting.
Techniques for decomposing variances, materiality thresholds, narrative generation, waterfall chart methodology, and budget vs actual vs forecast comparisons.
When inputs are supplied through report URLs, read the SandBase API map. Resolve the current schema with sandbase_describe_tool before using a listed capability through sandbase_call_tool.
Define the sign convention before calculating and label favorable/unfavorable separately: a numerically positive variance can be favorable for revenue and unfavorable for expense. When the comparison value is zero, report the percentage as not meaningful rather than dividing by zero.
Variance Decomposition Techniques
Price / Volume Decomposition
The most fundamental variance decomposition. Used for revenue, cost of goods, and any metric that can be expressed as Price x Volume.
Formula:
Total Variance = Actual - Budget (or Prior)
Volume Effect = (Actual Volume - Budget Volume) x Budget Price
Price Effect = (Actual Price - Budget Price) x Actual Volume
Mix Effect = Residual (interaction term), or allocated proportionally
Verification: Volume Effect + Price Effect = Total Variance
(when mix is embedded in the price/volume terms)
Three-way decomposition (separating mix):
Volume Effect = (Actual Volume - Budget Volume) x Budget Price x Budget Mix
Price Effect = (Actual Price - Budget Price) x Actual Volume x Actual Mix
Mix Effect = Budget Price x Actual Volume x (Actual Mix - Budget Mix)
Example — Revenue variance:
- Budget: 10,000 units at $50 = $500,000
- Actual: 11,000 units at $48 = $528,000
- Total variance: +$28,000 favorable
- Volume effect: +1,000 units x $50 = +$50,000 (favorable — sold more units)
- Price effect: -$2 x 11,000 units = -$22,000 (unfavorable — lower ASP)
- Net: +$28,000
Rate / Mix Decomposition
Used when analyzing blended rates across segments with different unit economics.
Formula:
Rate Effect = Sum of (Actual Volume_i x (Actual Rate_i - Budget Rate_i))
Mix Effect = Sum of (Budget Rate_i x (Actual Volume_i - Expected Volume_i at Budget Mix))
Example — Gross margin variance:
- Product A: 60% margin, Product B: 40% margin
- Budget mix: 50% A, 50% B → Blended margin 50%
- Actual mix: 40% A, 60% B → Blended margin 48%
- Mix effect explains 2pp of margin compression
Headcount / Compensation Decomposition
Used for analyzing payroll and people-cost variances.
Total Comp Variance = Actual Compensation - Budget Compensation
Decompose into:
1. Headcount variance = (Actual HC - Budget HC) x Budget Avg Comp
2. Rate variance = (Actual Avg Comp - Budget Avg Comp) x Budget HC
3. Mix variance = Difference due to level/department mix shift
4. Timing variance = Hiring earlier/later than planned (partial-period effect)
5. Attrition impact = Savings from unplanned departures (partially offset by backfill costs)
Spend Category Decomposition
Used for operating expense analysis when price/volume is not applicable.
Total OpEx Variance = Actual OpEx - Budget OpEx
Decompose by:
1. Headcount-driven costs (salaries, benefits, payroll taxes, recruiting)
2. Volume-driven costs (hosting, transaction fees, commissions, shipping)
3. Discretionary spend (travel, events, professional services, marketing programs)
4. Contractual/fixed costs (rent, insurance, software licenses, subscriptions)
5. One-time / non-recurring (severance, legal settlements, write-offs, project costs)
6. Timing / phasing (spend shifted between periods vs plan)
Materiality Thresholds and Investigation Triggers
Setting Thresholds
Materiality thresholds determine which variances require investigation and narrative explanation. Set thresholds based on:
- Financial statement materiality: Typically 1-5% of a key benchmark (revenue, total assets, net income)
- Line item size: Larger line items warrant lower percentage thresholds
- Volatility: More volatile line items may need higher thresholds to avoid noise
- Management attention: What level of variance would change a decision?
Recommended Threshold Framework
Use organization-approved materiality when available. The percentages below are illustrative starting points, not universal defaults.
| Comparison Type | Dollar Threshold | Percentage Threshold | Trigger |
|---|---|---|---|
| Actual vs Budget | Organization-specific | 10% | Either exceeded |
| Actual vs Prior Period | Organization-specific | 15% | Either exceeded |
| Actual vs Forecast | Organization-specific | 5% | Either exceeded |
| Sequential (MoM) | Organization-specific | 20% | Either exceeded |
Set dollar thresholds based on your organization's size. Common practice: 0.5%-1% of revenue for income statement items.
Investigation Priority
When multiple variances exceed thresholds, prioritize investigation by:
- Largest absolute dollar variance — biggest P&L impact
- Largest percentage variance — may indicate process issue or error
- Unexpected direction — variance opposite to trend or expectation
- New variance — item that was on track and is now off
- Cumulative/trending variance — growing each period
Narrative Generation for Variance Explanations
Structure for Each Variance Narrative
[Line Item]: [Favorable/Unfavorable] va
Read the complete source ↗