Practical Trucking Excel Guides for Canadian Carriers
Worked examples from The Loaded Mile, a product of Big Sky Dispatch Services Inc. All amounts below are fictional CAD examples, not market rates. Use your own verified costs. Have questions? Reach out to sales@loaded-mile.ca.
How to calculate trucking cost per mile
Add fixed and variable operating costs for the same period and divide by total miles including deadhead. For example, $12,000 in monthly costs divided by 6,000 total miles equals $2.00 per mile. A run with 200 loaded miles plus 40 deadhead miles costs $480 at that CPM. Always exclude costs already accounted for elsewhere to avoid double counting.
How to price a dedicated trucking contract
List round-trip miles, empty repositioning, driver time, equipment costs, fuel, waiting time, and agreed extras. At an estimated all-in cost of $900 and a 20% target margin on revenue, required revenue is $900 / (1 - 0.20) = $1,125 CAD before applicable taxes. Applying a 20% markup instead yields $1,080, which is not the same margin. Do not count fuel twice when adding FSC.
How to organize a daily truck dispatch board
Assign each shipment a unique ID, then track customer, planned pickup and delivery, assigned driver, truck and trailer units, appointment slots, next check call, and current status. Regularly review double bookings and overdue actions, and update reported availability promptly. Remember that reported availability does not verify legal hours of service.
Paperwork to review before trucking invoicing
Audit the agreed rate confirmation, bill of lading, signed proof of delivery, written accessorial approvals, timestamp evidence, required receipts, invoice references, and specific billing instructions. Requirements depend on individual customer agreements; readiness is a thorough internal checklist, not final delivery.