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 | 14 | 10,063 | $6,742 | 718.8 mi | 701.3 mi | 9,818 | $6,578 | 718.8 |
98% excess
|
| 2 | Jason Yenser | 15 | 1,068 | $716 | 71.2 mi | 45 mi | 676 | $453 | 71.2 |
63% 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 | Carlos Puebla | 9 | 248 | $166 | 27.5 mi | 10.7 mi | 97 | $65 | 27.6 |
39% excess
|
| 6 | Shady Messak | 4 | 199 | $133 | 49.9 mi | 31.4 mi | 125 | $84 | 49.8 |
63% excess
|
| 7 | Davon Cox | 5 | 183 | $123 | 36.6 mi | 16.2 mi | 81 | $54 | 36.6 |
44% excess
|
| 8 | Vivian Hyde | 7 | 141 | $94 | 20.2 mi | 12.3 mi | 86 | $58 | 20.1 |
61% excess
|
| 9 | Fady Messak | 3 | 119 | $80 | 39.7 mi | 22.8 mi | 68 | $46 | 39.7 |
57% excess
|
| 10 | Andre Samuda | 4 | 114 | $76 | 28.5 mi | 21.9 mi | 88 | $59 | 28.5 |
77% excess
|
| 11 | Alberto Galan | 3 | 80 | $54 | 26.7 mi | 10.8 mi | 32 | $21 | 26.7 |
40% excess
|
| 12 | Bryan Rodriguez | 1 | 32 | $21 | 32.4 mi | 13.9 mi | 14 | $9 | 32 |
44% excess
|
| 13 | Konstantin Barskiy | 1 | 31 | $21 | 30.9 mi | 20.4 mi | 20 | $13 | 31 |
65% excess
|
| 14 | Rick Charles | 1 | 29 | $19 | 28.7 mi | 0 mi | 0 | $0 | 29 |
0% excess
|