Picture a small distributor walking its warehouse at the end of the year. Near the back, on the top shelves, there are boxes that nobody has touched in a long time: a product line that looked promising two years ago, a batch bought at a good price "just in case," a few items a customer asked for once and never ordered again. On paper they are worth money. On the shelf, they are doing nothing.
The uncomfortable part is that nobody decided to keep them. Nobody sat down and chose to tie up cash in slow stock. It happened one reasonable purchase at a time, and the system never told anyone it was happening.
Stock on the shelf is not free
When a product sits unsold, it feels like the cost is zero, because no invoice arrives for it. But holding stock has costs that show up in different places. One common way to group them looks like this:
- Capital. The money spent on the goods is not available for anything else. If you borrowed to buy them, you pay interest. If you didn't, you still gave up what that cash could have done elsewhere.
- Space and handling. Rent, utilities, shelving, and the staff time to move, count and tidy the goods. A pallet of slow stock occupies a spot a fast mover could use.
- Shrinkage. Items that get lost, damaged or stolen. The longer something sits, the more chances there are.
- Insurance. Stock is usually insured, and what you hold affects what you pay.
- Obsolescence. Products go out of fashion, get replaced by a new model, or pass their useful life. Eventually the only way out is a deep discount or a write-off.
Reference sources on carrying cost describe these same components, and they usually express the total as a yearly percentage of the stock's value. I won't quote a number here, because it varies widely by industry, product and financing. The point is that it is never zero, and it keeps running while the product doesn't move.
Why slow stock goes unnoticed
In many small and mid-sized businesses, stock data lives in a spreadsheet or in an accounting tool that was built to record transactions, not to ask questions. It can tell you what you have. It rarely tells you what you have and shouldn't.
Total stock value can even look healthy while the mix underneath is going bad. A warehouse can be full of the wrong things and still pass every count, because the count only checks that the numbers match, not that the products are worth holding.
How to spot slow movers
You do not need a sophisticated model to find most of the problem. Two reports you probably already have, sales history and current stock, answer most of it when you put them side by side.
- Days since the last sale. For each product, how long since it last left the building? A list sorted by that number puts the worst cases at the top.
- Stock against sales rate. If you sell about ten a month and hold four hundred, that is a different situation from selling ten and holding twenty. Dividing stock by recent sales gives a rough "months of cover."
- Stock value by product. A slow item that is also expensive deserves attention before a slow item that costs almost nothing.
- Age of the stock. For anything that can expire or spoil, when it was received matters as much as how much there is.
None of these require perfect data. They require the two reports to be connected, which is where a spreadsheet gets painful and a purpose-built system gets easy.
What a well-built system should flag
A custom stock system can do this work for you instead of waiting for someone to remember to run a report. In practice that means:
- A slow-mover list that updates itself. Products with no sales in a window you choose, or with far more stock than recent demand justifies, shown with their value.
- Warnings before purchasing. When someone raises a purchase order for an item that already has months of cover, the system says so at that moment, when it can still change the decision.
- Age and expiry alerts. For goods with a shelf life, a list of what needs to move first.
- The cost of the pile, in one number. Total value of stock that hasn't moved in six or twelve months, so the conversation with the team is about a figure and not a feeling.
- A decision trail. If someone chooses to keep a slow item, for a good reason such as a seasonal product or a contract, that choice is recorded and the item stops raising false alarms.
The aim is not to eliminate all slow stock. Some of it is deliberate and sensible. The aim is that every slow item is a decision somebody made, not an accident nobody saw.
A first step you can take this week
Export your sales history and your current stock into one sheet. For each product, add the date of the last sale and the number of months of stock you hold at the current sales rate. Sort it. Look at the top twenty rows and ask a single question about each one: do we want to keep holding this, and why?
That list is the real requirement for a system. It shows which questions your business needs answered automatically, instead of once a year during a count.