Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
376
Total Travel Cost
$38,753
57,840 miles
Avoidable Cost
$28,311
42,255 excess miles
Optimal Cost
$10,441
If closest tech always used
Avg Excess / WO
112.4 mi
$75.30 per WO
Median Excess
18.9 mi
Outlier Rate (>50mi)
34.6%
130 WOs

Actual Travel Expenses

From 132 WOs with expense data
Total Expenses
$37,480
Labor - Travel
$25,153
Mileage
$0
Lodging
$4,575
Airfare
$1,191
Car Rental
$1,480
Per Diem
$2,275
Meals
$0
Other
$2,807

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 Luis Iser 38 5,080 $3,404 133.7 mi 88.2 mi 3,351 $2,245 133.7
66% excess
4 Fady Khouzam 18 4,969 $3,329 276 mi 225.3 mi 4,055 $2,717 276.1
82% excess
5 Derick Velazquez 34 4,194 $2,810 123.4 mi 66.8 mi 2,271 $1,522 123.4
54% excess
6 Jared Heisler 36 2,443 $1,637 67.9 mi 1.9 mi 67 $45 67.9
3% excess
7 Konstantin Barskiy 4 1,988 $1,332 497 mi 485.9 mi 1,944 $1,302 497
98% excess
8 Fady Messak 5 1,916 $1,284 383.2 mi 339.9 mi 1,699 $1,138 383.2
89% excess
9 Rodney Charles 8 1,371 $919 171.4 mi 60.2 mi 482 $323 171.4
35% excess
10 Jason Yenser 21 1,353 $907 64.5 mi 37.5 mi 787 $527 64.4
58% excess
11 Patricia Gordon 9 1,286 $862 142.8 mi 42.5 mi 383 $257 142.9
30% excess
12 Raymond Ebanks 8 1,111 $744 138.8 mi 84.4 mi 675 $452 138.9
61% excess
13 Rick Charles 20 803 $538 40.2 mi 0.4 mi 8 $5 40.2
1% excess
14 Allan Klus 10 712 $477 71.2 mi 14.6 mi 146 $98 71.2
21% excess
15 Ryan Lewis 2 632 $423 315.9 mi 259.2 mi 518 $347 316
82% excess
16 Jackson Reeves 12 501 $336 41.7 mi 11.3 mi 136 $91 41.8
27% excess
17 Vivian Hyde 15 432 $289 28.8 mi 13.3 mi 199 $133 28.8
46% excess
18 Fanfan Siku 5 399 $267 79.7 mi 38.6 mi 193 $129 79.8
48% excess
19 Joe Hudson 3 347 $232 115.7 mi 51.9 mi 156 $105 115.7
45% excess
20 Jeffrey Coles 5 263 $176 52.6 mi 15.4 mi 77 $52 52.6
29% excess
21 April Nuovo 4 258 $173 64.4 mi 0 mi 0 $0 64.5
0% excess
22 Carlos Puebla 9 248 $166 27.5 mi 10.7 mi 97 $65 27.6
39% excess
23 Bennet O Dartey 1 211 $141 211.1 mi 134.5 mi 135 $90 211
64% excess
24 Marvin Rivas 21 210 $141 10 mi 0 mi 0 $0 10
0% excess
25 Shady Messak 4 199 $133 49.9 mi 31.4 mi 125 $84 49.8
63% excess
26 Davon Cox 5 183 $123 36.6 mi 16.2 mi 81 $54 36.6
44% excess
27 Horace Barnes 3 174 $117 57.9 mi 44.3 mi 133 $89 58
76% excess
28 Bruce Ballard 2 161 $108 80.4 mi 48 mi 96 $64 80.5
60% excess
29 Andre Samuda 4 114 $76 28.5 mi 21.9 mi 88 $59 28.5
77% excess
30 Bryan Rodriguez 2 113 $76 56.3 mi 14.5 mi 29 $19 56.5
26% excess