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 | Bruce Ballard | 61 | 4,621 | $3,096 | 75.8 mi | 23 mi | 1,406 | $942 | 75.8 |
30% excess
|
| 2 | Paul Mccormish | 2 | 729 | $488 | 364.4 mi | 346.4 mi | 693 | $464 | 364.5 |
95% excess
|
| 3 | Marvin Rivas | 49 | 704 | $472 | 14.4 mi | 0 mi | 0 | $0 | 14.4 |
0% excess
|
| 4 | Fady Khouzam | 1 | 542 | $363 | 542.2 mi | 483.3 mi | 483 | $324 | 542 |
89% excess
|
| 5 | Patricia Gordon | 4 | 447 | $299 | 111.6 mi | 54 mi | 216 | $145 | 111.8 |
48% excess
|
| 6 | Nkosi Wilson | 6 | 319 | $214 | 53.1 mi | 14.6 mi | 88 | $59 | 53.2 |
28% excess
|
| 7 | Jackson Reeves | 1 | 199 | $133 | 199.2 mi | 47 mi | 47 | $31 | 199 |
24% excess
|
| 8 | Rick Charles | 1 | 130 | $87 | 129.6 mi | 83.6 mi | 84 | $56 | 130 |
65% excess
|
| 9 | Samuel Biddie | 1 | 37 | $25 | 36.8 mi | 0 mi | 0 | $0 | 37 |
0% excess
|