InventoryUpdated 10 min read
What dead stock costs you: turnover and carrying cost

In this article
Open your inventory report and sort it by last sale date. You'll almost always find the same thing: part of the warehouse hasn't moved in months. You already paid for that stock. It takes up shelf space, gets insured, gets counted every month and loses value. And because it makes no noise, nobody looks at it.
Sleeping money
Dormant money is the value, at cost, of products that haven't sold in more than 90 days. It's cash that left your account and won't come back until someone buys. Meanwhile it racks up interest, rent and shrinkage.
Having inventory isn't the problem; without it you can't sell. The problem is the part that doesn't turn. A study of US public manufacturing companies found that median days of inventory fell from 96 to 81 between 1981 and 2000, and that firms with abnormally high inventories had abnormally poor long-term stock returns (Chen, Frank and Wu, 2005). The same study has a useful warning: the firms with the very lowest inventories didn't do best, just average. Zero isn't the goal.
To find out how much sleeping money you have and what it costs, you need three numbers: turnover, days of inventory and your annual carrying cost rate.
The formulas: turnover, days and carrying cost
Inventory turnover (in turns)
Turnover = cost of goods sold for the year ÷ average inventory at cost. Use COGS, not revenue: inventory is valued at cost, and if you divide revenue by it, your margin inflates the turnover.
Average inventory is (beginning inventory + ending inventory) ÷ 2. If your business is seasonal, average all 12 month-end balances instead: with only two data points, a full or empty December skews the whole result.
Days of inventory
Days of inventory = 365 ÷ turnover. That's the same as average inventory ÷ COGS × 365. It tells you how many days it would take to sell what you have if you kept selling at last year's pace. A turnover of 4 is about 91 days; a turnover of 12, about 30.
Annual carrying cost rate
It's the sum of five costs, each as a percentage of average inventory. There are rule-of-thumb figures floating around, but we couldn't find a primary source behind them, so we won't give you one: build yours from your own numbers. It takes an afternoon.
| Component | What it includes | How to get it |
|---|---|---|
| A. Capital | What the money tied up in stock costs you | The annual rate on your working capital loan. If you have no debt, what that money would earn elsewhere |
| B. Storage | Warehouse rent or cost, utilities, warehouse staff, racking | Annual warehouse cost ÷ average inventory |
| C. Insurance and taxes | Coverage on the stock and any inventory taxes | Annual premium ÷ average inventory |
| D. Shrink | Shortages, damage, theft and counting errors | Negative inventory adjustments for the year ÷ average inventory |
| E. Obsolescence | Value lost to expired, outdated or superseded items and clearance sales | Write-offs and clearance markdowns for the year ÷ average inventory |
| Carrying cost rate | A + B + C + D + E | Your annual percentage |
| Annual carrying cost | Average inventory × rate | What you pay each year to keep the warehouse full |
For shrink, if you don't track it, there's a US retail reference point: it averaged 1.6% of sales in 2022 (NRF, 2023). Watch the base: that's a percentage of sales, not of inventory, and it comes from stores, not distributors. Use it only as a ballpark until you've counted your own.
The part people forget most is obsolescence. It doesn't show up as an expense until someone decides to mark it down or write it off, and by then the product has already lost much of its value. Go through the last 12 months of write-offs and clearance sales: it's usually the line that surprises people most.
Worked example: a distributor with $300,000 on the shelves
This is an illustrative example with round numbers. A distributor sells goods that cost it $1,200,000 a year and carries, on average, $300,000 in inventory. It pays 12% a year on a working capital line. The warehouse (rent, utilities and two people) costs $24,000 a year.
| Item | Example value | Math |
|---|---|---|
| COGS for the year | $1,200,000 | From the income statement |
| Average inventory | $300,000 | Average of 12 month-ends |
| Turnover | 4 turns | 1,200,000 ÷ 300,000 |
| Days of inventory | 91 days | 365 ÷ 4 |
| A. Capital | 12% · $36,000 | Loan rate |
| B. Storage | 8% · $24,000 | 24,000 ÷ 300,000 |
| C. Insurance | 1% · $3,000 | Annual premium |
| D. Shrink | 1.5% · $4,500 | Negative adjustments for the year |
| E. Obsolescence | 3% · $9,000 | Write-offs and markdowns for the year |
| Carrying cost rate | 25.5% | 12 + 8 + 1 + 1.5 + 3 |
| Annual carrying cost | $76,500 | 300,000 × 25.5% |
Now the sleeping money. Sorting inventory by last sale shows that $90,000 (30%) is in products that haven't sold in more than 90 days. Carrying them costs $90,000 × 25.5% = about $23,000 a year.
But you don't get all of that back. If you clear out that stock and keep the same warehouse and the same people, the rent doesn't go down. What does drop right away is capital, insurance, shrink and obsolescence: 12 + 1 + 1.5 + 3 = 17.5%. Freeing up half the sleeping money ($45,000) puts that cash back in the bank and saves about $7,900 a year (45,000 × 17.5%). Storage only drops if the space you free up lets you stop paying for something: a smaller warehouse, one less shift, or outside storage you no longer need.
That difference matters when you decide. If someone shows you savings calculated with the full rate, ask which part is actually variable for you.
The table to classify your products
Overall turnover tells you how you're doing; it doesn't tell you what to do. For that, classify every product on two axes: how long it's gone without selling and how much it weighs in your sales.
By age: days since last sale
| Days without a sale | Status | What to do |
|---|---|---|
| 0 to 30 | Active | Nothing special. Check that the reorder point is still right |
| 31 to 90 | Slow | Hold new purchases. Check whether a price, a customer or a season changed |
| 91 to 180 | Sleeping | Don't reorder without a customer order. Offer it to customers who used to buy it, bundle it, or ask the supplier to swap it |
| Over 180 | Dead | Decide this month: clearance, return, donation or write-off. Every month you wait, it's worth less |
By sales weight: ABC
Sort products by annual COGS, highest to lowest, and add up the running percentage. Those in the first 80% are A; those from 80% to 95% are B; the rest are C. The 80/95 cutoffs are a convention, not a law: adjust them if your catalog is very short.
| Active or slow | Sleeping or dead | |
|---|---|---|
| A | Protect it: here a stockout costs more than the inventory. Check the minimum stock every month | Rare and urgent: something changed (a customer left, a competitor showed up). Find out before you mark it down |
| B | Buy based on actual sales from the last 3 months, not on the last big order | Hold purchases and offer it to customers who used to buy it |
| C | Buy smaller and more often, or switch it to order-on-demand | First in line for clearance. It's almost pure sleeping money |
- Pull the listExport from your system, per product: units on hand, unit cost, last sale date and COGS for the last 12 months. If your system can't give you the last sale date, you've found your first problem.
- Calculate value at costUnits on hand × unit cost. Total it by age bucket. Sleeping plus dead is your sleeping money.
- Tag A, B and CSort by annual COGS and accumulate. Cross it with age in the table above.
- Assign an owner and a dateEvery sleeping or dead product gets an action and a deadline. Without that, the same list shows up unchanged next quarter.
- Repeat monthlyThe first time takes a day. After that, an hour. Watch whether sleeping money goes up or down; that number tells you more than overall turnover.
Signs your purchasing runs on autopilot
- Purchase orders repeat the last order to the supplier instead of looking at actual sales.
- Nobody can tell you your days of inventory without opening a file.
- Some products have stock on hand but don't appear on a single invoice from the last quarter.
- You buy in bulk for the discount, but nobody checks whether the discount covers the time on the shelf.
- The physical count rarely matches the system, and the adjustment gets made at year-end.
- Clearance sales happen when you run out of space, not according to a rule.
- Sales reps can't see real stock and promise products you don't have, while other items pile up.
- Your best sellers run out while your slowest items pile up.
If you checked three or more, the problem isn't the warehouse: purchasing, sales and inventory aren't looking at the same data. The table helps once. To keep it from happening again, the information has to stay current without anyone building it by hand. To track it every week, dead stock is one of the KPIs on the Monday dashboard.
When cutting inventory isn't the right call
Less inventory isn't always better. Remember the study: the firms with the very lowest inventories didn't get the best results (Chen, Frank and Wu, 2005). Don't cut without thinking it through if:
- The product is critical for a big customer or for your own operation (a spare part, an input with no substitute). A stockout costs more than a year on the shelf.
- Your supplier takes weeks to restock or sells seasonally. That stock is your safety margin, not sleeping money.
- The volume discount is larger than the cost of carrying the extra units for as long as it takes to sell them. Run it with your rate: a 5% discount covers about two and a half months at a 25% rate.
- You expect a supplier price increase that's bigger than your carrying cost over that period.
- A clearance sale would undercut your price with customers who pay full price. Sometimes returning to the supplier, donating or writing it off is better.
If you have few products, high turnover and almost nothing past 90 days, you don't need a new system for this. Redo the table every month in a spreadsheet and put the last sale date in front of whoever places orders.
What to bring to the purchasing meeting
Once you have your carrying cost rate and your sleeping money, you have two numbers for the purchasing meeting: how much cash you can free up, and how much you save each year if you do. That turns “let's buy just in case” into math.
To keep the number low, purchasing has to see actual sales and the age of each product when placing an order, and sales has to see real stock when quoting. If those live in separate files today, sleeping money will grow back, because nobody sees it growing. It's the most common case at distributors.
Sources
- Chen, H., Frank, M. Z. and Wu, O. Q., "What Actually Happened to the Inventories of American Companies Between 1981 and 2000?," Management Science 51(7), 2005 (opens in a new tab)
- Summary of the Chen, Frank and Wu study, University of Minnesota research repository (opens in a new tab)
- National Retail Federation, "National Retail Security Survey 2023," 2023 (opens in a new tab)