Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
309
Total Travel Cost
$32,164
48,006 miles
Avoidable Cost
$24,022
35,854 excess miles
Optimal Cost
$8,142
If closest tech always used
Avg Excess / WO
116.0 mi
$77.74 per WO
Median Excess
13.6 mi
Outlier Rate (>50mi)
23%
71 WOs

Actual Travel Expenses

From 127 WOs with expense data
Total Expenses
$36,566
Labor - Travel
$25,153
Mileage
$0
Lodging
$4,010
Airfare
$1,191
Car Rental
$1,480
Per Diem
$2,025
Meals
$0
Other
$2,707

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 Nkosi Wilson 28 17,006 $11,394 607.4 mi 584.6 mi 16,370 $10,968 607.4
96% excess
2 Philmon Mehari 28 8,883 $5,952 317.3 mi 281.2 mi 7,874 $5,276 317.3
89% excess
3 Fady Khouzam 18 4,969 $3,329 276 mi 225.3 mi 4,055 $2,717 276.1
82% excess
4 Jared Heisler 36 2,443 $1,637 67.9 mi 1.9 mi 67 $45 67.9
3% excess
5 Fady Messak 5 1,916 $1,284 383.2 mi 339.9 mi 1,699 $1,138 383.2
89% excess
6 Rodney Charles 8 1,371 $919 171.4 mi 60.2 mi 482 $323 171.4
35% excess
7 Jason Yenser 21 1,353 $907 64.5 mi 37.5 mi 787 $527 64.4
58% excess
8 Patricia Gordon 9 1,286 $862 142.8 mi 42.5 mi 383 $257 142.9
30% excess
9 Luis Iser 12 1,018 $682 84.8 mi 72.4 mi 869 $582 84.8
85% excess
10 Derick Velazquez 4 977 $655 244.2 mi 210.8 mi 843 $565 244.3
86% excess
11 Rick Charles 20 803 $538 40.2 mi 0.4 mi 8 $5 40.2
1% excess
12 Allan Klus 10 712 $477 71.2 mi 14.6 mi 146 $98 71.2
21% excess
13 Ryan Lewis 2 632 $423 315.9 mi 259.2 mi 518 $347 316
82% excess
14 Raymond Ebanks 5 589 $395 117.8 mi 34.1 mi 170 $114 117.8
29% excess
15 Jackson Reeves 12 501 $336 41.7 mi 11.3 mi 136 $91 41.8
27% excess
16 Vivian Hyde 15 432 $289 28.8 mi 13.3 mi 199 $133 28.8
46% excess
17 Fanfan Siku 5 399 $267 79.7 mi 38.6 mi 193 $129 79.8
48% excess
18 Joe Hudson 3 347 $232 115.7 mi 51.9 mi 156 $105 115.7
45% excess
19 Jeffrey Coles 5 263 $176 52.6 mi 15.4 mi 77 $52 52.6
29% excess
20 April Nuovo 4 258 $173 64.4 mi 0 mi 0 $0 64.5
0% excess
21 Carlos Puebla 9 248 $166 27.5 mi 10.7 mi 97 $65 27.6
39% excess
22 Bennet O Dartey 1 211 $141 211.1 mi 134.5 mi 135 $90 211
64% excess
23 Marvin Rivas 21 210 $141 10 mi 0 mi 0 $0 10
0% excess
24 Shady Messak 4 199 $133 49.9 mi 31.4 mi 125 $84 49.8
63% excess
25 Davon Cox 5 183 $123 36.6 mi 16.2 mi 81 $54 36.6
44% excess
26 Bruce Ballard 2 161 $108 80.4 mi 48 mi 96 $64 80.5
60% excess
27 Konstantin Barskiy 2 127 $85 63.7 mi 47.4 mi 95 $64 63.5
75% excess
28 Andre Samuda 4 114 $76 28.5 mi 21.9 mi 88 $59 28.5
77% excess
29 Bryan Rodriguez 2 113 $76 56.3 mi 14.5 mi 29 $19 56.5
26% excess
30 Alberto Galan 3 80 $54 26.7 mi 10.8 mi 32 $21 26.7
40% excess