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 | 12 | 17,991 | $12,054 | 1499.3 mi | 1361.8 mi | 16,341 | $10,948 | 1499.3 |
91% excess
|
| 2 | Joseph Nuovo | 59 | 5,093 | $3,412 | 86.3 mi | 1.5 mi | 87 | $58 | 86.3 |
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 | 18 | 2,115 | $1,417 | 117.5 mi | 59.2 mi | 1,066 | $714 | 117.5 |
50% excess
|
| 5 | Jason Yenser | 2 | 172 | $115 | 85.9 mi | 58.8 mi | 118 | $79 | 86 |
69% excess
|
| 6 | April Nuovo | 1 | 112 | $75 | 112.0 mi | 84.7 mi | 85 | $57 | 112 |
76% excess
|
| 7 | Israel Martell | 1 | 35 | $23 | 34.8 mi | 25.6 mi | 26 | $17 | 35 |
74% excess
|
| 8 | Jackson Reeves | 1 | 32 | $21 | 31.7 mi | 0.0 mi | 0 | $0 | 32 |
0% excess
|
| 9 | Carlos Puebla | 1 | 24 | $16 | 23.8 mi | 19.1 mi | 19 | $13 | 24 |
79% excess
|
| 10 | Fady Khouzam | 1 | 18 | $12 | 17.9 mi | 14.6 mi | 15 | $10 | 18 |
83% excess
|