Inventory Intelligence & Demand Forecasting

Ridgeline Outdoor Co. 路 Live Inventory as of Dec 15, 2024 14:32 UTC

Stockout Revenue Loss (7d)
$41,200
+218% vs prev 7d
Days of Supply (Avg)
37.2
-4.3% healthy
Overstock Carrying Cost
$18,940
+12.1% 30d
Forecast Accuracy (MAPE)
14.2%
-2.8pp vs Q2
Inventory Turnover (Ann.)
6.8x
+0.9x YoY
Reorder Point Accuracy
82.4%
-11.2pp Supplier C delay

SKU Risk Matrix: Stockout vs. Overstock Exposure

Critical Risk
High Overstock
Moderate Risk
Healthy Range

Days of Supply Heatmap by Top SKUs 脳 Week

SKU
W42
W43
W44
W45
W46
W47
W48
W49
Ultra-Lite Tent 2P
42
38
24
12
4
0
28
35
Hydro Backpack 40L
56
52
48
45
42
39
36
31
Camp Cookware Set
38
22
8
0
0
0
19
34
Trail Runner Mid GTX
82
79
76
73
68
64
61
58
Merino Base Layer
44
41
37
29
23
15
11
26
Alpine Sleeping Bag
51
49
46
43
40
38
35
32
Scale:
0-7d
8-20d
21-35d
36-65d
65+d

Supplier Lead Time Variance

Demand Forecast Accuracy (MAPE) by Category

鈿狅笍 Kitchen Category Alert
MAPE spiked to 31.2% after viral TikTok video drove unexpected demand for Camp Cookware Set (SKU-7832). Recalibrating forecast model.

Sell-Through Rate by Category (Weekly)

GMROI by Category

Tents & Shelters 3.2x
Packs & Bags 2.8x
Footwear 2.4x
Apparel 2.1x
Kitchen 1.9x

Inventory Turnover by Supplier

Markdown Depth by SKU Age

0-90 days 3.2%
91-180 days 12.8%
181-270 days 28.4%
270+ days 47.2%

SKU Inventory Master Table

SKU Name Category Supplier Units DoS GMROI Carrying Cost Status
Ultra-Lite Tent 2P Tents & Shelters Supplier C 142 4 3.8x $487 Critical
Hydro Backpack 40L Packs & Bags Supplier A 518 31 2.9x $1,124 Monitor
Camp Cookware Set Kitchen Supplier B 287 34 2.1x $624 Healthy
Trail Runner Mid GTX Footwear Supplier D 1,248 58 2.4x $3,182 Overstock
Merino Base Layer Apparel Supplier E 394 26 2.2x $871 Monitor
Alpine Sleeping Bag Tents & Shelters Supplier C 672 35 3.1x $1,456 Healthy
Summit Trekking Poles Packs & Bags Supplier B 823 41 2.7x $1,092 Healthy
Insulated Water Bottle 32oz Kitchen Supplier A 1,524 67 1.8x $2,247 Overstock

Stockout Revenue Loss Timeline (90d)

馃毃 Week 7 Event: Supplier C Port Delay
19-day shipping delay caused stockout of Ultra-Lite Tent 2P and Alpine Sleeping Bag, driving $41.2K revenue loss spike. Reorder point accuracy dropped to 71% during event window.

Top Overstock SKUs by Carrying Cost

Trail Runner Mid GTX
1,248 units 路 58 DoS
$3,182
Insulated Water Bottle 32oz
1,524 units 路 67 DoS
$2,247
Alpine Sleeping Bag
672 units 路 35 DoS
$1,456
Hydro Backpack 40L
518 units 路 31 DoS
$1,124
Summit Trekking Poles
823 units 路 41 DoS
$1,092
Total Carrying Cost (Top 10) $18,940

Inventory Capital Efficiency: Q4 Performance

Gross Margin
52.3%
Stockout Loss
-2.8%
Carrying Cost
-1.9%
Inventory-Adj Margin
47.6%