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 | 111 | 5,418 | $3,630 | 48.8 mi | 29.5 mi | 3,271 | $2,192 | 48.8 |
60% excess
|
| 2 | Angel Rios | 43 | 2,703 | $1,811 | 62.8 mi | 11 mi | 473 | $317 | 62.9 |
17% excess
|
| 3 | Michael Russell | 9 | 2,153 | $1,443 | 239.2 mi | 233.7 mi | 2,104 | $1,410 | 239.2 |
98% excess
|
| 4 | Justin Armas | 36 | 1,574 | $1,055 | 43.7 mi | 8.2 mi | 295 | $198 | 43.7 |
19% excess
|
| 5 | Kwame Cobb | 16 | 717 | $480 | 44.8 mi | 23.5 mi | 375 | $251 | 44.8 |
52% excess
|
| 6 | Michah Brackett | 1 | 507 | $340 | 507.1 mi | 489.5 mi | 490 | $328 | 507 |
97% excess
|
| 7 | Rene Yescas | 11 | 475 | $318 | 43.2 mi | 16.2 mi | 178 | $119 | 43.2 |
37% excess
|
| 8 | Jeffrey Pastor | 1 | 70 | $47 | 69.5 mi | 28.9 mi | 29 | $19 | 70 |
41% excess
|