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 | Anthony Wright | 86 | 7,240 | $4,851 | 84.2 mi | 54.3 mi | 4,668 | $3,128 | 84.2 |
64% excess
|
| 2 | Dylan Ingraham | 46 | 4,156 | $2,785 | 90.3 mi | 42.8 mi | 1,971 | $1,321 | 90.3 |
47% excess
|
| 3 | Jason Cunningham | 33 | 3,352 | $2,246 | 101.6 mi | 58.3 mi | 1,923 | $1,288 | 101.6 |
57% excess
|
| 4 | Joseph Anderson | 51 | 3,334 | $2,234 | 65.4 mi | 39.3 mi | 2,002 | $1,341 | 65.4 |
60% excess
|
| 5 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 6 | Henry Holmes | 61 | 3,117 | $2,088 | 51.1 mi | 19.2 mi | 1,169 | $783 | 51.1 |
38% excess
|
| 7 | Yves Dessin | 23 | 2,640 | $1,769 | 114.8 mi | 89.2 mi | 2,052 | $1,375 | 114.8 |
78% excess
|
| 8 | Elkin Barahona | 53 | 1,532 | $1,026 | 28.9 mi | 15.8 mi | 838 | $561 | 28.9 |
55% excess
|
| 9 | Robert Rivera | 25 | 844 | $565 | 33.7 mi | 12.4 mi | 311 | $208 | 33.8 |
37% excess
|
| 10 | Cynthia G Deville | 4 | 624 | $418 | 156 mi | 88.9 mi | 356 | $239 | 156 |
57% excess
|
| 11 | Michael Swingle | 6 | 480 | $322 | 80 mi | 26.1 mi | 156 | $105 | 80 |
33% excess
|
| 12 | Torre Gifford | 7 | 437 | $293 | 62.4 mi | 19.9 mi | 139 | $93 | 62.4 |
32% excess
|
| 13 | Eric Colon | 2 | 167 | $112 | 83.5 mi | 0 mi | 0 | $0 | 83.5 |
0% excess
|
| 14 | Craig Walker | 1 | 146 | $98 | 145.9 mi | 8.4 mi | 8 | $5 | 146 |
5% excess
|
| 15 | Ray Andreu | 2 | 54 | $36 | 27 mi | 17.6 mi | 35 | $23 | 27 |
65% excess
|
| 16 | Matthew Sebzda | 1 | 19 | $13 | 19.1 mi | 8.6 mi | 9 | $6 | 19 |
47% excess
|
| 17 | David Cavaco | 1 | 17 | $11 | 17.1 mi | 13.5 mi | 14 | $9 | 17 |
82% excess
|
| 18 | Kenneth Lancara | 1 | 9 | $6 | 9.4 mi | 0 mi | 0 | $0 | 9 |
0% excess
|