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 | 80 | 7,120 | $4,770 | 89 mi | 64.8 mi | 5,182 | $3,472 | 89 |
73% excess
|
| 2 | Tim Holman | 69 | 4,517 | $3,026 | 65.5 mi | 41.9 mi | 2,894 | $1,939 | 65.5 |
64% excess
|
| 3 | Michael Russell | 53 | 3,803 | $2,548 | 71.8 mi | 58.1 mi | 3,081 | $2,064 | 71.8 |
81% excess
|
| 4 | Angel Rios | 50 | 3,473 | $2,327 | 69.5 mi | 10.7 mi | 533 | $357 | 69.5 |
15% excess
|
| 5 | Michah Brackett | 25 | 3,153 | $2,113 | 126.1 mi | 58.8 mi | 1,471 | $986 | 126.1 |
47% excess
|
| 6 | Kwame Cobb | 16 | 2,977 | $1,995 | 186.1 mi | 158.7 mi | 2,540 | $1,702 | 186.1 |
85% excess
|
| 7 | Jason Morris | 40 | 1,744 | $1,168 | 43.6 mi | 6.9 mi | 278 | $186 | 43.6 |
16% excess
|
| 8 | Justin Armas | 33 | 1,347 | $902 | 40.8 mi | 8.7 mi | 286 | $192 | 40.8 |
21% excess
|
| 9 | Andrew Przybyla | 2 | 1,189 | $797 | 594.7 mi | 589.5 mi | 1,179 | $790 | 594.5 |
99% excess
|
| 10 | Rene Yescas | 10 | 469 | $314 | 46.9 mi | 17.8 mi | 178 | $119 | 46.9 |
38% excess
|
| 11 | Jeffrey Pastor | 1 | 70 | $47 | 69.5 mi | 28.9 mi | 29 | $19 | 70 |
41% excess
|