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 | Philip Krogstad | 163 | 6,165 | $4,131 | 37.8 mi | 21.1 mi | 3,441 | $2,305 | 37.8 |
56% excess
|
| 2 | Pero Popovic | 39 | 1,958 | $1,312 | 50.2 mi | 41.3 mi | 1,610 | $1,079 | 50.2 |
82% excess
|
| 3 | Megan Allen | 1 | 1,431 | $959 | 1430.7 mi | 1419.2 mi | 1,419 | $951 | 1431 |
99% excess
|
| 4 | Brandon Green | 31 | 1,309 | $877 | 42.2 mi | -0.4 mi | 87 | $58 | 42.2 |
7% excess
|
| 5 | Pete Ramos | 4 | 934 | $626 | 233.6 mi | 112.8 mi | 451 | $302 | 233.5 |
48% excess
|
| 6 | Chris Galasso | 40 | 720 | $482 | 18.0 mi | 5.4 mi | 214 | $143 | 18 |
30% excess
|
| 7 | James Duff | 1 | 646 | $433 | 646.0 mi | 643.4 mi | 643 | $431 | 646 |
100% excess
|
| 8 | Dustin Antolin | 5 | 476 | $319 | 95.1 mi | 34.4 mi | 172 | $115 | 95.2 |
36% excess
|
| 9 | Michael Harris | 9 | 326 | $218 | 36.2 mi | 21.4 mi | 192 | $129 | 36.2 |
59% excess
|