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 | 28 | 17,006 | $11,394 | 607.4 mi | 584.6 mi | 16,370 | $10,968 | 607.4 |
96% excess
|
| 2 | Philmon Mehari | 28 | 8,883 | $5,952 | 317.3 mi | 281.2 mi | 7,874 | $5,276 | 317.3 |
89% excess
|
| 3 | Fady Khouzam | 18 | 4,969 | $3,329 | 276 mi | 225.3 mi | 4,055 | $2,717 | 276.1 |
82% excess
|
| 4 | Jared Heisler | 36 | 2,443 | $1,637 | 67.9 mi | 1.9 mi | 67 | $45 | 67.9 |
3% excess
|
| 5 | Fady Messak | 5 | 1,916 | $1,284 | 383.2 mi | 339.9 mi | 1,699 | $1,138 | 383.2 |
89% excess
|
| 6 | Rodney Charles | 8 | 1,371 | $919 | 171.4 mi | 60.2 mi | 482 | $323 | 171.4 |
35% excess
|
| 7 | Jason Yenser | 21 | 1,353 | $907 | 64.5 mi | 37.5 mi | 787 | $527 | 64.4 |
58% excess
|
| 8 | Patricia Gordon | 9 | 1,286 | $862 | 142.8 mi | 42.5 mi | 383 | $257 | 142.9 |
30% excess
|
| 9 | Luis Iser | 12 | 1,018 | $682 | 84.8 mi | 72.4 mi | 869 | $582 | 84.8 |
85% excess
|
| 10 | Derick Velazquez | 4 | 977 | $655 | 244.2 mi | 210.8 mi | 843 | $565 | 244.3 |
86% excess
|
| 11 | Rick Charles | 20 | 803 | $538 | 40.2 mi | 0.4 mi | 8 | $5 | 40.2 |
1% excess
|
| 12 | Allan Klus | 10 | 712 | $477 | 71.2 mi | 14.6 mi | 146 | $98 | 71.2 |
21% excess
|
| 13 | Ryan Lewis | 2 | 632 | $423 | 315.9 mi | 259.2 mi | 518 | $347 | 316 |
82% excess
|
| 14 | Raymond Ebanks | 5 | 589 | $395 | 117.8 mi | 34.1 mi | 170 | $114 | 117.8 |
29% excess
|
| 15 | Jackson Reeves | 12 | 501 | $336 | 41.7 mi | 11.3 mi | 136 | $91 | 41.8 |
27% excess
|
| 16 | Vivian Hyde | 15 | 432 | $289 | 28.8 mi | 13.3 mi | 199 | $133 | 28.8 |
46% excess
|
| 17 | Fanfan Siku | 5 | 399 | $267 | 79.7 mi | 38.6 mi | 193 | $129 | 79.8 |
48% excess
|
| 18 | Joe Hudson | 3 | 347 | $232 | 115.7 mi | 51.9 mi | 156 | $105 | 115.7 |
45% excess
|
| 19 | Jeffrey Coles | 5 | 263 | $176 | 52.6 mi | 15.4 mi | 77 | $52 | 52.6 |
29% excess
|
| 20 | April Nuovo | 4 | 258 | $173 | 64.4 mi | 0 mi | 0 | $0 | 64.5 |
0% excess
|
| 21 | Carlos Puebla | 9 | 248 | $166 | 27.5 mi | 10.7 mi | 97 | $65 | 27.6 |
39% excess
|
| 22 | Bennet O Dartey | 1 | 211 | $141 | 211.1 mi | 134.5 mi | 135 | $90 | 211 |
64% excess
|
| 23 | Marvin Rivas | 21 | 210 | $141 | 10 mi | 0 mi | 0 | $0 | 10 |
0% excess
|
| 24 | Shady Messak | 4 | 199 | $133 | 49.9 mi | 31.4 mi | 125 | $84 | 49.8 |
63% excess
|
| 25 | Davon Cox | 5 | 183 | $123 | 36.6 mi | 16.2 mi | 81 | $54 | 36.6 |
44% excess
|
| 26 | Bruce Ballard | 2 | 161 | $108 | 80.4 mi | 48 mi | 96 | $64 | 80.5 |
60% excess
|
| 27 | Konstantin Barskiy | 2 | 127 | $85 | 63.7 mi | 47.4 mi | 95 | $64 | 63.5 |
75% excess
|
| 28 | Andre Samuda | 4 | 114 | $76 | 28.5 mi | 21.9 mi | 88 | $59 | 28.5 |
77% excess
|
| 29 | Bryan Rodriguez | 2 | 113 | $76 | 56.3 mi | 14.5 mi | 29 | $19 | 56.5 |
26% excess
|
| 30 | Alberto Galan | 3 | 80 | $54 | 26.7 mi | 10.8 mi | 32 | $21 | 26.7 |
40% excess
|