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 | Ben Heinz | 72 | 25,754 | $17,255 | 357.7 mi | 351.9 mi | 25,334 | $16,974 | 357.7 |
98% excess
|
| 2 | Minh Huynh | 24 | 24,165 | $16,191 | 1006.9 mi | 986.5 mi | 23,675 | $15,862 | 1006.9 |
98% excess
|
| 3 | Shawn Kelley | 12 | 17,920 | $12,006 | 1493.4 mi | 1450.5 mi | 17,406 | $11,662 | 1493.3 |
97% excess
|
| 4 | VPD Bench | 634 | 11,484 | $7,694 | 18.1 mi | 17 mi | 10,790 | $7,229 | 18.1 |
94% excess
|
| 5 | Chris Bakkemo | 12 | 10,399 | $6,967 | 866.6 mi | 859.5 mi | 10,314 | $6,910 | 866.6 |
99% excess
|
| 6 | Kwame Cobb | 24 | 9,394 | $6,294 | 391.4 mi | 262.8 mi | 6,308 | $4,226 | 391.4 |
67% excess
|
| 7 | Rozier Cole | 18 | 6,258 | $4,193 | 347.7 mi | 241.7 mi | 4,351 | $2,915 | 347.7 |
70% excess
|
| 8 | Maria Davis | 51 | 6,257 | $4,192 | 122.7 mi | 102.4 mi | 5,223 | $3,499 | 122.7 |
83% excess
|
| 9 | Jose Gutierrez | 43 | 3,771 | $2,527 | 87.7 mi | 80.2 mi | 3,450 | $2,312 | 87.7 |
91% excess
|
| 10 | Ronnie Salone | 6 | 3,271 | $2,192 | 545.1 mi | 54.9 mi | 329 | $220 | 545.2 |
10% excess
|
| 11 | Curtis Sprague | 7 | 3,175 | $2,127 | 453.6 mi | 241.1 mi | 1,688 | $1,131 | 453.6 |
53% excess
|
| 12 | Dustin Antolin | 6 | 1,473 | $987 | 245.4 mi | 0 mi | 0 | $0 | 245.5 |
0% excess
|
| 13 | Larry Alberty | 54 | 1,127 | $755 | 20.9 mi | 5.9 mi | 319 | $214 | 20.9 |
28% excess
|
| 14 | Jared Rappaport | 63 | 948 | $635 | 15 mi | 0 mi | 0 | $0 | 15 |
0% excess
|
| 15 | Hermilo Solano | 31 | 943 | $632 | 30.4 mi | 20.3 mi | 629 | $421 | 30.4 |
67% excess
|
| 16 | Charles Sellon | 3 | 869 | $582 | 289.5 mi | 282.5 mi | 848 | $568 | 289.7 |
98% excess
|
| 17 | Pete Ramos | 9 | 760 | $509 | 84.5 mi | 1.1 mi | 10 | $7 | 84.4 |
1% excess
|
| 18 | Mike McNamara | 14 | 285 | $191 | 20.3 mi | 20.3 mi | 284 | $190 | 20.4 |
100% excess
|
| 19 | Jon Kuehl | 1 | 127 | $85 | 126.7 mi | 0 mi | 0 | $0 | 127 |
0% excess
|
| 20 | Steven Bionelli | 13 | 51 | $34 | 3.9 mi | 3.9 mi | 50 | $34 | 3.9 |
98% excess
|
| 21 | Tim Dinh | 3 | 48 | $32 | 16 mi | 15.9 mi | 48 | $32 | 16 |
100% excess
|
| 22 | Judith Alvarez | 6 | 17 | $11 | 2.8 mi | 0 mi | 0 | $0 | 2.8 |
0% excess
|
| 23 | Chane Lacy | 1 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|
| 24 | Jermaine Hernandez | 7 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|
| 25 | Nidal Al-Sharif | 14 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|
| 26 | Zachary Stieben | 1 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|