Freight Tender Analysis: Lane Bids, Carrier Scoring & Award Scenarios
Run a shipper's truckload tender from lane file to award memo: baseline cost, normalising bids with fuel and accessorials, lowest bid per lane, carrier scorecards, best-value and capacity-aware award scenarios, backup carriers and leakage, savings and an award dashboard, with every cell checked as you go.
The first lesson is free — no account needed.
About this course
A freight tender analysis course that runs the truckload tender of one fictional shipper, Harlow Home Goods, from the lane file to the award memo in a spreadsheet, for transportation and procurement analysts, logistics managers and supply chain students. You calculate the baseline spend and the network rate per mile the right way, convert bids in different formats into one all-in cost per load with a fuel surcharge table and stop-off charges, find the lowest bid, its carrier and the gap to the runner-up per lane with MINIFS and INDEX/MATCH, score carriers on on-time delivery, tender acceptance and claims, compare a lowest-cost and a best-value award and test them against committed capacity, price the routing guide risk of backup carriers and spot loads, measure savings per lane and as a volume-weighted percentage, and chart the award by carrier. Fictional shipper and rates. The first lab is free.
Lessons
- Lane Volumes & the Baseline CostFree
- Normalising Bids: Rate Basis, Fuel Surcharge & Accessorials Pro
- Lowest Bid per Lane: MINIFS, COUNTIF & INDEX/MATCH Pro
- Carrier Scorecards: On-time, Tender Acceptance & Claims Pro
- Award Scenarios: Lowest Cost, Best Value & Capacity Limits Pro
- Backup Carriers & Routing Guide Risk Pro
- Savings vs Baseline by Lane & in Total Pro
- Award Summary Dashboard Pro