Normalising Carrier Rate Sheets So You Can Compare Rates Fairly
Turn messy carrier rate sheets into one comparable format, including fuel, ODA and minimum charges, so you pick carriers on true cost.
Every carrier sends rates differently. One quotes per kg by zone, another per box, a third a flat rate per trip. Fuel surcharge is a percentage on one sheet and linked to diesel price on another. ODA, docket, handling and COD charges are buried in footnotes. Comparing them side by side is close to impossible.
So the choice often falls back on habit or the lowest headline rate. Then the invoices arrive with minimum chargeable weight, volumetric weight and out-of-delivery-area fees that were never in the comparison. The cheapest carrier on paper turns out to be expensive on your actual shipment mix, and nobody can say by how much.
Why not just compare per-kg rates?
Because much of the difference sits elsewhere. Minimum chargeable weight, volumetric divisors, fuel rules and ODA fees can change the actual bill sharply for light or remote shipments. Pricing a real shipment sample shows the true cost.
How often should we redo the comparison?
At least when carriers revise rates, when your shipment mix changes, such as new regions or SKUs, or when fuel surcharges move. With a fixed schema, re-running it is quick, so quarterly is a reasonable default.
Can this help us audit carrier invoices too?
Yes. Once rates live in a structured schema, each invoice line can be recalculated and compared with what was billed. Differences in weight, surcharges or zone become visible instead of being paid by default.