Logistics Network Performance & Freight Cost Optimization

CrateWell Consumer Goods · 340K shipments/year · 28 carriers · Target: $4.20 freight cost/unit

Freight Cost / Unit
$5.63
+34% vs target
On-Time Delivery
83.7%
-3.8% MoM
Tender Accept Rate
71.4%
-11.6% MoM
Accessorial Rate
8.2%
+1.4% MoM
Avg Dwell Time
4.6h
+48% vs baseline
CO2e per Shipment
62kg
stable

Lane Performance Heatmap — On-Time Delivery % by Origin-Destination

Atlanta DC
Dallas DC
LA Port
Memphis DC
Newark DC
Phoenix DC
Southeast Region
91%
78%
68%
85%
89%
76%
Midwest Region
84%
92%
71%
88%
79%
82%
West Coast
73%
77%
94%
75%
69%
90%
Northeast
86%
80%
67%
91%
93%
78%
Southwest
79%
88%
83%
81%
72%
89%
≥85% (On Target)
80-84% (Warning)
75-79% (At Risk)
<75% (Critical)

Freight Cost Decomposition — Contract to Actual

Base contract $4.20/unit → $5.63 actual (+ $1.43 premium/unit = $22M annual overage at 340K shipments)

Spot vs. Contract Rate Variance by Mode

Winter storm event (wk 9-11) drove TL spot rate +62% vs contract baseline

Carrier Scorecard — Top 10 by Volume

Carrier Shipments/Mo OTD % Tender Accept % Avg Cost/Unit Accessorial % Capacity Util % Risk Score
XPO Logistics 4,210 78.3% 61.2% $5.81 9.1% 68% High
J.B. Hunt 3,890 91.4% 88.7% $4.92 5.3% 82% Low
Schneider National 3,450 87.2% 76.4% $5.38 7.8% 74% Med
Old Dominion 2,980 93.1% 91.3% $4.67 4.2% 86% Low
Estes Express 2,610 89.6% 82.1% $5.02 6.4% 79% Low
YRC Freight 2,340 81.7% 69.8% $5.94 10.3% 71% High
Knight-Swift 2,120 86.9% 79.6% $5.21 7.1% 76% Med
Werner Enterprises 1,890 88.3% 84.2% $5.08 6.7% 80% Low
Saia LTL 1,720 92.4% 89.1% $4.83 5.6% 84% Low
Landstar System 1,540 85.1% 74.3% $5.47 8.9% 72% Med

Accessorial Cost Breakdown — Last 30 Days

$2.8M total accessorial costs (8.2% of freight spend) — detention +18% MoM

On-Time Delivery Rate Trend — 13 Weeks

Week 9-11 winter storm event dropped OTD from 89% to 74% (Southeast TL mode)

Modal Shift Opportunity Analysis — Potential Savings by Lane

Shifting 12% of TL volume to intermodal on identified lanes = $3.2M annual savings + 18% CO2e reduction

Spot vs. Contract Rate Variance by Lane — Cost Premium Outliers

Bubble size = shipment volume; lanes in red quadrant (>20% premium, >2000 shipments) = priority renegotiation targets