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 | 39 | 10,170 | $6,814 | 260.8 mi | 88.0 mi | 3,434 | $2,301 | 260.8 |
34% excess
|
| 2 | Omar Serrano | 156 | 9,713 | $6,508 | 62.3 mi | 40.7 mi | 6,349 | $4,254 | 62.3 |
65% excess
|
| 3 | Tim Holman | 123 | 6,784 | $4,545 | 55.2 mi | 24.0 mi | 2,947 | $1,974 | 55.2 |
43% excess
|
| 4 | Jason Morris | 87 | 5,595 | $3,749 | 64.3 mi | 10.7 mi | 932 | $624 | 64.3 |
17% excess
|
| 5 | Angel Rios | 86 | 5,427 | $3,636 | 63.1 mi | 12.1 mi | 1,039 | $696 | 63.1 |
19% excess
|
| 6 | Michael Russell | 96 | 4,922 | $3,298 | 51.3 mi | 38.4 mi | 3,683 | $2,468 | 51.3 |
75% excess
|
| 7 | Justin Armas | 65 | 4,639 | $3,108 | 71.4 mi | 7.5 mi | 490 | $328 | 71.4 |
11% excess
|
| 8 | Kwame Cobb | 23 | 4,051 | $2,714 | 176.2 mi | 148.2 mi | 3,408 | $2,283 | 176.1 |
84% excess
|
| 9 | Rene Yescas | 40 | 1,340 | $898 | 33.5 mi | 17.8 mi | 712 | $477 | 33.5 |
53% excess
|
| 10 | Andrew Przybyla | 3 | 1,222 | $819 | 407.3 mi | 402.6 mi | 1,208 | $809 | 407.3 |
99% excess
|
| 11 | Jeffrey Pastor | 5 | 117 | $78 | 23.3 mi | 9.3 mi | 46 | $31 | 23.4 |
39% excess
|