Should ABC Analysis Rank by Dollars or by Picks?

Answer first

For slotting, ABC analysis should rank items by how often they are picked, not by their dollar value. Most ABC reports rank by dollars because that is what the ERP produces by default, and for financial purposes that is correct. But placement is about reducing walking, and walking is driven by pick frequency, not by price. An expensive item picked twice a month does not belong in your best location. A cheap item picked forty times a day does.

The common mistake

ABC analysis sorts your items into A, B, and C groups so you can treat the important ones differently. The question is: important by what measure. Ask most systems and the answer is dollar-volume, price times quantity. That is the default report, and it is genuinely the right lens for a lot of financial and inventory decisions.

It is the wrong lens for slotting, and using it is one of the most common quiet mistakes in warehouse layout.

Why dollars are the wrong variable for placement

Slotting exists to reduce travel. Travel happens when a picker walks to an item. So the items that deserve the best, closest locations are the ones a picker reaches for most often, regardless of what they cost.

Consider two items. One is a high-value component picked twice a month. The other is a cheap consumable picked dozens of times a day. Rank by dollars and the expensive component looks like your A item and gets pride of place near packing. Rank by picks and it is obvious that the cheap consumable is what your pickers actually walk to, over and over, and it is the one that belongs up front.

Put the high-dollar, low-pick item in your golden location and you have optimized for the balance sheet in a place where the balance sheet does not walk. Your pickers still trek to the consumable dozens of times a day.

The insider version of this point

The academic literature is blunt about it. Ranking items by dollar-volume is a financial perspective, and warehouse efficiency is not a financial question, it is an operational one. For placement, the useful ranking is by pick activity.

This is also a quick way to sanity-check your own slotting. Pull your current A locations, the best pick faces near packing, and ask what is in them. If it is your highest-revenue items rather than your most-picked items, your placement is optimizing the wrong variable, and it is almost certainly because it was slotted off a default dollar-based report.

How to do it right

The fix is not complicated in principle. Pull pick frequency per item over a recent, representative window, ideally something like ninety days so seasonality does not distort it. Rank by that. Compare the top of that list against what is actually in your best locations. The items that appear high on the pick-frequency list but are not in good locations are your re-slotting candidates, and the gap between the two lists is your opportunity.

The difficulty is not the concept, it is keeping it current, because pick frequency drifts as your order profile changes. But even a one-time correction from dollars to picks usually surfaces obvious wins.

The takeaway

If you are going to use ABC analysis to drive slotting, make sure the letters mean what you think they mean. A, B, and C should reflect how often items are picked, not how much they are worth. It is the same technique pointed at the right variable, and pointing it at the wrong one is the difference between a layout that serves your accountant and one that serves your pickers.