Skip to content
Efidis
Efidis

InventoryUpdated 10 min read

What dead stock costs you: turnover and carrying cost

3D illustration of a warehouse shelf with boxes, a pallet and a lilac price tag.
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.

ComponentWhat it includesHow to get it
A. CapitalWhat the money tied up in stock costs youThe annual rate on your working capital loan. If you have no debt, what that money would earn elsewhere
B. StorageWarehouse rent or cost, utilities, warehouse staff, rackingAnnual warehouse cost ÷ average inventory
C. Insurance and taxesCoverage on the stock and any inventory taxesAnnual premium ÷ average inventory
D. ShrinkShortages, damage, theft and counting errorsNegative inventory adjustments for the year ÷ average inventory
E. ObsolescenceValue lost to expired, outdated or superseded items and clearance salesWrite-offs and clearance markdowns for the year ÷ average inventory
Carrying cost rateA + B + C + D + EYour annual percentage
Annual carrying costAverage inventory × rateWhat 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.

ItemExample valueMath
COGS for the year$1,200,000From the income statement
Average inventory$300,000Average of 12 month-ends
Turnover4 turns1,200,000 ÷ 300,000
Days of inventory91 days365 ÷ 4
A. Capital12% · $36,000Loan rate
B. Storage8% · $24,00024,000 ÷ 300,000
C. Insurance1% · $3,000Annual premium
D. Shrink1.5% · $4,500Negative adjustments for the year
E. Obsolescence3% · $9,000Write-offs and markdowns for the year
Carrying cost rate25.5%12 + 8 + 1 + 1.5 + 3
Annual carrying cost$76,500300,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 saleStatusWhat to do
0 to 30ActiveNothing special. Check that the reorder point is still right
31 to 90SlowHold new purchases. Check whether a price, a customer or a season changed
91 to 180SleepingDon'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 180DeadDecide 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 slowSleeping or dead
AProtect it: here a stockout costs more than the inventory. Check the minimum stock every monthRare and urgent: something changed (a customer left, a competitor showed up). Find out before you mark it down
BBuy based on actual sales from the last 3 months, not on the last big orderHold purchases and offer it to customers who used to buy it
CBuy smaller and more often, or switch it to order-on-demandFirst in line for clearance. It's almost pure sleeping money
  1. 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.
  2. Calculate value at costUnits on hand × unit cost. Total it by age bucket. Sleeping plus dead is your sleeping money.
  3. Tag A, B and CSort by annual COGS and accumulate. Cross it with age in the table above.
  4. 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.
  5. 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

  1. 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)
  2. Summary of the Chen, Frank and Wu study, University of Minnesota research repository (opens in a new tab)
  3. National Retail Federation, "National Retail Security Survey 2023," 2023 (opens in a new tab)
See how we work in route-based distribution

Frequently asked questions

Buy what sells, not what piles up

Efidis builds a custom app where purchasing sees what each product really sells before placing an order. On the call we'll review your dead stock and where to start freeing it up.