Inventory & Demand Planning
Last 90 days
Last 30 days
Last 12 months
All Categories
Beauty
Electronics
Home & Garden
All Tiers
A-Tier
B-Tier
C-Tier
GMROII
$3.22
+$0.18 vs prior quarter
Stockout Revenue Loss (30d)
$62,400
Critical: >$50K threshold
Forecast Accuracy (WMAPE)
22.4%
-3.1pp vs prior quarter
Overstock Carrying Cost
$18.2K
-$4.1K MoM
Avg Days of Supply (A-Tier)
21.3
Target: 18-28 days
Supplier OTIF
81.6%
-4.2pp (Below 85%)
Demand Forecast vs. Actual Sales
Days of Supply by SKU Tier
A-Tier
21.3
days (healthy)
B-Tier
45.2
days (acceptable)
C-Tier
88.7
days (overstocked)
Sell-Through Rate by Recent POs
Supplier OTIF Scorecard
GreenLeaf Textiles
92%
Pacific Electronics
74%
Verdant Botanicals
88%
SmartPack Logistics
68%
Artisan Home Co
91%
SKU Velocity Acceleration Index (Week-over-Week)
Product Category
W1
W2
W3
W4
W5
W6
W7
W8
W9
W10
W11
W12
W13
Beauty
1.1
1.2
0.9
1.3
1.4
1.8
1.2
1.1
0.9
1.0
1.0
1.1
1.2
Electronics
1.0
0.8
0.7
0.8
0.9
1.0
0.9
0.8
0.7
0.6
0.7
0.8
0.9
Home & Garden
1.1
1.2
1.3
1.2
1.1
1.2
1.4
1.5
1.4
1.3
1.2
1.3
1.4
Apparel
1.0
1.0
1.1
1.0
0.9
1.0
1.1
1.0
1.0
0.8
0.9
1.0
1.1
Index >1.5: High acceleration
0.7-1.3: Normal
<0.7: Declining velocity
GMROII by Product Category
Category
Avg Inventory
Gross Margin
GMROII
Status
Beauty
$148,200
$562,800
$3.80
Strong
Home & Garden
$232,100
$786,400
$3.39
Good
Apparel
$186,500
$448,800
$2.41
Acceptable
Electronics
$294,700
$412,600
$1.40
Review