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 | Henry Holmes | 142 | 6,380 | $4,275 | 44.9 mi | 19.2 mi | 2,731 | $1,830 | 44.9 |
43% excess
|
| 2 | Torre Gifford | 152 | 4,441 | $2,975 | 29.2 mi | 9.1 mi | 1,383 | $927 | 29.2 |
31% excess
|
| 3 | Dylan Ingraham | 69 | 4,322 | $2,896 | 62.6 mi | 23.3 mi | 1,611 | $1,079 | 62.6 |
37% excess
|
| 4 | Cynthia G Deville | 73 | 4,144 | $2,776 | 56.8 mi | 17.2 mi | 1,256 | $842 | 56.8 |
30% excess
|
| 5 | Kenneth Lancara | 328 | 3,504 | $2,348 | 10.7 mi | 0.0 mi | 0 | $0 | 10.7 |
0% excess
|
| 6 | Robert Rivera | 9 | 3,442 | $2,306 | 382.5 mi | 280.1 mi | 2,521 | $1,689 | 382.4 |
73% excess
|
| 7 | Kevin Cogdill | 12 | 3,425 | $2,295 | 285.4 mi | 262.8 mi | 3,153 | $2,113 | 285.4 |
92% excess
|
| 8 | Rozier Cole | 20 | 3,334 | $2,234 | 166.7 mi | 102.5 mi | 2,050 | $1,374 | 166.7 |
61% excess
|
| 9 | Matthew Sebzda | 3 | 870 | $583 | 290.1 mi | 280.0 mi | 840 | $563 | 290 |
97% excess
|
| 10 | Robert Lewis | 2 | 350 | $235 | 174.8 mi | 102.4 mi | 205 | $137 | 175 |
59% excess
|
| 11 | Eric Colon | 3 | 305 | $204 | 101.8 mi | 0.0 mi | 0 | $0 | 101.7 |
0% excess
|
| 12 | Praelow Cameron | 1 | 232 | $155 | 232.2 mi | 198.6 mi | 199 | $133 | 232 |
86% excess
|
| 13 | Craig Walker | 1 | 148 | $99 | 148.5 mi | 0.0 mi | 0 | $0 | 148 |
0% excess
|