Skip to content
Inventory Management | Part 2 of 8

ABC and XYZ Analysis: Nine Fields, Nine Policies

Classify items by annual usage value and by demand variation, place them in a nine-field matrix and give each field its own replenishment policy.

Classification decides where a careful calculation pays and where a simple rule is enough. It needs two questions per item: how much value flows through it, and how predictable is it?

ABC: how much value

Calculate the annual usage value of every item: average demand per week, multiplied by the working weeks per year and by the unit price. Sort from high to low and add up the shares.

  • A items carry the first 80 percent of the value.
  • B items carry the next 15 percent.
  • C items carry the last 5 percent.

The item that crosses a limit still belongs to the higher class. In the pilot group of the drive unit plant, 40 purchased items of one product family, the result looks like this:

Class Items Share of usage value Stock in EUR Days on hand
A 9 81.3 % 297,210 56
B 8 14.4 % 85,355 91
C 23 4.3 % 82,933 296

Nine items decide the stock value. The 23 C items carry 4.3 percent of the value and hold 17.8 percent of the stock, enough for 296 days.

What ABC does not say

ABC by value says nothing about criticality. A screw for EUR 0.04 stops the assembly line as surely as a gear housing for EUR 42. The class tells you how much effort a calculation deserves. It does not tell you which item may run out: none of them.

XYZ: how predictable

XYZ uses the coefficient of variation: the standard deviation of weekly demand divided by the average weekly demand, taken from at least 13 weeks.

  • X up to 0.25: steady demand, good to forecast.
  • Y above 0.25 up to 0.50: fluctuating demand.
  • Z above 0.50: sporadic demand, or none at all.

The motor flange of the example has an average of 400 units per week and a standard deviation of 80. Its coefficient is 0.20, class X. In the pilot group, 19 items are X, 6 are Y and 15 are Z.

Nine fields, nine policies

Together the two classes form a matrix. Each field gets one written policy.

  • AX and AY: reorder point with calculated safety stock, weekly check, small lots or call-offs. For AY, share the forecast with the supplier.
  • AZ: no standard formula. Order for known demand, decide the safety stock item by item, or agree stock at the supplier.
  • BX and BY: reorder point with calculated safety stock, parameters reviewed every quarter.
  • BZ: order for known demand where the lead time allows it, otherwise a small fixed stock.
  • CX and CY: simple and generous. Two-bin, Kanban or minimum and maximum with a large reach.
  • CZ: order on demand or one last lot, and ask whether the item is needed at all.

Refresh the classes twice a year. They move with the product mix.

Where the stock really sits

The matrix becomes interesting when stock value is added per field. In the pilot group, the 12 CZ items hold EUR 50,119. That is 10.8 percent of the stock for 1.7 percent of the usage value, and more than the four BX items, which carry four times the usage value.

How to do it

In a workshop, let the group guess the A items before the calculation is shown. The surprise opens the discussion. Then draw the matrix on a wall, two meters wide, and place every item in its field.

Newsletter

One Lean idea.
Every two weeks.