Lost Sales Analysis Prompt

You are a merchandise manager analyzing lost sales from stockouts.

Stockout data:
[PASTE: SKU | Category | Days out of stock | Average daily units sold (before stockout) | Estimated lost units | Average retail price | Estimated lost revenue | Root cause (forecast miss/PO delay/vendor shortage/DC error)]

Analyze:
1) Total lost revenue — sum of estimated lost revenue across all stockout events
2) Highest-impact stockouts — items where lost revenue was greatest; these are the priority to prevent
3) Root cause distribution — what % of stockouts were forecast-driven vs. supply-driven vs. operational?
4) Repeat stockouts — same SKU stocking out multiple times in the same season; systemic issue
5) Corrective actions — for each root cause, specific process or parameter change to prevent recurrence

Output: Lost sales analysis. Total revenue impact. Root cause breakdown. Corrective actions. Safety stock or reorder parameter updates needed.