Supply Chain Control Tower — Inventory Positioning & Working Capital

Arcturus Consumer Goods • November 2024 • 6 DCs, 4,800 SKUs

Total Inventory Value
$487M
+$43M vs. Q1 (9.7%)
Avg. Inventory Turn Rate
3.2×
↓ 0.9× vs. Target (4.1×)
Days Inventory Outstanding
68d
↑ 16d vs. Q1 (52d)
Stock-Out Rate (SKU-DC)
7.2%
↓ 2.1% MoM
Overstock Exposure
$127M
26.1% of Total Inv.
Slow-Mover Concentration
34.2%
1,643 SKUs, $166M

Inventory Network Map — Overstock vs. Stock-Out by DC

CHI Overstock: $47M SO: 11.4% ATL Overstock: $18M, SO: 4.2% PHI Overstock: $21M, SO: 5.8% DAL Overstock: $23M, SO: 8.1% PHX Overstock: $10M, SO: 6.3% LAX Overstock: $8M, SO: 3.9% High Overstock (>$20M) Balanced

Inventory Treemap — SKU Class & Category by Value

A-Class Electronics
$148M
B-Elect
$42M
C-Elect
$38M
A-Class Home Goods
$89M
B-Class Home
$61M
A-Tools
$47M
C-Home
$34M
B-Tools
$18M
C-Tools
$10M

Turn Rate by SKU Class

Safety Stock Accuracy Index

DIO by Category

Overstock by DC

SKU Rationalization Candidates — C-Class Slow Movers

SKU Category Inventory Value Turn Rate Days Coverage DC Count Recommendation
SKU-E-4782 Electronics $847K 0.3× 247d 4 Liquidate
SKU-H-2134 Home Goods $623K 0.4× 198d 5 Consolidate to 2 DCs
SKU-T-8821 Tools $512K 0.5× 176d 3 Discontinue
SKU-E-5593 Electronics $489K 0.6× 164d 6 Rebalance to CHI only
SKU-H-7742 Home Goods $407K 0.7× 148d 4 Markdown 30%
SKU-T-3309 Tools $391K 0.8× 132d 2 Monitor
SKU-E-9214 Electronics $364K 0.4× 189d 5 Liquidate
SKU-H-5167 Home Goods $328K 0.9× 121d 3 Consolidate to 1 DC

Working Capital Waterfall — Overstock Reduction Scenario

Rebalancing Transfer Execution

Execution Rate (30d)
78.4%
643 of 820 recommended transfers completed

Demand Forecast MAPE — By SKU Class & Horizon

Inventory Turn Rate by DC & SKU Class — 6-Month Heatmap

Jun
Jul
Aug
Sep
Oct
Nov
CHI-A
4.8
4.2
3.1
2.6
2.3
1.9
CHI-B
3.9
3.7
2.9
2.4
2.1
1.7
CHI-C
1.8
1.5
1.2
0.9
0.7
0.4
ATL-A
5.1
4.9
4.6
4.3
4.1
3.9
DAL-A
4.2
3.8
3.4
3.1
2.8
2.6
PHX-B
3.6
3.4
3.1
2.9
2.7
2.5