ABC-XYZ: not every product deserves the same attention

A few products carry most of the money; some sell steadily and others unpredictably. Classifying both ways tells you where to focus.

A · 10 parts · 81% of salesB · 16 parts · 14% of salesC · 14 parts · 5% of sales$0$209K$418K$627K$835K0%25%50%75%100%Parts, from highest to lowest annual sales →Cumulative % of sales ─Annual sales ($)P-002 · Belts · $835K a year · 35% of salesP-034 · Hydraulics · $374K a year · 16% of salesP-012 · Electrical · $228K a year · 10% of salesP-027 · Bearings · $131K a year · 5% of salesP-035 · Bearings · $96K a year · 4% of salesP-028 · Electrical · $71K a year · 3% of salesP-032 · Electrical · $69K a year · 3% of salesP-009 · Electrical · $55K a year · 2% of salesP-031 · Seals & gaskets · $51K a year · 2% of salesP-037 · Tires · $41K a year · 2% of salesP-040 · Seals & gaskets · $36K a year · 2% of salesP-011 · Electrical · $34K a year · 1% of salesP-025 · Electrical · $30K a year · 1% of salesP-020 · Electrical · $26K a year · 1% of salesP-024 · Filters · $24K a year · 1% of salesP-039 · Electrical · $23K a year · 1% of salesP-036 · Electrical · $22K a year · 1% of salesP-004 · Bearings · $20K a year · 1% of salesP-029 · Tires · $18K a year · 1% of salesP-017 · Bearings · $17K a year · 1% of salesP-021 · Seals & gaskets · $17K a year · 1% of salesP-013 · Bearings · $15K a year · 1% of salesP-007 · Bearings · $14K a year · 1% of salesP-030 · Bearings · $13K a year · 1% of salesP-010 · Bearings · $12K a year · 0% of salesP-022 · Hydraulics · $11K a year · 0% of salesP-005 · Tires · $10K a year · 0% of salesP-006 · Filters · $10K a year · 0% of salesP-023 · Filters · $10K a year · 0% of salesP-018 · Tires · $9K a year · 0% of salesP-014 · Bearings · $9K a year · 0% of salesP-008 · Hydraulics · $9K a year · 0% of salesP-033 · Seals & gaskets · $9K a year · 0% of salesP-016 · Belts · $9K a year · 0% of salesP-019 · Seals & gaskets · $8K a year · 0% of salesP-015 · Hydraulics · $7K a year · 0% of salesP-026 · Belts · $7K a year · 0% of salesP-038 · Electrical · $7K a year · 0% of salesP-003 · Seals & gaskets · $6K a year · 0% of salesP-001 · Filters · $6K a year · 0% of salesA up to 80%B up to 95%

The 3 × 3 matrix

XYZABC

The big number is the share of sales in each box. Click a box to light up its parts and see what to do with them.

A · high valueB · mediumC · low valueCumulative salesCutoff line
40 of 40 parts
A parts
10 · 25%
Sales in A
81%
C parts
14 · 35%
Sales in C
5%
Erratic (Z) parts
12 · 30%
Sales that are A and erratic
10%

The stage shows a catalogue of 40 spare parts, one bar per part, sorted from the one that sells the most dollars a year to the one that sells the least. The white line adds them up: after the first bar, after the first two, and so on.

Look how fast the white line climbs. In most businesses a handful of parts bring in most of the money. That is the Pareto rule, often called 80/20: about 20% of the products make about 80% of the sales.

ABC puts a name on it. A = the few parts that make up the first 80% of the value. B = the next 15%. C = the long tail of cheap or slow parts that together add up to only 5%.

Variability (XYZ)

Value is only half the story. Two parts can sell the same dollars a year: one sells a little every single week, the other sells nothing for two months and then a big order arrives. The second one is much harder to stock.

XYZ measures that. We take 26 weeks of sales and compare how much they swing with the average. That ratio is the coefficient of variation (CV). X = steady (low CV), Y = it moves around, Z = erratic or lumpy.

CV = weekly σ ÷ weekly average
σ (sigma) is how far a typical week lands from the average. CV 0.2 means weeks usually land within ±20% of the average; CV 1.5 means the swings are bigger than the average itself.

The 3 × 3 matrix

Put both together and you get nine boxes. Each box needs a different way of working — how often you review it, how much safety stock it gets, and how much of your planners' time it deserves. Lesson 3 turns each box into an ordering rule.

The 80 / 95 cutoffs and the 0.5 / 1.0 CV lines are common starting points, not laws. Pick lines that give you a manageable number of A items to watch closely — then keep them the same so the classes mean something month after month.

Try this

What to remember

  • A few parts make most of your sales. Find them and give them your best attention.
  • ABC ranks by value: A = first ~80% of sales, B = next ~15%, C = the long tail.
  • XYZ ranks by predictability: the coefficient of variation compares the weekly swings with the average.
  • The combination tells you how to manage each part: AX is easy money, AZ needs a human, CZ may not belong in stock at all.
  • Re-run the classification every quarter — products move between boxes as the business changes.