Explain budget, forecast, e prior-period variances com drivers, waterfall math, e ações. — Claude Skill

name: variance-analysis description: Decompose financial variances em drivers com narrative explanations e waterfall analysis. usar when analyzing budget vs. actual, period-over-period changes, revenue ou expense variances, ou preparing variance commentary para leadership. argument-hint: "<line item> <period> vs <comparison>"

Variance Analysis

Important: Esta skill assists com variance analysis workflows but does não provide financial advice. todos analyses deve be reviewed by qualified financial professionals antes usar in reporting.

Techniques para decomposing variances, materiality thresholds, narrative generation, waterfall chart methodology, e budget vs actual vs forecast comparisons.

Variance Decomposition Techniques

Price / Volume Decomposition

o most fundamental variance decomposition. Used para revenue, cost de goods, e qualquer métrica that can be expressed as Price x Volume.

Formula:

Total Variance = Actual - Budget (ou Prior)

Volume Effect = (Actual Volume - Budget Volume) x Budget Price
Price Effect = (Actual Price - Budget Price) x Actual Volume
Mix Effect = Residual (interaction term), ou allocated proportionally

Verification: Volume Effect + Price Effect = Total Variance
(when mix is embedded in o 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 Budget Volume x Actual Mix
Mix Effect = Budget Price x Budget 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

taxa / Mix Decomposition

Used when analyzing blended taxas across segments com different unit economics.

Formula:

taxa Effect = Sum de (Actual Volume_i x (Actual Rate_i - Budget Rate_i))
Mix Effect = Sum de (Budget Rate_i x (Actual Volume_i - Expected Volume_i at Budget Mix))

Example — Gross margin variance:

• produto A: 60% margin, produto 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 de margin compression

Headcount / compensação Decomposition

Used para analyzing payroll e people-cost variances.

Total Comp Variance = Actual compensação - Budget compensação

Decompose em:
1. Headcount variance = (Actual HC - Budget HC) x Budget Avg Comp
2. taxa variance = (Actual Avg Comp - Budget Avg Comp) x Budget HC
3. Mix variance = Difference due para level/department mix shift
4. Timing variance = Hiring earlier/later than planned (partial-period effect)
5. Attrition impacto = Savings a partir de unplanned departures (partially offset by backfill costs)

Spend Category Decomposition

Used para operating expense analysis when price/volume is não applicable.

Total OpEx Variance = Actual OpEx - Budget OpEx

Decompose by:
1. Headcount-driven costs (salaries, benefits, payroll taxes, recrutamento)
2. Volume-driven costs (hosting, transaction fees, commissions, shipping)
3. Discretionary spend (travel, eventos, professional services, marketing programs)
4. Contractual/fixed costs (rent, insurance, software licenses, subscriptions)
5. One-time / non-recurring (severance, jurídico settlements, write-offs, project costs)
6. Timing / phasing (spend shifted between periods vs plano)

Materiality Thresholds e Investigation gatilhos

Setting Thresholds

Materiality thresholds determine which variances require investigation e narrative explanation. Set thresholds based on:

1. Financial statement materiality: Typically 1-5% da key benchmark (revenue, total assets, net income)
2. Line item size: Larger line items warrant lower percentage thresholds
3. Volatility: More volatile line items may precisar de higher thresholds para avoid noise
4. Management attention: What level de variance would change a decisão?

Recommended Threshold Framework

Set dollar thresholds based on o seu organization's size. Common practice: 0.5%-1% de revenue para income statement items.

Investigation prioridade

When multiple variances exceed thresholds, priorizar investigation by:

1. Largest absolute dollar variance — biggest P&L impacto
2. Largest percentage variance — may indicate processo issue ou error
3. Unexpected direction — variance opposite para tendência ou expectation
4. novo variance — item that was on track e is now off
5. Cumulative/trending variance — growing each period

Narrative Generation para Variance Explanations

Structure para Each Variance Narrative

[Line Item]: [Favorable/Unfavorable] variance de $[amount] ([percentage]%)
vs [comparison basis] para [period]

Driver: [Primary driver description]
[2-3 sentences explaining o business reason para o variance, com specific
quantification de contributing factors]

Outlook: [One-time / Expected para continue / Improving / Deteriorating]
ação: [None obrigatório / monitorizar / Investigate further / Update forecast]

Narrative qualidade checklist

Good variance narratives deve be:

• Specific: nomeia o actual driver, não just "higher than expected"
• Quantified: inclui dollar e percentage impacto de each driver
• Causal: Explains WHY it happened, não just WHAT happened
• Forward-looking: declara whether o variance is expected para continue
• acionável: Identifies qualquer obrigatório follow-up ou decisão
• Concise: 2-4 sentences, não a paragraph de filler

Common Narrative Anti-Patterns para Avoid

• "Revenue was higher than budget due para higher revenue" (circular — no actual explanation)
• "Expenses were elevated this period" (vague — which expenses? why?)
• "Timing" sem specifying what was early/late e when it will normalize
• "One-time" sem explaining what o item was
• "Various small items" para a material variance (devem decompose further)
• Focusing only on o largest driver e ignoring offsetting items

Waterfall Chart Methodology

Concept

A waterfall (ou bridge) chart shows how você get a partir de one value para another through a series de positive e negative contributors. Used para visualize variance decomposition.

dados Structure

Starting value: [Base/Budget/Prior period amount]
Drivers: [List de contributing factors com signed amounts]
Ending value: [Actual/Current period amount]

Verification: Starting value + Sum de todos drivers = Ending value

Text-Based Waterfall Format

When a charting tool is não disponível, present as a text waterfall:

WATERFALL: Revenue — Q4 Actual vs Q4 Budget

Q4 Budget Revenue $10,000K
|
|--[+] Volume growth (novo clientes) +$800K
|--[+] expansão revenue (existing clientes) +$400K
|--[-] Price reductions / discounting -$200K
|--[-] churn / contraction -$350K
|--[+] FX tailwind +$50K
|--[-] Timing (negócios slipped para Q1) -$150K
|
Q4 Actual Revenue $10,550K

Net Variance: +$550K (+5.5% favorable)

Bridge Reconciliation Table

Complement o waterfall com a reconciliation table:

Note: Percentages can exceed 100% para individual drivers when there are offsetting items.

Waterfall Best Practices

1. Order drivers a partir de largest positive para largest negative (ou in logical business sequência)
2. Keep para 5-8 drivers maximum — aggregate smaller items em "Other"
3. Verify o waterfall reconciles (start + drivers = end)
4. Color-code: green para favorable, red para unfavorable (in visual charts)
5. Label each bar com both o amount e a brief description
6. incluir a "Total Variance" summary bar

Budget vs Actual vs forecast Comparisons

Three-Way Comparison Framework

When para usar Each Comparison

• Actual vs Budget: Annual performance measurement, compensação decisões, board reporting. Budget is set at o beginning do year e typically não changed.
• Actual vs forecast: Operational management, identifying emerging issues. forecast is updated periodically (mensal ou trimestral) para reflect atual expectations.
• forecast vs Budget: Understanding how expectations have changed since planning. Useful para identifying planning precisão issues.
• Actual vs Prior Period: tendência analysis, sequential performance. Useful when budget is não meaningful (novo business lines, post-aquisição).
• Actual vs Prior Year: ano a ano growth analysis, seasonality-adjusted comparison.

forecast precisão Analysis

Track how accurate forecasts are over time para improve planning:

forecast precisão = 1 - |Actual - forecast| / |Actual|

MAPE (Mean Absolute Percentage Error) = Average de |Actual - forecast| / |Actual| across periods

Variance Trending

Track how variances evolve over o year para identify systematic bias:

• Consistently favorable: Budget may be too conservative (sandbagging)
• Consistently unfavorable: Budget may be too aggressive ou execution issues
• Growing unfavorable: Deteriorating performance ou unrealistic targets
• Shrinking variance: forecast precisão improving through o year (normal pattern)
• Volatile: Unpredictable business ou poor forecasting methodology