Assortment matrix: what it is and how to build one with ABC/XYZ analysis

Contents
  1. When people look up assortment planning
  2. What an assortment matrix is, in simple terms
  3. What an assortment matrix is made of
  4. How to build an assortment matrix: 7 steps with an example
  5. Assortment matrix example: an Excel layout
  6. How to review the matrix: dead stock, stockouts and new products
  7. When to keep the matrix in inventory software
  8. Frequently asked questions
  9. Sources

An assortment matrix is the list of products a store must always have for sale, with categories, price tiers, product roles, suppliers and minimum stock levels. You build it in seven steps: the customer, the category tree, width and depth, product roles, ABC analysis by profit, XYZ analysis by demand stability, and a decision for each item. The matrix then drives purchasing, catalog content and what to phase out.

The main mistake is building the matrix by gut feeling or straight from a supplier's catalog: money ends up in products that sell once a season, while bestsellers keep running out. Below: what a matrix is made of, a step-by-step calculation for an illustrative category of eight products, a ready table for Excel, and how to review the matrix.

When people look up assortment planning

Usually it is a store that has grown to a few hundred products: some sit for months, others are always out of stock, and the buyer reorders "same as last time". The searches go "assortment planning", "assortment planning template", "abc xyz analysis excel", and then "how to do assortment planning".

A template on its own will not help much: the columns are the same everywhere, and the "keep or drop" decision comes only from sales data. So below you get not only the table but also how to fill it in.

What an assortment matrix is, in simple terms

The assortment is everything the store has right now. The matrix is the plan: which products must always be there, in what quantity and why. The gap between the two shows stockouts (a matrix item has run out) and random items (a product is in stock but not in the matrix). A store does not buy products outside the matrix, even when a supplier offers a good deal.

Assortment matrix, assortment plan, product matrix: the same thing?

An assortment matrix and an assortment plan describe the same thing: what to carry and in what depth. "Product matrix" in retail means the same, but in strategy it usually refers to the BCG growth-share matrix with "stars", "cash cows", "question marks" and "dogs". The BCG matrix helps decide which business lines to invest in; the assortment matrix decides what to keep on the shelf.

What an assortment matrix is made of

Six parameters describe a matrix: width, depth, price tier, product role, minimum stock and supplier.

Matrix width is the number of categories: laundry, dishes, cleaning, hygiene; depth is the number of items per category
ParameterWhat it meansExample for a household cleaning store
WidthNumber of categoriesLaundry, dishes, cleaning, hygiene — 4 categories
DepthNumber of items in a categoryLaundry has 8 items: powders, liquids, pods, fabric softener, stain remover, bleach
Price tierValue, mid-range, premiumA regular liquid detergent and a premium eco detergent
Product roleWhy the product is in the rangeA cheap powder brings customers in, a stain remover raises the basket
Minimum stockThe level at which you reorder30 boxes of powder
SupplierMain and backupSupplier A; if out of stock, Supplier B

There are five product roles. The role decides how you judge a product: a traffic product does not have to earn much, a core product does.

  • Traffic — the lowest price or the highest demand; people come for it. Low margin.
  • Core — the base of the category's sales and profit.
  • Add-on — bought together with the main item: a stain remover with detergent. Raises the basket.
  • Image — an expensive or rare product that shapes how people see the store. Sells rarely.
  • Seasonal — enters the matrix for the season and leaves after it.
Five product roles in the matrix: traffic, core, add-on, image, seasonal

How to build an assortment matrix: 7 steps with an example

The first four steps set the frame, the last three run on sales numbers. A new store without sales history uses competitors' range and supplier forecasts for steps 5–6, then repeats them on its own data after a quarter.

  1. Define the customer. Who the store is for and in which price tier. This cuts half of the unnecessary items.
  2. Build the category tree. Categories and subcategories the way customers search, not the way the supplier's file is organized.
  3. Set width and depth. How many items each subcategory needs so there is a choice by price, without two identical products in one tier.
  4. Assign roles. In each category: traffic, core and add-on products.
  5. Run an ABC analysis by profit. It shows which products earn money.
  6. Run an XYZ analysis by sales. It shows how steadily each product sells.
  7. Decide on each item and set minimum stock levels.

Illustrative example for the arithmetic, not market data. The "Laundry" category of a household cleaning store, eight products, sales for one quarter:

ABC and XYZ for the "Laundry" category over a quarter (illustrative numbers)
ProductProfit, €Cumulative shareABCMonthly sales, unitsCoefficient of variationXYZ
Laundry powder, 3 kg1,20040.0%A100 / 105 / 954.1%X
Liquid detergent, 1.5 l80066.7%A60 / 70 / 5013.6%Y
Laundry pods, 30 pcs40080.0%A30 / 32 / 285.4%X
Fabric softener, 1 l25088.3%B40 / 20 / 3027.2%Z
Stain remover spray15093.3%B15 / 16 / 145.4%X
Bleach10096.7%C10 / 20 / 553.5%Z
Baby laundry detergent6098.7%C8 / 9 / 85.7%X
Premium eco detergent40100%C2 / 6 / 172.0%Z

Step 5: ABC analysis by profit

Sort products by profit from highest to lowest, calculate each one's share and the cumulative share. Common cut-offs: up to 80% of cumulative profit is group A, up to 95% is B, the rest is C. In the example the category's total profit is €3,000: the first three products make €2,400, which is 80%, so they are group A. Fabric softener and stain remover bring the share to 93.3% — group B; the last three are C.

ABC analysis: three group A products make 80% of profit, two are group B, three are group C

Rank by profit, not revenue: a cheap traffic product can be first by revenue and last by profit. More on the method in ABC analysis of product profitability.

Step 6: XYZ analysis by demand stability

Coefficient of variation = standard deviation of sales ÷ average sales × 100%. The lower it is, the more evenly the product sells. Common thresholds: up to 10% is X, 10–25% is Y, above 25% is Z; in practice you adjust them to the category's seasonality.

For the liquid detergent: average sales (60 + 70 + 50) ÷ 3 = 60 units. Deviations from the average are 0, +10 and −10, the mean of squared deviations is (0 + 100 + 100) ÷ 3 ≈ 66.7, and its square root ≈ 8.2. The coefficient is 8.2 ÷ 60 ≈ 13.6% — group Y. In Excel or Google Sheets the formula =STDEV.P(B2:D2)/AVERAGE(B2:D2) does the same, where B2:D2 are the product's monthly sales. Three months is the minimum for an example; for real decisions take six to twelve.

Step 7: a decision for each ABC/XYZ cell

Combine the two letters and you get nine cells, each with its own purchasing rule.

Nine-cell ABC/XYZ matrix: AX is always in stock, CZ is a candidate to phase out
CellProducts from the exampleDecision
AXPowder, podsAlways in stock, reorder at minimum stock, small safety stock
AYLiquid detergentAlways in stock, larger safety stock to cover demand swings
BXStain removerKeep: a steady add-on product
BZFabric softenerFind the reason for the spikes (a promotion, the supplier being out); buy to demand
CXBaby detergentKeep with minimal stock if your customers need it
CZBleach, eco detergentCandidates to phase out or sell to order

Before dropping a CZ product, check its role. The eco detergent in the example is a premium image product: you do not hold stock of it, but you keep it on the website and sell it to order. Bleach has no special role, so it goes.

Minimum stock is calculated as average daily sales × supplier lead time in days + safety stock. Powder: 100 units a month ÷ 30 ≈ 3.3 a day; with a 7-day lead time that is ≈ 23 units, plus 7 units of safety stock — 30 in total.

Assortment matrix example: an Excel layout

A finished matrix is a table with one row per item. You can copy the columns into Excel or Google Sheets as a template; the last column is a status that keeps the matrix alive: "New" — a product on trial, "In matrix" — must be in stock, "To order", "Phase out" — sell through and stop buying.

The "Laundry" matrix after the calculation (illustrative numbers)
ProductTierRoleABC/XYZSupplierMin. stockStatus
Laundry powder, 3 kgValueTrafficAXSupplier A30In matrix
Liquid detergent, 1.5 lMid-rangeCoreAYSupplier A20In matrix
Laundry pods, 30 pcsMid-rangeCoreAXSupplier B10In matrix
Fabric softener, 1 lMid-rangeAdd-onBZSupplier A12In matrix
Stain remover sprayMid-rangeAdd-onBXSupplier B5In matrix
BleachValueCoreCZSupplier A0Phase out
Baby laundry detergentMid-rangeCoreCXSupplier B3In matrix
Premium eco detergentPremiumImageCZSupplier B0To order

How to review the matrix: dead stock, stockouts and new products

Review the matrix monthly or quarterly, and seasonal categories before every season. Besides repeating ABC/XYZ, run three checks:

  • Dead stock. Products with no sales for one to two months. What to do with them is covered in the article on getting rid of dead stock.
  • Stockouts. Group A products that are regularly unavailable: change the minimum stock or the supplier. What an empty shelf costs is covered in how to prevent out-of-stock losses.
  • New products. New items in supplier price lists are matrix candidates with the "New" status. After a quarter they go through the same ABC/XYZ.

When to keep the matrix in inventory software

When you have hundreds of products and several suppliers: a monthly ABC and a dead-stock check in a spreadsheet then take a day, and sales and stock data have to be exported and combined every time.

In Elbuz the matrix lives in the catalog itself, where categories, suppliers and prices already are. The sales report calculates ABC analysis by profit on its own, shows products with no movement for more than 30 days and items with critically low stock. Products from supplier price lists that are not in your catalog show up as new items, which are candidates for expanding the matrix. How supplier files feed the catalog is described on the supplier feeds automation page.

An honest caveat: the report has no XYZ analysis, so you will calculate the coefficient of variation in a spreadsheet with the formula above. And if you have a few dozen products, the Excel layout from this article is enough for now.

Assortment with ElbuzSupplier price lists, catalog and sales analytics, 14 days free

Frequently asked questions

What is an assortment matrix?

The list of products a store must always have for sale, with categories, price tiers, roles, suppliers and minimum stock levels. Purchasing and catalog content follow it.

What is assortment in retail?

The full set of products a store offers right now, described by width (number of categories), depth (items per category) and price range. The matrix is the plan for that assortment; the gap between them shows stockouts and random items.

What is the difference between ABC and XYZ analysis?

ABC ranks products by how much profit or revenue they bring; XYZ ranks them by how steady their demand is, using the coefficient of variation. Together they give nine cells, from AX (valuable and steady) to CZ (low value and erratic).

How often should you review an assortment matrix?

Monthly or quarterly based on sales, and seasonal categories before every season. Check stockouts of group A products weekly.

How do you build an assortment matrix in Excel?

One row per item, with columns for product, tier, role, ABC/XYZ, supplier, minimum stock and status. For XYZ use =STDEV.P(…)/AVERAGE(…) over monthly sales.

What is the BCG product matrix?

A strategy tool that splits products or business units by market growth and relative market share into stars, cash cows, question marks and dogs. It tells you where to invest, not what to keep in stock.

Sources

Checked on October 31, 2026.

Save a link to this article Telegram Facebook X LinkedIn Viber WhatsApp
Learn more about Elbuz with AI Ask your question — pick a chat and let AI study this page for you:

Discussion of the topic – Assortment matrix: what it is and how to build one with ABC/XYZ analysis

0 comments

There are no reviews for this product.

Write a comment

Your email address will not be published. Required fields are checked

Next

Try Elbuz free