
Demand Forecast Analyst
Generate demand forecasts with documented assumptions and scenario analysis
What You Can Do
You can analyze historical demand patterns, generate statistical forecasts with explicit assumptions, and create best/base/worst-case scenarios for supply chain planning. The skill evaluates demand seasonality, trends, and volatility to produce actionable forecasts with confidence intervals. Your results include documented methodology, key assumptions, and specific recommendations for inventory and production planning.
Features
Automatically detect and quantify trends, seasonality, and cyclical patterns in your historical demand data
Generate forecasts using multiple statistical approaches (exponential smoothing, trend regression, seasonal decomposition) and compare accuracy
Transparently list all assumptions, methodology choices, and data limitations so stakeholders understand forecast foundations
Create best-case, base-case, and worst-case demand scenarios with probability weights for strategic planning
Quantify forecast uncertainty with statistical confidence bands at 80%, 90%, and 95% levels to inform safety stock decisions
Translate forecasts into specific inventory, production ramp, and procurement lead-time recommendations
Account for holiday peaks, seasonal fluctuations, and calendar effects to improve forecast accuracy
Example Output
Demand Forecast Summary (6-Month Outlook)
Historical Analysis
- Average monthly demand: 15,400 units
- Trend: +3.2% YoY growth
- Seasonality: Peak in Q4 (+28%), trough in Q1 (-18%)
- Volatility: 2,100 units (std dev)
Base-Case Forecast
| Month | Forecast | 80% CI | 90% CI | Notes |
|---|---|---|---|---|
| Sep | 16,800 | ±2,600 | ±3,100 | Summer decline ending |
| Oct | 18,900 | ±2,800 | ±3,400 | Pre-holiday ramp |
| Nov | 22,400 | ±3,200 | ±3,900 | Peak season |
| Dec | 21,600 | ±3,100 | ±3,800 | Holiday sustained |
Scenario Comparison
- Worst-Case (20%): 12% demand reduction → 14,700 avg units/month
- Base-Case (60%): Current trends → 16,900 avg units/month
- Best-Case (20%): 8% surge from new customers → 18,200 avg units/month
Key Assumptions ✓ Historical patterns remain stable ✓ No major product line changes ✓ Current macroeconomic conditions persist ✓ Seasonal factors consistent with past 24 months
What's Included
- Demand Pattern Analysis Report: Quantified trends, seasonality factors, and volatility metrics from your historical data
- 6-Month Forecast with Confidence Intervals: Point forecasts and statistical uncertainty bands at 80%, 90%, and 95% confidence levels
- Scenario Analysis Framework: Best/base/worst-case scenarios with explicit probability weights and business driver assumptions
- Documented Methodology: Complete transparency on forecasting methods, data quality issues, and key assumptions
- Supply Chain Recommendations: Specific guidance on safety stock levels, production ramps, and supplier lead time planning
- Assumption Sensitivity Analysis: Quantified impact of changing key assumptions on forecast outcomes
Who It's For
- Supply Chain Managers
- Demand Planners
- Manufacturing Operations Managers
- Production Schedulers
- Business Analysts
Best For
- Monthly and quarterly demand forecasting
- Scenario planning for capacity and inventory decisions
- Evaluating forecast uncertainty and risk
- Documenting assumptions for stakeholder alignment
- Seasonal demand adjustment and peak planning







