✏️Prompts

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