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 | 13 | 19,481 | $13,052 | 1498.6 mi | 1361.2 mi | 17,695 | $11,856 | 1498.5 |
91% excess
|
| 2 | Joseph Nuovo | 60 | 5,224 | $3,500 | 87.1 mi | 1.4 mi | 87 | $58 | 87.1 |
2% excess
|
| 3 | Davon Cox | 3 | 2,776 | $1,860 | 925.4 mi | 894.6 mi | 2,684 | $1,798 | 925.3 |
97% excess
|
| 4 | Fady Messak | 17 | 1,915 | $1,283 | 112.7 mi | 60 mi | 1,019 | $683 | 112.6 |
53% excess
|
| 5 | Jared Heisler | 1 | 1,011 | $677 | 1010.8 mi | 945.6 mi | 946 | $634 | 1011 |
94% excess
|
| 6 | Jason Yenser | 2 | 172 | $115 | 85.9 mi | 58.8 mi | 118 | $79 | 86 |
69% excess
|
| 7 | April Nuovo | 1 | 112 | $75 | 112 mi | 84.7 mi | 85 | $57 | 112 |
76% excess
|
| 8 | Israel Martell | 1 | 35 | $23 | 34.8 mi | 25.6 mi | 26 | $17 | 35 |
74% excess
|
| 9 | Jackson Reeves | 1 | 32 | $21 | 31.7 mi | 0 mi | 0 | $0 | 32 |
0% excess
|
| 10 | Carlos Puebla | 1 | 24 | $16 | 23.8 mi | 19.1 mi | 19 | $13 | 24 |
79% excess
|
| 11 | Fady Khouzam | 1 | 18 | $12 | 17.9 mi | 14.6 mi | 15 | $10 | 18 |
83% excess
|