Back to Details

variance-analysis

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

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.
重要提示：本技能可协助完成差异分析工作流，但不提供财务建议。所有分析内容在用于报告前，均需由合格的财务专业人员审核。
涵盖差异分解技巧、重要性阈值、说明性内容生成、瀑布图方法论，以及预算、实际与预测的对比分析。

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 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
这是最基础的差异分解方法，适用于收入、销货成本，以及任何可表示为“价格×数量”的指标。
公式：
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)
三元分解（拆分组合因素）：
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)
示例 — 收入差异：
  • 预算：10,000单位 at $50 = $500,000
  • 实际：11,000单位 at $48 = $528,000
  • 总差异：+$28,000（有利差异）
    • 数量影响：+1,000单位 × $50 = +$50,000（有利差异——销量增加）
    • 价格影响：-$2 × 11,000单位 = -$22,000（不利差异——平均售价降低）
    • 净额：+$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
适用于分析不同细分业务单元混合后的费率差异，这些单元具备不同的单位经济效益。
公式：
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))
示例 — 毛利率差异：
  • 产品A：60%毛利率，产品B：40%毛利率
  • 预算组合：50%A、50%B → 综合毛利率50%
  • 实际组合：40%A、60%B → 综合毛利率48%
  • 组合因素导致毛利率压缩2个百分点

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)
适用于分析薪资与人力成本差异。
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)
适用于无法应用价格/数量模型的运营费用分析。
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:
  1. Financial statement materiality: Typically 1-5% of a 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 need higher thresholds to avoid noise
  4. Management attention: What level of variance would change a decision?
重要性阈值用于确定哪些差异需要调查和说明性解释。阈值设置需基于以下因素：
  1. 财务报表重要性： 通常为关键基准（收入、总资产、净利润）的1-5%
  2. 项目规模： 金额较大的项目应设置更低的百分比阈值
  3. 波动性： 波动性较高的项目可能需要更高的阈值以避免干扰
  4. 管理层关注度： 多大的差异会影响决策？

Recommended Threshold Framework

推荐阈值框架

Comparison TypeDollar ThresholdPercentage ThresholdTrigger
Actual vs BudgetOrganization-specific10%Either exceeded
Actual vs Prior PeriodOrganization-specific15%Either exceeded
Actual vs ForecastOrganization-specific5%Either exceeded
Sequential (MoM)Organization-specific20%Either exceeded
Set dollar thresholds based on your organization's size. Common practice: 0.5%-1% of revenue for income statement items.
对比类型金额阈值百分比阈值触发条件
实际vs预算组织自定义10%任意一项超出
实际vs上期组织自定义15%任意一项超出
实际vs预测组织自定义5%任意一项超出
环比（月对月）组织自定义20%任意一项超出
金额阈值需根据组织规模设置。常见做法：损益表项目设置为收入的0.5%-1%。

Investigation Priority

调查优先级

When multiple variances exceed thresholds, prioritize investigation by:
  1. Largest absolute dollar variance — biggest P&L impact
  2. Largest percentage variance — may indicate process issue or error
  3. Unexpected direction — variance opposite to trend or expectation
  4. New variance — item that was on track and is now off
  5. Cumulative/trending variance — growing each period
当多个差异超出阈值时，按以下优先级开展调查：
  1. 绝对金额最大的差异 — 对损益表影响最大
  2. 百分比最大的差异 — 可能表明流程问题或错误
  3. 意外方向的差异 — 与趋势或预期相反的差异
  4. 新增差异 — 此前符合预期但现在偏离的项目
  5. 累积/趋势性差异 — 逐期扩大的差异

Narrative Generation for Variance Explanations

差异说明性内容生成

Structure for Each Variance Narrative

单个差异说明的结构

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

Driver: [Primary driver description]
[2-3 sentences explaining the business reason for the variance, with specific
quantification of contributing factors]

Outlook: [One-time / Expected to continue / Improving / Deteriorating]
Action: [None required / Monitor / Investigate further / Update forecast]
[项目名称]: [有利/不利]差异 $[金额]（[百分比]%）
对比[基准]，期间为[时间段]

驱动因素：[主要驱动因素描述]
[2-3句话解释差异的业务原因，包含各影响因素的具体量化数据]

展望：[一次性影响/预计持续/改善/恶化]
行动：[无需行动/监控/进一步调查/更新预测]

Narrative Quality Checklist

优质说明内容检查清单

Good variance narratives should be:
  • Specific: Names the actual driver, not just "higher than expected"
  • Quantified: Includes dollar and percentage impact of each driver
  • Causal: Explains WHY it happened, not just WHAT happened
  • Forward-looking: States whether the variance is expected to continue
  • Actionable: Identifies any required follow-up or decision
  • Concise: 2-4 sentences, not a paragraph of filler
优质的差异说明应满足：
  • 具体明确： 明确指出实际驱动因素，而非仅说“高于预期”
  • 量化呈现： 包含各驱动因素的金额和百分比影响
  • 因果清晰： 解释差异发生的原因，而非仅陈述事实
  • 前瞻性： 说明差异是否会持续
  • 可执行： 明确后续跟进或决策需求
  • 简洁： 2-4句话，避免冗余内容

Common Narrative Anti-Patterns to Avoid

需避免的常见说明反模式

  • "Revenue was higher than budget due to higher revenue" (circular — no actual explanation)
  • "Expenses were elevated this period" (vague — which expenses? why?)
  • "Timing" without specifying what was early/late and when it will normalize
  • "One-time" without explaining what the item was
  • "Various small items" for a material variance (must decompose further)
  • Focusing only on the largest driver and ignoring offsetting items
  • “收入高于预算是因为收入更高”（循环论证——无实际解释）
  • “本期费用偏高”（模糊——哪些费用？原因是什么？）
  • 仅提及“时间因素”，未说明具体提前/延后事项及何时恢复正常
  • 仅提及“一次性”，未说明具体项目
  • 对重大差异用“多项小额项目”概括（需进一步分解）
  • 仅关注最大驱动因素，忽略抵消项

Waterfall Chart Methodology

瀑布图方法论

Concept

概念

A waterfall (or bridge) chart shows how you get from one value to another through a series of positive and negative contributors. Used to visualize variance decomposition.
瀑布图（或桥梁图）展示通过一系列正负影响因素，如何从一个数值过渡到另一个数值。用于可视化差异分解结果。

Data Structure

数据结构

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

Verification:    Starting value + Sum of all drivers = Ending value
Starting value:  [基准/预算/上期金额]
Drivers:         [带正负符号的影响因素列表]
Ending value:    [实际/本期金额]

Verification:    Starting value + Sum of all drivers = Ending value

Text-Based Waterfall Format

文本型瀑布图格式

When a charting tool is not available, present as a text waterfall:
WATERFALL: Revenue — Q4 Actual vs Q4 Budget

Q4 Budget Revenue                                    $10,000K
  |
  |--[+] Volume growth (new customers)               +$800K
  |--[+] Expansion revenue (existing customers)      +$400K
  |--[-] Price reductions / discounting               -$200K
  |--[-] Churn / contraction                          -$350K
  |--[+] FX tailwind                                  +$50K
  |--[-] Timing (deals slipped to Q1)                 -$150K
  |
Q4 Actual Revenue                                    $10,550K

Net Variance: +$550K (+5.5% favorable)
当无图表工具时，可采用文本格式呈现瀑布图：
WATERFALL: Revenue — Q4 Actual vs Q4 Budget

Q4 Budget Revenue                                    $10,000K
  |
  |--[+] Volume growth (new customers)               +$800K
  |--[+] Expansion revenue (existing customers)      +$400K
  |--[-] Price reductions / discounting               -$200K
  |--[-] Churn / contraction                          -$350K
  |--[+] FX tailwind                                  +$50K
  |--[-] Timing (deals slipped to Q1)                 -$150K
  |
Q4 Actual Revenue                                    $10,550K

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

Bridge Reconciliation Table

调节表

Complement the waterfall with a reconciliation table:
DriverAmount% of VarianceCumulative
Volume growth+$800K145%+$800K
Expansion revenue+$400K73%+$1,200K
Price reductions-$200K-36%+$1,000K
Churn / contraction-$350K-64%+$650K
FX tailwind+$50K9%+$700K
Timing (deal slippage)-$150K-27%+$550K
Total variance+$550K100%
Note: Percentages can exceed 100% for individual drivers when there are offsetting items.
可搭配瀑布图使用调节表：
驱动因素金额占差异比例累计金额
销量增长+$800K145%+$800K
拓展收入+$400K73%+$1,200K
降价/折扣-$200K-36%+$1,000K
客户流失/收缩-$350K-64%+$650K
外汇利好+$50K9%+$700K
时间因素（交易延后至Q1）-$150K-27%+$550K
总差异+$550K100%
注：当存在抵消项时，单个驱动因素的占比可能超过100%。

Waterfall Best Practices

瀑布图最佳实践

  1. Order drivers from largest positive to largest negative (or in logical business sequence)
  2. Keep to 5-8 drivers maximum — aggregate smaller items into "Other"
  3. Verify the waterfall reconciles (start + drivers = end)
  4. Color-code: green for favorable, red for unfavorable (in visual charts)
  5. Label each bar with both the amount and a brief description
  6. Include a "Total Variance" summary bar
  1. 按影响从大到小排序（或按业务逻辑顺序）
  2. 最多保留5-8个驱动因素——将小额项目合并为“其他”
  3. 验证瀑布图的平衡性（起始值+驱动因素总和=结束值）
  4. 颜色编码：有利因素为绿色，不利因素为红色（可视化图表中）
  5. 每个条形标注金额及简短描述
  6. 包含“总差异”汇总条

Budget vs Actual vs Forecast Comparisons

预算vs实际vs预测对比

Three-Way Comparison Framework

三方对比框架

MetricBudgetForecastActualBud Var ($)Bud Var (%)Fcast Var ($)Fcast Var (%)
Revenue$X$X$X$XX%$XX%
COGS$X$X$X$XX%$XX%
Gross Profit$X$X$X$XX%$XX%
指标预算预测实际与预算差异（金额）与预算差异（百分比）与预测差异（金额）与预测差异（百分比）
收入$X$X$X$XX%$XX%
销货成本$X$X$X$XX%$XX%
毛利$X$X$X$XX%$XX%

When to Use Each Comparison

各对比场景的适用时机

  • Actual vs Budget: Annual performance measurement, compensation decisions, board reporting. Budget is set at the beginning of the year and typically not changed.
  • Actual vs Forecast: Operational management, identifying emerging issues. Forecast is updated periodically (monthly or quarterly) to reflect current expectations.
  • Forecast vs Budget: Understanding how expectations have changed since planning. Useful for identifying planning accuracy issues.
  • Actual vs Prior Period: Trend analysis, sequential performance. Useful when budget is not meaningful (new business lines, post-acquisition).
  • Actual vs Prior Year: Year-over-year growth analysis, seasonality-adjusted comparison.
  • 实际vs预算： 年度业绩考核、薪酬决策、董事会报告。预算在年初制定，通常不做调整。
  • 实际vs预测： 运营管理、识别潜在问题。预测会定期更新（月度或季度）以反映当前预期。
  • 预测vs预算： 了解自规划以来预期的变化。有助于识别规划准确性问题。
  • 实际vs上期： 趋势分析、环比业绩。当预算参考性不强时适用（如新业务线、收购后）。
  • 实际vs上年同期： 同比增长分析、季节性调整对比。

Forecast Accuracy Analysis

预测准确性分析

Track how accurate forecasts are over time to improve planning:
Forecast Accuracy = 1 - |Actual - Forecast| / |Actual|

MAPE (Mean Absolute Percentage Error) = Average of |Actual - Forecast| / |Actual| across periods
PeriodForecastActualVarianceAccuracy
Jan$X$X$X (X%)XX%
Feb$X$X$X (X%)XX%
...............
AvgMAPEXX%
跟踪预测的长期准确性以优化规划：
Forecast Accuracy = 1 - |Actual - Forecast| / |Actual|

MAPE (Mean Absolute Percentage Error) = Average of |Actual - Forecast| / |Actual| across periods
期间预测值实际值差异准确性
1月$X$X$X (X%)XX%
2月$X$X$X (X%)XX%
...............
平均MAPEXX%

Variance Trending

差异趋势跟踪

Track how variances evolve over the year to identify systematic bias:
  • Consistently favorable: Budget may be too conservative (sandbagging)
  • Consistently unfavorable: Budget may be too aggressive or execution issues
  • Growing unfavorable: Deteriorating performance or unrealistic targets
  • Shrinking variance: Forecast accuracy improving through the year (normal pattern)
  • Volatile: Unpredictable business or poor forecasting methodology
跟踪年度内差异的变化，识别系统性偏差：
  • 持续有利： 预算可能过于保守（留有余地）
  • 持续不利： 预算可能过于激进或存在执行问题
  • 不利差异扩大： 业绩恶化或目标不切实际
  • 差异缩小： 年度内预测准确性提升（正常模式）
  • 波动大： 业务不可预测或预测方法不佳