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 | Kenneth Lancara | 57 | 6,524 | $4,371 | 114.5 mi | 45.5 mi | 2,591 | $1,736 | 114.5 |
40% excess
|
| 2 | Cynthia G Deville | 32 | 5,071 | $3,398 | 158.5 mi | 35.5 mi | 1,136 | $761 | 158.5 |
22% excess
|
| 3 | Elkin Barahona | 6 | 3,389 | $2,271 | 564.8 mi | 496.9 mi | 2,982 | $1,998 | 564.8 |
88% excess
|
| 4 | Craig Walker | 36 | 2,391 | $1,602 | 66.4 mi | 2.1 mi | 74 | $50 | 66.4 |
3% excess
|
| 5 | Dylan Ingraham | 14 | 1,830 | $1,226 | 130.7 mi | 66.2 mi | 926 | $620 | 130.7 |
51% excess
|
| 6 | Michael Swingle | 11 | 977 | $655 | 88.8 mi | 9.2 mi | 101 | $68 | 88.8 |
10% excess
|
| 7 | Jason Cunningham | 2 | 571 | $383 | 285.7 mi | 71.4 mi | 143 | $96 | 285.5 |
25% excess
|
| 8 | Henry Holmes | 3 | 378 | $253 | 126.0 mi | 103.9 mi | 312 | $209 | 126 |
83% excess
|
| 9 | Praelow Cameron | 1 | 360 | $241 | 359.8 mi | 230.7 mi | 231 | $155 | 360 |
64% excess
|
| 10 | Rozier Cole | 1 | 335 | $224 | 335.4 mi | 13.2 mi | 13 | $9 | 335 |
4% excess
|
| 11 | Torre Gifford | 3 | 320 | $214 | 106.5 mi | 3.6 mi | 11 | $7 | 106.7 |
3% excess
|