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 | 44 | 44,349 | $29,714 | 1007.9 mi | 960.9 mi | 42,279 | $28,327 | 1007.9 |
95% excess
|
| 2 | Fady Messak | 17 | 15,565 | $10,429 | 915.6 mi | 872.5 mi | 14,833 | $9,938 | 915.6 |
95% excess
|
| 3 | Philmon Mehari | 15 | 14,671 | $9,830 | 978.1 mi | 938 mi | 14,070 | $9,427 | 978.1 |
96% excess
|
| 4 | Luis Iser | 113 | 9,677 | $6,484 | 85.6 mi | 63.4 mi | 7,161 | $4,798 | 85.6 |
74% excess
|
| 5 | Raymond Ebanks | 78 | 6,839 | $4,582 | 87.7 mi | 56.8 mi | 4,432 | $2,969 | 87.7 |
65% excess
|
| 6 | Jared Heisler | 96 | 5,991 | $4,014 | 62.4 mi | 12.9 mi | 1,237 | $829 | 62.4 |
21% excess
|
| 7 | Derick Velazquez | 64 | 3,763 | $2,521 | 58.8 mi | 32.6 mi | 2,087 | $1,398 | 58.8 |
55% excess
|
| 8 | Fady Khouzam | 4 | 3,668 | $2,458 | 917.1 mi | 878.3 mi | 3,513 | $2,354 | 917 |
96% excess
|
| 9 | Marvin Rivas | 2 | 1,930 | $1,293 | 965.2 mi | 953.9 mi | 1,908 | $1,278 | 965 |
99% excess
|
| 10 | Horace Barnes | 29 | 1,232 | $825 | 42.5 mi | 16.6 mi | 483 | $324 | 42.5 |
39% excess
|
| 11 | Joseph Nuovo | 1 | 1,122 | $752 | 1121.5 mi | 1108.6 mi | 1,109 | $743 | 1122 |
99% excess
|
| 12 | Bryan Rodriguez | 1 | 1,062 | $712 | 1062.3 mi | 962.5 mi | 963 | $645 | 1062 |
91% excess
|
| 13 | Rick Charles | 1 | 885 | $593 | 885.3 mi | 871.1 mi | 871 | $584 | 885 |
98% excess
|
| 14 | Joe Hudson | 1 | 700 | $469 | 700 mi | 697.4 mi | 697 | $467 | 700 |
100% excess
|