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 | Omar Serrano | 186 | 7,576 | $5,076 | 40.7 mi | 21.6 mi | 4,024 | $2,696 | 40.7 |
53% excess
|
| 2 | Angel Rios | 79 | 4,635 | $3,105 | 58.7 mi | 11.9 mi | 941 | $630 | 58.7 |
20% excess
|
| 3 | Justin Armas | 65 | 4,576 | $3,066 | 70.4 mi | 7.7 mi | 500 | $335 | 70.4 |
11% excess
|
| 4 | Michael Russell | 9 | 2,153 | $1,443 | 239.2 mi | 233.7 mi | 2,104 | $1,410 | 239.2 |
98% excess
|
| 5 | Rene Yescas | 41 | 1,346 | $902 | 32.8 mi | 17.4 mi | 712 | $477 | 32.8 |
53% excess
|
| 6 | Kwame Cobb | 22 | 990 | $663 | 45.0 mi | 21.6 mi | 475 | $318 | 45 |
48% excess
|
| 7 | Michah Brackett | 2 | 928 | $622 | 463.8 mi | 450.9 mi | 902 | $604 | 464 |
97% excess
|
| 8 | Jeffrey Pastor | 5 | 117 | $78 | 23.3 mi | 9.3 mi | 46 | $31 | 23.4 |
39% excess
|