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 | Nkosi Wilson | 27 | 20,564 | $13,778 | 761.6 mi | 738.4 mi | 19,937 | $13,358 | 761.6 |
97% excess
|
| 2 | Christopher Carroll | 8 | 8,746 | $5,860 | 1093.2 mi | 1075.8 mi | 8,606 | $5,766 | 1093.3 |
98% excess
|
| 3 | Megan Allen | 3 | 4,526 | $3,032 | 1508.7 mi | 1480.7 mi | 4,442 | $2,976 | 1508.7 |
98% excess
|
| 4 | Eric Mancerella | 19 | 4,440 | $2,975 | 233.7 mi | 56 mi | 1,065 | $714 | 233.7 |
24% excess
|
| 5 | Erwin Forster | 84 | 4,316 | $2,892 | 51.4 mi | 20.9 mi | 1,759 | $1,179 | 51.4 |
41% excess
|
| 6 | Andre Samuda | 166 | 4,102 | $2,748 | 24.7 mi | 7 mi | 1,165 | $781 | 24.7 |
28% excess
|
| 7 | Bryan Rodriguez | 36 | 3,984 | $2,669 | 110.7 mi | 21.8 mi | 785 | $526 | 110.7 |
20% excess
|
| 8 | James Duff | 5 | 3,788 | $2,538 | 757.6 mi | 755.3 mi | 3,776 | $2,530 | 757.6 |
100% excess
|
| 9 | Scott A Berry | 8 | 3,633 | $2,434 | 454.2 mi | 433.3 mi | 3,466 | $2,322 | 454.1 |
95% excess
|
| 10 | Horace Barnes | 3 | 3,363 | $2,253 | 1121 mi | 989 mi | 2,967 | $1,988 | 1121 |
88% excess
|
| 11 | Rodney Charles | 13 | 2,658 | $1,781 | 204.5 mi | 63.6 mi | 826 | $553 | 204.5 |
31% excess
|
| 12 | Bernard Thompson | 53 | 2,595 | $1,739 | 49 mi | 16.5 mi | 872 | $584 | 49 |
34% excess
|
| 13 | Vivian Hyde | 135 | 2,457 | $1,646 | 18.2 mi | 5.9 mi | 794 | $532 | 18.2 |
32% excess
|
| 14 | Davon Cox | 27 | 2,041 | $1,367 | 75.6 mi | 16.2 mi | 439 | $294 | 75.6 |
22% excess
|
| 15 | April Nuovo | 11 | 1,677 | $1,124 | 152.5 mi | 47.4 mi | 521 | $349 | 152.5 |
31% excess
|
| 16 | Sean Currie | 1 | 1,625 | $1,089 | 1625.1 mi | 1492.4 mi | 1,492 | $1,000 | 1625 |
92% excess
|
| 17 | Mohamed Shareed | 46 | 1,586 | $1,063 | 34.5 mi | 11.8 mi | 544 | $364 | 34.5 |
34% excess
|
| 18 | Edward Arias | 41 | 1,438 | $963 | 35.1 mi | 16.4 mi | 671 | $450 | 35.1 |
47% excess
|
| 19 | Fady Messak | 20 | 1,415 | $948 | 70.7 mi | 48 mi | 959 | $643 | 70.8 |
68% excess
|
| 20 | Joseph Nuovo | 8 | 1,338 | $896 | 167.2 mi | 24.4 mi | 195 | $131 | 167.3 |
15% excess
|
| 21 | David Trost | 73 | 1,277 | $856 | 17.5 mi | 5.1 mi | 370 | $248 | 17.5 |
29% excess
|
| 22 | Robert Butler | 1 | 1,253 | $840 | 1253.1 mi | 1200.3 mi | 1,200 | $804 | 1253 |
96% excess
|
| 23 | Philmon Mehari | 17 | 1,233 | $826 | 72.5 mi | 10.8 mi | 184 | $123 | 72.5 |
15% excess
|
| 24 | Fady Khouzam | 47 | 1,154 | $773 | 24.6 mi | 10.7 mi | 505 | $338 | 24.6 |
44% excess
|
| 25 | Alberto Galan | 37 | 1,135 | $760 | 30.7 mi | 17.7 mi | 654 | $438 | 30.7 |
58% excess
|
| 26 | Israel Martell | 69 | 1,060 | $710 | 15.4 mi | 4.6 mi | 315 | $211 | 15.4 |
30% excess
|
| 27 | Darek Kirkpatrick | 42 | 1,036 | $694 | 24.7 mi | 7.1 mi | 299 | $200 | 24.7 |
29% excess
|
| 28 | Luis Torres | 10 | 935 | $626 | 93.5 mi | 26.2 mi | 262 | $176 | 93.5 |
28% excess
|
| 29 | Taylor Duda | 22 | 911 | $610 | 41.4 mi | 26.9 mi | 593 | $397 | 41.4 |
65% excess
|
| 30 | Darrell Hope | 51 | 900 | $603 | 17.6 mi | 3 mi | 155 | $104 | 17.6 |
17% excess
|