What You Should Do About Truck Cost per Mile Spreadsheet Beginning in the Next 3 Minutes
Do the above calculations for each truck first, then use the exact same formula to have a fleet figure. If you have several trucks you'll want to figure your CPM for each truck and overall. A fancy truck with a tall payment can actually set the squeeze on your bottom line. Trucking is a challenging market and bad bookkeeping hurts a provider's odds of survival.
db-excel.com
Excel Spreadsheet Template