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 | 105 | 105,497 | $70,683 | 1004.7 mi | 949.8 mi | 99,819 | $66,879 | 1004.7 |
95% excess
|
| 2 | Todd Fogiel | 104 | 14,384 | $9,637 | 138.3 mi | 45.2 mi | 4,697 | $3,147 | 138.3 |
33% excess
|
| 3 | Scott R Roberts | 188 | 14,028 | $9,399 | 74.6 mi | 6.0 mi | 1,131 | $758 | 74.6 |
8% excess
|
| 4 | Rozier Cole | 65 | 12,581 | $8,429 | 193.6 mi | 68.2 mi | 4,435 | $2,971 | 193.6 |
35% excess
|
| 5 | Chris Galasso | 120 | 12,523 | $8,390 | 104.4 mi | 46.4 mi | 5,573 | $3,734 | 104.4 |
45% excess
|
| 6 | Michah Brackett | 20 | 12,052 | $8,075 | 602.6 mi | 240.3 mi | 4,806 | $3,220 | 602.6 |
40% excess
|
| 7 | Megan Allen | 9 | 11,561 | $7,746 | 1284.5 mi | 1255.9 mi | 11,303 | $7,573 | 1284.6 |
98% excess
|
| 8 | Christopher Womack | 61 | 8,397 | $5,626 | 137.7 mi | 50.8 mi | 3,097 | $2,075 | 137.7 |
37% excess
|
| 9 | Dustin Antolin | 86 | 8,309 | $5,567 | 96.6 mi | 24.2 mi | 2,078 | $1,392 | 96.6 |
25% excess
|
| 10 | Paul Bonang Jr | 118 | 7,098 | $4,756 | 60.1 mi | 0.2 mi | 19 | $13 | 60.2 |
0% excess
|
| 11 | Brandon Green | 83 | 7,037 | $4,715 | 84.8 mi | 23.7 mi | 1,965 | $1,317 | 84.8 |
28% excess
|
| 12 | Chane Lacy | 55 | 6,889 | $4,616 | 125.2 mi | 64.6 mi | 3,552 | $2,380 | 125.3 |
52% excess
|
| 13 | Andrew Przybyla | 6 | 5,791 | $3,880 | 965.1 mi | 783.6 mi | 4,701 | $3,150 | 965.2 |
81% excess
|
| 14 | Luis Torres | 54 | 4,419 | $2,961 | 81.8 mi | 13.4 mi | 723 | $484 | 81.8 |
16% excess
|
| 15 | Teddie Bracken | 132 | 4,414 | $2,957 | 33.4 mi | 10.7 mi | 1,417 | $949 | 33.4 |
32% excess
|
| 16 | Craig Walker | 43 | 4,034 | $2,703 | 93.8 mi | 9.0 mi | 387 | $259 | 93.8 |
10% excess
|
| 17 | Darrell Hope | 109 | 3,402 | $2,279 | 31.2 mi | 9.9 mi | 1,081 | $724 | 31.2 |
32% excess
|
| 18 | Kevin Cox | 34 | 3,170 | $2,124 | 93.2 mi | 23.8 mi | 810 | $543 | 93.2 |
26% excess
|
| 19 | Ray Andreu | 106 | 3,021 | $2,024 | 28.5 mi | 0.0 mi | 0 | $0 | 28.5 |
0% excess
|
| 20 | David Trost | 76 | 2,742 | $1,837 | 36.1 mi | 13.9 mi | 1,058 | $709 | 36.1 |
39% excess
|
| 21 | Erwin Forster | 39 | 2,545 | $1,705 | 65.2 mi | 4.6 mi | 181 | $121 | 65.3 |
7% excess
|
| 22 | Curtis Allen | 114 | 2,437 | $1,633 | 21.4 mi | 2.2 mi | 246 | $165 | 21.4 |
10% excess
|
| 23 | Darrell Hendrix | 21 | 2,350 | $1,575 | 111.9 mi | 15.3 mi | 321 | $215 | 111.9 |
14% excess
|
| 24 | Rene Yescas | 76 | 2,287 | $1,532 | 30.1 mi | 0.0 mi | 0 | $0 | 30.1 |
0% excess
|
| 25 | Thomas J Langenberg Jr | 15 | 1,568 | $1,051 | 104.5 mi | 58.7 mi | 881 | $590 | 104.5 |
56% excess
|
| 26 | Jason Cunningham | 17 | 1,471 | $986 | 86.5 mi | 17.9 mi | 304 | $204 | 86.5 |
21% excess
|
| 27 | Anthony Wirth | 21 | 1,431 | $959 | 68.2 mi | 0.0 mi | 0 | $0 | 68.1 |
0% excess
|
| 28 | Taylor Duda | 5 | 1,426 | $955 | 285.3 mi | 281.6 mi | 1,408 | $943 | 285.2 |
99% excess
|
| 29 | Joseph Anderson | 1 | 1,247 | $835 | 1246.8 mi | 1194.3 mi | 1,194 | $800 | 1247 |
96% excess
|
| 30 | Brandon Rodriguez | 2 | 1,185 | $794 | 592.4 mi | 592.4 mi | 1,185 | $794 | 592.5 |
100% excess
|