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 | Michah Brackett | 4 | 629 | $421 | 157.2 mi | 122.4 mi | 490 | $328 | 157.3 |
78% excess
|
| 2 | Angel Rios | 9 | 320 | $214 | 35.6 mi | 10.6 mi | 96 | $64 | 35.6 |
30% excess
|
| 3 | Kwame Cobb | 7 | 304 | $204 | 43.5 mi | 19.3 mi | 135 | $90 | 43.4 |
44% excess
|
| 4 | Omar Serrano | 6 | 198 | $133 | 33 mi | 10.3 mi | 62 | $42 | 33 |
31% excess
|
| 5 | Justin Armas | 2 | 142 | $95 | 70.8 mi | 9.5 mi | 19 | $13 | 71 |
13% excess
|
| 6 | Rene Yescas | 3 | 129 | $86 | 43 mi | 40 mi | 120 | $80 | 43 |
93% excess
|
| 7 | Jason Morris | 2 | 78 | $52 | 38.8 mi | 0 mi | 0 | $0 | 39 |
0% excess
|
| 8 | Tim Holman | 3 | 39 | $26 | 12.9 mi | 0 mi | 0 | $0 | 13 |
0% excess
|
| 9 | Michael Russell | 2 | 11 | $7 | 5.4 mi | 0 mi | 0 | $0 | 5.5 |
0% excess
|