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 | Mohamed Shareed | 90 | 5,144 | $3,446 | 57.2 mi | 39.1 mi | 3,518 | $2,357 | 57.2 |
68% excess
|
| 3 | Jason Cunningham | 3 | 4,230 | $2,834 | 1410.1 mi | 1400.2 mi | 4,201 | $2,815 | 1410 |
99% excess
|
| 4 | David Cavaco | 95 | 4,032 | $2,701 | 42.4 mi | 29 mi | 2,752 | $1,844 | 42.4 |
68% excess
|
| 5 | Edward Arias | 65 | 3,065 | $2,054 | 47.2 mi | 32.4 mi | 2,109 | $1,413 | 47.2 |
69% excess
|
| 6 | Nick O'Neill | 60 | 2,832 | $1,897 | 47.2 mi | 39.9 mi | 2,392 | $1,603 | 47.2 |
84% excess
|
| 7 | Christopher Carroll | 4 | 2,721 | $1,823 | 680.3 mi | 680.3 mi | 2,721 | $1,823 | 680.3 |
100% excess
|
| 8 | Erwin Forster | 36 | 2,156 | $1,445 | 59.9 mi | 40.6 mi | 1,463 | $980 | 59.9 |
68% excess
|
| 9 | Paul Bonang Jr | 39 | 1,806 | $1,210 | 46.3 mi | 14.9 mi | 581 | $389 | 46.3 |
32% excess
|
| 10 | Luis Torres | 31 | 1,707 | $1,144 | 55.1 mi | 31 mi | 960 | $643 | 55.1 |
56% excess
|
| 11 | Bernard Thompson | 32 | 1,631 | $1,093 | 51 mi | 22.7 mi | 727 | $487 | 51 |
45% excess
|
| 12 | Pete Ramos | 37 | 1,277 | $856 | 34.5 mi | 16.6 mi | 614 | $411 | 34.5 |
48% excess
|
| 13 | David Trost | 53 | 1,157 | $775 | 21.8 mi | 9.9 mi | 527 | $353 | 21.8 |
46% excess
|
| 14 | Taylor Duda | 19 | 849 | $569 | 44.7 mi | 29.8 mi | 567 | $380 | 44.7 |
67% excess
|
| 15 | Darek Kirkpatrick | 33 | 747 | $500 | 22.6 mi | 8.4 mi | 278 | $186 | 22.6 |
37% excess
|
| 16 | Hector Castaneda | 5 | 718 | $481 | 143.5 mi | 143.5 mi | 718 | $481 | 143.6 |
100% excess
|
| 17 | Darrell Hope | 25 | 595 | $399 | 23.8 mi | 11.8 mi | 295 | $198 | 23.8 |
50% excess
|
| 18 | Curtis Allen | 7 | 120 | $80 | 17.1 mi | 4.9 mi | 34 | $23 | 17.1 |
28% excess
|