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 | Minh Huynh | 24 | 24,165 | $16,191 | 1006.9 mi | 986.5 mi | 23,675 | $15,862 | 1006.9 |
98% excess
|
| 2 | Shawn Kelley | 12 | 17,920 | $12,006 | 1493.4 mi | 1450.5 mi | 17,406 | $11,662 | 1493.3 |
97% excess
|
| 3 | VPD Bench | 471 | 2,025 | $1,357 | 4.3 mi | 4.3 mi | 2,006 | $1,344 | 4.3 |
99% excess
|
| 4 | Charles Sellon | 3 | 869 | $582 | 289.5 mi | 282.5 mi | 848 | $568 | 289.7 |
98% excess
|
| 5 | Tim Dinh | 3 | 48 | $32 | 16 mi | 15.9 mi | 48 | $32 | 16 |
100% excess
|