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