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 | David Cavaco | 8 | 613 | $411 | 76.6 mi | 38.8 mi | 310 | $208 | 76.6 |
51% excess
|
| 2 | Mohamed Shareed | 8 | 444 | $297 | 55.4 mi | 42.4 mi | 339 | $227 | 55.5 |
76% excess
|
| 3 | Luis Torres | 7 | 332 | $222 | 47.4 mi | 26.7 mi | 187 | $125 | 47.4 |
56% excess
|
| 4 | Edward Arias | 6 | 284 | $190 | 47.3 mi | 30.5 mi | 183 | $123 | 47.3 |
64% excess
|
| 5 | Nick O'Neill | 4 | 176 | $118 | 44 mi | 36.6 mi | 146 | $98 | 44 |
83% excess
|
| 6 | Paul Bonang Jr | 6 | 152 | $102 | 25.3 mi | 8.5 mi | 51 | $34 | 25.3 |
34% excess
|
| 7 | Erwin Forster | 4 | 149 | $100 | 37.3 mi | 13.9 mi | 55 | $37 | 37.3 |
37% excess
|
| 8 | David Trost | 7 | 117 | $78 | 16.8 mi | 9.3 mi | 65 | $44 | 16.7 |
56% excess
|
| 9 | Bernard Thompson | 3 | 110 | $74 | 36.6 mi | 12.7 mi | 38 | $25 | 36.7 |
35% excess
|
| 10 | Darrell Hope | 4 | 80 | $54 | 19.9 mi | 5.3 mi | 21 | $14 | 20 |
26% excess
|
| 11 | Pete Ramos | 2 | 63 | $42 | 31.7 mi | 20.8 mi | 42 | $28 | 31.5 |
67% excess
|
| 12 | Taylor Duda | 1 | 20 | $13 | 19.8 mi | 15.6 mi | 16 | $11 | 20 |
80% excess
|
| 13 | Darek Kirkpatrick | 1 | 15 | $10 | 15.2 mi | 0 mi | 0 | $0 | 15 |
0% excess
|