Worked examples
Over-ordered after a promo spike
| Units on hand | 1200 |
| Average weekly sales | 60 |
| Target weeks of supply | 8 |
| Unit cost | $10.00 |
| Carrying cost rate | 25% |
| Cash tied up in overstock | $7,200.00 |
| Excess units | 720 |
| Annual carrying cost of excess | $1,800.00 |
720 excess units: $7,200 parked, burning $1,800 a year in carrying cost.
Mild overshoot
| Units on hand | 900 |
| Average weekly sales | 90 |
| Target weeks of supply | 6 |
| Unit cost | $10.00 |
| Carrying cost rate | 25% |
| Cash tied up in overstock | $3,600.00 |
| Excess units | 360 |
| Annual carrying cost of excess | $900.00 |
360 units over target: $3,600 tied up — worth trimming on the next PO, not panicking.
Frequently asked questions
How many weeks of supply should I target?
Enough to cover your supplier lead time plus safety stock plus one review cycle. A store restocking from overseas on a 6-week lead often targets 8–12 weeks; one with a domestic 1-week supplier can run 3–4. Setting the target is the honest part of measuring overstock cost — a generous target hides excess, a tight one flags stock you genuinely need.
Is overstock the same as dead stock?
No, and the distinction decides the remedy. Overstock is a product that sells at a healthy rate — you simply hold more weeks of it than you need, so the fix is to pause reordering and let sales bleed it down. Dead stock barely sells at any level, so waiting doesn’t help and you need markdowns or liquidation. This calculator prices the first problem; the dead stock cost calculator prices the second.
What does overstock actually cost me beyond the carrying rate?
The quiet costs are opportunity and risk: $7,200 parked in excess of one SKU is $7,200 not buying the fast mover that keeps stocking out, and every extra month on hand adds exposure to damage, obsolescence, and price erosion. There is also a Q4 trap — overstock occupying 3PL or FBA space during peak-surcharge months can double its storage component exactly when space is most expensive.
How do I work overstock down without wrecking my margin?
In order of margin preserved: stop reordering and let it sell through; feature it in email flows and bundles where the marketing cost is near zero; run a modest 10–15% promotion; and only then discount deeply or liquidate. Match the aggression to the carrying cost — if excess stock burns $150 a month, a slow no-discount bleed-down is fine; if it burns $1,500, buy the cash back faster.
Related calculators
- EOQ Calculator
- Reorder Point Calculator
- Safety Stock Calculator
- Break-even ROAS Calculator
- All calculators
Part of the Inventory collection.