Inventory Planning
Service levels are healthy, but cash is trapped in Replacement Parts - about $1.6M can be freed without touching service.
Balance customer service against working capital — optimized safety stock, projected positions, excess & obsolete, and the cash tied in inventory.
Inventory days
42
-3%target 38
Fill rate
97.4%
+0.6%vs target 98%
Working capital
$221.2M
+1.4%tied in inventory
Excess & obsolete
$9.2M
+4.2%write-down risk
Inventory turns
8.7x
+0.3%annualized
Projected inventory position ›
Index · projected balance vs safety stock & target
Service vs inventory ›
Trade-off curve — diminishing returns past ~46 days
Inventory by family ›
On-hand, policy targets, service & working capital
| Family | On-hand (u) | Safety stock | Days | Target days | Coverage | Fill rate | E&O | Working cap. |
|---|---|---|---|---|---|---|---|---|
| Home Appliances | 46,701 | 18,087 | 37 | 33 | 95.0% | $4.4M | $67.5M | |
| Power Tools | 41,923 | 14,274 | 50 | 40 | 94.0% | $1.3M | $72.7M | |
| Outdoor Equipment | 7,473 | 2,763 | 38 | 30 | 97.3% | $389K | $22.2M | |
| Smart Electronics | 8,230 | 2,991 | 34 | 31 | 93.2% | $2.7M | $31.9M | |
| Packaging & Supplies | 41,032 | 16,546 | 30 | 27 | 99.0% | $298K | $22.1M | |
| Replacement Parts | 22,197 | 9,128 | 49 | 45 | 94.6% | $258K | $4.8M |
Operi insight · Replacement Parts runs hottest at well above its target days on intermittent demand — the largest single working-capital release opportunity (~$1.6M) with no service impact. Home Appliances and Packaging are near optimal.