Calculate Deadhead Miles Percentage

Excel Formulas › Logistics & Trucking

All versions

Deadhead miles are the empty, unpaid miles a truck drives between loads. Tracking them as a percentage of total miles exposes wasted fuel and time.


Quick formula: Divide empty (deadhead) miles by total miles:
=EmptyMiles/TotalMiles

Lower is better. Most fleets aim to keep deadhead under 10–15%.

Functions used (tap for the full reference guide):

The example

A truck drove 1,200 total miles last week, of which 180 were empty.

AB
1ItemMiles
2Total miles1,200
3Empty miles180
4Deadhead %15.0%

The formula

Deadhead percentage is empty miles divided by total miles driven:

=B3/B2 // empty miles ÷ total miles, as a percent

How it works

How to use it:

  1. Record total miles driven for the period (1,200) and how many of those were empty between loads (180).
  2. Divide empty by total: 180 ÷ 1,200 = 0.15, or 15% deadhead.
  3. Loaded miles are the remainder, 1,020, which are the miles that actually earned revenue.
  4. Format as Percentage and track the trend; rising deadhead means more empty repositioning.

Multiply deadhead miles by your cost per mile to put a dollar figure on the waste.

Try it: interactive demo

Interactive

Enter total and empty miles; deadhead and loaded percentages update.

Variations

Loaded ratio instead

The complement — share of miles that paid.

=1-B3/B2

Cost of deadhead in dollars

Empty miles times cost per mile.

=B3*CostPerMile

Pitfalls & errors

Be consistent about what counts as deadhead — bobtail and repositioning miles should be included, or comparisons across weeks break down.

Pair deadhead % with revenue per loaded mile to see whether cutting empty miles is actually improving the bottom line.

Practice workbook

📊
Download the free Calculate Deadhead Miles Percentage practice workbook
Edit the yellow mile counts; deadhead and loaded percentages recalculate.

Frequently asked questions

What is an acceptable deadhead percentage?
It varies by lane and freight type, but many carriers target under 10–15%. Spot-market and specialized hauls often run higher.
Are deadhead miles ever paid?
Sometimes a shipper pays a deadhead allowance, but as a rule empty miles cost fuel and wages without freight revenue.
How do I reduce deadhead?
Better load planning, backhauls, and load boards that fill the return trip are the usual levers.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Cost per mile

Function references: SUMROUND