Inventory & Supply Chain Revenue Impact

Vitalcore Supply — Real-time revenue protection dashboard

Revenue at Risk Today
$34,820
+18% vs. last week
Tier-1 Stockout Rate
6.2%
Target: 3.0%
Overstock Exposure
$242K
11% of total inventory
Avg GMROII
2.8x
+0.3 vs. Q3
Reorder Point Accuracy
78%
-6% vs. last month
Dead Stock Value
$68.4K
Primarily NJ warehouse

SKU Revenue Risk Matrix — Top 24 SKUs by Revenue Impact

Critical Risk (Tier 1 Stockout)
Moderate Risk (Low Stock)
Healthy Stock
Overstock Risk

Stockout Frequency by SKU Tier × Month

Percentage of days with stockouts
Jul
Aug
Sep
Oct
Nov
Dec
Tier 1
2.1%
2.8%
3.4%
4.8%
7.2%
9.1%
Tier 2
1.2%
1.8%
2.1%
3.2%
4.6%
5.8%
Tier 3
0.4%
0.8%
1.1%
1.9%
2.8%
4.1%

GMROII by Category

Overstock Exposure by SKU — Top 16 Slow Movers

Category Conversion Rate vs. In-Stock Rate

Correlation coefficient: 0.84 — strong positive

Supplier Lead Time Variance (Days)

Active Stockout Alert Table — Tier 1 SKUs

SKU Product Name Days Out Lost Revenue/Day Total at Risk Warehouse ETA Restock
VCS-2401 Omega-3 Triple Strength 180ct 4 $3,240 $12,960 LA Dec 18
VCS-1803 Collagen Peptides Unflavored 32oz 3 $2,880 $8,640 Dallas Dec 16
VCS-3102 Probiotic Complex 90ct 6 $2,200 $13,200 NJ Dec 21
VCS-2209 Vitamin D3 5000IU 120ct 1 $1,680 $1,680 LA Dec 14
VCS-1604 Multivitamin Complete 60ct 2 $1,420 $2,840 Toronto Dec 15

Fulfillment Lead Time by Carrier × Zone

Average days from order to delivery
Zone 1-3
Zone 4-5
Zone 6-7
Zone 8
USPS Priority
2.1
2.8
3.4
4.2
UPS Ground
1.9
2.6
3.2
4.8
FedEx Ground
2.3
3.1
3.7
5.1

30-Day Sell-Through Rate by Category