Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
4,054
Total Travel Cost
$470,271
701,897 miles
Avoidable Cost
$403,781
602,659 excess miles
Optimal Cost
$66,490
If closest tech always used
Avg Excess / WO
148.7 mi
$99.60 per WO
Median Excess
10.0 mi
Outlier Rate (>50mi)
41.7%
1,692 WOs

Actual Travel Expenses

From 1,179 WOs with expense data
Total Expenses
$330,512
Labor - Travel
$229,514
Mileage
$4,713
Lodging
$38,733
Airfare
$9,314
Car Rental
$6,109
Per Diem
$14,800
Meals
$132
Other
$27,197

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 351 331,300 $221,971 943.9 mi 929.5 mi 326,268 $218,600 943.9
98% excess
2 Luis Iser 460 85,717 $57,430 186.3 mi 164.2 mi 75,553 $50,621 186.3
88% excess
3 Raymond Ebanks 398 59,680 $39,986 149.9 mi 131.7 mi 52,411 $35,115 149.9
88% excess
4 Fady Messak 25 22,713 $15,218 908.5 mi 864.7 mi 21,618 $14,484 908.5
95% excess
5 Robert Lewis 539 18,260 $12,234 33.9 mi 7.9 mi 4,255 $2,851 33.9
23% excess
6 Derick Velazquez 602 15,031 $10,071 25.0 mi 9.9 mi 5,953 $3,989 25
40% excess
7 Robert Rivera 299 14,833 $9,938 49.6 mi 17.8 mi 5,315 $3,561 49.6
36% excess
8 Philmon Mehari 15 14,671 $9,830 978.1 mi 938.0 mi 14,070 $9,427 978.1
96% excess
9 Kevin Cogdill 47 13,913 $9,322 296.0 mi 272.2 mi 12,793 $8,571 296
92% excess
10 Anthony Wright 164 13,389 $8,971 81.6 mi 51.1 mi 8,380 $5,615 81.6
63% excess
11 Horace Barnes 197 12,589 $8,435 63.9 mi 53.4 mi 10,526 $7,052 63.9
84% excess
12 Ryan Lewis 27 11,864 $7,949 439.4 mi 433.2 mi 11,696 $7,836 439.4
99% excess
13 Jared Heisler 135 8,541 $5,722 63.3 mi 13.8 mi 1,864 $1,249 63.3
22% excess
14 Joseph Anderson 168 8,404 $5,631 50.0 mi 16.6 mi 2,782 $1,864 50
33% excess
15 Yves Dessin 66 7,895 $5,290 119.6 mi 89.0 mi 5,876 $3,937 119.6
74% excess
16 Craig Walker 217 5,865 $3,930 27.0 mi 2.8 mi 611 $409 27
10% excess
17 Kenneth Lancara 46 5,495 $3,682 119.5 mi 13.6 mi 628 $421 119.5
11% excess
18 Marvin Rivas 8 5,269 $3,530 658.6 mi 645.9 mi 5,168 $3,463 658.6
98% excess
19 Rozier Cole 13 4,522 $3,030 347.8 mi 121.6 mi 1,580 $1,059 347.8
35% excess
20 Fady Khouzam 4 3,668 $2,458 917.1 mi 878.3 mi 3,513 $2,354 917
96% excess
21 Elkin Barahona 123 3,513 $2,354 28.6 mi 14.0 mi 1,727 $1,157 28.6
49% excess
22 Philip Krogstad 3 3,125 $2,094 1041.8 mi 1037.2 mi 3,112 $2,085 1041.7
100% excess
23 Douglas Pearce 2 3,093 $2,072 1546.4 mi 1532.2 mi 3,064 $2,053 1546.5
99% excess
24 Ray Andreu 111 3,088 $2,069 27.8 mi 0.3 mi 35 $23 27.8
1% excess
25 Shady Messak 3 2,748 $1,841 916.1 mi 910.0 mi 2,730 $1,829 916
99% excess
26 Minh Huynh 2 2,283 $1,530 1141.3 mi 1137.8 mi 2,276 $1,525 1141.5
100% excess
27 Emmanuel Morales 1 2,163 $1,449 2162.7 mi 2088.5 mi 2,088 $1,399 2163
97% excess
28 Megan Allen 2 2,152 $1,442 1076.1 mi 1036.5 mi 2,073 $1,389 1076
96% excess
29 Dylan Ingraham 9 2,067 $1,385 229.7 mi 129.2 mi 1,163 $779 229.7
56% excess
30 Andre Samuda 2 2,036 $1,364 1018.0 mi 943.6 mi 1,887 $1,264 1018
93% excess