Inventory math

Overstock Cost Calculator

Every unit beyond your target cover is cash asleep on a shelf — this prices exactly how much.

Overstock = units on hand − (weekly sales × target weeks of supply). The overstock cost is what those excess units tie up and burn: with 1,200 units on hand, sales of 60 a week, and a target of 8 weeks of cover, your target stock is 480 units, so 720 are excess — $7,200 of cash at a $10 unit cost, costing about $1,800 a year to carry at a 25% rate. Overstock still sells, unlike dead stock; it is simply too much of a good thing. Enter your stock, run rate, and target cover to see how much cash you could release.

Overstock Cost Calculator — your numbers

Cash tied up in overstock

$7,200.00

Excess units

720

Annual carrying cost of excess

$1,800.00

Estimate only. Results reflect exactly the numbers you enter — verify against your own accounting before making pricing decisions.

Embed this calculator on your site — free →

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

Part of the Inventory collection.