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 | 33 | 25,194 | $16,880 | 763.5 mi | 739.7 mi | 24,409 | $16,354 | 763.5 |
97% excess
|
| 2 | Bryan Rodriguez | 64 | 6,531 | $4,376 | 102.0 mi | 24.9 mi | 1,595 | $1,069 | 102 |
24% excess
|
| 3 | Sean Currie | 4 | 6,516 | $4,366 | 1628.9 mi | 1559.3 mi | 6,237 | $4,179 | 1629 |
96% excess
|
| 4 | Andre Samuda | 284 | 6,244 | $4,183 | 22.0 mi | 6.9 mi | 1,950 | $1,307 | 22 |
31% excess
|
| 5 | Vivian Hyde | 250 | 4,709 | $3,155 | 18.8 mi | 5.7 mi | 1,421 | $952 | 18.8 |
30% excess
|
| 6 | Eric Mancerella | 19 | 4,440 | $2,975 | 233.7 mi | 56.0 mi | 1,065 | $714 | 233.7 |
24% excess
|
| 7 | Fady Messak | 64 | 4,389 | $2,941 | 68.6 mi | 41.0 mi | 2,624 | $1,758 | 68.6 |
60% excess
|
| 8 | Fanfan Siku | 18 | 4,255 | $2,851 | 236.4 mi | 88.6 mi | 1,595 | $1,069 | 236.4 |
37% excess
|
| 9 | Joseph Nuovo | 24 | 4,194 | $2,810 | 174.8 mi | 50.4 mi | 1,211 | $811 | 174.8 |
29% excess
|
| 10 | Philmon Mehari | 65 | 3,938 | $2,638 | 60.6 mi | 14.8 mi | 965 | $647 | 60.6 |
25% excess
|
| 11 | Rodney Charles | 20 | 3,783 | $2,535 | 189.2 mi | 58.6 mi | 1,172 | $785 | 189.2 |
31% excess
|
| 12 | Davon Cox | 63 | 3,616 | $2,423 | 57.4 mi | 13.2 mi | 833 | $558 | 57.4 |
23% excess
|
| 13 | Alberto Galan | 124 | 3,515 | $2,355 | 28.3 mi | 18.4 mi | 2,279 | $1,527 | 28.3 |
65% excess
|
| 14 | Horace Barnes | 3 | 3,363 | $2,253 | 1121.0 mi | 989.0 mi | 2,967 | $1,988 | 1121 |
88% excess
|
| 15 | April Nuovo | 16 | 2,387 | $1,599 | 149.2 mi | 37.1 mi | 593 | $397 | 149.2 |
25% excess
|
| 16 | Shady Messak | 52 | 2,267 | $1,519 | 43.6 mi | 35.0 mi | 1,818 | $1,218 | 43.6 |
80% excess
|
| 17 | Luis Iser | 2 | 2,244 | $1,503 | 1122.2 mi | 1116.7 mi | 2,233 | $1,496 | 1122 |
100% excess
|
| 18 | Fady Khouzam | 59 | 2,144 | $1,436 | 36.3 mi | 16.2 mi | 953 | $639 | 36.3 |
44% excess
|
| 19 | Israel Martell | 131 | 1,746 | $1,170 | 13.3 mi | 4.8 mi | 623 | $417 | 13.3 |
36% excess
|
| 20 | Bruce Ballard | 2 | 1,677 | $1,124 | 838.4 mi | 706.0 mi | 1,412 | $946 | 838.5 |
84% excess
|
| 21 | Joe Hudson | 3 | 1,297 | $869 | 432.4 mi | 300.4 mi | 901 | $604 | 432.3 |
69% excess
|
| 22 | Carlos Puebla | 45 | 822 | $551 | 18.3 mi | 8.8 mi | 398 | $267 | 18.3 |
48% excess
|
| 23 | Bennet O Dartey | 1 | 698 | $468 | 698.3 mi | 565.6 mi | 566 | $379 | 698 |
81% excess
|
| 24 | Dillon Pilgrim | 26 | 494 | $331 | 19.0 mi | 9.8 mi | 254 | $170 | 19 |
51% excess
|
| 25 | Rick Charles | 5 | 468 | $314 | 93.6 mi | 75.0 mi | 375 | $251 | 93.6 |
80% excess
|
| 26 | Konstantin Barskiy | 3 | 325 | $218 | 108.4 mi | 12.4 mi | 37 | $25 | 108.3 |
11% excess
|
| 27 | Allan Klus | 1 | 322 | $216 | 322.0 mi | 133.8 mi | 134 | $90 | 322 |
42% excess
|
| 28 | Michael Steencken | 1 | 111 | $74 | 111.3 mi | 109.4 mi | 109 | $73 | 111 |
98% excess
|
| 29 | Jason Yenser | 1 | 90 | $60 | 89.9 mi | 45.0 mi | 45 | $30 | 90 |
50% excess
|