Lowest Bid per Lane: MINIFS, COUNTIF & INDEX/MATCH
This lesson is part of the course
In this lesson
From a long bid export you find, for every lane, the number of bids, the lowest bid, the carrier who placed it and how far ahead it is of the runner-up.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Lane Volumes & the Baseline Cost Locked
- Normalising Bids: Rate Basis, Fuel Surcharge & Accessorials Locked
- Lowest Bid per Lane: MINIFS, COUNTIF & INDEX/MATCH Locked
- Carrier Scorecards: On-time, Tender Acceptance & Claims Locked
- Award Scenarios: Lowest Cost, Best Value & Capacity Limits Locked
- Backup Carriers & Routing Guide Risk Locked
- Savings vs Baseline by Lane & in Total Locked
- Award Summary Dashboard Locked