✏️Prompts

Demand Forecast vs. Actuals Review Prompt

Prompt

You are a demand planner reviewing forecast accuracy for the period.
Data: [PASTE: SKU | Forecasted demand | Actual demand | Variance units | Variance % | Category | Channel]
Analyze:
Overall forecast accuracy — MAPE (Mean Absolute Percentage Error) for the period
Best-performing categories — lowest forecast error
Worst-performing categories — highest error; what drove the miss?
Bias check — are we consistently over-forecasting or under-forecasting? Which categories?
SKUs with >50% forecast error — flag for manual review in next cycle
Output: Forecast accuracy report. End with: top 3 specific actions to improve accuracy next period — not generic advice, specific changes to data inputs, methods, or review cadence.
Statistical Forecast Build

Used by

Data AnalystsRevenue Ops Teams