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 | Darek Kirkpatrick | 2 | 186 | $125 | 93.1 mi | 10.6 mi | 21 | $14 | 93 |
11% excess
|
| 2 | Erwin Forster | 4 | 149 | $100 | 37.3 mi | 13.9 mi | 55 | $37 | 37.3 |
37% excess
|
| 3 | Luis Torres | 2 | 128 | $86 | 64.1 mi | 43.5 mi | 87 | $58 | 64 |
68% excess
|
| 4 | Bernard Thompson | 3 | 110 | $74 | 36.6 mi | 12.7 mi | 38 | $25 | 36.7 |
35% excess
|
| 5 | Edward Arias | 4 | 103 | $69 | 25.7 mi | 9.5 mi | 38 | $25 | 25.8 |
37% excess
|
| 6 | Darrell Hope | 3 | 74 | $50 | 24.6 mi | 2.6 mi | 8 | $5 | 24.7 |
11% excess
|
| 7 | David Trost | 5 | 70 | $47 | 14.1 mi | 5.9 mi | 29 | $19 | 14 |
41% excess
|
| 8 | Pete Ramos | 2 | 63 | $42 | 31.7 mi | 20.8 mi | 42 | $28 | 31.5 |
67% excess
|
| 9 | Taylor Duda | 1 | 20 | $13 | 19.8 mi | 15.6 mi | 16 | $11 | 20 |
80% excess
|
| 10 | Mohamed Shareed | 2 | 8 | $5 | 3.8 mi | 3 mi | 6 | $4 | 4 |
75% excess
|
| 11 | Hector Castaneda | 1 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|