UC-379
Surcharge Annex Normalisation & Award
Normalises buried surcharge annexes onto one lane basis, compares landed cost bid by bid, and ranks the freight tender award.
TBDBuild Duration
XXXXIndicative ROI
XXXXBuild Cost
XXXXValue
The Challenge
Rate sheets arrive in different formats with surcharges buried in annexes, so lane comparison never happens. It persists because each mode is tendered by a different team and paid rates never feed back.
How It Works
- Reads carrier rate sheets, surcharge annexes, tender responses and paid freight invoices.
- Normalises every surcharge annex to a common lane basis and scores bids on landed cost.
- Gives the category manager a ranked award recommendation with the paid-rate evidence.
What It Removes
- Manual normalisation of carrier rate sheets
- Spreadsheet modelling of surcharge scenarios
- Arguing after award about which bid was cheapest
Input Data RequirementsCarrier rate sheets and surcharge annexes, tender responses, freight invoice history, lane volume forecasts, service records, fuel indices
Output FormatNormalised lane rate comparison with each surcharge annex restated, a ranked award recommendation per lane, and a paid-against-tendered register
“Every carrier prices differently and by the time we have normalised the sheets the tender window has closed”