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 | 151 | 12,167 | $8,152 | 80.6 mi | 49.8 mi | 7,521 | $5,039 | 80.6 |
62% excess
|
| 2 | Jason Cunningham | 76 | 8,548 | $5,727 | 112.5 mi | 68.5 mi | 5,203 | $3,486 | 112.5 |
61% excess
|
| 3 | Yves Dessin | 62 | 7,368 | $4,937 | 118.8 mi | 88.1 mi | 5,462 | $3,660 | 118.8 |
74% excess
|
| 4 | Dylan Ingraham | 83 | 7,155 | $4,794 | 86.2 mi | 43.4 mi | 3,604 | $2,415 | 86.2 |
50% excess
|
| 5 | Henry Holmes | 145 | 6,849 | $4,589 | 47.2 mi | 21.0 mi | 3,048 | $2,042 | 47.2 |
45% excess
|
| 6 | Elkin Barahona | 104 | 6,189 | $4,147 | 59.5 mi | 42.3 mi | 4,397 | $2,946 | 59.5 |
71% excess
|
| 7 | Joseph Anderson | 70 | 4,280 | $2,868 | 61.1 mi | 34.6 mi | 2,423 | $1,623 | 61.1 |
57% excess
|
| 8 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 9 | Cynthia G Deville | 11 | 1,577 | $1,057 | 143.4 mi | 68.4 mi | 752 | $504 | 143.4 |
48% excess
|
| 10 | Robert Rivera | 28 | 926 | $620 | 33.1 mi | 11.4 mi | 320 | $214 | 33.1 |
35% excess
|
| 11 | Torre Gifford | 11 | 557 | $373 | 50.7 mi | 16.9 mi | 185 | $124 | 50.6 |
33% excess
|
| 12 | Craig Walker | 4 | 481 | $322 | 120.1 mi | 2.1 mi | 8 | $5 | 120.3 |
2% excess
|
| 13 | Michael Swingle | 6 | 480 | $322 | 80.0 mi | 26.1 mi | 156 | $105 | 80 |
33% excess
|
| 14 | Eric Colon | 2 | 167 | $112 | 83.5 mi | 0.0 mi | 0 | $0 | 83.5 |
0% excess
|
| 15 | Jordan Moceri | 2 | 138 | $92 | 69.0 mi | 34.0 mi | 68 | $46 | 69 |
49% excess
|
| 16 | Jon Kuehl | 1 | 92 | $62 | 92.2 mi | 51.8 mi | 52 | $35 | 92 |
57% excess
|
| 17 | Arturo Diaz | 1 | 90 | $60 | 90.0 mi | 29.5 mi | 30 | $20 | 90 |
33% excess
|
| 18 | Vincent Nyathi | 2 | 62 | $42 | 30.8 mi | 0.0 mi | 0 | $0 | 31 |
0% excess
|
| 19 | Ray Andreu | 3 | 57 | $38 | 19.1 mi | 11.7 mi | 35 | $23 | 19 |
61% excess
|
| 20 | Matthew Sebzda | 1 | 19 | $13 | 19.1 mi | 8.6 mi | 9 | $6 | 19 |
47% excess
|
| 21 | David Cavaco | 1 | 17 | $11 | 17.2 mi | 13.5 mi | 14 | $9 | 17 |
82% excess
|
| 22 | Dustin Antolin | 1 | 11 | $7 | 10.6 mi | 0.0 mi | 0 | $0 | 11 |
0% excess
|
| 23 | Kenneth Lancara | 1 | 9 | $6 | 9.4 mi | 0.0 mi | 0 | $0 | 9 |
0% excess
|