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 | 12 | 1,995 | $1,337 | 166.2 mi | 148.6 mi | 1,783 | $1,195 | 166.3 |
89% excess
|
| 2 | Nkosi Wilson | 2 | 1,318 | $883 | 658.8 mi | 653.2 mi | 1,306 | $875 | 659 |
99% excess
|
| 3 | Fady Messak | 21 | 1,100 | $737 | 52.4 mi | 38.6 mi | 810 | $543 | 52.4 |
74% excess
|
| 4 | Fady Khouzam | 16 | 904 | $606 | 56.5 mi | 48.3 mi | 772 | $517 | 56.5 |
85% excess
|
| 5 | Alberto Galan | 19 | 591 | $396 | 31.1 mi | 21.8 mi | 415 | $278 | 31.1 |
70% excess
|
| 6 | Rodney Charles | 2 | 272 | $182 | 136.0 mi | 99.6 mi | 199 | $133 | 136 |
73% excess
|
| 7 | Israel Martell | 17 | 264 | $177 | 15.6 mi | 7.8 mi | 132 | $88 | 15.5 |
50% excess
|
| 8 | Luis Iser | 1 | 216 | $145 | 216.3 mi | 202.1 mi | 202 | $135 | 216 |
94% excess
|
| 9 | Philmon Mehari | 5 | 143 | $96 | 28.5 mi | 17.7 mi | 89 | $60 | 28.6 |
62% excess
|
| 10 | Allan Klus | 1 | 139 | $93 | 139.4 mi | 115.5 mi | 116 | $78 | 139 |
83% excess
|
| 11 | Shady Messak | 4 | 113 | $76 | 28.2 mi | 21.9 mi | 88 | $59 | 28.3 |
78% excess
|
| 12 | Bryan Rodriguez | 4 | 106 | $71 | 26.5 mi | 17.2 mi | 69 | $46 | 26.5 |
65% excess
|
| 13 | Carlos Puebla | 2 | 37 | $25 | 18.5 mi | 4.0 mi | 8 | $5 | 18.5 |
22% excess
|
| 14 | April Nuovo | 1 | 35 | $23 | 35.0 mi | 0.0 mi | 0 | $0 | 35 |
0% excess
|
| 15 | Davon Cox | 1 | 27 | $18 | 26.5 mi | 23.2 mi | 23 | $15 | 27 |
85% excess
|
| 16 | Eric Mancerella | 1 | 23 | $15 | 22.7 mi | 19.1 mi | 19 | $13 | 23 |
83% excess
|
| 17 | Samuel Biddie | 1 | 23 | $15 | 23.3 mi | 0.0 mi | 0 | $0 | 23 |
0% excess
|
| 18 | Patricia Gordon | 1 | 18 | $12 | 18.0 mi | 0.0 mi | 0 | $0 | 18 |
0% excess
|