Dead Inventory Agent
Trapped working capital, surfaced.
Identifies SKUs with zero outbound movement for more than 90 days, calculates trapped capital, and recommends liquidation or repositioning paths to free pallet positions.
Source: WMS · inventory_levels, stock_movements
Trapped capital
₱5.94M
Recoverable through action
Dormant lines
6
Across 4 warehouses
Units sitting
3,400
No movement > 90 days
Pallet positions
~36
Estimated, recoverable
Active findings · 4
high
SKU-1011
SKU-1011 Discontinued Cable Reel — 268 days dormant at WH-CLK
220 units, zero outbound movement since the product was discontinued. Locking ₱275,000 of working capital and 12 pallet positions.
Recommendation: Liquidate via secondary channel or scrap. Free pallet positions for SKU-1004 inbound.
Impact
₱275,000
high
SKU-1009
SKU-1009 Legacy Display Unit — 184 days dormant at WH-MNL
340 units at WH-MNL plus 120 at WH-CEB. No outbound since product line was retired. Total trapped capital ₱2,254,000.
Recommendation: Bundle with SKU-1002 service kits as field-spare allocation, or write down within Q2.
Impact
₱2,254,000
medium
SKU-1010
SKU-1010 Q1 Promo Tarpaulins — 142 days dormant at WH-MNL
1,800 units of seasonal marketing material. Campaign ended in January.
Recommendation: Donate, repurpose, or dispose. Recover 9 pallet positions.
Impact
₱1,710,000
medium
SKU-1012
SKU-1012 Holiday Bundle — 118 days dormant across WH-MNL & WH-DAV
920 units of post-season stock with no movement since the holiday cycle.
Recommendation: Repackage into Q3 promotional kits or markdown channel before stock loses commercial relevance.
Impact
₱1,702,000
By category
| Category | Lines | Units | Trapped | Share |
|---|---|---|---|---|
| Marketing | 3 | 2,720 | ₱3,412,000 | |
| Electronics | 2 | 460 | ₱2,254,000 | |
| Hardware | 1 | 220 | ₱275,000 |
By warehouse
| Warehouse | Lines | Trapped capital | Share |
|---|---|---|---|
|
Metro Manila DC
WH-MNL
|
3 | ₱4,560,000 | |
|
Cebu Hub
WH-CEB
|
1 | ₱588,000 | |
|
Davao South Yard
WH-DAV
|
1 | ₱518,000 | |
|
Clark Forward
WH-CLK
|
1 | ₱275,000 |
Dormant inventory line detail
Threshold: zero movement > 90 days| SKU | Category | Warehouse | On hand | Unit cost | Trapped capital | Days dormant |
|---|---|---|---|---|---|---|
|
Promo Q1 Tarpaulin Pack
SKU-1010
|
Marketing |
Metro Manila DC
WH-MNL
|
1,800 | ₱950 | ₱1,710,000 | 142d |
|
Legacy Display Unit DM-9
SKU-1009
|
Electronics |
Metro Manila DC
WH-MNL
|
340 | ₱4,900 | ₱1,666,000 | 184d |
|
Seasonal Holiday Bundle
SKU-1012
|
Marketing |
Metro Manila DC
WH-MNL
|
640 | ₱1,850 | ₱1,184,000 | 118d |
|
Legacy Display Unit DM-9
SKU-1009
|
Electronics |
Cebu Hub
WH-CEB
|
120 | ₱4,900 | ₱588,000 | 210d |
|
Seasonal Holiday Bundle
SKU-1012
|
Marketing |
Davao South Yard
WH-DAV
|
280 | ₱1,850 | ₱518,000 | 132d |
|
Discontinued Cable Reel
SKU-1011
|
Hardware |
Clark Forward
WH-CLK
|
220 | ₱1,250 | ₱275,000 | 268d |