Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
794
Total Travel Cost
$115,513
172,408 miles
Avoidable Cost
$90,324
134,812 excess miles
Optimal Cost
$25,217
If closest tech always used
Avg Excess / WO
169.7 mi
$113.72 per WO
Median Excess
16.4 mi
Outlier Rate (>50mi)
33%
262 WOs

Actual Travel Expenses

From 318 WOs with expense data
Total Expenses
$88,795
Labor - Travel
$63,472
Mileage
$1,735
Lodging
$9,586
Airfare
$1,880
Car Rental
$1,091
Per Diem
$4,825
Meals
$0
Other
$6,205

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 Philmon Mehari 22 32,890 $22,036 1495 mi 1358.6 mi 29,890 $20,026 1495
91% excess
2 Eric Mancerella 22 27,169 $18,203 1235 mi 1007 mi 22,153 $14,843 1235
82% excess
3 Davon Cox 16 21,912 $14,681 1369.5 mi 1336.2 mi 21,379 $14,324 1369.5
98% excess
4 Derick Velazquez 13 11,103 $7,439 854.1 mi 839.3 mi 10,911 $7,310 854.1
98% excess
5 Chris Bakkemo 12 10,399 $6,967 866.6 mi 859.5 mi 10,314 $6,910 866.6
99% excess
6 Chane Lacy 118 10,114 $6,776 85.7 mi 46.5 mi 5,485 $3,675 85.7
54% excess
7 Marvin Rivas 107 9,468 $6,344 88.5 mi 19.9 mi 2,125 $1,424 88.5
22% excess
8 Fady Khouzam 5 6,885 $4,613 1376.9 mi 1326.1 mi 6,630 $4,442 1377
96% excess
9 Arturo Diaz 58 6,712 $4,497 115.7 mi 77.6 mi 4,499 $3,014 115.7
67% excess
10 Maria Davis 46 5,699 $3,818 123.9 mi 109.7 mi 5,044 $3,379 123.9
89% excess
11 Curtis Sprague 36 4,538 $3,040 126.1 mi 51.4 mi 1,849 $1,239 126.1
41% excess
12 Christopher Womack 104 4,442 $2,976 42.7 mi 10.6 mi 1,104 $740 42.7
25% excess
13 Anthony Wirth 68 4,401 $2,949 64.7 mi 35.5 mi 2,415 $1,618 64.7
55% excess
14 Zachary Stieben 94 4,007 $2,685 42.6 mi 10.6 mi 993 $665 42.6
25% excess
15 Minh Huynh 2 3,274 $2,194 1637.1 mi 1607.2 mi 3,214 $2,153 1637
98% excess
16 Darrell Hendrix 13 2,480 $1,662 190.8 mi 62.6 mi 814 $545 190.8
33% excess
17 Jose Gutierrez 42 2,296 $1,538 54.7 mi 47.1 mi 1,978 $1,325 54.7
86% excess
18 Emmanuel Morales 1 1,227 $822 1227.3 mi 1200.3 mi 1,200 $804 1227
98% excess
19 Christopher Carroll 4 1,074 $720 268.5 mi 268.5 mi 1,074 $720 268.5
100% excess
20 Brendan Chaney 1 841 $563 840.8 mi 805.7 mi 806 $540 841
96% excess
21 Scott E Yelverton 4 735 $492 183.7 mi 154.9 mi 620 $415 183.8
84% excess
22 Andrew Przybyla 1 314 $210 314.1 mi 0 mi 0 $0 314
0% excess
23 Natosha Beierschmitt 4 281 $188 70.3 mi 40.2 mi 202 $135 70.3
72% excess
24 Christopher Ables 1 147 $98 147.4 mi 115.3 mi 115 $77 147
78% excess