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 | Patricia Gordon | 149 | 14,255 | $9,551 | 95.7 mi | 33.2 mi | 4,943 | $3,312 | 95.7 |
35% excess
|
| 2 | Marvin Rivas | 6 | 6,368 | $4,267 | 1061.4 mi | 998.8 mi | 5,993 | $4,015 | 1061.3 |
94% excess
|
| 3 | Bruce Ballard | 14 | 3,276 | $2,195 | 234.0 mi | 216.0 mi | 3,025 | $2,027 | 234 |
92% excess
|
| 4 | Fady Messak | 8 | 3,271 | $2,192 | 408.9 mi | 297.8 mi | 2,382 | $1,596 | 408.9 |
73% excess
|
| 5 | Ryan Lewis | 6 | 1,374 | $921 | 229.1 mi | 130.9 mi | 785 | $526 | 229 |
57% excess
|