LogConsult Academy · I2
Road Freight Procurement and Freight Bids
Build, run, and close a freight bid.
Lessons are recorded in Portuguese with Portuguese subtitles. Every lesson comes with its full text in English.
about US$ 370 · Prices in Brazilian reais (BRL), paid through Mercado Pago (Pix, credit card in up to 12 installments, or boleto). The checkout page is in Portuguese.
Program
5 video modules, 18 min, 5 exercises
- Preparing the bid: baseline, lots, and lanes
- Invitation, rounds, and decision criteria
- Analyzing proposals against a reference cost
- Allocation and contracting
- Post-bid management and spot freight
What you build
Bid kit: RFP document, spreadsheet, and analysis
Free sample: the first 2 minutes of module 1
Lesson text in English · 1
Preparing the bid: baseline, lots, and lanes
Preparing the bid. Hi, I'm Lia, the virtual presenter of LogConsult Academy. This is the first module of the course on Road Freight Procurement and Freight Bids. Here you will learn how to prepare a freight bid before inviting any carrier. We will build the historical shipment baseline, organize the lanes with their volumes, and group those lanes into lots that make sense for whoever will be pricing them.
Preparation decides the result. The quality of a freight bid is determined before the invitation goes out. When a carrier receives vague volumes and poorly described lanes, it builds a margin into the price to cover a risk it cannot measure. When it receives clean data, with volume per lane, vehicle type, and loading and unloading rules, it can calculate the real cost and offer a fairer price for both parties.
The historical baseline. The starting point is the historical baseline for the last twelve months, with one row per trip. Each row carries the origin, the destination, the weight, the volume, the vehicle type, the freight paid, and the accessorial costs. This baseline is usually scattered across the transportation management system, the invoices, and the team's spreadsheets. Putting together and cleaning this data takes time, but everything that comes next depends on it.
Lanes and volumes. With the baseline clean, you group the trips by origin and destination pair. For each lane, calculate the number of trips and the tons per month, both the average and the peak. In seasonal operations, such as agribusiness, show the volume month by month, because the carrier needs to know when it will need more trucks. Also adjust the volumes using next year's sales forecast.
Building the lots. Lots are groups of lanes that will be bid on together. The logic is to combine similar lanes, from the same region, with the same vehicle type or serving the same group of customers. A well-built lot lets the carrier take advantage of the truck's backhaul and offer a better price. Be careful with lots that are too small, which attract no interest, and with lots that are too large, which few carriers can serve.
Assumptions and requirements. Along with the lanes and the lots, the carrier needs to know the operation's assumptions. Provide the delivery lead times, the time windows at customers, and the free time for loading and unloading before detention is charged. Also say who buys the insurance, what the payment term is, and which documents are required. Every assumption left out comes back later as an accessorial cost on the invoice.
An example. Now let's look at a practical example, always with illustrative numbers. A food manufacturer made one thousand eight hundred trips in the year, spread across sixty-four lanes. When organizing the baseline, the team saw that fifteen lanes concentrated seventy percent of the volume. Those lanes were split into four lots by region. The smaller lanes formed two other lots, one for each vehicle type used in the operation.
Module exercise. Now it's your turn to apply what we covered in this module. Build the shipment baseline for the last twelve months of your operation, with one row per trip. Group by lane and calculate the average and peak volume. Then propose the bid lots and list the assumptions the carrier needs to know. In the next module, we will prepare the invitation, the proposal rounds, and the decision criteria. See you there.
Lessons are presented by Lia, a virtual presenter generated by AI. The content is written and reviewed by LogConsult.