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 | 31 | 3,548 | $2,377 | 114.4 mi | 45.5 mi | 1,409 | $944 | 114.5 |
40% excess
|
| 2 | Craig Walker | 22 | 1,186 | $795 | 53.9 mi | 3.4 mi | 74 | $50 | 53.9 |
6% excess
|
| 3 | Cynthia G Deville | 3 | 459 | $308 | 153 mi | 83.3 mi | 250 | $168 | 153 |
54% excess
|
| 4 | Dylan Ingraham | 3 | 415 | $278 | 138.2 mi | 56.7 mi | 170 | $114 | 138.3 |
41% excess
|
| 5 | Henry Holmes | 3 | 383 | $257 | 127.8 mi | 105.7 mi | 317 | $212 | 127.7 |
83% excess
|
| 6 | Rozier Cole | 1 | 335 | $224 | 335.4 mi | 13.2 mi | 13 | $9 | 335 |
4% excess
|
| 7 | Michael Swingle | 5 | 332 | $222 | 66.4 mi | 9.2 mi | 46 | $31 | 66.4 |
14% excess
|
| 8 | Torre Gifford | 3 | 320 | $214 | 106.5 mi | 3.6 mi | 11 | $7 | 106.7 |
3% excess
|