Demand Forecasting | Audit and Experimentation Prompt

What this prompt helps you do

Audit an existing page, process, dataset, or asset, separate facts from assumptions, and turn the highest-priority issues into tests with baselines, metrics, and stop conditions.

Prompt text

Act as a retail demand-planning analyst and audit the current [Page/Process/Data/Asset] related to the objective: forecast SKU demand and explain seasonality, promotions, price, channel, and external drivers. Materials: [At least 24 months of sales history], [Stockout flags], [Promotions and price], [Holidays], [Lead time and units]. Classify findings as Blocking, Major, Moderate, or Optimization, and quote the evidence that triggers each finding. Provide: (1) an issue list; (2) Baseline forecast, Scenario forecasts, Error and confidence interval, Demand drivers, Review plan; (3) at least four improvements or experiments prioritized by impact versus effort; (4) for each experiment, the hypothesis, change, primary metric, guardrail metrics, observation period, and stopping rule; and (5) required human approvals before publishing or execution. Special requirement: Use a Situation-Task-Constraints-Output structure. Specify units such as pieces, cartons, or pallets, and do not treat stockout-period sales as true demand.