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 | Mike Huffman | 41 | 12,515 | $8,385 | 305.2 mi | 243.1 mi | 9,967 | $6,678 | 305.2 |
80% excess
|
| 2 | Side Kick Technician | 18 | 6,974 | $4,673 | 387.4 mi | 377.8 mi | 6,801 | $4,557 | 387.4 |
98% excess
|
| 3 | Chris Galasso | 16 | 5,108 | $3,422 | 319.2 mi | 197.7 mi | 3,164 | $2,120 | 319.3 |
62% excess
|
| 4 | Kevin Cogdill | 15 | 4,586 | $3,073 | 305.8 mi | 295.1 mi | 4,426 | $2,965 | 305.7 |
97% excess
|
| 5 | Yves Dessin | 7 | 4,371 | $2,929 | 624.4 mi | 615.2 mi | 4,306 | $2,885 | 624.4 |
99% excess
|
| 6 | Robert Rivera | 48 | 4,146 | $2,778 | 86.4 mi | 49.2 mi | 2,364 | $1,584 | 86.4 |
57% excess
|
| 7 | Ronnie Salone | 47 | 3,234 | $2,167 | 68.8 mi | 8.2 mi | 384 | $257 | 68.8 |
12% excess
|
| 8 | Joe Evans | 20 | 2,763 | $1,851 | 138.1 mi | 127.3 mi | 2,546 | $1,706 | 138.2 |
92% excess
|
| 9 | Jason Cunningham | 28 | 2,746 | $1,840 | 98.1 mi | 41.9 mi | 1,173 | $786 | 98.1 |
43% excess
|
| 10 | Mark Stelter | 4 | 2,430 | $1,628 | 607.5 mi | 559.3 mi | 2,237 | $1,499 | 607.5 |
92% excess
|
| 11 | Christopher Womack | 11 | 1,636 | $1,096 | 148.8 mi | 63.6 mi | 700 | $469 | 148.7 |
43% excess
|
| 12 | Tyler Bollman | 2 | 1,487 | $996 | 743.7 mi | 677.3 mi | 1,355 | $908 | 743.5 |
91% excess
|
| 13 | Andrew Przybyla | 1 | 1,408 | $943 | 1407.5 mi | 1170.3 mi | 1,170 | $784 | 1408 |
83% excess
|
| 14 | Rozier Cole | 10 | 1,348 | $903 | 134.8 mi | 25.1 mi | 251 | $168 | 134.8 |
19% excess
|
| 15 | Michael Swingle | 7 | 1,190 | $797 | 170.0 mi | 98.4 mi | 689 | $462 | 170 |
58% excess
|
| 16 | Curtis Sprague | 2 | 1,120 | $750 | 560.1 mi | 478.1 mi | 956 | $641 | 560 |
85% excess
|
| 17 | Praelow Cameron | 7 | 1,092 | $732 | 156.0 mi | 59.7 mi | 418 | $280 | 156 |
38% excess
|
| 18 | Blake Ward | 5 | 1,073 | $719 | 214.5 mi | 171.6 mi | 858 | $575 | 214.6 |
80% excess
|
| 19 | Vincent Nyathi | 14 | 874 | $586 | 62.4 mi | 19.0 mi | 266 | $178 | 62.4 |
30% excess
|
| 20 | Christopher Carroll | 3 | 814 | $545 | 271.4 mi | 228.4 mi | 685 | $459 | 271.3 |
84% excess
|
| 21 | Scott R Roberts | 11 | 774 | $519 | 70.4 mi | 13.3 mi | 147 | $98 | 70.4 |
19% excess
|
| 22 | Joseph Anderson | 16 | 762 | $511 | 47.6 mi | 12.4 mi | 199 | $133 | 47.6 |
26% excess
|
| 23 | Jordan Moceri | 8 | 727 | $487 | 90.9 mi | 57.4 mi | 459 | $308 | 90.9 |
63% excess
|
| 24 | Brandon Green | 8 | 656 | $440 | 82.0 mi | 34.5 mi | 276 | $185 | 82 |
42% excess
|
| 25 | Cynthia G Deville | 29 | 632 | $423 | 21.8 mi | 2.5 mi | 72 | $48 | 21.8 |
11% excess
|
| 26 | Craig Walker | 16 | 620 | $415 | 38.8 mi | 0.0 mi | 0 | $0 | 38.8 |
0% excess
|
| 27 | Jon Sanchez | 18 | 601 | $403 | 33.4 mi | 0.2 mi | 4 | $3 | 33.4 |
1% excess
|
| 28 | Ray-Anthony Alston | 36 | 548 | $367 | 15.2 mi | 0.0 mi | 0 | $0 | 15.2 |
0% excess
|
| 29 | Anthony Wright | 5 | 546 | $366 | 109.1 mi | 81.1 mi | 406 | $272 | 109.2 |
74% excess
|
| 30 | Omar Serrano | 34 | 544 | $364 | 16.0 mi | 8.1 mi | 274 | $184 | 16 |
50% excess
|