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 | Praelow Cameron | 366 | 80,244 | $53,763 | 219.2 mi | 163.9 mi | 59,981 | $40,187 | 219.2 |
75% excess
|
| 2 | Mike Huffman | 136 | 21,778 | $14,591 | 160.1 mi | 106.6 mi | 14,496 | $9,712 | 160.1 |
67% excess
|
| 3 | Robert Rivera | 275 | 17,232 | $11,545 | 62.7 mi | 27.3 mi | 7,504 | $5,028 | 62.7 |
44% excess
|
| 4 | Emmanuel Morales | 12 | 17,114 | $11,466 | 1426.2 mi | 1296.5 mi | 15,558 | $10,424 | 1426.2 |
91% excess
|
| 5 | Robert Lewis | 227 | 16,168 | $10,833 | 71.2 mi | 17.2 mi | 3,906 | $2,617 | 71.2 |
24% excess
|
| 6 | Andrew Przybyla | 15 | 13,760 | $9,219 | 917.3 mi | 884.2 mi | 13,263 | $8,886 | 917.3 |
96% excess
|
| 7 | Nicole Floyd | 10 | 11,193 | $7,499 | 1119.3 mi | 569.7 mi | 5,697 | $3,817 | 1119.3 |
51% excess
|
| 8 | Ronnie Salone | 157 | 10,744 | $7,198 | 68.4 mi | 15.7 mi | 2,468 | $1,654 | 68.4 |
23% excess
|
| 9 | Cynthia G Deville | 161 | 10,599 | $7,101 | 65.8 mi | 15.5 mi | 2,502 | $1,676 | 65.8 |
24% excess
|
| 10 | Jason Morris | 10 | 10,011 | $6,707 | 1001.1 mi | 950.2 mi | 9,502 | $6,366 | 1001.1 |
95% excess
|
| 11 | Maximilian Tucker | 150 | 8,733 | $5,851 | 58.2 mi | 25.2 mi | 3,774 | $2,529 | 58.2 |
43% excess
|
| 12 | Brendan Chaney | 19 | 6,449 | $4,321 | 339.4 mi | 232.5 mi | 6,306 | $4,225 | 339.4 |
98% excess
|
| 13 | Joseph Anderson | 87 | 6,231 | $4,175 | 71.6 mi | 27.8 mi | 2,422 | $1,623 | 71.6 |
39% excess
|
| 14 | Christopher Carroll | 11 | 5,693 | $3,814 | 517.6 mi | 485.2 mi | 5,337 | $3,576 | 517.5 |
94% excess
|
| 15 | David Trost | 49 | 5,248 | $3,516 | 107.1 mi | 73.0 mi | 3,577 | $2,397 | 107.1 |
68% excess
|
| 16 | Vincent Nyathi | 104 | 4,773 | $3,198 | 45.9 mi | 11.4 mi | 1,186 | $795 | 45.9 |
25% excess
|
| 17 | Luis Torres | 108 | 4,213 | $2,823 | 39.0 mi | 15.9 mi | 1,717 | $1,150 | 39 |
41% excess
|
| 18 | Jason Cunningham | 48 | 3,824 | $2,562 | 79.7 mi | 10.7 mi | 513 | $344 | 79.7 |
13% excess
|
| 19 | Kevin Cox | 36 | 3,774 | $2,529 | 104.8 mi | 7.7 mi | 277 | $186 | 104.8 |
7% excess
|
| 20 | Phillip Castillo | 2 | 3,438 | $2,303 | 1718.8 mi | 1694.9 mi | 3,390 | $2,271 | 1719 |
99% excess
|
| 21 | Michael Swingle | 58 | 3,287 | $2,202 | 56.7 mi | 2.2 mi | 127 | $85 | 56.7 |
4% excess
|
| 22 | Christopher Womack | 68 | 3,144 | $2,106 | 46.2 mi | 13.2 mi | 901 | $604 | 46.2 |
29% excess
|
| 23 | Darrell Hendrix | 48 | 3,116 | $2,088 | 64.9 mi | 0.3 mi | 15 | $10 | 64.9 |
0% excess
|
| 24 | Jon Kuehl | 33 | 2,850 | $1,910 | 86.4 mi | 29.7 mi | 981 | $657 | 86.4 |
34% excess
|
| 25 | Dustin Antolin | 38 | 2,780 | $1,863 | 73.2 mi | 44.5 mi | 1,691 | $1,133 | 73.2 |
61% excess
|
| 26 | Jordan Moceri | 42 | 2,562 | $1,717 | 61.0 mi | 24.4 mi | 1,024 | $686 | 61 |
40% excess
|
| 27 | Craig Walker | 46 | 2,289 | $1,534 | 49.8 mi | 9.6 mi | 441 | $295 | 49.8 |
19% excess
|
| 28 | Curtis Allen | 46 | 1,949 | $1,306 | 42.4 mi | 25.0 mi | 1,148 | $769 | 42.4 |
59% excess
|
| 29 | Philip Krogstad | 43 | 1,819 | $1,219 | 42.3 mi | 7.4 mi | 319 | $214 | 42.3 |
18% excess
|
| 30 | Ed Danek | 1 | 1,779 | $1,192 | 1779.2 mi | 1775.9 mi | 1,776 | $1,190 | 1779 |
100% excess
|