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 | 6 | 5,871 | $3,934 | 978.5 mi | 950.2 mi | 5,701 | $3,820 | 978.5 |
97% excess
|
| 2 | Paul Mccormish | 70 | 4,635 | $3,105 | 66.2 mi | 9.3 mi | 651 | $436 | 66.2 |
14% excess
|
| 3 | Jordan Moceri | 69 | 4,328 | $2,900 | 62.7 mi | 39.9 mi | 2,756 | $1,847 | 62.7 |
64% excess
|
| 4 | Brandon Green | 59 | 4,265 | $2,858 | 72.3 mi | 35.4 mi | 2,091 | $1,401 | 72.3 |
49% excess
|
| 5 | Dustin Antolin | 69 | 4,204 | $2,817 | 60.9 mi | 10.1 mi | 696 | $466 | 60.9 |
17% excess
|
| 6 | Scott R Roberts | 74 | 3,815 | $2,556 | 51.6 mi | 6.9 mi | 508 | $340 | 51.6 |
13% excess
|
| 7 | Eric Mancerella | 28 | 3,649 | $2,445 | 130.3 mi | 50.3 mi | 1,409 | $944 | 130.3 |
39% excess
|
| 8 | Franco Jackson | 189 | 3,268 | $2,190 | 17.3 mi | 3.1 mi | 579 | $388 | 17.3 |
18% excess
|
| 9 | Megan Allen | 2 | 2,114 | $1,416 | 1057.2 mi | 1030.4 mi | 2,061 | $1,381 | 1057 |
97% excess
|
| 10 | Teddie Bracken | 64 | 2,082 | $1,395 | 32.5 mi | 9.3 mi | 598 | $401 | 32.5 |
29% excess
|
| 11 | Emmanuel Morales | 1 | 2,047 | $1,371 | 2046.8 mi | 2023 mi | 2,023 | $1,355 | 2047 |
99% excess
|
| 12 | Omar Serrano | 1 | 1,926 | $1,290 | 1926.3 mi | 1924.4 mi | 1,924 | $1,289 | 1926 |
100% excess
|
| 13 | Brandon Rodriguez | 1 | 1,126 | $754 | 1125.5 mi | 1123.6 mi | 1,124 | $753 | 1126 |
100% excess
|
| 14 | Jim Kingery | 20 | 1,100 | $737 | 55 mi | 54.4 mi | 1,087 | $728 | 55 |
99% excess
|
| 15 | Horace Barnes | 1 | 798 | $535 | 798 mi | 798 mi | 798 | $535 | 798 |
100% excess
|
| 16 | Fady Messak | 2 | 665 | $446 | 332.6 mi | 267.1 mi | 534 | $358 | 332.5 |
80% excess
|
| 17 | Jackson Reeves | 5 | 655 | $439 | 131 mi | 53.8 mi | 269 | $180 | 131 |
41% excess
|
| 18 | Ronnie Salone | 1 | 616 | $413 | 616.1 mi | 614.2 mi | 614 | $411 | 616 |
100% excess
|
| 19 | Samuel Biddie | 1 | 587 | $393 | 587.3 mi | 517.8 mi | 518 | $347 | 587 |
88% excess
|
| 20 | Christopher Carroll | 1 | 569 | $381 | 569.1 mi | 567.2 mi | 567 | $380 | 569 |
100% excess
|
| 21 | Minh Huynh | 1 | 510 | $342 | 509.8 mi | 502.2 mi | 502 | $336 | 510 |
98% excess
|
| 22 | Rick Charles | 1 | 328 | $220 | 328.3 mi | 294.5 mi | 294 | $197 | 328 |
90% excess
|
| 23 | Rodney Charles | 1 | 319 | $214 | 319.2 mi | 311.4 mi | 311 | $208 | 319 |
97% excess
|
| 24 | Ben McClerklin | 1 | 264 | $177 | 264.2 mi | 262.3 mi | 262 | $176 | 264 |
99% excess
|
| 25 | Brendan Chaney | 9 | 131 | $88 | 14.6 mi | -131.8 mi | 73 | $49 | 14.6 |
56% excess
|
| 26 | Jon Kuehl | 1 | 129 | $86 | 128.7 mi | 106.3 mi | 106 | $71 | 129 |
82% excess
|
| 27 | Vincent Nyathi | 1 | 100 | $67 | 99.5 mi | 94 mi | 94 | $63 | 100 |
94% excess
|
| 28 | Bob Cox | 3 | 5 | $3 | 1.8 mi | 0 mi | 0 | $0 | 1.7 |
0% excess
|