Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,958
Total Travel Cost
$231,890
346,104 miles
Avoidable Cost
$186,298
278,057 excess miles
Optimal Cost
$45,606
If closest tech always used
Avg Excess / WO
142.0 mi
$95.14 per WO
Median Excess
6.8 mi
Outlier Rate (>50mi)
30.4%
595 WOs

Actual Travel Expenses

From 68 WOs with expense data
Total Expenses
$39,075
Labor - Travel
$24,597
Mileage
$0
Lodging
$5,659
Airfare
$2,578
Car Rental
$1,288
Per Diem
$2,175
Meals
$458
Other
$2,319

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 Konstantin Barskiy 39 36,953 $24,759 947.5 mi 929.7 mi 36,259 $24,294 947.5
98% excess
2 Philmon Mehari 23 32,986 $22,101 1434.2 mi 1303.5 mi 29,981 $20,087 1434.2
91% excess
3 Fernando Lemos 20 31,385 $21,028 1569.2 mi 1561.2 mi 31,224 $20,920 1569.3
99% excess
4 Eric Mancerella 32 27,396 $18,355 856.1 mi 698.2 mi 22,344 $14,970 856.1
82% excess
5 Ben Heinz 72 25,728 $17,238 357.3 mi 351.9 mi 25,334 $16,974 357.3
98% excess
6 Davon Cox 20 22,308 $14,946 1115.4 mi 1078.1 mi 21,562 $14,447 1115.4
97% excess
7 Fady Messak 37 14,016 $9,391 378.8 mi 295.8 mi 10,944 $7,332 378.8
78% excess
8 Christopher Carroll 23 11,844 $7,935 515 mi 463.6 mi 10,663 $7,144 515
90% excess
9 Side Kick Technician 27 10,652 $7,137 394.5 mi 387.1 mi 10,452 $7,003 394.5
98% excess
10 Raymond Ebanks 39 6,272 $4,202 160.8 mi 150 mi 5,848 $3,918 160.8
93% excess
11 Ryan Lewis 27 5,573 $3,734 206.4 mi 69.3 mi 1,871 $1,254 206.4
34% excess
12 Bennet O Dartey 12 5,271 $3,532 439.3 mi 268.3 mi 3,220 $2,157 439.3
61% excess
13 Rozier Cole 16 4,528 $3,034 283 mi 229.7 mi 3,675 $2,462 283
81% excess
14 Jared Heisler 11 4,464 $2,991 405.8 mi 339.2 mi 3,731 $2,500 405.8
84% excess
15 Kevin Cogdill 19 4,406 $2,952 231.9 mi 217.5 mi 4,132 $2,768 231.9
94% excess
16 Shawn Kelley 2 4,300 $2,881 2149.9 mi 2138.4 mi 4,277 $2,866 2150
99% excess
17 Joseph Nuovo 26 4,288 $2,873 164.9 mi 45.1 mi 1,173 $786 164.9
27% excess
18 Andrew Przybyla 6 3,697 $2,477 616.2 mi 577.3 mi 3,464 $2,321 616.2
94% excess
19 Phillip Castillo 2 3,438 $2,303 1718.8 mi 1694.9 mi 3,390 $2,271 1719
99% excess
20 Fady Khouzam 9 3,389 $2,271 376.6 mi 327.6 mi 2,948 $1,975 376.6
87% excess
21 Jennifer Johnson 3 3,281 $2,198 1093.8 mi 1077.3 mi 3,232 $2,165 1093.7
99% excess
22 Kenneth Lancara 33 3,274 $2,194 99.2 mi 66 mi 2,179 $1,460 99.2
67% excess
23 Marvin Rivas 26 2,803 $1,878 107.8 mi 1.5 mi 38 $25 107.8
1% excess
24 Yves Dessin 8 2,544 $1,704 318 mi 298.1 mi 2,385 $1,598 318
94% excess
25 Praelow Cameron 28 2,313 $1,550 82.6 mi 26.5 mi 741 $496 82.6
32% excess
26 Scott A Berry 5 2,229 $1,493 445.8 mi 428.2 mi 2,141 $1,434 445.8
96% excess
27 Jackson Reeves 15 2,172 $1,455 144.8 mi 35.2 mi 528 $354 144.8
24% excess
28 Todd Fogiel 11 2,067 $1,385 187.9 mi 71.7 mi 788 $528 187.9
38% excess
29 Horace Barnes 28 2,046 $1,371 73.1 mi 67.3 mi 1,886 $1,264 73.1
92% excess
30 Scott R Roberts 20 2,043 $1,369 102.1 mi 8.5 mi 169 $113 102.2
8% excess