What's inside
- An Instructions tab and a Scorecard tab
- Input columns per carrier: on-time percentage, shipments in the period, claims filed, claims resolved, invoice accuracy percentage, and average discount percentage
- A claims resolution rate that calculates from claims filed and resolved
- A composite score that calculates automatically: on-time 35%, claims resolution 25%, invoice accuracy 25%, average discount 15%
- A notes column, and one example row to replace
How to use it
- Open the Scorecard tab and replace the example row with your first carrier.
- Add one row per carrier, typing only in the input columns.
- Leave the resolution rate and composite score columns alone. They calculate on their own.
- Change the weights in the formula if something other than on-time performance matters most to your operation.
- Update it monthly or quarterly, and bring it to carrier reviews and renewals.