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 | 108 | 7,708 | $5,164 | 71.4 mi | 7.4 mi | 800 | $536 | 71.4 |
10% excess
|
| 2 | Michah Brackett | 4 | 5,394 | $3,614 | 1348.5 mi | 1096.4 mi | 4,385 | $2,938 | 1348.5 |
81% excess
|
| 3 | Brandon Green | 45 | 4,805 | $3,219 | 106.8 mi | 36.8 mi | 1,654 | $1,108 | 106.8 |
34% excess
|
| 4 | Dustin Antolin | 42 | 4,144 | $2,776 | 98.7 mi | 23.1 mi | 970 | $650 | 98.7 |
23% excess
|
| 5 | Chris Galasso | 3 | 2,101 | $1,408 | 700.2 mi | 456.5 mi | 1,369 | $917 | 700.3 |
65% excess
|
| 6 | Teddie Bracken | 61 | 1,996 | $1,337 | 32.7 mi | 9.5 mi | 579 | $388 | 32.7 |
29% excess
|
| 7 | Kevin Cox | 2 | 276 | $185 | 138 mi | 47.8 mi | 96 | $64 | 138 |
35% excess
|
| 8 | Jordan Moceri | 3 | 251 | $168 | 83.5 mi | 18.9 mi | 57 | $38 | 83.7 |
23% excess
|
| 9 | Lawrence Yoder | 2 | 228 | $153 | 114.1 mi | 0 mi | 0 | $0 | 114 |
0% excess
|
| 10 | Franco Jackson | 2 | 149 | $100 | 74.5 mi | 23.7 mi | 47 | $31 | 74.5 |
32% excess
|