Scenarios, not spreadsheets
A sorted spreadsheet answers one question about a tender — which carrier is cheapest per line; a scored award plan answers the one that actually decides it.
Most freight awards are still decided in a spreadsheet sorted by price. It is fast, it feels objective, and it answers exactly one question: which carrier is cheapest on each line. The trouble is that cheapest-per-line is almost never the award you want. It scatters volume across dozens of carriers, ignores how your network actually moves, and hides the risk that sits underneath a low number.
A scenario is different. It is a complete award plan for the whole portfolio, scored on one consistent basis, that you can compare against other complete plans. The shift from spreadsheet to scenario is the shift from sorting to deciding.
The one-answer trap
Sort a bid sheet by price and you have optimised a column, not a portfolio. The winning cell on each lane knows nothing about the cell above it. Award every line to its cheapest bidder and you may end up with forty carriers, three of them holding a single lane each, and no fallback anywhere. The spreadsheet cannot warn you, because concentration and coverage are portfolio properties and the sort only sees rows.
This is why price-sorted awards so often unravel after signing. The number looked right; the shape of the award did not.
There is a subtler cost as well. A price-sorted award is almost impossible to explain as a whole, because it has no logic beyond "each line was cheapest." Ask why the portfolio ended up with the carrier mix it did and the honest answer is that no one chose the mix — it fell out of forty independent sorts. A scenario, by contrast, is a choice you can state in a sentence, which is exactly the difference between an award you can defend and one you can only report.
One recommendation, with alternatives
A serious tender does not hand you a menu of equally weighted options; it produces a recommendation you can act on, with the alternatives visible so the recommendation can be judged. From a single lane decision matrix — every shipment priced for every carrier, at every rate geography — the platform builds one recommended award plan and sets the main alternatives beside it:
- The recommended plan — each lot awarded to the carrier cheapest for that lot's lanes as a whole, with the reasons, coverage flags and confidence indicators attached lane by lane.
- Single-carrier consolidation — the whole book awarded to the one carrier that minimises total cost, trading savings for the simplicity of a single relationship.
- Geography-optimised — the recommended plan re-rated to each carrier's best rate geography: more saving on paper, but it depends on renegotiating lane definitions first.
Set side by side and scored on one basis, these turn an argument into a choice. Instead of debating carriers one lane at a time, you weigh a recommendation against the two directions it could sensibly move — cheaper but simpler, or cheaper but harder to negotiate — and decide with the trade-offs in front of you. The award math is deterministic: the same bids yield the same recommended plan on every run, so the comparison is one anyone can reproduce rather than one that depends on who built it.
Reading a near-tie
Sometimes the recommended plan and an alternative finish almost level — a portfolio of €4.59M against €4.62M. It is tempting to read that as indecision. It is the opposite: it is the tender telling you that cost has stopped being the deciding factor and something else should break the tie. A −0.7% difference is inside the margin of error of most bid data, so decide on the stronger service, the lower concentration, or the easier transition, and record that the cost gap was immaterial.
A near-tie is also a gift to whoever reviews the award later. It shows the alternative was a real fallback, not a distant runner-up, which makes the whole decision easier to defend.
Beyond the recommended plan
The recommended plan is deliberately conservative: it consolidates each lot to a single carrier and reports only the savings you can bank without renegotiating anything. Most portfolios hold more upside than that, and it does not disappear — it is ranked, by euro impact, in a separate opportunity ledger: the lot worth splitting across two carriers, the lane worth renegotiating to a better geography, the incumbent overspend worth challenging. Keeping these out of the headline award and in the ledger is what lets the recommended plan stay clean and defensible while the extra savings stay visible and optional.
Constraints work the same way. A concentration limit, or a plant relocation mid-tender, is not handled by quietly editing the award after the fact. It is handled up front — in how the tender is lotted, and in which ledger levers you accept or decline — so the constraint is visible in the plan a reviewer sees rather than buried in a set of manual changes they have to take on trust.
From plan to award
Choosing a plan is not the end. The chosen plan still has to become a real award — lane by lane, with your overrides applied and recorded — and then a rate file the transport-management system will accept. But starting from a scored plan rather than a sorted column changes everything downstream: the overrides are visible against a clear baseline, the rationale is already half-written, and the award you hand to execution has a shape you chose on purpose.
There is a cultural shift buried in this too. A tender run on a sorted spreadsheet tends to be defended one carrier at a time, which invites relitigation of every line. A tender run on a scored plan is defended as a strategy: you chose the plan that best balanced cost, service and risk, and the plan is on the table for anyone to inspect. The conversation moves up a level, from "why did carrier X lose lane 14" to "is this the right award for the portfolio" — which is the conversation worth having.
Spreadsheets answer the question they were sorted by. A scored award plan answers the question you were actually asked.