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 | Robert Rivera | 48 | 4,146 | $2,778 | 86.4 mi | 49.2 mi | 2,364 | $1,584 | 86.4 |
57% excess
|
| 2 | Kevin Cogdill | 6 | 1,792 | $1,201 | 298.7 mi | 288.9 mi | 1,733 | $1,161 | 298.7 |
97% excess
|
| 3 | Joseph Anderson | 16 | 762 | $511 | 47.6 mi | 12.4 mi | 199 | $133 | 47.6 |
26% excess
|
| 4 | Anthony Wright | 5 | 546 | $366 | 109.1 mi | 81.1 mi | 406 | $272 | 109.2 |
74% excess
|
| 5 | Robert Lewis | 8 | 423 | $283 | 52.9 mi | 0.0 mi | 0 | $0 | 52.9 |
0% excess
|
| 6 | Craig Walker | 13 | 391 | $262 | 30.1 mi | 0.0 mi | 0 | $0 | 30.1 |
0% excess
|
| 7 | Rozier Cole | 1 | 374 | $251 | 374.3 mi | 142.8 mi | 143 | $96 | 374 |
38% excess
|
| 8 | Ray Andreu | 14 | 348 | $233 | 24.9 mi | 0.0 mi | 0 | $0 | 24.9 |
0% excess
|
| 9 | Elkin Barahona | 12 | 228 | $153 | 19.0 mi | 3.8 mi | 46 | $31 | 19 |
20% excess
|
| 10 | Mark Franks | 1 | 103 | $69 | 103.0 mi | 95.4 mi | 95 | $64 | 103 |
92% excess
|