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 | James Duff | 19 | 16,621 | $11,136 | 874.8 mi | 865.4 mi | 16,442 | $11,016 | 874.8 |
99% excess
|
| 2 | Christopher Carroll | 10 | 9,454 | $6,334 | 945.4 mi | 921 mi | 9,210 | $6,171 | 945.4 |
97% excess
|
| 3 | Luis Torres | 137 | 6,601 | $4,423 | 48.2 mi | 16.9 mi | 2,316 | $1,552 | 48.2 |
35% excess
|
| 4 | Paul Bonang Jr | 105 | 5,898 | $3,952 | 56.2 mi | 6.6 mi | 689 | $462 | 56.2 |
12% excess
|
| 5 | Mohamed Shareed | 98 | 5,315 | $3,561 | 54.2 mi | 36.5 mi | 3,573 | $2,394 | 54.2 |
67% excess
|
| 6 | Jason Cunningham | 3 | 4,230 | $2,834 | 1410.1 mi | 1400.2 mi | 4,201 | $2,815 | 1410 |
99% excess
|
| 7 | David Cavaco | 98 | 4,148 | $2,779 | 42.3 mi | 28.7 mi | 2,814 | $1,885 | 42.3 |
68% excess
|
| 8 | Pete Ramos | 100 | 3,831 | $2,567 | 38.3 mi | 14.2 mi | 1,422 | $953 | 38.3 |
37% excess
|
| 9 | Erwin Forster | 76 | 3,740 | $2,506 | 49.2 mi | 19.2 mi | 1,463 | $980 | 49.2 |
39% excess
|
| 10 | Edward Arias | 81 | 3,592 | $2,407 | 44.3 mi | 28.6 mi | 2,320 | $1,554 | 44.3 |
65% excess
|
| 11 | Bernard Thompson | 54 | 2,901 | $1,944 | 53.7 mi | 17.6 mi | 953 | $639 | 53.7 |
33% excess
|
| 12 | Nick O'Neill | 61 | 2,832 | $1,897 | 46.4 mi | 39.2 mi | 2,392 | $1,603 | 46.4 |
84% excess
|
| 13 | David Trost | 102 | 2,588 | $1,734 | 25.4 mi | 9.5 mi | 966 | $647 | 25.4 |
37% excess
|
| 14 | Darrell Hope | 80 | 2,120 | $1,420 | 26.5 mi | 8.6 mi | 691 | $463 | 26.5 |
33% excess
|
| 15 | Curtis Allen | 92 | 2,063 | $1,382 | 22.4 mi | 6.4 mi | 589 | $395 | 22.4 |
29% excess
|
| 16 | Darek Kirkpatrick | 40 | 965 | $647 | 24.1 mi | 7.5 mi | 299 | $200 | 24.1 |
31% excess
|
| 17 | Taylor Duda | 21 | 868 | $582 | 41.3 mi | 27.3 mi | 574 | $385 | 41.3 |
66% excess
|
| 18 | Hector Castaneda | 7 | 718 | $481 | 102.5 mi | 102.5 mi | 718 | $481 | 102.6 |
100% excess
|
| 19 | Jim Kingery | 2 | 110 | $74 | 55 mi | 54.4 mi | 109 | $73 | 55 |
99% excess
|
| 20 | Shawn Rogers | 1 | 96 | $64 | 95.5 mi | -25.2 mi | 0 | $0 | 96 |
0% excess
|
| 21 | Brandon Green | 1 | 6 | $4 | 5.7 mi | 0 mi | 0 | $0 | 6 |
0% excess
|