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 | 204 | 192,518 | $128,987 | 943.7 mi | 928.4 mi | 189,403 | $126,900 | 943.7 |
98% excess
|
| 2 | Raymond Ebanks | 191 | 29,142 | $19,525 | 152.6 mi | 139.4 mi | 26,631 | $17,843 | 152.6 |
91% excess
|
| 3 | Luis Iser | 146 | 27,431 | $18,379 | 187.9 mi | 177.2 mi | 25,877 | $17,338 | 187.9 |
94% excess
|
| 4 | Ryan Lewis | 23 | 10,103 | $6,769 | 439.3 mi | 433.5 mi | 9,971 | $6,681 | 439.3 |
99% excess
|
| 5 | Horace Barnes | 114 | 7,785 | $5,216 | 68.3 mi | 59.9 mi | 6,831 | $4,577 | 68.3 |
88% excess
|
| 6 | Derick Velazquez | 297 | 3,080 | $2,064 | 10.4 mi | 3.1 mi | 918 | $615 | 10.4 |
30% excess
|
| 7 | Robert Lewis | 259 | 2,174 | $1,457 | 8.4 mi | 1.9 mi | 502 | $336 | 8.4 |
23% excess
|
| 8 | Andre Samuda | 2 | 2,036 | $1,364 | 1018.0 mi | 943.6 mi | 1,887 | $1,264 | 1018 |
93% excess
|
| 9 | Philmon Mehari | 2 | 1,928 | $1,292 | 964.1 mi | 922.0 mi | 1,844 | $1,235 | 964 |
96% excess
|
| 10 | Jared Heisler | 14 | 1,399 | $937 | 100.0 mi | 59.4 mi | 832 | $557 | 99.9 |
59% excess
|
| 11 | Davon Cox | 1 | 1,025 | $687 | 1024.9 mi | 991.8 mi | 992 | $665 | 1025 |
97% excess
|
| 12 | Fady Messak | 1 | 990 | $663 | 989.9 mi | 977.0 mi | 977 | $655 | 990 |
99% excess
|