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 | Philmon Mehari | 8 | 7,745 | $5,189 | 968.2 mi | 928.1 mi | 7,425 | $4,975 | 968.1 |
96% excess
|
| 2 | Luis Iser | 38 | 5,080 | $3,404 | 133.7 mi | 88.2 mi | 3,351 | $2,245 | 133.7 |
66% excess
|
| 3 | Derick Velazquez | 33 | 3,340 | $2,238 | 101.2 mi | 43.4 mi | 1,432 | $959 | 101.2 |
43% excess
|
| 4 | Jared Heisler | 36 | 2,443 | $1,637 | 67.9 mi | 1.9 mi | 67 | $45 | 67.9 |
3% excess
|
| 5 | Konstantin Barskiy | 2 | 1,860 | $1,246 | 930.2 mi | 924.5 mi | 1,849 | $1,239 | 930 |
99% excess
|
| 6 | Fady Messak | 2 | 1,797 | $1,204 | 898.5 mi | 815.6 mi | 1,631 | $1,093 | 898.5 |
91% excess
|
| 7 | Fady Khouzam | 2 | 1,782 | $1,194 | 890.7 mi | 880.6 mi | 1,761 | $1,180 | 891 |
99% excess
|
| 8 | Raymond Ebanks | 8 | 1,111 | $744 | 138.8 mi | 84.4 mi | 675 | $452 | 138.9 |
61% excess
|
| 9 | Horace Barnes | 3 | 174 | $117 | 57.9 mi | 44.3 mi | 133 | $89 | 58 |
76% excess
|
| 10 | Robert Lewis | 4 | 27 | $18 | 6.9 mi | 1.1 mi | 5 | $3 | 6.8 |
19% excess
|