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 | Brandon Rodriguez | 2 | 1,126 | $754 | 562.8 mi | 561.8 mi | 1,124 | $753 | 563 |
100% excess
|
| 2 | Horace Barnes | 1 | 798 | $535 | 798.0 mi | 798.0 mi | 798 | $535 | 798 |
100% excess
|
| 3 | David Hernandez | 2 | 673 | $451 | 336.4 mi | 336.4 mi | 673 | $451 | 336.5 |
100% excess
|
| 4 | Ben McClerklin | 4 | 264 | $177 | 66.0 mi | 65.6 mi | 262 | $176 | 66 |
99% excess
|
| 5 | Arturo Diaz | 1 | 199 | $133 | 199.0 mi | 197.2 mi | 197 | $132 | 199 |
99% excess
|
| 6 | Joe Evans | 1 | 179 | $120 | 179.4 mi | 167.2 mi | 167 | $112 | 179 |
93% excess
|
| 7 | Matthew Sebzda | 4 | 76 | $51 | 19.1 mi | 8.6 mi | 34 | $23 | 19 |
45% excess
|
| 8 | Kenneth Lancara | 2 | 20 | $13 | 10.0 mi | 0.0 mi | 0 | $0 | 10 |
0% excess
|
| 9 | Ray-Anthony Alston | 1 | 15 | $10 | 15.3 mi | 2.1 mi | 2 | $1 | 15 |
13% excess
|
| 10 | Anthony Wirth | 1 | 15 | $10 | 14.8 mi | 9.2 mi | 9 | $6 | 15 |
60% excess
|
| 11 | Angel Rios | 1 | 10 | $7 | 9.6 mi | 0.0 mi | 0 | $0 | 10 |
0% excess
|
| 12 | Jeffrey Pastor | 3 | 7 | $5 | 2.4 mi | 2.3 mi | 7 | $5 | 2.3 |
100% excess
|
| 13 | Dylan Ingraham | 1 | 3 | $2 | 3.5 mi | 0.0 mi | 0 | $0 | 3 |
0% excess
|
| 14 | David Trost | 1 | 2 | $1 | 1.6 mi | 0.0 mi | 0 | $0 | 2 |
0% excess
|
| 15 | Jason Morris | 1 | 2 | $1 | 2.3 mi | 0.0 mi | 0 | $0 | 2 |
0% excess
|
| 16 | Michah Brackett | 1 | 1 | $1 | 1.1 mi | 0.0 mi | 0 | $0 | 1 |
0% excess
|
| 17 | Kevin Cox | 1 | 1 | $1 | 1.0 mi | 0.0 mi | 0 | $0 | 1 |
0% excess
|
| 18 | Chris Galasso | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 19 | Davon Cox | 2 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 20 | Chane Lacy | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 21 | Carlos Robles | 3 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 22 | Darrell Hope | 4 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 23 | Darrell Hendrix | 2 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 24 | Bryan Rodriguez | 2 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 25 | David Cavaco | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 26 | Ben Heinz | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 27 | Darek Kirkpatrick | 2 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 28 | Daniel Clark | 2 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 29 | Derick Velazquez | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 30 | Cynthia G Deville | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|