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)
- 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