Intermittent Demand Handling Prompt

You are a demand planner reviewing SKUs with intermittent or lumpy demand.
Data: [PASTE: SKU | Monthly demand for last 12 months (include zeros) | Unit cost | Lead time (days)]
For SKUs with intermittent demand (many zero-demand periods):
Calculate demand frequency — % of periods with non-zero demand
Calculate average demand when demand occurs (ADI — average demand interval)
Classify: smooth / erratic / intermittent / lumpy (use Syntetos-Boylan classification if possible)
Recommend forecasting approach: Croston’s method / moving average of non-zero periods / min/max with manual review
Recommend stocking policy: stock and replenish / stock-to-order / do not stock (order on demand only)
Output: Intermittent demand classification table. Stocking policy recommendation per SKU. Estimated inventory reduction from reclassifying do-not-stock items.
Demand Plan Risk & Opportunity Register