Critical Stock Agent
Stockouts on your fastest-moving SKUs.
Calculates days-of-cover per warehouse from on-hand × velocity, cross-references the open replenishment pipeline, and surfaces SKUs that will hit zero before the next receipt.
Source: WMS · inventory_levels, purchase_orders
Critical lines
4
At or below safety stock
Below reorder
0
Replenish this week
Healthy / monitor
16
No action needed
Avg days of cover
1,108.9d
Across all stocked lines
Active findings · 3
high
SKU-1002
SKU-1002 Industrial PCB Board v3 — 4.3 days of cover at WH-MNL
On-hand 180 vs reorder point 600. Daily velocity 42/day. Replenishment PO is 50 days late. WH-CLK at 3.4 days of cover.
Recommendation: Air-freight 800 units from SUP-002 against PO-2026-0142 to buy 19 days of cover. Reroute outbound from WH-CEB if production at NCR is at risk.
Impact
₱12,400,000
high
SKU-1006
SKU-1006 Sensor Module SX-22 — stockout at WH-CEB
On-hand 0 at Cebu Hub. WH-MNL at 2.3 days of cover. Open PO from SUP-006 is 22 days late.
Recommendation: Transfer 60 units from WH-MNL to WH-CEB. Issue rush PO to alternate vendor (qualification: SUP-008 has compatible variant).
Impact
₱4,950,000
medium
SKU-1004
SKU-1004 HDPE Resin Pellets — trending toward reorder at WH-CLK
On-hand 220 vs reorder point 150. Velocity has climbed from 7 to 9.5/day in the last 14 days. Will hit reorder point in 8 days at current run rate.
Recommendation: Trigger replenishment now (lead time 21 days from SUP-004) instead of waiting for the system flag.
Impact
₱1,024,000
Inventory health by SKU × warehouse
Sorted by criticality, then days of cover| SKU | ABC | Warehouse | Supplier | On hand | Reorder pt | Velocity / day | Days of cover | Status |
|---|---|---|---|---|---|---|---|---|
|
Sensor Module SX-22
SKU-1006
|
A |
Cebu Hub
WH-CEB
|
Hanoi Precision Components | 0 | 150 | 11.0 | stockout | Critical |
|
Sensor Module SX-22
SKU-1006
|
A |
Metro Manila DC
WH-MNL
|
Hanoi Precision Components | 42 | 250 | 18.0 | 2.3d | Critical |
|
Industrial PCB Board v3
SKU-1002
|
A |
Clark Forward
WH-CLK
|
Shenzhen Linwei Electronics | 95 | 400 | 28.0 | 3.4d | Critical |
|
Industrial PCB Board v3
SKU-1002
|
A |
Metro Manila DC
WH-MNL
|
Shenzhen Linwei Electronics | 180 | 600 | 42.0 | 4.3d | Critical |
|
Corrugated Box 12x12x10
SKU-1001
|
A |
Cebu Hub
WH-CEB
|
Cebu Industrial Packaging Corp. | 6,800 | 4,500 | 480.0 | 14.2d | Healthy |
|
Corrugated Box 12x12x10
SKU-1001
|
A |
Metro Manila DC
WH-MNL
|
Cebu Industrial Packaging Corp. | 12,400 | 8,000 | 850.0 | 14.6d | Healthy |
|
Corrugated Box 12x12x10
SKU-1001
|
A |
Davao South Yard
WH-DAV
|
Cebu Industrial Packaging Corp. | 3,200 | 2,000 | 210.0 | 15.2d | Healthy |
|
Stretch Film 500mm
SKU-1007
|
B |
Metro Manila DC
WH-MNL
|
Iloilo Logistics Supplies | 1,400 | 800 | 62.0 | 22.6d | Healthy |
|
Cleaning Solvent 5L
SKU-1005
|
C |
Metro Manila DC
WH-MNL
|
Davao Agro Distributors | 320 | 200 | 14.0 | 22.9d | Healthy |
|
HDPE Resin Pellets 25kg
SKU-1004
|
A |
Clark Forward
WH-CLK
|
Bangkok Resin Trading Co. | 220 | 150 | 9.5 | 23.2d | Healthy |
|
Stainless Bolt M8x40
SKU-1003
|
B |
Cebu Hub
WH-CEB
|
Manila Steel & Fasteners | 9,200 | 5,000 | 380.0 | 24.2d | Healthy |
|
Stainless Bolt M8x40
SKU-1003
|
B |
Metro Manila DC
WH-MNL
|
Manila Steel & Fasteners | 18,500 | 10,000 | 720.0 | 25.7d | Healthy |
|
HDPE Resin Pellets 25kg
SKU-1004
|
A |
Metro Manila DC
WH-MNL
|
Bangkok Resin Trading Co. | 480 | 250 | 18.0 | 26.7d | Healthy |
|
Industrial Lubricant 20L
SKU-1008
|
B |
Clark Forward
WH-CLK
|
Kuala Lumpur Chemicals Bhd. | 220 | 120 | 8.0 | 27.5d | Healthy |
|
Seasonal Holiday Bundle
SKU-1012
|
C |
Metro Manila DC
WH-MNL
|
Iloilo Logistics Supplies | 640 | 100 | 0.3 | 2,133.3d | Healthy |
|
Legacy Display Unit DM-9
SKU-1009
|
C |
Cebu Hub
WH-CEB
|
Shenzhen Linwei Electronics | 120 | 30 | 0.1 | 2,400.0d | Healthy |
|
Seasonal Holiday Bundle
SKU-1012
|
C |
Davao South Yard
WH-DAV
|
Iloilo Logistics Supplies | 280 | 60 | 0.1 | 2,800.0d | Healthy |
|
Legacy Display Unit DM-9
SKU-1009
|
C |
Metro Manila DC
WH-MNL
|
Shenzhen Linwei Electronics | 340 | 50 | 0.1 | 3,400.0d | Healthy |
|
Promo Q1 Tarpaulin Pack
SKU-1010
|
C |
Metro Manila DC
WH-MNL
|
Cebu Industrial Packaging Corp. | 1,800 | 200 | 0.2 | 9,000.0d | Healthy |
|
Discontinued Cable Reel
SKU-1011
|
C |
Clark Forward
WH-CLK
|
Manila Steel & Fasteners | 220 | 50 | 0.0 | — | Healthy |