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 | Paul Mccormish | 17 | 6,196 | $4,151 | 364.4 mi | 346.4 mi | 5,890 | $3,946 | 364.5 |
95% excess
|
| 2 | Patricia Gordon | 17 | 6,005 | $4,023 | 353.2 mi | 335.2 mi | 5,699 | $3,818 | 353.2 |
95% excess
|
| 3 | Ryan Lewis | 25 | 5,044 | $3,379 | 201.7 mi | 63.5 mi | 1,587 | $1,063 | 201.8 |
31% excess
|
| 4 | Bruce Ballard | 31 | 4,556 | $3,053 | 147 mi | 22.9 mi | 711 | $476 | 147 |
16% excess
|
| 5 | Samuel Biddie | 9 | 1,793 | $1,201 | 199.2 mi | 50.3 mi | 452 | $303 | 199.2 |
25% excess
|
| 6 | Fady Messak | 1 | 717 | $480 | 716.6 mi | 545.2 mi | 545 | $365 | 717 |
76% excess
|