ABC inventory classification: how to sort your stock by value and count it less often
In short
ABC inventory classification ranks stock lines by annual consumption value and splits them into A, B and C bands. Run the sort on twelve months of sales, then count and reorder A lines most often.
- Annual consumption value is units sold in twelve months multiplied by unit cost.
- Rank lines high to low, add a running percentage, and cut the list into A, B and C bands.
- Common starting ranges put A lines at 70 to 80 percent of value, but your own data sets the cut-offs.
- Count A lines most often, B lines less often, and C lines once or twice a year.
- Re-run the sort every six to twelve months and override cheap lines that stop jobs.
ABC inventory classification ranks every stock line by annual consumption value and splits the list into A, B and C bands, so counting, reordering and supplier time go to the lines that carry the money. Here is the afternoon procedure.
ABC inventory classification is a way of ranking every stock line by its annual consumption value (units sold in a year multiplied by unit cost) and splitting the ranked list into three bands: A for the few lines that carry most of the money, B for the middle, and C for the long tail. To band your own stock, export twelve months of sales by line, price each line at a consistent cost, rank from highest to lowest value, add a running percentage, and draw the A, B and C cut-offs. You can finish the sort in an afternoon, and it tells you where to spend your counting, reordering and supplier time.
The idea rests on the Pareto principle: a small share of lines usually produces a large share of value. Published guides commonly put A lines at roughly 10 to 20 percent of items and 70 to 80 percent of annual value, with C lines at 50 to 70 percent of items and only 5 to 10 percent of value. Treat those as starting points. Your own spread will differ, and the sort shows you what it is.
What You Need Before You Start
You need three columns for every stock line: the SKU, the quantity sold or used over the last twelve months, and a unit cost. Twelve months smooths out seasonality, which matters in sectors such as promotional merchandise where one Q4 campaign can distort a quarter. A spreadsheet is enough. If your inventory records live in business management software, the sales-by-line export gives you the first two columns directly.
Pick one cost basis and stick to it. Average cost, last cost and standard cost all work, but mixing them within a single sort produces a ranking nobody can defend. Clean the data first: merge duplicate SKUs, check that units of measure agree (boxes versus pieces is the classic trap), and remove discontinued lines with no sales.
Rank by cost, not by price
Using selling price instead of cost inflates lines with fat margins and hides the capital you actually have tied up in stock. Use selling price only if your goal is revenue focus, and say so on the sheet.
The Sort, Step by Step
Export twelve months of sales by stock line
Pull quantity sold per SKU for the last twelve complete months. Include every line you stock or buy for stock, including slow movers, because the slow lines are what fill the C band.
Attach a single unit cost to each line
Add the cost per unit using one consistent basis. If supplier prices changed during the year, use the current average cost so each line is valued the same way.
Calculate annual consumption value
Multiply annual units by unit cost for each line. A line selling 20,000 units at $0.25 is worth $5,000 a year. A line selling 1,500 units at $8.00 is worth $12,000. Volume alone does not decide priority.
Rank the lines from highest value to lowest
Sort the sheet by annual consumption value, descending. The first row is the line that matters most to your stock investment.
Add each line's share and a running total
Divide each line's value by the grand total, then add a cumulative percentage column. The cumulative column is the one you will cut on.
Draw the A, B and C cut-offs
Pick thresholds on the cumulative column. A common choice is A up to about 70 to 80 percent, B up to about 95 percent, and C for the rest. Adjust until the A band holds a number of lines your team can realistically watch.
Review the exceptions before you finalize
Flag cheap lines that would stop a job if they ran out, such as a fixing or a label stock with a long lead time. Promote them one band. Pure arithmetic does not know about criticality, so a short human review does.
Attach a policy to each band and record it against the line
Write the band onto each stock record, then set the counting, reorder and supplier rules for it. Re-run the sort every six to twelve months, because lines move between bands.
A Worked Example With Ten Lines
The table below is illustrative, not real data, and ten lines is far fewer than a real catalog. It shows the mechanics only.
| Line | Annual units | Unit cost | Annual value | Cumulative share | Band | |---|---|---|---|---|---| | Insulated bottle | 4,000 | $6.00 | $24,000 | 24.5% | A | | Hoodie | 1,200 | $18.00 | $21,600 | 46.5% | A | | Tote bag | 6,000 | $2.50 | $15,000 | 61.8% | A | | Power bank | 1,500 | $8.00 | $12,000 | 74.1% | A | | Notebook | 5,000 | $1.60 | $8,000 | 82.3% | B | | Cap | 1,800 | $3.50 | $6,300 | 88.7% | B | | Pen | 20,000 | $0.25 | $5,000 | 93.8% | B | | Lanyard | 8,000 | $0.40 | $3,200 | 97.1% | C | | Sticker | 10,000 | $0.20 | $2,000 | 99.1% | C | | Keyring | 3,000 | $0.30 | $900 | 100% | C |
Total annual value is $98,000. The four A lines are 40 percent of the lines and 74 percent of the value. The pen has by far the highest unit volume yet sits in B, which is exactly the point: counting pens carefully would feel busy and protect little money.
What Each Band Changes in Practice
Once lines are banded, the same three jobs get different levels of effort. The frequencies below are a sensible starting pattern rather than a rule, so tune them to your own error rates.
Counting
Cycle counting is where the sort pays back first. Count A lines often, for example monthly, B lines quarterly, and C lines once or twice a year. A shortage on a high-value line shows up quickly and costs real money, so it deserves the short loop. Our guide to cycle counting without shutting the warehouse covers how to run the counts themselves.
Reordering
A lines justify individual attention: a deliberate reorder point, a reviewed safety stock level, and a weekly look at cover. C lines can run on simple rules, larger order quantities and fewer orders. Raising purchase orders for a cheap line less often cuts admin without much risk.
Supplier attention
Your A lines should map to a short list of suppliers. Those are the relationships worth a regular review of lead times, price and on-time delivery. Do not spend the same energy chasing the supplier of a C line worth a few hundred dollars a year.
Keep the band on the record
Store the A, B or C value as a field on each stock line. Reports, count lists and reorder reviews can then filter by band instead of someone re-sorting a spreadsheet each time.
Common Mistakes When Banding Stock
The first mistake is treating the percentage ranges as fixed laws. They are conventions, and sources that publish them say so. If your top three lines carry 60 percent of value, your A band is three lines, not fifteen.
The second is sorting once and forgetting it. Seasonal lines, a new customer programme or a price change will move lines across band edges, so schedule a re-run. The third is letting bad data through: duplicate SKUs split one line's value in two and can push a genuine A line into B.
The last is ignoring criticality. A cheap component that halts every installation is a C line on paper and an A line in practice. Keep a short override list and review it each time you re-sort.
Putting the Sort to Work
Run the sort this week on one afternoon of data work, write the band onto each line, and change one thing per band: the count schedule, the reorder review, or the supplier conversation. You will see the effect in the first count cycle, when most of your counting hours go to the lines that matter.
Sources
- ABC Analysis for Inventory Management: A Manufacturing GuideSimple Manufacturing · accessed 2026-10-16
- ABC Analysis for Inventory: Definition & Best PracticesTimly · accessed 2026-10-16