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 | Pete Ramos | 14 | 623 | $417 | 44.5 mi | 30.2 mi | 422 | $283 | 44.5 |
68% excess
|
| 2 | David Cavaco | 8 | 613 | $411 | 76.6 mi | 38.8 mi | 310 | $208 | 76.6 |
51% excess
|
| 3 | Mohamed Shareed | 8 | 444 | $297 | 55.4 mi | 42.4 mi | 339 | $227 | 55.5 |
76% excess
|
| 4 | Luis Torres | 15 | 440 | $295 | 29.3 mi | 12.5 mi | 187 | $125 | 29.3 |
43% excess
|
| 5 | Edward Arias | 6 | 284 | $190 | 47.3 mi | 30.5 mi | 183 | $123 | 47.3 |
64% excess
|
| 6 | Paul Bonang Jr | 9 | 201 | $135 | 22.3 mi | 5.7 mi | 51 | $34 | 22.3 |
25% excess
|
| 7 | David Trost | 10 | 199 | $133 | 19.9 mi | 9.5 mi | 95 | $64 | 19.9 |
48% excess
|
| 8 | Darek Kirkpatrick | 2 | 186 | $125 | 93.1 mi | 10.6 mi | 21 | $14 | 93 |
11% excess
|
| 9 | Nick O'Neill | 4 | 176 | $118 | 44 mi | 36.6 mi | 146 | $98 | 44 |
83% excess
|
| 10 | Erwin Forster | 4 | 149 | $100 | 37.3 mi | 13.9 mi | 55 | $37 | 37.3 |
37% excess
|
| 11 | Curtis Allen | 6 | 143 | $96 | 23.9 mi | 1.8 mi | 11 | $7 | 23.8 |
8% excess
|
| 12 | Bernard Thompson | 3 | 110 | $74 | 36.6 mi | 12.7 mi | 38 | $25 | 36.7 |
35% excess
|
| 13 | Jim Kingery | 2 | 110 | $74 | 55 mi | 54.4 mi | 109 | $73 | 55 |
99% excess
|
| 14 | Darrell Hope | 5 | 99 | $66 | 19.8 mi | 4.3 mi | 21 | $14 | 19.8 |
21% excess
|
| 15 | Taylor Duda | 1 | 20 | $13 | 19.8 mi | 15.6 mi | 16 | $11 | 20 |
80% excess
|
| 16 | Hector Castaneda | 1 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|