ABC-XYZ Inventory Analysis: A Step-by-Step Guide
A step-by-step ABC XYZ analysis guide for manufacturers: the nine-box matrix, thresholds, CV math, and the policy to run for each segment.
ABC XYZ analysis is the fastest way to stop treating 5,000 SKUs the same way — which is the root cause of most mid-market inventory pain. Plain ABC tells you what's worth money. XYZ tells you what's predictable. Cross them and you get a nine-box grid that says, for every part, exactly how tightly to control it and how to forecast it. I ran this at a $250M furniture manufacturer and it was the single highest-leverage planning exercise we did, because it turned "we have an inventory problem" into "we have a problem in these three boxes."
Here's how to run an ABC XYZ analysis end to end, the thresholds that actually work, and the policy to attach to each segment.
What ABC and XYZ each measure
They answer two different questions, and you need both.
- ABC = value. Classic Pareto. A small slice of SKUs drives most of your annual consumption value. Rank parts by annual usage in dollars, then split into A, B, C.
- XYZ = demand variability. How predictable is the demand pattern? X is steady and easy to forecast. Z is erratic and ugly. The metric is the coefficient of variation (CV) — standard deviation of demand divided by mean demand.
ABC alone leads you astray. A high-value A-item that's wildly erratic (an AZ) needs a completely different policy than a high-value steady item (an AX), even though ABC lumps them together. XYZ is the missing axis.
Step 1 — Run the ABC classification
Pull 12 months of consumption per SKU. Multiply annual usage quantity by unit cost to get annual usage value. Sort descending. Compute the cumulative percentage of total value.
Standard thresholds:
| Class | Share of SKUs | Share of value |
|---|---|---|
| A | ~10–20% | ~70–80% |
| B | ~20–30% | ~15–20% |
| C | ~50–70% | ~5–10% |
Don't religiously force 80/15/5. Look at where the curve actually bends and cut there. In a furniture BOM, the A-class was a few hundred SKUs out of several thousand and it carried most of our tied-up cash. Those are the parts where a 1% holding improvement is real money.
Step 2 — Run the XYZ classification
For each SKU, take monthly demand over the same 12 months. Compute the coefficient of variation:
CV = Standard Deviation of Demand ÷ Mean Demand
Then bucket:
| Class | CV range | Demand pattern | Forecastability |
|---|---|---|---|
| X | < 0.5 | Stable, low fluctuation | High — forecast tightly |
| Y | 0.5–1.0 | Trending or seasonal | Medium — model the pattern |
| Z | > 1.0 | Erratic, sporadic, lumpy | Low — buffer or make-to-order |
A CV of 0.2 means demand barely moves month to month — forecast it and trust the number. A CV of 1.5 means demand is all over the place; no forecast saves you, so you manage it with buffer stock or by not stocking it at all.
One trap: SKUs with intermittent demand (zeros most months, a spike occasionally) will throw a high CV and land in Z. That's correct — they belong in Z — but forecast them with intermittent-demand methods (Croston's), not by averaging zeros into a meaningless mean.
Step 3 — Build the nine-box matrix
Cross the two axes and every SKU lands in one of nine cells:
| X (steady) | Y (variable) | Z (erratic) | |
|---|---|---|---|
| A (high value) | AX | AY | AZ |
| B (mid value) | BX | BY | BZ |
| C (low value) | CX | CY | CZ |
This grid is the whole point. It tells you where to spend attention. The top-left (AX) is your dream segment — high value, dead predictable. The top-right (AZ) is where you bleed: expensive parts with unpredictable demand, the hardest combination in your catalog.
Step 4 — Attach a policy to each box
Classification without policy is a colorful spreadsheet. Here's what to do with each segment:
- AX — high value, predictable. Tight automated replenishment, low safety stock, frequent small orders, high service level (98–99%). The math is reliable, so squeeze inventory hard. JIT candidates.
- AY — high value, seasonal/trending. Forecast with seasonality and trend models. Moderate safety stock that flexes with the season. Review monthly.
- AZ — high value, erratic. The danger zone. Don't try to forecast your way out. Consider make-to-order, vendor-managed inventory, or strategic buffer with tight management attention. Every dollar here is risk.
- BX / BY — mid value. Standard reorder-point policies. Automate the BX, model the BY. Don't over-engineer.
- BZ — mid value, erratic. Modest buffer, periodic review, accept some stockouts. Not worth heavy forecasting effort.
- CX — low value, predictable. Bulk-buy, hold plenty, automate fully, review rarely. Cheap to over-stock; the labor to manage tightly costs more than the inventory.
- CY / CZ — low value, variable/erratic. Min-max with generous buffers, or two-bin systems on the shop floor. These are the parts you should stop spending planning time on. Set it and forget it.
The pattern across the grid: forecast effort goes up-and-left, buffer-and-ignore goes down-and-right. Don't run MRP gymnastics on a CZ washer. Don't run a two-bin system on an AX motor.
What this actually fixes
The reason ABC XYZ analysis matters for a manufacturer:
- It finds your stranded cash. Excess almost always concentrates in CZ and BZ — low-value erratic parts where someone over-bought "to be safe." Quantify it and you've found the working capital to free up.
- It stops the stockouts that hurt. AX and AY stockouts are the ones that halt a line or miss a customer ship. Segmenting lets you over-protect exactly those without over-protecting everything.
- It rations your team's attention. Your planners can't tune 5,000 SKUs. The matrix tells them the few hundred that deserve real thought (AX, AY, AZ) and the thousands that should run on autopilot.
Run it on a cadence, not once
SKUs migrate across the grid. A new product climbs from C to A. A maturing one goes from Y to X as demand settles. A discontinued line drifts into Z. Re-run the full classification quarterly, and you'll catch parts whose policy no longer fits before they turn into excess or a stockout.
The failure mode is doing this once in a consulting engagement, printing the matrix, and never refreshing it. Within two quarters it's stale. Push it into your planning system so it recomputes automatically and your team reviews the movers between boxes.
See where your cash is stuck
Most mid-market manufacturers have never run a clean ABC XYZ analysis, and the moment they do, the same picture appears: over-stocked CZ junk, under-protected AX critical parts. We'll run a free planning-maturity and stranded-inventory teardown on your item master, build your nine-box matrix, and show you exactly which segments are eating working capital. Book a call and bring 12 months of usage data — you'll walk away with the matrix and the policy for each box.
Let's see what's worth building first.
A 15-minute call: tell me where your AI or planning is stuck, and I'll tell you the one thing worth building first — and whether it's worth doing at all.