Travel & Margin Analysis

Quantify excess travel cost and identify optimization opportunities across your field service operation

Tech Placement Detail →
WOs Analyzed
14
Total Travel Cost
$19,665
29,350 miles
Avoidable Cost
$9,020
13,463 excess miles
Optimal Cost
$10,645
If closest tech always used
Avg Excess / WO
961.6 mi
$644.29 per WO
Median Excess
865.7 mi
Outlier Rate (>50mi)
100%
14 WOs

Actual Travel Expenses

From 12 WOs with expense data
Total Expenses
$4,481
Labor - Travel
$2,411
Mileage
$0
Lodging
$708
Airfare
$665
Car Rental
$317
Per Diem
$225
Meals
$0
Other
$154

Technician Travel Utilization

Top 30 techs by total miles driven. High total miles + high avg excess = overloaded tech being dispatched far. Low WO count + high miles = potential territory misalignment.

#TechnicianWOs Total MilesTotal Travel Cost Avg Actual DistAvg Excess Total Excess MilesAvoidable Cost Miles/WO Ratio Travel Load
1 Carlos Puebla 4 9,555 $6,402 2388.7 mi 865.7 mi 3,463 $2,320 2388.8
36% excess
2 Fady Khouzam 4 8,929 $5,982 2232.2 mi 2067.7 mi 8,271 $5,542 2232.3
93% excess
3 Paul Mccormish 3 5,812 $3,894 1937.3 mi 414.3 mi 1,243 $833 1937.3
21% excess
4 Bennet O Dartey 3 5,055 $3,387 1685.0 mi 162.0 mi 486 $326 1685
10% excess