How often should we reclassify SKUs?
Full review annually; trigger review when any SKU's 12-month usage rank moves more than 20 places.
Library / Inventory Control / ABC Classification
ZBI Business Control Library
ABC Classification
ABC Classification: plain-English definition, formula, worked example, how to interpret the result, peer-based benchmark guidance, common mistakes, and management actions in the ZBI Business Control Library.
What is ABC Classification?
ABC classification ranks SKUs by cumulative contribution—usually annual usage value or revenue—so you focus control where euros concentrate. Class A SKUs drive most of the value; B and C get lighter policies. At Merkur Trade, a EUR 5M industrial supplies distributor in Split, the top 15% of SKUs by annual usage value account for 78% of total usage value. That is classic A-class concentration. I use ABC to decide cycle-count frequency, buyer attention, and safety-stock tiers—not as a one-time spreadsheet from 2019 that nobody updates when a promoted SKU jumps from C to A mid-year.
Why ABC Classification matters
Without ABC, buyers treat a EUR 12 gasket the same as a EUR 120k motor line—expedite freight chases C-class while A-class stockouts lose key accounts. Merkur Trade found 18% of buyer hours on SKUs contributing under 3% of margin because classification had not been refreshed after two OEM wins. Warehouse cycle counts hit easy bins while A-class pick faces drift. Finance sees carrying cost rise on C-class MOQ orders while service fails on lines that matter. ABC is the routing code for every other inventory KPI—wrong class means wrong safety stock, wrong count frequency, wrong escalation.
Formula and variables
Classify SKUs by cumulative revenue or usage contribution
Annual usage value — units consumed or sold × unit cost (or revenue), ranked descending.
Cumulative % — running total of usage value ÷ total usage value (A ≈ top 70–80%, B next 15–20%, C remainder).
Excel: Use RANK or sort by annual usage value; cumulative % column in Excel.
Real business example
Merkur Trade runs annual ABC on 4,200 active SKUs: sort by annual usage value, compute cumulative percent. The top 15% of SKUs (630 items) drive 78% of total annual usage value—these become A-class with weekly availability review and monthly cycle counts on pick face. Next 25% land in B; remaining 60% in C with quarterly counts and min-max replenishment. One low-value spare rated C stops a EUR 400k packaging line—engineering flags it 'critical' and overrides to A despite low revenue rank.
How to interpret the result
ABC tells you where to spend control effort—not which SKUs to delete.
- Top 15% driving 78% usage value is tight A-class—buyers can focus without covering half the catalogue.
- Revenue-only ABC misses low-value line-stoppers; add a criticality flag outside the rank.
- Thresholds unchanged three years promote C-class habits on SKUs that graduated to A.
- Link ABC to safety stock, cycle count, and stockout escalation in one policy page.
Benchmark context
Pareto concentration varies by catalogue breadth—15% of SKUs driving 78% of usage value is strong A-class focus for a broad industrial distributor. If A-class exceeds 30% of SKU count, thresholds are too loose and buyers cannot prioritize. Compare year-on-year concentration: flattening curves often mean new product scatter without retirement of old SKUs. Peers in MRO often add XYZ demand-variability on top of ABC for buffer sizing.
Red flags
- ABC thresholds unchanged three years—promoted SKUs still treated as C-class; expedite spend on items that matter.
- A-class SKUs exceed 50% of line count—buyers cannot focus; service and cost both suffer.
- Top 15% concentration fell from 78% to 65% year-on-year without new product launch—SKU proliferation diluting control.
- Criticality overrides exceed 5% of catalogue—everyone flags 'critical' and ABC loses meaning.
- Stockouts cluster on SKUs ranked B or C by revenue but stocked as A by operations habit.
Common mistakes
- Classifying by revenue only—critical EUR 8 spares rated C until they stop a production line.
- Leaving ABC thresholds unchanged for three years while product mix shifted after two OEM wins.
- Letting A-class exceed 50% of line count—classification too loose to focus buyer time.
- No link between ABC class and cycle-count frequency—accuracy drifts on the SKUs that matter.
- Running ABC once in Excel without feeding ERP parameters—report says A, system treats C.
What should management do next?
- Reclassify the full portfolio annually; mid-year review for SKUs with large rank moves.
- Add criticality flag for low-value line-stoppers outside revenue ABC.
- Link ABC to cycle count, safety stock, and buyer focus list in one published policy.
- Cap A-class at an agreed SKU count; escalate additions to supply chain lead.
- Train sales and ops on monthly ABC changes that affect lead time promises.
Related calculators
Related analyzers
Related templates & software
Related KPI pages
Related blog articles
FAQ
Can we use units instead of revenue for ABC?
For spares and MRO, yes—add criticality flag for low-value stoppers. Revenue-only ABC misses line-down parts.
Top 15% driving 78%—how many SKUs should be A-class?
Often 10–20% of SKUs driving 70–80% of value. Merkur Trade holds A at 15%; tighten if count creeps above 25%.
Does ABC drive safety stock policy?
It should. Document service level by class and link to safety-stock formula in the S&OP pack.
Who approves ABC threshold changes?
Supply chain lead with finance concurrence and sales input on strategic SKUs. Ad hoc buyer changes erode focus.
Summary
ABC classification concentrates control on SKUs that drive usage value. Refresh ranks on schedule, add criticality where revenue rank lies, and wire class into every inventory policy—not a static spreadsheet.
Reviewed by ZBI Business Control Library · Last updated 2026-06-15