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 | Kwame Cobb | 33 | 6,448 | $4,320 | 195.4 mi | 169 mi | 5,579 | $3,738 | 195.4 |
87% excess
|
| 2 | Omar Serrano | 92 | 5,594 | $3,748 | 60.8 mi | 36.2 mi | 3,331 | $2,232 | 60.8 |
60% excess
|
| 3 | Angel Rios | 57 | 3,704 | $2,482 | 65 mi | 14.8 mi | 843 | $565 | 65 |
23% excess
|
| 4 | Michael Russell | 11 | 2,632 | $1,763 | 239.3 mi | 233.6 mi | 2,569 | $1,721 | 239.3 |
98% excess
|
| 5 | Justin Armas | 42 | 2,013 | $1,349 | 47.9 mi | 11.4 mi | 478 | $320 | 47.9 |
24% excess
|
| 6 | Michah Brackett | 4 | 1,995 | $1,337 | 498.7 mi | 227.6 mi | 910 | $610 | 498.8 |
46% excess
|
| 7 | Rene Yescas | 52 | 1,847 | $1,237 | 35.5 mi | 8.1 mi | 421 | $282 | 35.5 |
23% excess
|
| 8 | Jeffrey Pastor | 4 | 77 | $52 | 19.1 mi | 9 mi | 36 | $24 | 19.3 |
47% excess
|
| 9 | Jared Rappaport | 1 | 15 | $10 | 15 mi | 0 mi | 0 | $0 | 15 |
0% excess
|
| 10 | Larry Alberty | 1 | 14 | $9 | 14.3 mi | 0 mi | 0 | $0 | 14 |
0% excess
|