Free tool · How much is dead stock costing me?

Dead stock cost calculator

Dead stock ties up cash and keeps costing money while it sits: storage, insurance, the cost of the money tied up in it, and damage or expiry. Enter its value at cost, your own yearly holding cost as a percentage, and how long you expect to keep it.

The formula

  • Monthly holding cost = stock value × yearly holding cost % ÷ 12
  • Holding cost for the period = monthly holding cost × months held
  • Worst case = holding cost + stock value (if it is finally written off)

Storage, insurance, the cost of capital and damage, as a % of value a year. Use your own figure.

Holding cost for the period
1,000
Cost a month
166.67
Worst case if written off
11,000

Example (the numbers are illustrative; use your own): 10,000 of stock that isn't selling, a yearly holding cost of 20% and 6 more months on the shelf. It costs about 167 a month, 1,000 over 6 months, and 11,000 in total if you end up writing it off.

Link straight to a result, for example https://www.ceazr.com/tools/dead-stock-cost-calculator?value=10000&rate=20&months=6

Questions people also ask

What should I use for the holding cost percentage?
Your own. Add up a year of storage, insurance and the interest or return you give up on the money tied in stock, plus losses to damage or expiry, and divide by your average stock value.
When is stock 'dead'?
Set a rule that fits your products, such as no sales in 90 or 180 days at a location. Short-dated goods need a shorter rule.
What can I do with dead stock?
Move it to a location where it sells, bundle or discount it, return it to the supplier if they allow it, or write it off and free the space. Our dead stock guide goes through each option.

Ceazr tracks these numbers for every product at every location. Try it free for 14 days.

Get a quote