Inventory Optimization & Replenishment Intelligence

Real-time visibility into stock health, replenishment cycles, and margin preservation

Last Updated

Jan 15, 2025 08:42 AM

North Star Metric

GMROII: 4.2x

Gross Margin Return on Inventory Investment

+8.3% vs LY

Portfolio Turnover

5.8x

+0.4

Avg Days of Supply

-3 days

Stockout Risk $

$47K

Alert

12 SKUs critical

Dead Stock %

6.2%

-1.8%

Target: <8%

Overall Fill Rate

96.8%

+1.2%

Target: 97%+

Carrying Cost %

23.4%

-2.1%

Benchmark: 20-30%

Critical Stockout Alerts — Immediate Action Required

12 SKUs

SKU	Product	Days Supply	Lead Time	Revenue/Day	$ at Risk	Status
SKU-4782	Pro Series Backpack - Black	7 days	18 days	$1,240	$13,640	CRITICAL
SKU-3291	Wireless Charger Stand	8 days	21 days	$870	$11,310	CRITICAL
SKU-5621	Eco Water Bottle 32oz	9 days	15 days	$620	$3,720	HIGH
SKU-7834	Premium Yoga Mat	9 days	17 days	$490	$3,920	HIGH
SKU-2184	Bluetooth Speaker Mini	6 days	19 days	$780	$10,140	CRITICAL

Inventory Turnover by Category

Fill Rate by Channel

Days of Supply Trend (90-Day Rolling Average)

Dead Stock by Age Bucket

180-270 days $124K (3.1%)

270-365 days $87K (2.2%)

365+ days $36K (0.9%)

Markdown Recommendation

Trigger 30% markdown on 365+ day items within 14 days to preserve $22K margin

Warehouse Utilization by Zone

Zone A - High-Velocity 92%

Zone B - Medium-Velocity 78%

Zone C - Slow-Velocity 61%

Zone D - Overstock 44%

Capacity Alert

Zone A at 92% — prioritize outbound velocity or overflow to Zone B

PO Cycle Time vs. Committed Lead Time (by Supplier)

Supplier

Actual Committed Variance

GlobalTech Manufacturing

22 days 18 days +4

Pacific Textiles Co.

31 days 28 days +3

EuroComponents GmbH

14 days 15 days -1

Asia Packaging Ltd.

26 days 21 days +5

Demand Forecast Accuracy (MAPE by SKU Tier)

A-Tier SKUs

12.3%

Target: <15%

B-Tier SKUs

21.7%

Target: <25%

C-Tier SKUs

32.1%

Target: <35%

Data refreshed every 15 minutes • Last sync: NetSuite ERP, Shopify, ShipBob WMS