✏️Prompts

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