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 | Christopher Carroll | 5 | 5,476 | $3,669 | 1095.2 mi | 1067.3 mi | 5,337 | $3,576 | 1095.2 |
97% excess
|
| 2 | David Trost | 47 | 4,883 | $3,272 | 103.9 mi | 70.5 mi | 3,315 | $2,221 | 103.9 |
68% excess
|
| 3 | Luis Torres | 105 | 4,101 | $2,748 | 39.1 mi | 15.8 mi | 1,655 | $1,109 | 39.1 |
40% excess
|
| 4 | Joseph Anderson | 2 | 2,703 | $1,811 | 1351.6 mi | 1175.1 mi | 2,350 | $1,575 | 1351.5 |
87% excess
|
| 5 | Curtis Allen | 43 | 1,825 | $1,223 | 42.4 mi | 24.7 mi | 1,064 | $713 | 42.4 |
58% excess
|
| 6 | Mike Huffman | 9 | 1,532 | $1,026 | 170.3 mi | 118.4 mi | 1,065 | $714 | 170.2 |
70% excess
|
| 7 | Erwin Forster | 34 | 1,219 | $817 | 35.8 mi | 1.0 mi | 32 | $21 | 35.9 |
3% excess
|
| 8 | Pete Ramos | 34 | 916 | $614 | 27.0 mi | 5.2 mi | 178 | $119 | 26.9 |
19% excess
|
| 9 | Bernard Thompson | 15 | 891 | $597 | 59.4 mi | 10.3 mi | 154 | $103 | 59.4 |
17% excess
|
| 10 | Jon Kuehl | 3 | 728 | $488 | 242.6 mi | 0.0 mi | 0 | $0 | 242.7 |
0% excess
|
| 11 | Edward Arias | 15 | 527 | $353 | 35.1 mi | 14.1 mi | 211 | $141 | 35.1 |
40% excess
|
| 12 | Mohamed Shareed | 9 | 362 | $243 | 40.2 mi | 21.5 mi | 194 | $130 | 40.2 |
54% excess
|
| 13 | Chris Galasso | 2 | 54 | $36 | 26.9 mi | 6.4 mi | 13 | $9 | 27 |
24% excess
|
| 14 | Darek Kirkpatrick | 5 | 47 | $31 | 9.4 mi | 0.0 mi | 0 | $0 | 9.4 |
0% excess
|
| 15 | Maximilian Tucker | 1 | 27 | $18 | 27.2 mi | 0.0 mi | 0 | $0 | 27 |
0% excess
|
| 16 | Philip Krogstad | 1 | 27 | $18 | 26.8 mi | 0.0 mi | 0 | $0 | 27 |
0% excess
|
| 17 | Brandon Green | 1 | 6 | $4 | 5.7 mi | 0.0 mi | 0 | $0 | 6 |
0% excess
|