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 | Luis Iser | 38 | 5,080 | $3,404 | 133.7 mi | 88.2 mi | 3,351 | $2,245 | 133.7 |
66% excess
|
| 4 | Fady Khouzam | 18 | 4,969 | $3,329 | 276 mi | 225.3 mi | 4,055 | $2,717 | 276.1 |
82% excess
|
| 5 | Derick Velazquez | 34 | 4,194 | $2,810 | 123.4 mi | 66.8 mi | 2,271 | $1,522 | 123.4 |
54% excess
|
| 6 | Jared Heisler | 36 | 2,443 | $1,637 | 67.9 mi | 1.9 mi | 67 | $45 | 67.9 |
3% excess
|
| 7 | Konstantin Barskiy | 4 | 1,988 | $1,332 | 497 mi | 485.9 mi | 1,944 | $1,302 | 497 |
98% excess
|
| 8 | Fady Messak | 5 | 1,916 | $1,284 | 383.2 mi | 339.9 mi | 1,699 | $1,138 | 383.2 |
89% excess
|
| 9 | Rodney Charles | 8 | 1,371 | $919 | 171.4 mi | 60.2 mi | 482 | $323 | 171.4 |
35% excess
|
| 10 | Jason Yenser | 21 | 1,353 | $907 | 64.5 mi | 37.5 mi | 787 | $527 | 64.4 |
58% excess
|
| 11 | Patricia Gordon | 9 | 1,286 | $862 | 142.8 mi | 42.5 mi | 383 | $257 | 142.9 |
30% excess
|
| 12 | Raymond Ebanks | 8 | 1,111 | $744 | 138.8 mi | 84.4 mi | 675 | $452 | 138.9 |
61% excess
|
| 13 | Rick Charles | 20 | 803 | $538 | 40.2 mi | 0.4 mi | 8 | $5 | 40.2 |
1% excess
|
| 14 | Allan Klus | 10 | 712 | $477 | 71.2 mi | 14.6 mi | 146 | $98 | 71.2 |
21% excess
|
| 15 | Ryan Lewis | 2 | 632 | $423 | 315.9 mi | 259.2 mi | 518 | $347 | 316 |
82% excess
|
| 16 | Jackson Reeves | 12 | 501 | $336 | 41.7 mi | 11.3 mi | 136 | $91 | 41.8 |
27% excess
|
| 17 | Vivian Hyde | 15 | 432 | $289 | 28.8 mi | 13.3 mi | 199 | $133 | 28.8 |
46% excess
|
| 18 | Fanfan Siku | 5 | 399 | $267 | 79.7 mi | 38.6 mi | 193 | $129 | 79.8 |
48% excess
|
| 19 | Joe Hudson | 3 | 347 | $232 | 115.7 mi | 51.9 mi | 156 | $105 | 115.7 |
45% excess
|
| 20 | Jeffrey Coles | 5 | 263 | $176 | 52.6 mi | 15.4 mi | 77 | $52 | 52.6 |
29% excess
|
| 21 | April Nuovo | 4 | 258 | $173 | 64.4 mi | 0 mi | 0 | $0 | 64.5 |
0% excess
|
| 22 | Carlos Puebla | 9 | 248 | $166 | 27.5 mi | 10.7 mi | 97 | $65 | 27.6 |
39% excess
|
| 23 | Bennet O Dartey | 1 | 211 | $141 | 211.1 mi | 134.5 mi | 135 | $90 | 211 |
64% excess
|
| 24 | Marvin Rivas | 21 | 210 | $141 | 10 mi | 0 mi | 0 | $0 | 10 |
0% excess
|
| 25 | Shady Messak | 4 | 199 | $133 | 49.9 mi | 31.4 mi | 125 | $84 | 49.8 |
63% excess
|
| 26 | Davon Cox | 5 | 183 | $123 | 36.6 mi | 16.2 mi | 81 | $54 | 36.6 |
44% excess
|
| 27 | Horace Barnes | 3 | 174 | $117 | 57.9 mi | 44.3 mi | 133 | $89 | 58 |
76% excess
|
| 28 | Bruce Ballard | 2 | 161 | $108 | 80.4 mi | 48 mi | 96 | $64 | 80.5 |
60% excess
|
| 29 | Andre Samuda | 4 | 114 | $76 | 28.5 mi | 21.9 mi | 88 | $59 | 28.5 |
77% excess
|
| 30 | Bryan Rodriguez | 2 | 113 | $76 | 56.3 mi | 14.5 mi | 29 | $19 | 56.5 |
26% excess
|