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 | Scott A Berry | 5 | 2,229 | $1,493 | 445.8 mi | 428.2 mi | 2,141 | $1,434 | 445.8 |
96% excess
|
| 2 | Christopher Carroll | 1 | 1,090 | $730 | 1089.8 mi | 1089.8 mi | 1,090 | $730 | 1090 |
100% excess
|
| 3 | Erwin Forster | 4 | 149 | $100 | 37.3 mi | 13.9 mi | 55 | $37 | 37.3 |
37% excess
|
| 4 | Luis Torres | 2 | 128 | $86 | 64.1 mi | 43.5 mi | 87 | $58 | 64 |
68% excess
|
| 5 | Bernard Thompson | 3 | 110 | $74 | 36.6 mi | 12.7 mi | 38 | $25 | 36.7 |
35% excess
|
| 6 | Edward Arias | 4 | 103 | $69 | 25.7 mi | 9.5 mi | 38 | $25 | 25.8 |
37% excess
|
| 7 | Pete Ramos | 2 | 63 | $42 | 31.7 mi | 20.8 mi | 42 | $28 | 31.5 |
67% excess
|
| 8 | David Trost | 4 | 58 | $39 | 14.4 mi | 7.3 mi | 29 | $19 | 14.5 |
50% excess
|
| 9 | Darrell Hope | 2 | 54 | $36 | 27.2 mi | 3.9 mi | 8 | $5 | 27 |
15% excess
|
| 10 | Taylor Duda | 1 | 20 | $13 | 19.8 mi | 15.6 mi | 16 | $11 | 20 |
80% excess
|
| 11 | Darek Kirkpatrick | 1 | 15 | $10 | 15.2 mi | 0 mi | 0 | $0 | 15 |
0% excess
|
| 12 | Mohamed Shareed | 2 | 8 | $5 | 3.8 mi | 3 mi | 6 | $4 | 4 |
75% excess
|