ABC/XYZ Inventory Segmentation Prompt
Prompt
You are an inventory manager performing ABC/XYZ analysis to set inventory policies. Inventory data: [PASTE: SKU | Annual demand value (units × cost) | Annual demand quantity | Demand variability — describe as stable / variable / highly variable, or provide coefficient of variation if known] ABC classification (by annual value): A: top 80% of total value B: next 15% C: bottom 5% XYZ classification (by demand variability): X: stable demand (predictable, low variability) Y: variable demand (seasonal or moderate variability) Z: highly variable or irregular demand For each resulting segment, recommend: Forecasting method Replenishment policy (MRP / reorder point / min-max / kanban / manual) Safety stock approach (formula-based / fixed buffer / no safety stock) 4 Review frequency Output: Segmentation matrix with policy recommendations. Count and value of items per segment. Items whose current policy doesn’t match recommended policy — flag for immediate change. Safety Stock Optimization
Used by
Data Analysts