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 | Megan Allen | 6 | 9,052 | $6,065 | 1508.7 mi | 1480.7 mi | 8,884 | $5,952 | 1508.7 |
98% excess
|
| 2 | James Duff | 11 | 8,189 | $5,487 | 744.5 mi | 727.0 mi | 7,997 | $5,358 | 744.5 |
98% excess
|
| 3 | Scott A Berry | 15 | 6,993 | $4,685 | 466.2 mi | 447.1 mi | 6,707 | $4,494 | 466.2 |
96% excess
|
| 4 | Erwin Forster | 105 | 6,733 | $4,511 | 64.1 mi | 45.2 mi | 4,746 | $3,180 | 64.1 |
70% excess
|
| 5 | Edward Arias | 71 | 3,358 | $2,250 | 47.3 mi | 22.1 mi | 1,566 | $1,049 | 47.3 |
47% excess
|
| 6 | Christopher Carroll | 3 | 3,269 | $2,190 | 1089.8 mi | 1089.8 mi | 3,269 | $2,190 | 1089.7 |
100% excess
|
| 7 | Mohamed Shareed | 81 | 2,886 | $1,934 | 35.6 mi | 12.1 mi | 979 | $656 | 35.6 |
34% excess
|
| 8 | Taylor Duda | 66 | 2,805 | $1,879 | 42.5 mi | 24.8 mi | 1,636 | $1,096 | 42.5 |
58% excess
|
| 9 | Bernard Thompson | 51 | 2,561 | $1,716 | 50.2 mi | 16.0 mi | 819 | $549 | 50.2 |
32% excess
|
| 10 | Darek Kirkpatrick | 58 | 1,799 | $1,205 | 31.0 mi | 10.9 mi | 634 | $425 | 31 |
35% excess
|
| 11 | Pete Ramos | 45 | 1,675 | $1,122 | 37.2 mi | 25.4 mi | 1,144 | $766 | 37.2 |
68% excess
|
| 12 | David Trost | 72 | 1,187 | $795 | 16.5 mi | 5.0 mi | 358 | $240 | 16.5 |
30% excess
|
| 13 | Hector Castaneda | 5 | 718 | $481 | 143.5 mi | 143.5 mi | 718 | $481 | 143.6 |
100% excess
|
| 14 | Maximilian Tucker | 2 | 526 | $352 | 263.2 mi | 238.1 mi | 476 | $319 | 263 |
90% excess
|
| 15 | Darrell Hope | 21 | 347 | $232 | 16.5 mi | 4.3 mi | 90 | $60 | 16.5 |
26% excess
|
| 16 | Luis Torres | 5 | 308 | $206 | 61.5 mi | 43.5 mi | 218 | $146 | 61.6 |
71% excess
|
| 17 | Curtis Allen | 6 | 232 | $155 | 38.6 mi | 24.0 mi | 144 | $96 | 38.7 |
62% excess
|