Brothers, let me start with a real morning in our warehouse — back before we'd ever run an ABC analysis.
Last November, peak season. Shift starts at 7:30. Our picker Lao Zhang heads out for his first order and doesn't come back for 40 minutes. I ask him what happened. He says: "Boss, that best-selling paper towel — the 24-pack family size, we shipped 800 cases yesterday — it's in Zone G, level 3, the farthest corner. One round trip takes me six minutes."
I lost it. The best-selling product in the building, sitting in the farthest slot. Who laid out these locations?
Nobody. That's the answer. The slots were set three years ago when we opened — whatever zone had space got the product. Three years later, best sellers and dead stock are all mixed together, and my pickers walk enough extra miles every day to circle the building twenty times. Let me be blunt: in a lot of warehouses, slotting isn't planned. It just accumulates.
So we tried something dirt simple that worked shockingly well: ABC analysis. No WMS module, no consultants. One laptop, one Excel file, two days. Picking got nearly 30% faster — and that's not a number I made up. We measured picker walking distance for two straight weeks.
What ABC Really Is: Rank by Sales Dollars, Not Units
ABC analysis in one sentence: rank your SKUs by sales revenue, highest to lowest. The SKUs making up the top 80% of cumulative revenue are A. The next 15% are B. The last 5% are C.
Note: revenue, not units sold. That's where most people blow it. More on that in a minute.
We pulled twelve months of sales data — three columns: SKU, product name, revenue. Here's an illustrative table (I made up the numbers; the method is real):
| Rank | SKU | 12-mo revenue ($k) | Cumulative % | Class |
|---|---|---|---|---|
| 1 | 24-pack family paper towels | 120 | 35% | A |
| 2 | 5L laundry detergent | 80 | 58% | A |
| 3 | 3-ply facial tissue 10-pack | 45 | 72% | A |
| 4 | Heavy-duty trash bags | 28 | 80% | A |
| 5 | Disposable paper cups | 15 | 84% | B |
| 6 | Kitchen wipes | 12 | 88% | B |
| 7 | Toilet brush set | 8 | 90% | B |
| 8 | Dusting wand | 5 | 92% | B |
| 9 | Window squeegee | 4 | 93% | C |
| 10 | Drain cleaner | 3 | 94% | C |
| … | 200 long-tail SKUs | 20 | 100% | C |
See the pattern? Out of 200+ SKUs, just 4 are Class A, driving 80% of revenue. This isn't unique to us — a warehouse consulting blog (thewarehouseengineers) published a case where 9% of SKUs drove 78% of sales, and slotting by ABC cut pick time by 27%. Matches our 30% almost exactly. This law holds everywhere.
In Excel it's three steps: ① sort by revenue, descending; ② add a cumulative revenue column and a cumulative percentage column (= cumulative ÷ total); ③ mark ≤80% as A, 80–95% as B, the rest as C. If you can SUM and sort, you can do this. Thirty minutes, done.
From ABC Classes to Slots: The Golden Zone Rule
Classification is just the means. The goal is putting A SKUs closest to the picker. Here's the golden-zone rule we run on now:
A goes in the golden zone: the two rack rows nearest the pack-and-check station, at waist height (levels 1–2 — no bending, no climbing). Our golden zone is 60 pallet positions, A-class only. That paper towel moved from Zone G to Row A, level 1. Lao Zhang's round trip went from six minutes to one.
B goes in the near zone: one ring out from the golden zone, or level 3 and up. A few steps away — not prime, but handy.
C goes far and high: the back of the building, level 4 and up. Stuff that moves once a week doesn't mind the distance.
We moved in waves, SKU by SKU: A-class first (4 SKUs, one morning, picking was faster that same afternoon), B-class the next day, C-class whenever we had spare hands. Don't try a "big-bang weekend re-slot." You can't afford the downtime in peak season, and you don't have the labor in the off-season.
Two Mistakes That Undo Everything
Mistake 1: ranking by units instead of revenue. We made this one first. By units, the $0.99 socks selling 100,000 pairs a month ranked #1, while the big-ticket appliances selling 200 units a month landed in Class C. So the socks got the golden zone and the appliances got the back corner. Pickers walked less — but the warehouse didn't make more money. Remember: ABC is about dollars, not pieces. If your operation is discrete order picking where travel distance is the main cost, ranking by pick frequency also works. Just don't use units.
Mistake 2: classifying once and forgetting it for three years. We ran ABC in 2023. In 2024 we started livestream e-commerce and the best sellers completely changed. Under the old classification, the golden zone was full of last year's viral products while the new winners sat in the far corner gathering dust. Now it's locked in: re-run ABC every quarter, and relocate any SKU that changed class within the month. Re-running is twenty minutes in Excel. Don't be lazy about it — best sellers turn over faster than you think.
One advanced note: ABC measures "how much money it makes." XYZ measures "how stable the demand is." AX items — profitable and steady — get bolted into the golden zone permanently. AZ items — profitable but spiky — get flexible slots. That's the ABC×XYZ matrix. We only run plain ABC in our warehouse. It's enough.
A Word to Fellow Warehouse Folks
Let me be straight with you. The hard part of ABC analysis isn't Excel. It's committing to move the slots. Plenty of warehouse managers build the spreadsheet, put it on the boss's desk, hear "let's wait for the slow season," and wait a year. My advice: move the A-class first. Four to ten SKUs, half a day, results visible the same afternoon. Take the pick-time data back to your boss and the resources usually follow.
Slotting is like farming: the best land should grow the highest-yield crop. Parking your best seller in the farthest slot is leaving your best field fallow. One Excel run, two days, and the field is planted right.
By Chen Feng, Warehouse Operations Manager
