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 | 27 | 16,839 | $11,282 | 623.7 mi | 612.1 mi | 16,526 | $11,072 | 623.7 |
98% excess
|
| 2 | Fady Messak | 15 | 726 | $486 | 48.4 mi | 37.5 mi | 562 | $377 | 48.4 |
77% excess
|
| 3 | Fady Khouzam | 12 | 603 | $404 | 50.3 mi | 43.3 mi | 519 | $348 | 50.3 |
86% excess
|
| 4 | Luis Iser | 2 | 439 | $294 | 219.5 mi | 209.5 mi | 419 | $281 | 219.5 |
95% excess
|
| 5 | Alberto Galan | 8 | 258 | $173 | 32.2 mi | 22.3 mi | 178 | $119 | 32.3 |
69% excess
|
| 6 | Horace Barnes | 3 | 217 | $145 | 72.3 mi | 66.5 mi | 200 | $134 | 72.3 |
92% excess
|
| 7 | Raymond Ebanks | 1 | 174 | $117 | 173.9 mi | 168.2 mi | 168 | $113 | 174 |
97% excess
|
| 8 | Israel Martell | 6 | 108 | $72 | 17.9 mi | 12.6 mi | 75 | $50 | 18 |
69% excess
|
| 9 | Bryan Rodriguez | 4 | 106 | $71 | 26.5 mi | 17.2 mi | 69 | $46 | 26.5 |
65% excess
|
| 10 | Robert Lewis | 7 | 66 | $44 | 9.5 mi | 3.8 mi | 27 | $18 | 9.4 |
41% excess
|
| 11 | Philmon Mehari | 1 | 44 | $29 | 43.8 mi | 27 mi | 27 | $18 | 44 |
61% excess
|
| 12 | Derick Velazquez | 5 | 29 | $19 | 5.7 mi | 0 mi | 0 | $0 | 5.8 |
0% excess
|
| 13 | Davon Cox | 1 | 27 | $18 | 26.5 mi | 23.2 mi | 23 | $15 | 27 |
85% excess
|
| 14 | Eric Mancerella | 1 | 23 | $15 | 22.7 mi | 19.1 mi | 19 | $13 | 23 |
83% excess
|
| 15 | Samuel Biddie | 1 | 23 | $15 | 23.3 mi | 0 mi | 0 | $0 | 23 |
0% excess
|