Operations Intelligence INSIGHT

Freeing Cash Trapped in Dead Stock

A practical way to decide which slow-moving inventory deserves action.

Slow inventory is a cash question. An aging report answers a date question. That mismatch is why the report gets opened every few months and the money stays exactly where it was.

Most retailers and dealers know they are carrying some slow-moving inventory. The harder part is deciding what to do about it.

An aging report can identify hundreds or thousands of items that have not sold recently. That is useful. But it creates a problem of its own: when everything on the report looks like an issue, it is difficult to know where to start.

The result is usually familiar. The report gets reviewed occasionally, a few obvious items get handled, and the larger problem stays exactly where it was.

Age matters. Dollars matter more.

Suppose you have two items. The first has not sold in 420 days. You have one on hand, and your investment is $32. The second has not sold in 230 days. You have nine on hand, and your investment is $2,100.

Sorted by age, the first item looks like the bigger problem.

Money tied up in each item

Item A — 420 days, 1 on hand

$32

 

Item B — 230 days, 9 on hand

$2,100

 

Item A is older by six months. Item B has sixty-five times the money in it. An aging report sorted by days puts the wrong one at the top.

From a cash standpoint, the second item is far more important. This is why an aging report is a starting point, not a decision.

Two stacked bars of the same slow-moving stock. By number of items: 62% under $100, 26% between $100 and $500, 9% between $500 and $2,000, 3% over $2,000. By dollars tied up: 7%, 18%, 34% and 41% respectively. Twelve percent of the items hold three-quarters of the money.
Age tells you what is old. Dollars tell you what is worth a decision. The two rankings are almost never the same list.

Age is only one of the questions

When you review slow inventory, a handful of questions put age in context.

How many do we have?

How much money is tied up?

When did it last sell?

How often has it sold historically?

Did we recently buy more?

Is demand seasonal?

Has the item been superseded?

Can it be returned?

Does a product line or key customer depend on it?

Is the current price part of the problem?

None of those questions tells you what to do on its own. Together they give you a much better picture than a date does.

Not all old inventory is bad inventory

Some slow-moving inventory belongs on the shelf. Service may need access to parts that sell infrequently. A seasonal product can go months without movement and still be exactly right to carry. You may stock an item on purpose because customers expect to find it, even though it does not turn quickly.

That is why labeling everything past a certain age as dead can mislead you. It is a judgment call — but better information makes the judgment easier.

There is a related situation that is easier to miss. Imagine an item that sells one or two units a year, and you have one on hand. That is probably reasonable. Now imagine the same item with seven on hand. The item is not the problem. The quantity is.

Or take an item that gets reordered every time one sells, even though current stock already represents several years of normal demand. That is not dead stock yet. But it is where next year’s dead stock is being created.

A good inventory review asks both questions: what has already gone stale, and where are we carrying more than the sales history supports? The second one gives you the chance to act before the money is stuck.

Start where action can matter

If your aging report has 2,000 lines on it, solving the whole list is not a realistic plan. Start by isolating the items where a decision could change something.

Where to look first

The largest dollars tied up in weak-moving items

Products with unusually high quantities relative to sales

Items still being purchased despite limited movement

Products that can still be returned

Aging items where the price may be contributing to the problem

Superseded or obsolete products with meaningful investment

Instead of asking someone to work the dead-stock report, hand them a manageable group of items worth reviewing. Twenty meaningful decisions are usually worth more than staring at 2,000 lines.

Getting rid of it is not the only option

Once an item deserves attention, the next question is not automatically how to make it disappear. There are more choices than that, and the right one depends on the item.

Stop replenishing

Reduce the quantity

Return it

Transfer it

Change the price

Bundle it

Promote it

Use it in service

Keep it on purpose

Write it down

Dispose of it

That range of options is another reason a blanket age rule is rarely enough on its own.

This is really a cash question

Inventory sitting on a shelf is money. When it sells, that money comes back into the business and can go to work again. When it does not sell, the cash stays where it is.

That matters because the same dollars could be doing something else — faster-moving inventory, payroll, equipment, facility work, paying down borrowing, taking a buying opportunity, or simply creating some breathing room.

Which makes slow inventory more than a parts or purchasing issue. It is a financial issue for the whole business.

Where do we have meaningful dollars tied up in inventory that no longer matches the way we actually sell?

That question produces a far more useful conversation than “we need to clean up our dead stock.”

Age still matters. But now you are looking at age alongside quantity, investment, demand, and the role the item plays in the business. You are no longer trying to make an enormous report disappear. You are deciding where action makes the biggest difference — which is a much more practical place to start.

How this connects

Area: Operations — inventory and the cash tied up in it.

Applies across: Revenue and Executive — buying decides what you own, and what you own decides what your cash is doing.

Read next: Turning Work Orders Into a Production System — the same problem in the service department, where the report also fails to say what is actually stuck.

ProfitEdge Systems helps independent retailers and dealers improve profitability and operating performance through consulting, training, and intelligence tools. See how we help →

Katherine Mitchell

About the author
Katherine Mitchell, Retail Strategist

Katherine helps independent retailers and dealers strengthen operations through practical intelligence, hands-on consulting, and training that makes better routines easier to sustain.

Have an operating problem you want to work through? Schedule a Strategy Session →

Work through it with someone

Bring the problem you keep re-solving

Most of what ends up in these articles started as a question from a shop owner or a dealer principal. If something here sounds like your month, say so and we will look at it together.

Start a conversation →