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 | Michael Swingle | 53 | 3,032 | $2,031 | 57.2 mi | 20.2 mi | 1,073 | $719 | 57.2 |
35% excess
|
| 6 | Samuel Biddie | 9 | 1,793 | $1,201 | 199.2 mi | 50.3 mi | 452 | $303 | 199.2 |
25% excess
|
| 7 | James Duff | 19 | 864 | $579 | 45.5 mi | 14.8 mi | 281 | $188 | 45.5 |
33% excess
|
| 8 | Fady Messak | 1 | 717 | $480 | 716.6 mi | 545.2 mi | 545 | $365 | 717 |
76% excess
|
| 9 | Rozier Cole | 1 | 340 | $228 | 339.6 mi | 129.4 mi | 129 | $86 | 340 |
38% excess
|
| 10 | Praelow Cameron | 2 | 305 | $204 | 152.6 mi | 28 mi | 56 | $38 | 152.5 |
18% excess
|
| 11 | Todd Fogiel | 1 | 128 | $86 | 127.9 mi | 56.5 mi | 56 | $38 | 128 |
44% excess
|