Cellwise Start free

Guided project · 5 steps Cellwise Plus

Owner-operator cost per mile in Excel

Turn a truck's monthly bills, fuel and miles into a cost per mile and the minimum rate per loaded mile worth taking.

You will use: SUM, ROUNDUP

Starting data

RowABCDE
1Fixed costPer monthRunning costValue
2Truck payment2350Diesel per gallon3.85
3Trailer payment650MPG6.5
4Insurance1180Maintenance and tires per mile0.19
5Permits and plates160Fuel per mile
6ELD and load board120Total cost per mile
7Phone and office140Miles per month9800
8Total fixedDeadhead share0.12
9Fixed per mileTarget profit per mile0.45
10Minimum rate per loaded mile

Build it step by step

  1. Step 1

    Add up the monthly fixed costs in B8.

    B8Formula included with Cellwise PlusFormula in the app
  2. Step 2

    Spread the fixed costs over the miles you run: B8 divided by the miles per month in E7. Write it in B9.

    B9Formula included with Cellwise PlusFormula in the app
  3. Step 3

    Fuel per mile is the diesel price divided by MPG. Write it in E5.

    E5Formula included with Cellwise PlusFormula in the app
  4. Step 4

    Total cost per mile in E6: fixed per mile, plus maintenance and tires, plus fuel.

    E6Formula included with Cellwise PlusFormula in the app
  5. Step 5

    Only loaded miles get paid. In E10, add the target profit to the cost per mile and divide by the loaded share (1 minus the deadhead share), rounded up to the cent with ROUNDUP.

    E10Formula included with Cellwise PlusFormula in the app

Guides for the formulas in this project