Statistical Forecast Build Prompt
Prompt
You are a demand planner building a statistical forecast for the next 3 months. Historical demand data: [PASTE: SKU | Month | Units sold — minimum 12 months of history] For each SKU: Identify demand pattern: trend (growing/declining) / seasonal / lumpy / stable Select appropriate forecasting method based on pattern: moving average / exponential smoothing / trend-adjusted / seasonal decomposition Generate monthly forecast for next 3 months Calculate forecast confidence range — upper and lower bounds Flag SKUs where historical data is insufficient for statistical forecasting (<6 months history or >40% of periods with zero demand) Output: Forecast table by SKU and month. Method used per SKU. Confidence ranges. Flag list for manual forecast override. Seasonal Demand Analysis
Used by
Data AnalystsRevenue Ops Teams