Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
302
Total Travel Cost
$43,152
64,406 miles
Avoidable Cost
$26,258
39,191 excess miles
Optimal Cost
$16,894
If closest tech always used
Avg Excess / WO
129.8 mi
$86.95 per WO
Median Excess
29.9 mi
Outlier Rate (>50mi)
39.1%
118 WOs

Actual Travel Expenses

From 140 WOs with expense data
Total Expenses
$44,504
Labor - Travel
$29,324
Mileage
$322
Lodging
$6,204
Airfare
$1,850
Car Rental
$799
Per Diem
$2,525
Meals
$0
Other
$3,479

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 Ryan Lewis 34 9,752 $6,534 286.8 mi 129.3 mi 4,398 $2,947 286.8
45% excess
2 Patricia Gordon 17 6,005 $4,023 353.2 mi 335.2 mi 5,699 $3,818 353.2
95% excess
3 Bryan Rodriguez 8 5,973 $4,002 746.6 mi 579.3 mi 4,634 $3,105 746.6
78% excess
4 Paul Mccormish 16 5,831 $3,907 364.5 mi 346.5 mi 5,543 $3,714 364.4
95% excess
5 Michael Swingle 90 5,502 $3,686 61.1 mi 24.4 mi 2,198 $1,473 61.1
40% excess
6 Davon Cox 7 5,305 $3,554 757.8 mi 590.5 mi 4,133 $2,769 757.9
78% excess
7 Bruce Ballard 35 5,300 $3,551 151.4 mi 24.1 mi 843 $565 151.4
16% excess
8 Philmon Mehari 6 4,483 $3,004 747.2 mi 579.9 mi 3,479 $2,331 747.2
78% excess
9 Samuel Biddie 21 3,770 $2,526 179.5 mi 21.5 mi 452 $303 179.5
12% excess
10 Vivian Hyde 3 2,101 $1,408 700.4 mi 580.1 mi 1,740 $1,166 700.3
83% excess
11 Praelow Cameron 10 1,783 $1,195 178.3 mi 52.8 mi 528 $354 178.3
30% excess
12 James Duff 37 1,692 $1,134 45.7 mi 14.5 mi 538 $360 45.7
32% excess
13 Christopher Carroll 5 1,643 $1,101 328.7 mi 301.9 mi 1,510 $1,012 328.6
92% excess
14 Andre Samuda 2 1,469 $984 734.5 mi 648.6 mi 1,297 $869 734.5
88% excess
15 Rodney Charles 2 1,318 $883 658.9 mi 491.1 mi 982 $658 659
75% excess
16 Fady Messak 2 1,313 $880 656.7 mi 512.1 mi 1,024 $686 656.5
78% excess
17 Todd Fogiel 5 735 $492 147.1 mi 11.3 mi 56 $38 147
8% excess
18 Rozier Cole 1 340 $228 339.6 mi 129.4 mi 129 $86 340
38% excess
19 Henry Holmes 1 91 $61 90.8 mi 4.8 mi 5 $3 91
5% excess