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 | Scott R Roberts | 20 | 2,043 | $1,369 | 102.1 mi | 8.5 mi | 169 | $113 | 102.2 |
8% excess
|
| 2 | Todd Fogiel | 9 | 1,919 | $1,286 | 213.3 mi | 87.6 mi | 788 | $528 | 213.2 |
41% excess
|
| 3 | Jason Cunningham | 3 | 640 | $429 | 213.3 mi | 82.6 mi | 248 | $166 | 213.3 |
39% excess
|
| 4 | Michah Brackett | 1 | 438 | $293 | 438 mi | 50.9 mi | 51 | $34 | 438 |
12% excess
|
| 5 | Chris Galasso | 5 | 382 | $256 | 76.3 mi | 18.2 mi | 91 | $61 | 76.4 |
24% excess
|
| 6 | Rozier Cole | 1 | 321 | $215 | 321.2 mi | 201.4 mi | 201 | $135 | 321 |
63% excess
|
| 7 | Dustin Antolin | 6 | 243 | $163 | 40.6 mi | 3.6 mi | 22 | $15 | 40.5 |
9% excess
|
| 8 | Craig Walker | 1 | 204 | $137 | 204.1 mi | 74.1 mi | 74 | $50 | 204 |
36% excess
|
| 9 | Brandon Green | 2 | 172 | $115 | 86.2 mi | 6.8 mi | 14 | $9 | 86 |
8% excess
|
| 10 | Ray Andreu | 7 | 161 | $108 | 23 mi | 0 mi | 0 | $0 | 23 |
0% excess
|
| 11 | Curtis Allen | 5 | 130 | $87 | 26.1 mi | 2.2 mi | 11 | $7 | 26 |
8% excess
|
| 12 | Teddie Bracken | 3 | 97 | $65 | 32.5 mi | 8.3 mi | 25 | $17 | 32.3 |
26% excess
|
| 13 | David Trost | 3 | 83 | $56 | 27.6 mi | 10.2 mi | 30 | $20 | 27.7 |
36% excess
|
| 14 | Darrell Hope | 2 | 80 | $54 | 40.2 mi | 7.3 mi | 15 | $10 | 40 |
19% excess
|
| 15 | Rene Yescas | 2 | 63 | $42 | 31.6 mi | 0 mi | 0 | $0 | 31.5 |
0% excess
|
| 16 | Paul Bonang Jr | 3 | 49 | $33 | 16.2 mi | 0 mi | 0 | $0 | 16.3 |
0% excess
|
| 17 | Anthony Wirth | 4 | 46 | $31 | 11.6 mi | 0 mi | 0 | $0 | 11.5 |
0% excess
|
| 18 | Natosha Beierschmitt | 1 | 15 | $10 | 15 mi | -22.3 mi | 0 | $0 | 15 |
0% excess
|
| 19 | Kevin Cox | 1 | 8 | $5 | 8.1 mi | 0 mi | 0 | $0 | 8 |
0% excess
|