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 | 2 | 1,318 | $883 | 658.8 mi | 653.2 mi | 1,306 | $875 | 659 |
99% excess
|
| 2 | Fady Khouzam | 12 | 765 | $513 | 63.8 mi | 57.1 mi | 685 | $459 | 63.8 |
90% excess
|
| 3 | Alberto Galan | 5 | 195 | $131 | 39.0 mi | 27.8 mi | 139 | $93 | 39 |
71% excess
|
| 4 | Bryan Rodriguez | 4 | 106 | $71 | 26.5 mi | 17.2 mi | 69 | $46 | 26.5 |
65% excess
|
| 5 | Israel Martell | 3 | 91 | $61 | 30.3 mi | 20.3 mi | 61 | $41 | 30.3 |
67% excess
|
| 6 | Philmon Mehari | 2 | 87 | $58 | 43.6 mi | 22.5 mi | 45 | $30 | 43.5 |
52% excess
|
| 7 | Fady Messak | 2 | 75 | $50 | 37.5 mi | 26.4 mi | 53 | $36 | 37.5 |
71% excess
|
| 8 | Shady Messak | 2 | 38 | $25 | 18.9 mi | 10.2 mi | 20 | $13 | 19 |
53% excess
|
| 9 | Carlos Puebla | 2 | 37 | $25 | 18.5 mi | 4.0 mi | 8 | $5 | 18.5 |
22% excess
|
| 10 | Konstantin Barskiy | 1 | 31 | $21 | 31.0 mi | 20.4 mi | 20 | $13 | 31 |
65% excess
|
| 11 | Davon Cox | 1 | 27 | $18 | 26.5 mi | 23.2 mi | 23 | $15 | 27 |
85% excess
|