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 | Christopher Carroll | 7 | 7,656 | $5,130 | 1093.7 mi | 1073.8 mi | 7,516 | $5,036 | 1093.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 | Erwin Forster | 76 | 3,740 | $2,506 | 49.2 mi | 19.2 mi | 1,463 | $980 | 49.2 |
39% excess
|
| 4 | Bernard Thompson | 52 | 2,520 | $1,688 | 48.5 mi | 15.8 mi | 824 | $552 | 48.5 |
33% excess
|
| 5 | Mohamed Shareed | 43 | 1,465 | $982 | 34.1 mi | 12.3 mi | 527 | $353 | 34.1 |
36% excess
|
| 6 | Edward Arias | 40 | 1,430 | $958 | 35.8 mi | 16.6 mi | 664 | $445 | 35.8 |
46% excess
|
| 7 | David Trost | 67 | 1,154 | $773 | 17.2 mi | 5 mi | 336 | $225 | 17.2 |
29% excess
|
| 8 | Darek Kirkpatrick | 40 | 965 | $647 | 24.1 mi | 7.5 mi | 299 | $200 | 24.1 |
31% excess
|
| 9 | Luis Torres | 10 | 935 | $626 | 93.5 mi | 26.2 mi | 262 | $176 | 93.5 |
28% excess
|
| 10 | Darrell Hope | 50 | 882 | $591 | 17.6 mi | 3.1 mi | 155 | $104 | 17.6 |
18% excess
|
| 11 | Taylor Duda | 21 | 868 | $582 | 41.3 mi | 27.3 mi | 574 | $385 | 41.3 |
66% excess
|
| 12 | Hector Castaneda | 7 | 718 | $481 | 102.5 mi | 102.5 mi | 718 | $481 | 102.6 |
100% excess
|
| 13 | Pete Ramos | 15 | 551 | $369 | 36.7 mi | 24.9 mi | 374 | $251 | 36.7 |
68% excess
|
| 14 | Curtis Allen | 6 | 191 | $128 | 31.8 mi | 3.1 mi | 19 | $13 | 31.8 |
10% excess
|
| 15 | Shawn Rogers | 1 | 96 | $64 | 95.5 mi | -25.2 mi | 0 | $0 | 96 |
0% excess
|