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 | 40 | 12,372 | $8,289 | 309.3 mi | 221.2 mi | 8,848 | $5,928 | 309.3 |
72% excess
|
| 2 | Michah Brackett | 40 | 9,170 | $6,144 | 229.3 mi | 47.3 mi | 1,892 | $1,268 | 229.3 |
21% excess
|
| 3 | Omar Serrano | 93 | 7,520 | $5,038 | 80.9 mi | 56.5 mi | 5,255 | $3,521 | 80.9 |
70% excess
|
| 4 | Fernando Lemos | 32 | 7,079 | $4,743 | 221.2 mi | 172.2 mi | 5,510 | $3,692 | 221.2 |
78% excess
|
| 5 | Tim Holman | 77 | 5,025 | $3,367 | 65.3 mi | 38.7 mi | 2,978 | $1,995 | 65.3 |
59% excess
|
| 6 | Justin Armas | 48 | 4,745 | $3,179 | 98.9 mi | 58.1 mi | 2,787 | $1,867 | 98.9 |
59% excess
|
| 7 | Angel Rios | 64 | 4,474 | $2,998 | 69.9 mi | 14.1 mi | 903 | $605 | 69.9 |
20% excess
|
| 8 | Michael Russell | 56 | 4,282 | $2,869 | 76.5 mi | 63.3 mi | 3,546 | $2,376 | 76.5 |
83% excess
|
| 9 | Jason Morris | 43 | 1,849 | $1,239 | 43 mi | 8.2 mi | 354 | $237 | 43 |
19% excess
|
| 10 | Rene Yescas | 52 | 1,847 | $1,237 | 35.5 mi | 8.1 mi | 421 | $282 | 35.5 |
23% excess
|
| 11 | Andrew Przybyla | 2 | 1,189 | $797 | 594.7 mi | 589.5 mi | 1,179 | $790 | 594.5 |
99% excess
|
| 12 | Tyler Bollman | 3 | 552 | $370 | 184 mi | 20.4 mi | 61 | $41 | 184 |
11% excess
|
| 13 | Jeffrey Pastor | 4 | 77 | $52 | 19.1 mi | 9 mi | 36 | $24 | 19.3 |
47% excess
|
| 14 | Jared Rappaport | 1 | 15 | $10 | 15 mi | 0 mi | 0 | $0 | 15 |
0% excess
|
| 15 | Larry Alberty | 1 | 14 | $9 | 14.3 mi | 0 mi | 0 | $0 | 14 |
0% excess
|
| 16 | Nidal Al-Sharif | 13 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|