ABC-XYZ matrix: a SKU’s contribution to sales and demand stability
From a table of SKU sales over several periods splits them into classes A, B, C by contribution to sales and X, Y, Z by demand stability (the coefficient of variation), shows the matrix of sales shares and the number of SKUs and suggests a stock policy for each SKU.
At a glance
- What question does it answer?
- Which SKUs bring sales, which of them are stable, and what stock policy to assign to them.
- What data is needed?
- SKU sales over equal periods, one metric.
- How to read the result?
- Example on the default values (12 illustrative SKUs, 6 periods): class A gives 84.7% of sales with 58.3% of SKUs, AX articles 4 with a sales share of 58%, with unstable demand 4, candidates to drop CZ 1. Example on the default values: SKUs in the calculation: 12; Share of class A SKUs: 58.3%; Share of class A sales: 84.7%; AX SKUs: 4. The figures are illustrative: enter your own to see your result.
Why and how to reason
Not all SKUs are equally important, and not all are equally predictable. So they are classified along two axes. ABC answers “how much money does it bring”: SKUs in descending sales, class A are those that give the first 80% of cumulative sales, B up to 95%, the rest C. XYZ answers “how stable is demand”: the coefficient of variation (standard deviation ÷ mean) up to 30% is X, up to 60% Y, above Z. The basic jacket sells 180, 190, 175, 185, 195, 180: variation 4%, class X. The seasonal dress 20, 40, 110, 180, 230, 60: variation 78%, class Z. The 3 × 3 matrix gives a policy. AX: auto-reorder and high service. CZ: a candidate for removal. Here there are 12 SKUs, 58% of them class A give 85% of sales, AX are 4 items (58% of sales), unstable Z are four.
When to use it
Reach for it when setting stock policy, choosing which items to reorder automatically and where to keep safety stock, and when cleaning the assortment. Do not use it on short series (fewer than 6 periods) and on novelties: variation without history is random. Assumptions: the 80/95 and 30/60 boundaries are yours and can change, sales are taken in one valuation and for comparable periods.
How to read the result
First look at the matrix of sales shares: how much money is in each cell. AX and AY hold the business: they need high service and an accurate forecast. AZ are the hardest: much money and unstable demand, a more frequent order and safety stock are needed. Candidates for removal CZ (here 1, their sales share is small) should be checked before removal: perhaps it is a novelty or an item for a set. If the sales share of class C is 4% but there are many SKUs, you pay for complexity: consider cutting. For each SKU the calculation suggests a policy, but the decision remains yours.
Common mistakes
The usual mistakes: counting variation of a seasonal item over a year as instability although seasonality is predictable (use seasonal indices), taking ABC by quantity rather than money or margin, including novelties without history. Revisit classes quarterly, not once a year. Do not leave classes without decisions: every cell of the matrix should lead to a concrete ordering rule, otherwise the classification remains a report.
What data is needed?
- SKU sales over equal periods, one metric.
- The A, B and X, Y limits: yours, there is no single standard.
- For seasonal SKUs the season’s periods.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Class A limit | % of cumulative sales | 80 | A SKU is in A while the cumulative share of sales before it is below this limit. Your choice. |
| Class B limit | % of cumulative sales | 95 | C follows. Must be above the A limit. |
| Class X limit | % variation | 30 | The coefficient of variation not above this value: demand is stable. There is no single standard; for fashion the limits are wider than for basics. |
| Class Y limit | % variation | 60 | Above this is class Z: demand is unstable. Must be above the X limit. |
How it is calculated
| Step | Formula |
|---|---|
| ABC class | A while the cumulative share before the article is below the A limit; then B up to the B limit; otherwise C |
| Variation | standard deviation across periods ÷ mean, in percent (sample standard deviation, divisor n − 1) |
| XYZ class | X when variation is not above the X limit; Y not above the Y limit; otherwise Z |
| Policy | by the 3 × 3 table: from automatic reorder for AX to dropping for CZ |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Articles in the calculation
- 12
- Share of class A articles
- 58.3 %
- Share of class A sales
- 84.7 %
- AX articles
- 4Large and stable: the base of the range.
- Share of AX sales
- 58 %
- Articles with unstable demand (Z)
- 4
- Share of class C sales
- 4.3 %
- Candidates to drop (CZ)
- 1
- 0 … 58 %
Data as a table
| X | Y | Z | |
|---|---|---|---|
| A | 58 | 6.5 | 20.3 |
| B | 7.7 | 0 | 3.3 |
| C | 2.7 | 0 | 1.6 |
Data as a table
| Demand variation, % | Share of sales, % | |
|---|---|---|
| 4 | 19.31 | Basic jacket |
| 4.42 | 16.78 | Straight jeans |
| 4.49 | 12.41 | White T-shirt |
| 78.14 | 11.19 | Seasonal dress |
| 7.88 | 9.47 | Basic sneakers |
| 86.55 | 9.09 | Mid-season coat |
| 44.31 | 6.47 | Shirt |
| 6.08 | 4.28 | Socks (set) |
| 28.78 | 3.41 | Scarf |
| 91.89 | 3.32 | Hat |
| 11.06 | 2.71 | Bag |
| 95.48 | 1.56 | Belt |
Articles by descending sales
| Article | Sales | Share, % | Cumulative, % | ABC | Variation, % | XYZ | Class | Policy |
|---|---|---|---|---|---|---|---|---|
| Basic jacket | 1,105 | 19.3 | 19.3 | A | 4 | X | AX | Keep in stock always, automatic reorder |
| Straight jeans | 960 | 16.8 | 36.1 | A | 4.4 | X | AX | Keep in stock always, automatic reorder |
| White T-shirt | 710 | 12.4 | 48.5 | A | 4.5 | X | AX | Keep in stock always, automatic reorder |
| Seasonal dress | 640 | 11.2 | 59.7 | A | 78.1 | Z | AZ | Order in small parts, watch the stock |
| Basic sneakers | 542 | 9.5 | 69.2 | A | 7.9 | X | AX | Keep in stock always, automatic reorder |
| Mid-season coat | 520 | 9.1 | 78.3 | A | 86.6 | Z | AZ | Order in small parts, watch the stock |
| Shirt | 370 | 6.5 | 84.7 | A | 44.3 | Y | AY | Hold with a cushion, reorder by forecast |
| Socks (set) | 245 | 4.3 | 89 | B | 6.1 | X | BX | Automatic reorder with a stock cap |
| Scarf | 195 | 3.4 | 92.4 | B | 28.8 | X | BX | Automatic reorder with a stock cap |
| Hat | 190 | 3.3 | 95.7 | B | 91.9 | Z | BZ | Order to demand, do not pile up |
| Bag | 155 | 2.7 | 98.4 | C | 11.1 | X | CX | Minimal stock, rare orders |
| Belt | 89 | 1.6 | 100 | C | 95.5 | Z | CZ | A candidate to drop or to make to order |
Classes are relative to your range and your limits: there is no single standard for the limits. Z for a seasonal article often means seasonality and not weak demand; compare periods of one season. For footwear and children’s count at the model and size-core level: demand by single size is jagged. For accessories check dropping an article against margin and stock.
Nuances and limits
- Calling a seasonal SKU unstable over a year: compare periods of one season.
- Dropping CZ without checking margin and role in the look: an accessory may be needed.
- Taking zeros for no demand when the item was out of stock: an empty cell means “no data”.