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 | 19 | 13,538 | $9,070 | 712.5 mi | 698.2 mi | 13,265 | $8,888 | 712.5 |
98% excess
|
| 2 | Jason Yenser | 17 | 1,213 | $813 | 71.3 mi | 46.0 mi | 782 | $524 | 71.4 |
64% excess
|
| 3 | Philmon Mehari | 17 | 1,009 | $676 | 59.4 mi | 23.4 mi | 399 | $267 | 59.4 |
40% excess
|
| 4 | Fady Khouzam | 8 | 574 | $385 | 71.8 mi | 47.2 mi | 378 | $253 | 71.8 |
66% excess
|
| 5 | Shady Messak | 11 | 480 | $322 | 43.7 mi | 29.2 mi | 322 | $216 | 43.6 |
67% excess
|
| 6 | Carlos Puebla | 9 | 248 | $166 | 27.5 mi | 10.7 mi | 97 | $65 | 27.6 |
39% excess
|
| 7 | Vivian Hyde | 9 | 195 | $131 | 21.7 mi | 11.4 mi | 103 | $69 | 21.7 |
53% excess
|
| 8 | Fady Messak | 4 | 190 | $127 | 47.5 mi | 17.1 mi | 68 | $46 | 47.5 |
36% excess
|
| 9 | Andre Samuda | 7 | 183 | $123 | 26.1 mi | 19.4 mi | 136 | $91 | 26.1 |
74% excess
|
| 10 | Davon Cox | 5 | 183 | $123 | 36.6 mi | 16.2 mi | 81 | $54 | 36.6 |
44% excess
|
| 11 | Rick Charles | 2 | 114 | $76 | 57.2 mi | 37.6 mi | 75 | $50 | 57 |
66% excess
|
| 12 | Alberto Galan | 4 | 113 | $76 | 28.2 mi | 13.6 mi | 54 | $36 | 28.3 |
48% excess
|
| 13 | Michael Steencken | 1 | 87 | $58 | 87.5 mi | 46.3 mi | 46 | $31 | 87 |
53% excess
|
| 14 | Bryan Rodriguez | 1 | 32 | $21 | 32.4 mi | 13.9 mi | 14 | $9 | 32 |
44% excess
|
| 15 | Konstantin Barskiy | 1 | 31 | $21 | 31.0 mi | 20.4 mi | 20 | $13 | 31 |
65% excess
|