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 | Samuel Biddie | 54 | 21,138 | $14,162 | 391.5 mi | 271.4 mi | 14,653 | $9,818 | 391.4 |
69% excess
|
| 2 | Jackson Reeves | 34 | 6,122 | $4,102 | 180.1 mi | 47.1 mi | 1,601 | $1,073 | 180.1 |
26% excess
|
| 3 | Paul Mccormish | 7 | 1,276 | $855 | 182.3 mi | 135.3 mi | 947 | $634 | 182.3 |
74% excess
|
| 4 | Shady Messak | 1 | 744 | $498 | 744.4 mi | 542.6 mi | 543 | $364 | 744 |
73% excess
|
| 5 | Fady Messak | 1 | 656 | $440 | 656.3 mi | 426.9 mi | 427 | $286 | 656 |
65% excess
|
| 6 | Rodney Charles | 1 | 474 | $318 | 473.8 mi | 469.3 mi | 469 | $314 | 474 |
99% excess
|