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 | Marvin Rivas | 8 | 12,914 | $8,652 | 1614.2 mi | 855.0 mi | 6,840 | $4,583 | 1614.3 |
53% excess
|
| 2 | Jackson Reeves | 7 | 10,164 | $6,810 | 1452.0 mi | 919.0 mi | 6,433 | $4,310 | 1452 |
63% excess
|
| 3 | Fady Messak | 2 | 4,238 | $2,839 | 2119.1 mi | 1286.5 mi | 2,573 | $1,724 | 2119 |
61% excess
|
| 4 | Luis Iser | 1 | 2,433 | $1,630 | 2433.4 mi | 1704.2 mi | 1,704 | $1,142 | 2433 |
70% excess
|
| 5 | Michah Brackett | 30 | 2,428 | $1,627 | 80.9 mi | 4.0 mi | 120 | $80 | 80.9 |
5% excess
|
| 6 | Nkosi Wilson | 1 | 1,874 | $1,256 | 1873.7 mi | 1144.5 mi | 1,144 | $766 | 1874 |
61% excess
|
| 7 | Kwame Cobb | 2 | 1,350 | $905 | 674.8 mi | 151.3 mi | 303 | $203 | 675 |
22% excess
|
| 8 | Michael Russell | 1 | 446 | $299 | 445.8 mi | 380.4 mi | 380 | $255 | 446 |
85% excess
|