Quantify excess travel cost and identify optimization opportunities across your field service operation
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.
| # | Technician | WOs | Total Miles | Total Travel Cost | Avg Actual Dist | Avg Excess | Total Excess Miles | Avoidable Cost | Miles/WO Ratio | Travel Load |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Konstantin Barskiy | 200 | 189,377 | $126,883 | 946.9 mi | 931.7 mi | 186,342 | $124,849 | 946.9 |
98% excess
|
| 2 | Luis Iser | 297 | 47,173 | $31,606 | 158.8 mi | 136.5 mi | 40,536 | $27,159 | 158.8 |
86% excess
|
| 3 | Raymond Ebanks | 249 | 35,925 | $24,070 | 144.3 mi | 127 mi | 31,625 | $21,189 | 144.3 |
88% excess
|
| 4 | Fady Messak | 17 | 15,565 | $10,429 | 915.6 mi | 872.5 mi | 14,833 | $9,938 | 915.6 |
95% excess
|
| 5 | Philmon Mehari | 15 | 14,671 | $9,830 | 978.1 mi | 938 mi | 14,070 | $9,427 | 978.1 |
96% excess
|
| 6 | Derick Velazquez | 467 | 13,674 | $9,162 | 29.3 mi | 12.3 mi | 5,734 | $3,842 | 29.3 |
42% excess
|
| 7 | Horace Barnes | 177 | 11,498 | $7,704 | 65 mi | 54.1 mi | 9,570 | $6,412 | 65 |
83% excess
|
| 8 | Kevin Cogdill | 26 | 7,629 | $5,111 | 293.4 mi | 258.7 mi | 6,727 | $4,507 | 293.4 |
88% excess
|
| 9 | Anthony Wright | 89 | 7,540 | $5,052 | 84.7 mi | 55.1 mi | 4,907 | $3,288 | 84.7 |
65% excess
|
| 10 | Robert Lewis | 347 | 6,761 | $4,530 | 19.5 mi | 3.1 mi | 1,088 | $729 | 19.5 |
16% excess
|
| 11 | Jared Heisler | 96 | 5,991 | $4,014 | 62.4 mi | 12.9 mi | 1,237 | $829 | 62.4 |
21% excess
|
| 12 | Robert Rivera | 163 | 5,393 | $3,613 | 33.1 mi | 6.9 mi | 1,117 | $748 | 33.1 |
21% excess
|
| 13 | Rozier Cole | 13 | 4,522 | $3,030 | 347.8 mi | 121.6 mi | 1,580 | $1,059 | 347.8 |
35% excess
|
| 14 | Joseph Anderson | 69 | 4,334 | $2,904 | 62.8 mi | 31.3 mi | 2,159 | $1,447 | 62.8 |
50% excess
|
| 15 | Craig Walker | 139 | 4,243 | $2,843 | 30.5 mi | 4.4 mi | 611 | $409 | 30.5 |
14% excess
|
| 16 | Kenneth Lancara | 32 | 3,775 | $2,529 | 118 mi | 10.1 mi | 324 | $217 | 118 |
9% excess
|
| 17 | Fady Khouzam | 4 | 3,668 | $2,458 | 917.1 mi | 878.3 mi | 3,513 | $2,354 | 917 |
96% excess
|
| 18 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 19 | Yves Dessin | 25 | 2,682 | $1,797 | 107.3 mi | 82.1 mi | 2,052 | $1,375 | 107.3 |
77% excess
|
| 20 | Emmanuel Morales | 1 | 2,163 | $1,449 | 2162.7 mi | 2088.5 mi | 2,088 | $1,399 | 2163 |
97% excess
|
| 21 | Marvin Rivas | 2 | 1,930 | $1,293 | 965.2 mi | 953.9 mi | 1,908 | $1,278 | 965 |
99% excess
|
| 22 | Elkin Barahona | 61 | 1,889 | $1,266 | 31 mi | 17 mi | 1,038 | $695 | 31 |
55% excess
|
| 23 | Dylan Ingraham | 8 | 1,726 | $1,156 | 215.8 mi | 133.6 mi | 1,069 | $716 | 215.8 |
62% excess
|
| 24 | Ray Andreu | 60 | 1,393 | $933 | 23.2 mi | 0.6 mi | 35 | $23 | 23.2 |
3% excess
|
| 25 | David Hernandez | 2 | 1,345 | $901 | 672.7 mi | 672.7 mi | 1,345 | $901 | 672.5 |
100% excess
|
| 26 | Minh Huynh | 1 | 1,140 | $764 | 1139.8 mi | 1137.7 mi | 1,138 | $762 | 1140 |
100% excess
|
| 27 | Joseph Nuovo | 1 | 1,122 | $752 | 1121.5 mi | 1108.6 mi | 1,109 | $743 | 1122 |
99% excess
|
| 28 | Natosha Beierschmitt | 1 | 1,108 | $742 | 1108 mi | 1089.9 mi | 1,090 | $730 | 1108 |
98% excess
|
| 29 | Bryan Rodriguez | 1 | 1,062 | $712 | 1062.3 mi | 962.5 mi | 963 | $645 | 1062 |
91% excess
|
| 30 | Megan Allen | 1 | 1,030 | $690 | 1029.7 mi | 991.3 mi | 991 | $664 | 1030 |
96% excess
|