You’re running a warehouse you can’t see

By Matthew Boos 

Most wholesale distributors track revenue closely and margin loosely. That gap is where profit disappears.

Picture a warehouse running full tilt at three in the morning. Product on every shelf, forklifts moving all day, invoices going out on time. This looks like a business that has it figured out.

Now imagine there are no lights in that warehouse. Nobody can read the labels. Nobody knows which pallets are worth touching and which ones are eating money every time someone picks and ships them. Work keeps happening, but nobody is actually deciding anything. They are moving boxes in the dark.

That is what most wholesale distributors are doing when they only track revenue.

A full warehouse is not the same as a profitable one

Revenue is business comfort food. When it goes up, everyone relaxes a little and the hard questions get postponed.

Margin is harder because it forces you to know what each product actually costs to buy, receive, put away, pick, pack, and deliver, and then hold that against what you charged. Margin forces you to do the math.

And that math is best done at the SKU level. Underperforming distributors rarely have that picture. They have a blended gross margin across the company, maybe by category if the ERP is set up cleanly, and a rough sense that certain customers are better than others. That is a warehouse with the lights off. It looks busy and full, but you still cannot see what matters.

When you finally run the numbers, the pattern is depressingly familiar. A distributor carrying 3,000 active SKUs typically finds that somewhere around 400 of them are generating most of the margin. Another 800 are roughly a wash. The remaining 1,800 are thin or outright negative once you load in what it actually costs to touch those items. Those SKUs still sit on the shelf, eat up space and cash, and cost you labor every time someone has to touch them. The warehouse is full. Nobody turned the lights on.

The same blindness that hides unprofitable SKUs also hides unprofitable customers. Most owners have heard the 80/20 rule and applied it to revenue. That is the wrong version. Revenue concentration tells you who buys a lot. It does not tell you who is worth keeping.

Some of your largest accounts by volume are margin-negative once you price in order complexity, return rates, special delivery requirements, and the amount of time your team spends managing that relationship. A big customer is not the same thing as a good customer. Often they are just the ones your team hears from the most.

What you actually need to see

Gross margin is a starting point, not an answer.

Two SKUs can carry the same gross margin percentage and produce completely different profit outcomes depending on how they move. One ships on full pallets to a single location, turns predictably, and generates no exceptions. The other moves in ones and twos, gets returned, needs special handling, and somebody ends up on the phone with that customer every other week. Same gross margin line. Completely different cost to serve.

What you need is contribution margin at the SKU level: gross margin minus inbound freight, receiving, warehouse labor for put-away and pick, storage, returns, and handling exceptions. The pricing waterfall concept maps this journey from list price through discounts, credits, and freight until you land on pocket margin, what you actually keep. Most distributors have never seen that number by SKU. When they do, it changes what they think they are selling.

Start with your top 100 SKUs by revenue and build the real cost model for each one. Some will look worse than expected. A few mid-catalog items will look better than anyone assumed. That is the beginning of actually knowing what is in the building.

Customer profitability works the same way. Activity-based costing assigns your real service costs to the customers who drive them and regularly surfaces accounts that look great on the revenue report and bleed margin in practice. High-volume customers with short payment terms, frequent small orders, and demanding delivery requirements are expensive to service. Their volume is real. Whether they make you money is a different question.

Keeping the lights on

Finding this out once does not solve anything. If you run the analysis twice a year and file it away, all you bought was an expensive, short-lived sense of comfort.

The reports that actually change behavior tend to share four traits:

  • SKU contribution ranked by total margin dollars, not percentage, so you can see where the real money is concentrated.
  • Customer profitability ranked the same way, with a hard flag on any account below a defined floor after cost to serve.
  • A period-over-period margin bridge that breaks down whether movement came from volume, customer mix, product mix, price, or supplier cost.
  • A short watch list of SKUs and customers who moved significantly in either direction since the last review.

Your ERP almost certainly has the data to support this. The gap is not the system. It is that nobody built the habit of pulling this view and putting it in front of a decision maker on a set schedule. The distributors who manage margin well have made it a standing agenda item, assigned ownership, and tied it to actual decisions about pricing and product mix. That, more than any new software, is what separates the distributors who protect their margin from the ones who slowly give it away.

When supplier costs move

Every time a supplier raises a price, there is a window between when your cost goes up and when your selling price follows. That window is where your margin quietly disappears.

It does not happen as one event anyone would call a crisis. It happens one item at a time, across dozens of SKUs, over months, until the owner notices the business is working harder and somehow less profitable.

The distributors who hold their margin know their SKU-level cost basis before the supplier conversation, so a price increase gets modeled immediately rather than discovered at month-end. They treat a cost increase as the moment to reset price, not something to get to later. And they set minimum margins by SKU class so every negotiation has a floor. Going below it requires a decision by someone with authority, not a rep doing whatever it takes to keep the account happy.

Standard cost loading helps here. Show your sales team a cost figure that already includes a small buffer above what you actually paid. Their floor is higher than your cost. When a customer pushes back and the rep gives a little ground, the margin absorbs it instead of disappearing.

Also worth reviewing: any long-term pricing agreements that predate your current cost structure. A lot of warehouses are honoring prices negotiated two years ago against costs that have since moved. Nobody ever went back to those deals because nobody was watching how far the gap had opened up.

Turning the lights on

When distributors run this exercise, the picture is usually the same. A third to half the SKU count is contributing almost nothing. A few large customers who dominate the revenue report are diluting the margin of the accounts around them. And somewhere in the middle of the catalog, a cluster of unglamorous SKUs with steady demand and simple logistics are carrying the business.

Your warehouse is already full. The real question is whether you actually know which of those pallets are making you any money.

Share this resource