How to Do an ABC Analysis? A Guide to Inventory Classification, the Pareto Rule and Spotting Dead Stock
How do you do an ABC analysis? The Pareto rule in inventory, step-by-step classification, a sample ABC table, management rules by class, XYZ analysis and spotting dead stock.
Contents 10 sections
- What is ABC analysis?
- What data is used in ABC analysis?
- How do you do an ABC analysis step by step?
- Example: the ABC table of a store with 10 products
- How are class A, B and C products managed?
- What is XYZ analysis, and how is it combined with ABC?
- What is dead stock, and how do you spot it?
- The 7 most common mistakes in ABC analysis
- How do you do an ABC analysis with NetKasam?
- Frequently Asked Questions About ABC Analysis
In a business that holds hundreds of products in stock, it is impossible to give every product the same attention. Nor is it necessary: in most businesses a few products bring in most of the sales, while half the products account for only a small share of total sales. Even so, counting, ordering and promotion decisions are usually applied to all products at the same frequency. The answer to how to do an ABC analysis is to divide products into three classes according to the value they bring to the business and focus your attention on the products that create the most value.
In this guide we explain ABC analysis step by step: the Pareto (80/20) rule, which data to use in the analysis, building an ABC table with a 10-product example, how to manage class A, B and C products, XYZ analysis that measures how regular demand is, dead stock detection that reveals money tied up in inventory, and the 7 most common mistakes. The products and figures in the examples were chosen only to illustrate the method.
What is ABC analysis?
In short: ABC analysis is the classification of products in inventory as A (most important), B (medium) and C (least important) according to the value they bring to the business. The goal is to devote limited time and capital to the products that create the most value.
The method is based on the Pareto principle: in many areas, most of the results come from a small share of the causes. In inventory, this shows up as "about 20% of products make up about 80% of sales value." The ratios will not come out at exactly 80/20 in every business; what matters is seeing that value is concentrated in a few products and making management decisions accordingly.
ABC analysis is one of the core tools of product management and inventory planning. Many decisions, from counting frequency to supplier selection and from promotion plans to warehouse layout, differ depending on which class a product is in. You can find the general framework of inventory management in our article what you need to know about inventory management.
What data is used in ABC analysis?
In short: The most common measure is annual sales (consumption) value: units sold per year × unit cost. Trading businesses can also use sales revenue, and those focused on profitability can use gross profit. What matters is using the same measure and the same period for all products.
Looking only at units sold is misleading. A ₺15 product that sells 2,000 units a year creates ₺30,000 in value, while a ₺1,600 product that sells 300 units a year creates ₺480,000. Ranked by units, the first product comes out on top; ranked by value, the second is far more important. That is why ABC analysis always uses units and unit value together.
| Measure | Account | When is it used? |
|---|---|---|
| Annual consumption value | Annual units × Unit cost | For managing money tied up in inventory and planning counts and orders |
| Annual sales revenue | Annual units × Selling price (excluding VAT) | For seeing the contribution to revenue and making promotion and showcase decisions |
| Annual gross profit | Annual units × (Selling price − Unit cost) | For seeing the contribution to profit and making pricing and product range decisions |
The period is usually the last 12 months; for seasonal products a full year matters because it covers every season. All the data needed for the analysis (units sold and cost by product) is already in your bookkeeping and inventory records. To calculate cost correctly, see our article how to calculate inventory cost.
How do you do an ABC analysis step by step?
In short: Calculate each product's annual value, sort the products by value from largest to smallest, and find each product's share of the total and its cumulative share; products with a cumulative share up to 80% go into class A, up to 95% into class B, and the rest into class C.
- 01Get the dataReport units sold and unit cost by product for the last 12 months.
- 02Calculate the valueFor each product, find annual units × unit cost.
- 03SortArrange the products by value from largest to smallest.
- 04Find the sharesCalculate each product's share of the total and its cumulative share from top to bottom.
- 05ClassifyMark up to a cumulative 80% as A, up to 95% as B, and the rest as C.
- 06Set rulesDefine counting, ordering and promotion rules for each class.
The analysis is refreshed every three or six months; products can change class.
- Annual value = Units sold per year × Unit cost
- Product's share (%) = Product's annual value ÷ Total value of all products × 100
- Cumulative share (%) = Sum of the shares in the ranking up to that product
- Class = A for a cumulative share up to 80%, B between 80–95%, C above 95%
- Inventory carrying cost = Average inventory value × Annual carrying rate
The 80% and 95% thresholds are a common starting point; depending on the business, they can be adjusted within the 70–90% and 90–95% ranges.
Example: the ABC table of a store with 10 products
In short: Of 10 products with a total annual value of ₺1,000,000, 2 (20% of the products) make up 80% of the value and are class A; 3 products fall into class B and 5 into class C. Half of the products account for only 5% of the total value.
Below is the last 12 months of data from a store selling home textiles. The products are sorted by annual value. The figures were chosen only to illustrate the method:
| Rank | Product | Annual value | Share | Cumulative share | Class |
|---|---|---|---|---|---|
| 1 | Duvet cover set | 480.000 ₺ | %48,0 | %48,0 | A |
| 2 | Coverlet set | 320.000 ₺ | %32,0 | %80,0 | A |
| 3 | Towel set | 70.000 ₺ | %7,0 | %87,0 | B |
| 4 | Pillow | 50.000 ₺ | %5,0 | %92,0 | B |
| 5 | Blanket | 30.000 ₺ | %3,0 | %95,0 | B |
| 6 | Tablecloth | 18.000 ₺ | %1,8 | %96,8 | C |
| 7 | Cushion cover | 12.000 ₺ | %1,2 | %98,0 | C |
| 8 | Bath mat | 9.000 ₺ | %0,9 | %98,9 | C |
| 9 | Napkin set | 7.000 ₺ | %0,7 | %99,6 | C |
| 10 | Oven mitt | 4.000 ₺ | %0,4 | %100,0 | C |
- Duvet cover set (A)48%
- Coverlet set (A)32%
- Towel set (B)7%
- Pillow (B)5%
- Blanket (B)3%
- Tablecloth (C)1.8%
- Cushion cover (C)1.2%
- Bath mat (C)0.9%
- Napkin set (C)0.7%
- Oven mitt (C)0.4%
Prepared with sample values. Value: annual units × unit cost.
- Class A (2 products)₺800,00080%
- Class B (3 products)₺150,00015%
- Class C (5 products)₺50,0005%
Prepared with sample values.
The table makes the store's day-to-day priorities clear. Being out of stock on the duvet cover and coverlet sets for a week can cost more than the five C products' combined value for a whole year. By contrast, the five C products account for half the counting and ordering work yet bring in only 5% of the value.
- 20%of products (2 items) are class A
- 80%class A's share of total value
- 50%of products (5 items) are class C
- 5%class C's share of total value
Prepared with sample values.
How are class A, B and C products managed?
In short: Class A products are counted often, their stock levels are watched closely, their reorder level is kept tight, and they are never allowed to run out. Class B is checked at regular intervals. For class C, stock and workload are kept to a minimum; orders are placed in bulk and infrequently.
| Topic | Class A | Class B | Class C |
|---|---|---|---|
| Stock check | Daily or weekly | Weekly | Monthly |
| Counting frequency (suggested) | Once a month | Every three months | Every six months |
| Reorder level | Tight; a buffer against the risk of stockouts | Medium | Low |
| Order | Frequent, small batches; alternative supplier | On a regular schedule | In bulk and infrequently |
| Pricing and promotions | Price monitored carefully, no unnecessary discounts | Seasonal promotions | Bundles, cross-selling, liquidation if needed |
| Warehouse layout | Shelves closest to picking | Medium distance | Distant shelves |
The common logic behind these rules is to spread effort in proportion to value. Because running out of A products is very costly, holding a little extra stock is acceptable. For C products, every extra unit ties up capital; these products are positioned to help sales alongside other products. For ideas on selling products together, see how to cross-sell.
What is XYZ analysis, and how is it combined with ABC?
In short: XYZ analysis classifies products by how regular their demand is: X means steady and predictable, Y fluctuating or seasonal, and Z irregular and hard-to-predict demand. ABC answers "how important is it," while XYZ answers "how predictable is it."
When the two analyses are used together, nine combinations emerge, and a different inventory policy is applied to each. The four most commonly used are:
- AX (valuable and steady): Because demand is predictable, stock can be kept low and orders placed frequently. This is the easiest group to manage and the most profitable.
- AZ (valuable but irregular): This is the riskiest group. Running out of stock is expensive, and excess stock ties up a lot of capital. It requires a fast-delivery agreement with the supplier and close monitoring.
- CX (low value but steady): Suited to automatic, bulk ordering; this is the group whose management should take the least time.
- CZ (low value and irregular): A dead stock candidate. Consider sourcing to order, bundling or removing it from the catalog.
Demand regularity is measured by how close monthly sales are to each other. A product with similar sales every month falls into class X, a product whose sales rise in certain months into class Y, and a product that sells nothing in some months and suddenly sells in others into class Z.
What is dead stock, and how do you spot it?
In short: Dead stock is products that have not sold at all for a certain period (usually 90 or 180 days). To spot it, check each product's last sale date and group stock by "days since last sale."
Dead stock is a silent cost: it sits on the shelf, takes up warehouse space, ties up capital, goes out of fashion or spoils. The annual cost of holding stock is found by adding up storage, insurance, loss of value and the opportunity cost of the tied-up money. For example, if this cost is taken as 25% of inventory value per year, ₺60,000 of stock older than 90 days creates roughly ₺15,000 in cost per year. The rate is an example; calculate it with your own warehouse and financing costs.
| Since last sale | Inventory value (example) | Situation | What to do? |
|---|---|---|---|
| 0–30 days | 250.000 ₺ | Active | Normal management |
| 31–90 days | 90.000 ₺ | Slowing | Review price, visibility and product page; stop new orders |
| 91–180 days | 40.000 ₺ | Dead stock risk | Promotion, bundling, trial on a different sales channel |
| More than 180 days | 20.000 ₺ | Dead stock | Explore liquidation, wholesale or returning to the supplier |
Two rules stand out in fighting dead stock. First, no new orders are placed for a slowing product; the problem usually grows out of the habit of "stock is running low, let's buy more." Second, the liquidation decision should not be delayed: the value of an unsold product falls over time, and a discount rejected today may not be enough six months from now. We explained how to present discontinued products to customers in our article how to manage out-of-stock products. You can find other ways to reduce inventory cost in our article ways to reduce inventory cost.
Recommended readingHow to Transfer Stock Between Warehouses? Training on Transfer Needs, Days of Coverage, Dispatch Lists and Receiving CountsThe 7 most common mistakes in ABC analysis
In short: The most common mistakes are ranking products only by units sold, doing the analysis once and leaving it, putting new products into class C, and classifying without changing management rules.
- Looking only at units. A cheap, fast-selling product looks valuable. Value is always measured as units × unit cost (or revenue).
- Doing the analysis once. Demand changes and products change class. The analysis should be refreshed every three or six months.
- Putting new products into class C. A product with a short sales history looks low in value. New products are tracked separately and classified once enough data builds up.
- Ignoring seasonality. A product sold in winter looks like a C with summer data. For seasonal products, full-year data is used.
- Classifying without setting rules. The value of an ABC table shows up through different counting, ordering and promotion rules for each class. Without rules, the analysis is just a report.
- Liquidating complementary products. C products sold together with an A product are the ones that grow the basket. Check co-purchase data before liquidating.
- Merging variants. A T-shirt's total sales may be class A, but some sizes and colors are dead stock. The analysis should also be done at the variant level; we explained variant management in our article how to manage products with variants.
How do you do an ABC analysis with NetKasam?
In short: NetKasam keeps your sales and stock movements, costs and inventory turnover rates by product; by exporting reports to Excel you can build your ABC table in minutes, and with reorder levels you keep your class A products from running out.
With NetKasam inventory management you see your products' inventory turnover rates and report your costs. The detailed stock movements report shows when each product and each variant was sold; this is where the last-sale information needed to spot dead stock comes from. By setting a reorder level for your products, you purchase on time with reorder reports prepared according to inventory turnover; this is the most important protection for class A products.
In the Reports section, save the sales-by-product report and export it to Excel to do the ABC ranking with a few formulas. If you have more than one warehouse, branch and warehouse management lets you report each warehouse separately and transfer dead stock to the warehouse where it sells better. Bookkeeping and the e-Invoice system are always free.
Frequently Asked Questions About ABC Analysis
What is ABC analysis?
It is the classification of products in inventory as A, B and C according to the value they bring to the business. Class A products make up about 80% of the value, B the next 15%, and C the remaining 5%.
How do you do an ABC analysis?
Calculate each product's annual value (units × unit cost), sort the products from largest to smallest and find their cumulative shares. Products with a cumulative share up to 80% go into class A, up to 95% into class B, and the rest into class C.
Why are the percentages 80/15/5 in ABC analysis?
These thresholds are a common starting point based on the Pareto principle. Depending on the business's product mix, they can be adjusted to 70–90% for A and 90–95% for B; what matters is using the same thresholds in every analysis.
How often should an ABC analysis be done?
Refreshing it every three or six months is recommended. For seasonal products, use data from the last 12 months, and track new products separately until enough sales data builds up.
What is XYZ analysis?
It classifies products by how regular their demand is: X means steady, Y fluctuating or seasonal, and Z irregular demand. Used together with ABC, it lets you set a more accurate inventory policy for each product.
What is dead stock?
It is a product that has not sold at all for a certain period, usually 90 or 180 days. It takes up warehouse space, ties up capital and loses value; it should be cleared through promotions, bundles or liquidation.
Should class C products be removed from the catalog?
Not right away. Some C products grow the basket by selling alongside A products. Before deciding to liquidate or remove them, look at co-purchase data and how regular the demand is.
Can an ABC analysis be done in Excel?
Yes. Export units sold and cost data by product to Excel; calculate the value, share and cumulative share columns with a few formulas, then fill in the class column based on the thresholds.
ABC analysis lets you look at your inventory through the lens of value for the first time. Today, pull the sales-by-product report for the last 12 months, sort it by value and mark the products up to a cumulative 80%. The moment you check the reorder levels of the products on this short list and set aside the products that have not sold at all in the last 90 days, you will see where the money in your inventory is working and where it is just sitting.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.