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 | 71 | 21,454 | $14,374 | 302.2 mi | 209.2 mi | 14,855 | $9,953 | 302.2 |
69% excess
|
| 2 | Michah Brackett | 59 | 17,686 | $11,850 | 299.8 mi | 69.0 mi | 4,069 | $2,726 | 299.8 |
23% excess
|
| 3 | Justin Armas | 98 | 14,858 | $9,955 | 151.6 mi | 92.0 mi | 9,020 | $6,043 | 151.6 |
61% excess
|
| 4 | Omar Serrano | 186 | 11,323 | $7,586 | 60.9 mi | 36.8 mi | 6,839 | $4,582 | 60.9 |
60% excess
|
| 5 | Fernando Lemos | 36 | 8,655 | $5,799 | 240.4 mi | 160.1 mi | 5,763 | $3,861 | 240.4 |
67% excess
|
| 6 | Tim Holman | 138 | 7,410 | $4,965 | 53.7 mi | 22.2 mi | 3,058 | $2,049 | 53.7 |
41% excess
|
| 7 | Angel Rios | 108 | 6,835 | $4,579 | 63.3 mi | 14.4 mi | 1,555 | $1,042 | 63.3 |
23% excess
|
| 8 | Jason Morris | 91 | 5,725 | $3,836 | 62.9 mi | 11.1 mi | 1,009 | $676 | 62.9 |
18% excess
|
| 9 | Michael Russell | 100 | 5,405 | $3,621 | 54.0 mi | 41.5 mi | 4,149 | $2,780 | 54.1 |
77% excess
|
| 10 | Rene Yescas | 128 | 3,961 | $2,654 | 30.9 mi | 7.9 mi | 1,008 | $675 | 30.9 |
25% excess
|
| 11 | Curtis Sprague | 2 | 3,690 | $2,472 | 1844.8 mi | 1354.1 mi | 2,708 | $1,814 | 1845 |
73% excess
|
| 12 | Andrew Przybyla | 4 | 1,289 | $864 | 322.4 mi | 302.0 mi | 1,208 | $809 | 322.3 |
94% excess
|
| 13 | Tyler Bollman | 7 | 1,288 | $863 | 184.0 mi | 43.6 mi | 305 | $204 | 184 |
24% excess
|
| 14 | Jeffrey Pastor | 8 | 124 | $83 | 15.4 mi | 6.7 mi | 53 | $36 | 15.5 |
43% excess
|
| 15 | Jim Kingery | 1 | 55 | $37 | 55.0 mi | 54.4 mi | 54 | $36 | 55 |
98% excess
|
| 16 | Larry Alberty | 2 | 26 | $17 | 12.9 mi | 0.0 mi | 0 | $0 | 13 |
0% excess
|
| 17 | Jared Rappaport | 1 | 15 | $10 | 15.0 mi | 0.0 mi | 0 | $0 | 15 |
0% excess
|
| 18 | Nidal Al-Sharif | 25 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|