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 | 19 | 13,678 | $9,164 | 719.9 mi | 703.5 mi | 13,367 | $8,956 | 719.9 |
98% excess
|
| 2 | Natosha Beierschmitt | 7 | 9,469 | $6,344 | 1352.8 mi | 1339.2 mi | 9,375 | $6,281 | 1352.7 |
99% excess
|
| 3 | Jason Yenser | 61 | 4,136 | $2,771 | 67.8 mi | 42 mi | 2,563 | $1,717 | 67.8 |
62% excess
|
| 4 | Shady Messak | 63 | 2,469 | $1,654 | 39.2 mi | 21.5 mi | 1,357 | $909 | 39.2 |
55% excess
|
| 5 | Philmon Mehari | 57 | 1,856 | $1,244 | 32.6 mi | 13.4 mi | 762 | $511 | 32.6 |
41% excess
|
| 6 | Alberto Galan | 60 | 1,853 | $1,242 | 30.9 mi | 10 mi | 598 | $401 | 30.9 |
32% excess
|
| 7 | Curtis Allen | 93 | 1,812 | $1,214 | 19.5 mi | 3.1 mi | 286 | $192 | 19.5 |
16% excess
|
| 8 | Bryan Rodriguez | 48 | 1,779 | $1,192 | 37.1 mi | 13.4 mi | 645 | $432 | 37.1 |
36% excess
|
| 9 | Fady Khouzam | 29 | 1,634 | $1,095 | 56.3 mi | 42 mi | 1,217 | $815 | 56.3 |
74% excess
|
| 10 | Davon Cox | 44 | 1,480 | $992 | 33.6 mi | 16.5 mi | 726 | $486 | 33.6 |
49% excess
|
| 11 | David Trost | 35 | 1,165 | $781 | 33.3 mi | 14.8 mi | 518 | $347 | 33.3 |
44% excess
|
| 12 | Israel Martell | 26 | 855 | $573 | 32.9 mi | 21.1 mi | 548 | $367 | 32.9 |
64% excess
|
| 13 | Pete Ramos | 42 | 844 | $565 | 20.1 mi | 2.4 mi | 102 | $68 | 20.1 |
12% excess
|
| 14 | Darrell Hope | 26 | 824 | $552 | 31.7 mi | 18.5 mi | 480 | $322 | 31.7 |
58% excess
|
| 15 | Rodney Charles | 9 | 788 | $528 | 87.6 mi | 71.1 mi | 640 | $429 | 87.6 |
81% excess
|
| 16 | Carlos Puebla | 35 | 787 | $527 | 22.5 mi | 7.1 mi | 250 | $168 | 22.5 |
32% excess
|
| 17 | Konstantin Barskiy | 22 | 681 | $456 | 31 mi | 13.2 mi | 290 | $194 | 31 |
43% excess
|
| 18 | Rick Charles | 8 | 424 | $284 | 53 mi | 20.7 mi | 166 | $111 | 53 |
39% excess
|
| 19 | Chris Galasso | 29 | 423 | $283 | 14.6 mi | 0 mi | 0 | $0 | 14.6 |
0% excess
|
| 20 | Vivian Hyde | 17 | 390 | $261 | 23 mi | 12.1 mi | 206 | $138 | 22.9 |
53% excess
|
| 21 | Fady Messak | 10 | 352 | $236 | 35.2 mi | 14.8 mi | 148 | $99 | 35.2 |
42% excess
|
| 22 | Michael Steencken | 4 | 335 | $224 | 83.7 mi | 57.6 mi | 231 | $155 | 83.8 |
69% excess
|
| 23 | Edward Arias | 14 | 313 | $210 | 22.4 mi | 15.3 mi | 214 | $143 | 22.4 |
68% excess
|
| 24 | Andre Samuda | 9 | 245 | $164 | 27.2 mi | 19.8 mi | 178 | $119 | 27.2 |
73% excess
|
| 25 | Mohamed Shareed | 6 | 206 | $138 | 34.3 mi | 29 mi | 174 | $117 | 34.3 |
84% excess
|
| 26 | Philip Krogstad | 3 | 190 | $127 | 63.5 mi | 56.2 mi | 168 | $113 | 63.3 |
88% excess
|
| 27 | Maximilian Tucker | 3 | 72 | $48 | 23.9 mi | 6.1 mi | 18 | $12 | 24 |
25% excess
|