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 | Luis Iser | 1 | 1,113 | $746 | 1113.0 mi | 1079.1 mi | 1,079 | $723 | 1113 |
97% excess
|
| 2 | Israel Martell | 2 | 1,016 | $681 | 508.0 mi | 385.3 mi | 771 | $517 | 508 |
76% excess
|
| 3 | Fady Messak | 2 | 665 | $446 | 332.6 mi | 267.1 mi | 534 | $358 | 332.5 |
80% excess
|
| 4 | Samuel Biddie | 1 | 622 | $417 | 621.9 mi | 588.0 mi | 588 | $394 | 622 |
95% excess
|
| 5 | Andre Samuda | 1 | 407 | $273 | 407.0 mi | 326.2 mi | 326 | $218 | 407 |
80% excess
|
| 6 | Shady Messak | 1 | 371 | $249 | 370.8 mi | 337.0 mi | 337 | $226 | 371 |
91% excess
|
| 7 | Jason Yenser | 1 | 312 | $209 | 312.0 mi | 278.2 mi | 278 | $186 | 312 |
89% excess
|
| 8 | Jackson Reeves | 1 | 162 | $109 | 162.5 mi | 122.5 mi | 122 | $82 | 162 |
75% excess
|
| 9 | Paul Mccormish | 1 | 40 | $27 | 40.0 mi | 0.0 mi | 0 | $0 | 40 |
0% excess
|