I’ve handled annual freight negotiations and considered bringing in a third party to analyze our spend. We ended up doing the work ourselves with Excel and SAP. The question I wanted answered was straightforward: What would we have paid if the proposed rates had applied to the shipments we actually sent?
Here’s a simplified example. Say one carrier quotes $8 a package and another quotes $7.50 plus a $3 residential delivery fee. On 100 packages, the second bid starts out $50 cheaper. If 20 of those packages go to residential addresses, that adds $60. The cheaper bid now costs $10 more. Change the mix to five residential deliveries and I’d reach a different conclusion.
For an actual comparison, I’d pull shipment-level detail for a representative period and price the same shipments under each bid. I’d keep the destination, billed weight, service level, and applicable fees visible. Then I’d check the calculation against a few actual invoices. If I can’t reproduce what we paid under the current agreement, I’d want to understand that gap before using the spreadsheet to negotiate the next one.
I’d also ask operations where a carrier change could affect pickups or delivery commitments, and accounting which fees have been hard to reconcile. Sales needs a say when a customer has a receiving requirement we’ve agreed to. With those answers, I can decide which rate to push on, which service commitment to protect, and whether switching carriers is worth it.
Sometimes the most useful thing to take into a negotiation is one line from an invoice and a count of how often it showed up last year. That gives both sides something specific to work on.