Anyone who runs a warehouse knows the feeling: hundreds or thousands of different items, all demanding attention at once. The problem is that a day only has so many hours, and treating every item as equally important is the fastest way to spend energy where it yields little.
ABC analysis starts from a simple, slightly uncomfortable idea: in most inventories, a small fraction of the items accounts for the largest share of the value. If you can identify that fraction, you can give it the care it deserves and lighten the management of everything else. It is neither new nor sophisticated, but it remains one of the techniques that returns the most per hour invested.
In this article we look at what ABC analysis is, how to calculate it step by step, how to combine it with demand predictability, and which policies make sense for each class. At the end, a short case shows how the same company can free up capital without adding a single extra shelf.
What ABC inventory analysis is
ABC analysis is a way of ranking stock items by importance, so you can then apply different levels of attention to them. The usual yardstick is the annual consumption value: how much each item represents in money over a year, considering the quantity that moves and the cost of each unit.
With that value calculated for every item, you sort the list from highest to lowest and group the items into three classes. The A items are the few that weigh a lot — typically around 70% to 80% of the value. The B items are a middle group. The C items are the many that, added together, weigh little. The idea behind this is the Pareto principle, the famous 80/20: a few causes explain most of the effects.
Why "treating everything the same" is expensive
When there is no criterion, attention gets distributed almost at random — often to the items that cause the most trouble at the moment, not to those that weigh most on the business. The result is well known: stockouts on the products that generate revenue and, at the same time, shelves full of low-value items that tie up capital.
Ranking by importance solves two problems at once. It concentrates the planning, counting and negotiation effort on the A items, where each improvement has real impact. And it lets you simplify the management of the C items, where the cost of controlling them in detail is greater than the benefit. Managing well often means deciding where not to spend attention.
How to classify: the step-by-step method
The calculation is accessible and fits in a spreadsheet or a simple query to the system. The steps are always the same:
- Gather the data for each item: consumption (or sales) over the last year and unit cost.
- Calculate the annual value of each item. In SQL, it would be something like
SELECT sku, SUM(quantidade * custo_unitario) AS valor_anual FROM movimentos GROUP BY sku. - Sort the items from highest annual value to lowest.
- Accumulate the percentage of the total value as you move down the list.
- Set the cut-offs: for example, class A up to 80% of the accumulated value, B from 80% to 95%, C the rest.
The thresholds are not sacred. Some companies use 70/20/10, others prefer four classes. What matters is that the cut-offs reflect the reality of the business and are stable enough to guide decisions.
Combining ABC with XYZ: value and predictability
ABC analysis tells you how much each item is worth, but not whether demand is easy or hard to predict. Two items can have the same annual value and behave in opposite ways: one sells steadily every week, the other disappears for months and then spikes.
This is where XYZ analysis comes in, classifying items by the regularity of demand. X items have stable, predictable demand; Y items have moderate or seasonal variation; Z items are erratic. Crossing the two matrices gives a much richer grid: an AX item (high value, stable demand) calls for tight but easy-to-plan control, while an AZ item (high value, erratic demand) is the real headache, where it pays to invest in better forecasting and safety stock.
Which policies to apply to each class
Once you have classified, the practical question is: what should you do differently with each group? Some guidelines that tend to work:
- A items: frequent review, careful forecasts, more regular cycle counts and close relationships with suppliers. Every percentage point of improvement here is worth a lot.
- B items: balanced management, with automatic replenishment rules and periodic review. They do not warrant obsession, but they should not be neglected either.
- C items: simplify as much as possible. Larger, less frequent orders, automatic minimum levels and less human time spent. The goal is that they do not steal attention from the A items.
Note that service levels can also vary: it makes sense to ensure almost total availability on the A items that sustain revenue and to accept a little more stockout risk on the low-impact C items.
Common mistakes in ABC analysis
The technique is simple, but there are traps. The most common is classifying only by quantity sold, ignoring cost — an item can move a lot and be worth little. Another is looking only at value and forgetting criticality: a cheap component can stop an entire production line if it runs out, which makes it strategic despite falling into class C.
There is also the mistake of treating the classification as something final. Demand changes, products enter and leave the catalogue, seasonality shifts the weights. An ABC analysis done once and forgotten quickly stops reflecting reality.
A short case: a distributor that freed up capital
Consider an electrical supplies distributor with around 4,000 items. The team felt they spent their days "putting out fires" and that the warehouse was always full, yet stockouts on the important products never stopped. Applying an ABC analysis, they found that about 12% of the items accounted for almost 80% of the consumption value.
The change was one of focus, not effort. The A items moved to weekly review and more attentive forecasts; the C items moved to quarterly orders with automatic minimum levels. After two quarters, the stock value tied up in slow-moving items had dropped by around 18%, while the availability of key products rose. No extra space was bought and no extra people were hired — the inventory was simply looked at through a lens of priorities.
How to keep the classification alive
For ABC analysis to stay useful, it has to be recalculated regularly — quarterly or half-yearly, depending on the pace of the business. It is worth watching the items that jump class, because those moves usually tell a story: a product rising to A may be gaining traction in the market; one falling to C may be heading toward obsolescence.
Automating the calculation in a BI report helps make the classification part of the routine rather than a one-off exercise. That way, the conversation shifts from "do we have too much stock?" to "do we have too much stock where?".
In practice
ABC analysis does not solve everything, but it gives something rare in inventory management: a clear way to decide where to put your attention. Start simple, with the data you already have, and rank items by annual value. Then apply different policies to each class and, if possible, cross with demand predictability to fine-tune. The gain does not come from working more, but from working where the return is greater — and in a warehouse with thousands of items, that makes all the difference.
