✏️Prompts

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