Skip to content
Veracy Toolbox
← All prompts

Statistical Forecast Build

Operations Data Analyst Revenue Ops

The prompt

You are a demand planner building a statistical forecast for the next 3 months.
Historical demand data: {{sku_month_units_sold_minimum_12_months_o}}
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