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 | Nkosi Wilson | 50 | 34,851 | $23,350 | 697.0 mi | 678.0 mi | 33,901 | $22,714 | 697 |
97% excess
|
| 2 | Natosha Beierschmitt | 14 | 18,852 | $12,631 | 1346.5 mi | 1333.3 mi | 18,667 | $12,507 | 1346.6 |
99% excess
|
| 3 | Jason Yenser | 127 | 8,968 | $6,009 | 70.6 mi | 42.3 mi | 5,376 | $3,602 | 70.6 |
60% excess
|
| 4 | Shady Messak | 96 | 3,713 | $2,488 | 38.7 mi | 20.7 mi | 1,989 | $1,333 | 38.7 |
54% excess
|
| 5 | Curtis Allen | 154 | 3,418 | $2,290 | 22.2 mi | 6.3 mi | 967 | $648 | 22.2 |
28% excess
|
| 6 | Alberto Galan | 91 | 3,062 | $2,052 | 33.6 mi | 12.0 mi | 1,088 | $729 | 33.6 |
36% excess
|
| 7 | David Trost | 82 | 2,462 | $1,650 | 30.0 mi | 13.4 mi | 1,098 | $736 | 30 |
45% excess
|
| 8 | Philmon Mehari | 70 | 2,040 | $1,367 | 29.1 mi | 11.5 mi | 805 | $539 | 29.1 |
39% excess
|
| 9 | Fady Khouzam | 34 | 1,991 | $1,334 | 58.5 mi | 44.2 mi | 1,502 | $1,006 | 58.6 |
75% excess
|
| 10 | Bryan Rodriguez | 81 | 1,980 | $1,327 | 24.4 mi | 8.0 mi | 646 | $433 | 24.4 |
33% excess
|
| 11 | Pete Ramos | 91 | 1,966 | $1,317 | 21.6 mi | 4.2 mi | 385 | $258 | 21.6 |
20% excess
|
| 12 | Douglas Pearce | 1 | 1,592 | $1,067 | 1591.5 mi | 1561.3 mi | 1,561 | $1,046 | 1592 |
98% excess
|
| 13 | Sean Currie | 1 | 1,584 | $1,061 | 1583.5 mi | 1553.3 mi | 1,553 | $1,041 | 1584 |
98% excess
|
| 14 | Davon Cox | 45 | 1,567 | $1,050 | 34.8 mi | 16.6 mi | 746 | $500 | 34.8 |
48% excess
|
| 15 | Darrell Hope | 46 | 1,477 | $990 | 32.1 mi | 18.3 mi | 841 | $563 | 32.1 |
57% excess
|
| 16 | Carlos Puebla | 50 | 1,065 | $714 | 21.3 mi | 5.3 mi | 266 | $178 | 21.3 |
25% excess
|
| 17 | Konstantin Barskiy | 34 | 1,052 | $705 | 31.0 mi | 13.4 mi | 455 | $305 | 30.9 |
43% excess
|
| 18 | Luis Iser | 1 | 1,050 | $704 | 1050.4 mi | 1020.2 mi | 1,020 | $683 | 1050 |
97% excess
|
| 19 | Chris Galasso | 66 | 1,037 | $695 | 15.7 mi | 0.1 mi | 8 | $5 | 15.7 |
1% excess
|
| 20 | Israel Martell | 32 | 1,033 | $692 | 32.3 mi | 19.5 mi | 623 | $417 | 32.3 |
60% excess
|
| 21 | Vivian Hyde | 41 | 990 | $663 | 24.1 mi | 9.8 mi | 403 | $270 | 24.1 |
41% excess
|
| 22 | Derick Velazquez | 1 | 949 | $636 | 949.0 mi | 930.5 mi | 931 | $624 | 949 |
98% excess
|
| 23 | Michael Steencken | 10 | 834 | $559 | 83.4 mi | 53.3 mi | 533 | $357 | 83.4 |
64% excess
|
| 24 | Rodney Charles | 8 | 697 | $467 | 87.1 mi | 69.3 mi | 555 | $372 | 87.1 |
80% excess
|
| 25 | Edward Arias | 24 | 638 | $427 | 26.6 mi | 21.1 mi | 506 | $339 | 26.6 |
79% excess
|
| 26 | Rick Charles | 14 | 635 | $425 | 45.4 mi | 16.9 mi | 236 | $158 | 45.4 |
37% excess
|
| 27 | Fady Messak | 14 | 528 | $354 | 37.7 mi | 12.5 mi | 175 | $117 | 37.7 |
33% excess
|
| 28 | Andre Samuda | 18 | 525 | $352 | 29.2 mi | 21.9 mi | 395 | $265 | 29.2 |
75% excess
|
| 29 | Charles Sellon | 1 | 269 | $180 | 268.7 mi | 258.7 mi | 259 | $174 | 269 |
96% excess
|
| 30 | Mohamed Shareed | 9 | 267 | $179 | 29.6 mi | 22.9 mi | 206 | $138 | 29.7 |
77% excess
|