Freight Cost Intelligence & Budget Variance

Hartwell Consumer Goods · Q3 2024 YTD · FC% Target: 7.6% (Current: 8.3%)

Total Freight Spend
$25.7M
+$2.1M vs budget
Accessorial Charge Rate
18.7%
+3.2pp vs baseline
Freight Audit Recovery
$47K
2.3% recovery rate
Mode Mix Cost Index
1.09
9% above optimal
Spot Market Dependency
22%
+13pp from Q2
FC% of Net Revenue
8.3%
Target: 7.6%

Freight Spend Variance Waterfall (Budget vs. Actual)

Weekly Freight Spend Trend (12 Weeks)

Mode Mix Distribution & Cost

Lane Cost Per Unit vs. Benchmark (Top 20 Lanes)

Accessorial Charges

Fuel Surcharge Index

Spot vs. Contract Rate

Freight Cost per Order Line

Invoice Payment Cycle (Days)

Lane-Level Cost Intelligence (High-Variance Lanes)

Lane Origin DC Volume (Units) Avg CPU Benchmark CPU Variance ACR % Spot % Status
Columbus-ATL Columbus OH 47,200 $2.87 $2.34 +22.6% 24.1% 38% Critical
Ontario-LAX Ontario CA 38,900 $1.94 $1.67 +16.2% 19.8% 29% Warning
Dallas-PHX Dallas TX 29,400 $3.12 $2.91 +7.2% 16.4% 12% Warning
Columbus-NYC Columbus OH 41,800 $2.56 $2.48 +3.2% 14.2% 8% On Track
Ontario-SEA Ontario CA 22,100 $4.21 $3.87 +8.8% 21.3% 18% Warning
Dallas-DEN Dallas TX 18,700 $3.44 $3.56 -3.4% 11.9% 5% On Track
Columbus-MIA Columbus OH 31,200 $3.78 $3.12 +21.2% 26.7% 41% Critical
Ontario-PDX Ontario CA 15,600 $4.89 $4.65 +5.2% 17.1% 14% Warning

Freight Spend Concentration (Top 10 Carriers)

Concentration Risk Index by DC

Columbus OH 0.68

Top 3 carriers: 68% of volume

Ontario CA 0.71

Top 3 carriers: 71% of volume

Dallas TX 0.54

Top 3 carriers: 54% of volume

Network Risk Score: 0.64 (Moderate) — Consider diversifying carrier mix at Columbus and Ontario to mitigate service disruption risk.