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 | Megan Allen | 3 | 4,526 | $3,032 | 1508.7 mi | 1480.7 mi | 4,442 | $2,976 | 1508.7 |
98% excess
|
| 2 | James Duff | 5 | 3,788 | $2,538 | 757.6 mi | 755.3 mi | 3,776 | $2,530 | 757.6 |
100% excess
|
| 3 | Scott A Berry | 8 | 3,633 | $2,434 | 454.2 mi | 433.3 mi | 3,466 | $2,322 | 454.1 |
95% excess
|
| 4 | Christopher Carroll | 3 | 3,269 | $2,190 | 1089.8 mi | 1089.8 mi | 3,269 | $2,190 | 1089.7 |
100% excess
|
| 5 | Erwin Forster | 43 | 2,665 | $1,786 | 62 mi | 40.9 mi | 1,759 | $1,179 | 62 |
66% excess
|
| 6 | Mohamed Shareed | 40 | 1,502 | $1,006 | 37.6 mi | 13.4 mi | 537 | $360 | 37.6 |
36% excess
|
| 7 | Bernard Thompson | 32 | 1,493 | $1,000 | 46.7 mi | 20.2 mi | 646 | $433 | 46.7 |
43% excess
|
| 8 | Edward Arias | 31 | 997 | $668 | 32.2 mi | 15.9 mi | 493 | $330 | 32.2 |
49% excess
|
| 9 | Taylor Duda | 20 | 892 | $598 | 44.6 mi | 29.3 mi | 585 | $392 | 44.6 |
66% excess
|
| 10 | David Trost | 45 | 830 | $556 | 18.4 mi | 6.3 mi | 285 | $191 | 18.4 |
34% excess
|
| 11 | Darek Kirkpatrick | 35 | 818 | $548 | 23.4 mi | 7.9 mi | 278 | $186 | 23.4 |
34% excess
|
| 12 | Hector Castaneda | 5 | 718 | $481 | 143.5 mi | 143.5 mi | 718 | $481 | 143.6 |
100% excess
|
| 13 | Pete Ramos | 14 | 537 | $360 | 38.3 mi | 26.7 mi | 374 | $251 | 38.4 |
70% excess
|
| 14 | Luis Torres | 4 | 252 | $169 | 62.9 mi | 44.7 mi | 179 | $120 | 63 |
71% excess
|
| 15 | Darrell Hope | 17 | 234 | $157 | 13.8 mi | 3.4 mi | 58 | $39 | 13.8 |
25% excess
|
| 16 | Curtis Allen | 3 | 38 | $25 | 12.7 mi | 4.7 mi | 14 | $9 | 12.7 |
37% excess
|