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 | Chris Galasso | 10 | 4,878 | $3,268 | 487.8 mi | 312.5 mi | 3,125 | $2,094 | 487.8 |
64% excess
|
| 2 | Scott R Roberts | 10 | 730 | $489 | 73 mi | 14.7 mi | 147 | $98 | 73 |
20% excess
|
| 3 | Christopher Womack | 2 | 625 | $419 | 312.5 mi | 253.4 mi | 507 | $340 | 312.5 |
81% excess
|
| 4 | Rozier Cole | 2 | 461 | $309 | 230.5 mi | 83.2 mi | 166 | $111 | 230.5 |
36% excess
|
| 5 | Brandon Green | 3 | 362 | $243 | 120.7 mi | 62 mi | 186 | $125 | 120.7 |
51% excess
|
| 6 | Todd Fogiel | 3 | 336 | $225 | 112.1 mi | 1.6 mi | 5 | $3 | 112 |
1% excess
|
| 7 | David Trost | 2 | 186 | $125 | 93.2 mi | 28.7 mi | 57 | $38 | 93 |
31% excess
|
| 8 | Craig Walker | 1 | 110 | $74 | 109.8 mi | 0 mi | 0 | $0 | 110 |
0% excess
|
| 9 | Jason Cunningham | 1 | 47 | $31 | 46.6 mi | 0 mi | 0 | $0 | 47 |
0% excess
|
| 10 | Darrell Hope | 1 | 46 | $31 | 46.4 mi | 21.3 mi | 21 | $14 | 46 |
46% excess
|
| 11 | Luis Torres | 1 | 44 | $29 | 44.2 mi | 0 mi | 0 | $0 | 44 |
0% excess
|
| 12 | Dustin Antolin | 2 | 39 | $26 | 19.5 mi | 0 mi | 0 | $0 | 19.5 |
0% excess
|
| 13 | Rene Yescas | 1 | 23 | $15 | 22.8 mi | 0 mi | 0 | $0 | 23 |
0% excess
|
| 14 | Curtis Allen | 2 | 11 | $7 | 5.6 mi | 0 mi | 0 | $0 | 5.5 |
0% excess
|