Dead Stock Identifier

Classify your inventory by health tier, see the true cost of holding dead stock, and compare recovery options — markdown, liquidation, or reinvestment in products that sell.

Inventory Overview

$
SKUs
%

Inventory Classification (% of value)

%
%
%
%
Healthy Slow Dead Obsolete

Costs & Recovery

%
%
%
% of cost

Problem Inventory

$30,000

25% of total (63 SKUs)

Monthly Holding Cost

$750

$9,000/yr on dead + obsolete

Capital Trapped

$30,000

Locked in dead & obsolete stock

Inventory Health

68/100

Needs attention

Health score 68/100 — 25% of inventory is dead or obsolete, costing $750/mo to hold. Take action on worst SKUs.

Inventory Breakdown by Tier

Tier% of ValueValue (cost)Est. SKUsMonthly HoldAction
Healthy(< 30 days)50%$60,000125$1,500HighestReorder as needed
Slow-moving(31-90 days)25%$30,00063$750Markdown 20%
Dead stock(91-180 days)15%$18,00038$450Markdown 40%
Obsolete(180+ days)10%$12,00025$300Liquidate at 15%

Recovery by Action

Slow stock (20% markdown)$53,333
P&L on slow clearance+$23,333

Dead stock (40% markdown)$24,000
P&L on dead clearance+$6,000

Obsolete (15% liquidation)$1,800
Loss on liquidation$-10,200

Total cash recovered$79,133

Act Now vs. Do Nothing (6 months)

What happens if you hold dead & obsolete stock for 6 more months:

Holding cost (6 months)-$4,500
Further value loss (~30%)-$5,400

Do-nothing cost-$9,900

Loss if you act now-$0
Savings vs. waiting+$9,900

Reinvestment Opportunity

Capital freed

$30,000

From clearing problem stock

Potential return (2 turns)

$33,000

Reinvested in healthy inventory

Holding saved per year

$9,000

No longer paying to store dead stock

Related Tools