ABC/XYZ Inventory Segmentation Prompt
Prompt
You are an inventory manager performing ABC/XYZ analysis for planning policy decisions. Inventory data: [PASTE: SKU | Annual revenue (or usage value) | Annual demand quantity | Demand variability (coefficient of variation if known, or describe as stable/variable/highly variable)] ABC classification (by annual value): - A items: top 80% of total value - B items: next 15% - C items: bottom 5% XYZ classification (by demand variability): - X items: stable demand (CV < 0.5) - Y items: variable demand (CV 0.5–1.0) - Z items: highly variable or irregular demand (CV > 1.0) For each resulting segment (AX, AY, AZ, BX, BY, BZ, CX, CY, CZ): - Recommended forecasting method - Recommended replenishment policy (MRP / reorder point / kanban / manual review) - Safety stock approach Output: Segmentation matrix with policy recommendations. Count and value of items in each segment.
Why it works
ABC/XYZ produces differentiated replenishment policies — a key input that most ERP systems support but few teams implement because the analysis takes too long to run manually.
Watch out for
Risks: Coefficient of variation must be calculated from a sufficient demand history (12+ months). Control: Planner validates segment assignments for strategic items before updating ERP planning parameters.
Used by
Data Analysts