Back to Details

forecast-modeling

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Forecast Modeling System Skill

预测建模系统Skill

When to Use

适用场景

  • Launching new forecasting cadences or revisiting methodology.
  • Running scenario planning ahead of board meetings or budget cycles.
  • Auditing deviations between forecast, pipeline, and actuals.
  • 启动新的预测周期或重新审视方法论时。
  • 董事会会议或预算周期前进行场景规划时。
  • 审计预测、销售漏斗与实际数据之间的偏差时。

Framework

框架

  1. Method Selection – pick bottom-up CRM, top-down macro, cohort, or blended models and document assumptions.
  2. Driver Mapping – define win rates, velocity, expansion, churn, pricing, and seasonality inputs.
  3. Scenario Logic – establish base/upside/downside cases with tunable levers for sensitivity analysis.
  4. Model Governance – list data sources, refresh cadence, validation checks, and ownership.
  5. Output Packaging – standardize tables, charts, and narrative prompts for exec review.
  1. 方法选择——选择自下而上的CRM模型、自上而下的宏观模型、群组模型或混合模型，并记录假设条件。
  2. 驱动因素映射——定义赢单率、转化速度、业务拓展、客户流失、定价和季节性等输入项。
  3. 场景逻辑——建立基准/乐观/悲观场景，搭配可调节的变量进行敏感性分析。
  4. 模型治理——列出数据源、更新频率、验证检查机制和负责人。
  5. 输出封装——标准化用于高管评审的表格、图表和说明性提示。

Templates

模板

  • Driver tree diagram connecting levers to KPIs.
  • Scenario sheet (assumption → base/upside/downside values).
  • Model QA checklist (data freshness, formula audits, version history).
  • 连接变量与关键绩效指标（KPI）的驱动因素树状图。
  • 场景表格（假设条件 → 基准/乐观/悲观数值）。
  • 模型质量检查清单（数据新鲜度、公式审计、版本历史）。

Tips

小贴士

  • Keep raw inputs + assumptions in version control for auditability.
  • Pair with 
    variance-analysis
    skill to recalibrate after each cycle.
  • Automate sensitivity runs to answer "what-if" questions during reviews.
  • 将原始输入和假设条件纳入版本控制，以便审计。
  • 搭配
    variance-analysis
    Skill使用，在每个周期后重新校准模型。
  • 自动化敏感性分析运行，以便在评审期间解答“假设分析”类问题。