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 | Natosha Beierschmitt | 30 | 28,862 | $19,338 | 962.1 mi | 925.8 mi | 27,773 | $18,608 | 962.1 |
96% excess
|
| 2 | Eric Mancerella | 98 | 14,656 | $9,820 | 149.5 mi | 56.0 mi | 5,492 | $3,680 | 149.6 |
37% excess
|
| 3 | Paul Mccormish | 170 | 10,314 | $6,910 | 60.7 mi | 4.8 mi | 820 | $549 | 60.7 |
8% excess
|
| 4 | Dustin Antolin | 153 | 9,303 | $6,233 | 60.8 mi | 12.2 mi | 1,869 | $1,252 | 60.8 |
20% excess
|
| 5 | Jordan Moceri | 113 | 8,257 | $5,532 | 73.1 mi | 48.4 mi | 5,470 | $3,665 | 73.1 |
66% excess
|
| 6 | Jim Kingery | 128 | 7,040 | $4,717 | 55.0 mi | 54.4 mi | 6,957 | $4,661 | 55 |
99% excess
|
| 7 | Franco Jackson | 349 | 5,872 | $3,934 | 16.8 mi | 2.6 mi | 916 | $614 | 16.8 |
16% excess
|
| 8 | Brandon Green | 93 | 5,818 | $3,898 | 62.6 mi | 28.1 mi | 2,612 | $1,750 | 62.6 |
45% excess
|
| 9 | Scott R Roberts | 104 | 5,546 | $3,716 | 53.3 mi | 5.2 mi | 544 | $364 | 53.3 |
10% excess
|
| 10 | Fady Messak | 11 | 4,713 | $3,158 | 428.4 mi | 328.2 mi | 3,611 | $2,419 | 428.5 |
77% excess
|
| 11 | Teddie Bracken | 133 | 4,414 | $2,957 | 33.2 mi | 10.7 mi | 1,417 | $949 | 33.2 |
32% excess
|
| 12 | Megan Allen | 4 | 4,229 | $2,833 | 1057.2 mi | 1030.4 mi | 4,122 | $2,762 | 1057.3 |
97% excess
|
| 13 | Jackson Reeves | 26 | 4,047 | $2,711 | 155.6 mi | 112.7 mi | 2,930 | $1,963 | 155.7 |
72% excess
|
| 14 | Luis Iser | 2 | 2,125 | $1,424 | 1062.3 mi | 1005.6 mi | 2,011 | $1,347 | 1062.5 |
95% excess
|
| 15 | Emmanuel Morales | 1 | 2,047 | $1,371 | 2046.8 mi | 2023.1 mi | 2,023 | $1,355 | 2047 |
99% excess
|
| 16 | Omar Serrano | 1 | 1,926 | $1,290 | 1926.3 mi | 1924.4 mi | 1,924 | $1,289 | 1926 |
100% excess
|
| 17 | Mike Huffman | 14 | 1,644 | $1,101 | 117.4 mi | 55.9 mi | 782 | $524 | 117.4 |
48% excess
|
| 18 | Taylor Duda | 3 | 1,387 | $929 | 462.4 mi | 460.5 mi | 1,381 | $925 | 462.3 |
100% excess
|
| 19 | Samuel Biddie | 2 | 1,209 | $810 | 604.6 mi | 552.9 mi | 1,106 | $741 | 604.5 |
91% excess
|
| 20 | Brandon Rodriguez | 1 | 1,126 | $754 | 1125.5 mi | 1123.6 mi | 1,124 | $753 | 1126 |
100% excess
|
| 21 | Israel Martell | 2 | 1,016 | $681 | 508.0 mi | 385.3 mi | 771 | $517 | 508 |
76% excess
|
| 22 | Rodney Charles | 3 | 1,008 | $675 | 336.1 mi | 275.1 mi | 825 | $553 | 336 |
82% excess
|
| 23 | Bennet O Dartey | 3 | 881 | $590 | 293.8 mi | 218.3 mi | 655 | $439 | 293.7 |
74% excess
|
| 24 | Horace Barnes | 1 | 798 | $535 | 798.0 mi | 798.0 mi | 798 | $535 | 798 |
100% excess
|
| 25 | Rick Charles | 2 | 657 | $440 | 328.3 mi | 294.5 mi | 589 | $395 | 328.5 |
90% excess
|
| 26 | Ronnie Salone | 1 | 616 | $413 | 616.1 mi | 614.2 mi | 614 | $411 | 616 |
100% excess
|
| 27 | Christopher Carroll | 1 | 569 | $381 | 569.1 mi | 567.2 mi | 567 | $380 | 569 |
100% excess
|
| 28 | Bruce Ballard | 1 | 558 | $374 | 557.9 mi | 524.0 mi | 524 | $351 | 558 |
94% excess
|
| 29 | Minh Huynh | 1 | 510 | $342 | 509.8 mi | 502.2 mi | 502 | $336 | 510 |
98% excess
|
| 30 | Andre Samuda | 1 | 407 | $273 | 407.0 mi | 326.2 mi | 326 | $218 | 407 |
80% excess
|