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 | Konstantin Barskiy | 31 | 19,720 | $13,212 | 636.1 mi | 624.3 mi | 19,353 | $12,967 | 636.1 |
98% excess
|
| 2 | Luis Iser | 10 | 2,268 | $1,520 | 226.8 mi | 220.3 mi | 2,203 | $1,476 | 226.8 |
97% excess
|
| 3 | Raymond Ebanks | 8 | 1,357 | $909 | 169.6 mi | 162.7 mi | 1,301 | $872 | 169.6 |
96% excess
|
| 4 | Nkosi Wilson | 2 | 1,318 | $883 | 658.8 mi | 653.2 mi | 1,306 | $875 | 659 |
99% excess
|
| 5 | Fady Messak | 21 | 1,100 | $737 | 52.4 mi | 38.6 mi | 810 | $543 | 52.4 |
74% excess
|
| 6 | Fady Khouzam | 16 | 904 | $606 | 56.5 mi | 48.3 mi | 772 | $517 | 56.5 |
85% excess
|
| 7 | Alberto Galan | 19 | 591 | $396 | 31.1 mi | 21.8 mi | 415 | $278 | 31.1 |
70% excess
|
| 8 | Ryan Lewis | 1 | 437 | $293 | 436.8 mi | 431.0 mi | 431 | $289 | 437 |
99% excess
|
| 9 | Rodney Charles | 2 | 272 | $182 | 136.0 mi | 99.6 mi | 199 | $133 | 136 |
73% excess
|
| 10 | Horace Barnes | 4 | 271 | $182 | 67.8 mi | 59.9 mi | 240 | $161 | 67.8 |
89% excess
|
| 11 | Israel Martell | 17 | 264 | $177 | 15.6 mi | 7.8 mi | 132 | $88 | 15.5 |
50% excess
|
| 12 | Philmon Mehari | 5 | 143 | $96 | 28.5 mi | 17.7 mi | 89 | $60 | 28.6 |
62% excess
|
| 13 | Allan Klus | 1 | 139 | $93 | 139.4 mi | 115.5 mi | 116 | $78 | 139 |
83% excess
|
| 14 | Robert Lewis | 11 | 122 | $82 | 11.1 mi | 3.0 mi | 33 | $22 | 11.1 |
27% excess
|
| 15 | Shady Messak | 4 | 113 | $76 | 28.2 mi | 21.9 mi | 88 | $59 | 28.3 |
78% excess
|
| 16 | Derick Velazquez | 19 | 109 | $73 | 5.7 mi | 0.0 mi | 0 | $0 | 5.7 |
0% excess
|
| 17 | Bryan Rodriguez | 4 | 106 | $71 | 26.5 mi | 17.2 mi | 69 | $46 | 26.5 |
65% excess
|
| 18 | Carlos Puebla | 2 | 37 | $25 | 18.5 mi | 4.0 mi | 8 | $5 | 18.5 |
22% excess
|
| 19 | April Nuovo | 1 | 35 | $23 | 35.0 mi | 0.0 mi | 0 | $0 | 35 |
0% excess
|
| 20 | Davon Cox | 1 | 27 | $18 | 26.5 mi | 23.2 mi | 23 | $15 | 27 |
85% excess
|
| 21 | Eric Mancerella | 1 | 23 | $15 | 22.7 mi | 19.1 mi | 19 | $13 | 23 |
83% excess
|
| 22 | Samuel Biddie | 1 | 23 | $15 | 23.3 mi | 0.0 mi | 0 | $0 | 23 |
0% excess
|
| 23 | Patricia Gordon | 1 | 18 | $12 | 18.0 mi | 0.0 mi | 0 | $0 | 18 |
0% excess
|