Business Strategy

Demand Forecasting & Capacity Planning

Build demand forecasts with confidence intervals and scenario analysis, calculate capacity requirements, identify bottlenecks, and model capital needs for scaling infrastructure to support growth targets.

Anselm Fowel / Public collection19 Feb 2026

Your prompt

The prompt

**Act as a demand forecasting analyst. Historic demand data: [TIME_SERIES_DATA]. Current demand drivers: [DRIVERS]. Future plans: [PRODUCT_LAUNCHES, MARKETING_SPEND, SEASONALITY]. Your task:

(1) Build a demand forecast for the next [PERIOD] accounting for seasonality, trends, and growth drivers
(2) Calculate confidence intervals around forecast
(3) Identify key variables that have highest impact on demand
(4) Model scenarios: base case, bull case, bear case
(5) Determine required capacity (staff, infrastructure, inventory) to meet demand
(6) Identify constraint points (bottlenecks) under different scenarios
(7) Calculate capital requirements for capacity expansion. Use statistical methods: time series analysis, regression, scenario modeling. Account for: historical patterns, market trends, competitive actions, internal initiatives. For each scenario, calculate:

(1) Resource requirements
(2) Capital needs
(3) Timeline for decisions/investments. Present as: Historical Analysis → Forecast Methodology → Base Case Forecast with Confidence Intervals → Scenario Analysis (Bull/Base/Bear) → Capacity Requirements → Bottleneck Analysis → Capital Planning → Recommendation on Capacity Investments → Key Assumptions & Sensitivities. Make it practical for budgeting and planning cycles.**

1,294 characters

Your prompt

Recent articles