Freight Cost Allocation & Carrier Rate Intelligence

MidlandFreight Solutions Ltd • QTD Freight Spend £4.82M • 5 Carriers, 4 Modes

Freight COGS %
9.3%
+2.2pp vs Q1
Lane Rate Variance
+£68K
Overbilled
Accessorial % of Total
26.4%
+3.1pp vs Q1
XPO Commitment Util.
68.1%
Below 75% tier
Risk: £87K discount loss
Invoice Accuracy
91.7%
-1.2pp MoM
64 errors in 772 invoices
Avg FSC Rate
18.3%
+2.5pp vs contract
Fuel: £487K accessorial

Lane Rate Variance: Contract vs. Actual (Top 10 Lanes, QTD)

Accessorial Breakdown (QTD £1.27M)

Carrier Utilization vs. Commitment

Spot Rate Premium (Road, Top 6 Lanes)

Rate Escalation Velocity (% per Quarter)

Carrier Invoice Detail — High Variance Shipments (Last 30 Days)

Invoice Date Carrier Lane Mode Contract Rate Invoiced Rate Variance Accessorials Status
2024-05-18DSVBirmingham-ManchesterRoad£342£356+£14 (4.1%)£42Disputed
2024-05-17XPOLeeds-LondonRoad£388£408+£20 (5.2%)£65Disputed
2024-05-16DB SchenkerGlasgow-BristolRoad£512£500-£12 (2.3%)£88Paid
2024-05-15DHLNewcastle-SouthamptonRoad£446£458+£12 (2.7%)£51Review
2024-05-14Kuehne+NagelEdinburgh-BirminghamRoad£398£398£0£47Paid
2024-05-13XPOCardiff-LondonRoad£314£328+£14 (4.5%)£39Review
2024-05-12DSVManchester-LeedsRoad£198£206+£8 (4.0%)£28Review
2024-05-11DB SchenkerLondon-GlasgowRail£624£618-£6 (1.0%)£102Paid

Mode Split (QTD Volume)

FSC Effective Rate Trend

Invoice Error Rate

Mode Shift Savings Opportunity

LaneCurrent ModeSuggestedAnnual Savings
London-GlasgowRoadRail£34,200
Birmingham-EdinburghRoadIntermodal£28,600
Manchester-BristolRoadRail£19,400
Leeds-SouthamptonRoadIntermodal£16,800

Lane Benchmark vs. Market Index

Contract Event Timeline (Next 12 Months)

DateCarrierEventImpactAction Required
Jun 2024XPOCommitment Review£87K discount at riskIncrease volume 107 shipments/month
Aug 2024DSVRate Renewal5.5% escalation proposedNegotiate fuel cap clause
Oct 2024DB SchenkerContract ExpiryRenegotiateRFP launch Aug 1
Dec 2024DHLVolume Tier ResetMaintain current tierNo action
Feb 2025Kuehne+NagelFSC Index ChangeSwitch to DOE indexModel impact by lane