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 | Minh Huynh | 58 | 55,985 | $37,510 | 965.3 mi | 945.0 mi | 54,812 | $36,724 | 965.3 |
98% excess
|
| 2 | Shawn Kelley | 23 | 38,044 | $25,489 | 1654.1 mi | 1620.1 mi | 37,261 | $24,965 | 1654.1 |
98% excess
|
| 3 | Ben Heinz | 73 | 26,134 | $17,510 | 358.0 mi | 347.0 mi | 25,334 | $16,974 | 358 |
97% excess
|
| 4 | Chris Bakkemo | 24 | 20,798 | $13,935 | 866.6 mi | 859.5 mi | 20,628 | $13,821 | 866.6 |
99% excess
|
| 5 | VPD Bench | 1,335 | 19,273 | $12,913 | 14.4 mi | 13.7 mi | 18,224 | $12,210 | 14.4 |
95% excess
|
| 6 | Kwame Cobb | 48 | 17,419 | $11,671 | 362.9 mi | 238.5 mi | 11,446 | $7,669 | 362.9 |
66% excess
|
| 7 | Charles Sellon | 12 | 14,345 | $9,611 | 1195.4 mi | 983.0 mi | 11,796 | $7,903 | 1195.4 |
82% excess
|
| 8 | Curtis Sprague | 19 | 14,049 | $9,413 | 739.4 mi | 537.7 mi | 10,217 | $6,845 | 739.4 |
73% excess
|
| 9 | Maria Davis | 98 | 13,641 | $9,139 | 139.2 mi | 120.0 mi | 11,758 | $7,878 | 139.2 |
86% excess
|
| 10 | Jose Gutierrez | 84 | 8,072 | $5,408 | 96.1 mi | 83.5 mi | 7,018 | $4,702 | 96.1 |
87% excess
|
| 11 | Rozier Cole | 26 | 7,652 | $5,127 | 294.3 mi | 168.1 mi | 4,370 | $2,928 | 294.3 |
57% excess
|
| 12 | Ronnie Salone | 9 | 5,837 | $3,911 | 648.5 mi | 36.6 mi | 329 | $220 | 648.6 |
6% excess
|
| 13 | Larry Alberty | 109 | 2,775 | $1,859 | 25.5 mi | 8.9 mi | 965 | $647 | 25.5 |
35% excess
|
| 14 | Hermilo Solano | 64 | 1,937 | $1,298 | 30.3 mi | 19.4 mi | 1,240 | $831 | 30.3 |
64% excess
|
| 15 | Dustin Antolin | 13 | 1,901 | $1,274 | 146.2 mi | 0.0 mi | 0 | $0 | 146.2 |
0% excess
|
| 16 | Jared Rappaport | 100 | 1,504 | $1,008 | 15.0 mi | 0.0 mi | 0 | $0 | 15 |
0% excess
|
| 17 | Pete Ramos | 16 | 1,401 | $939 | 87.5 mi | 15.9 mi | 254 | $170 | 87.6 |
18% excess
|
| 18 | Mike McNamara | 26 | 533 | $357 | 20.5 mi | 20.4 mi | 530 | $355 | 20.5 |
99% excess
|
| 19 | Jason Cunningham | 1 | 399 | $267 | 399.5 mi | 41.0 mi | 41 | $27 | 399 |
10% excess
|
| 20 | Eric Colon | 2 | 151 | $101 | 75.5 mi | 0.0 mi | 0 | $0 | 75.5 |
0% excess
|
| 21 | Jon Kuehl | 1 | 127 | $85 | 126.7 mi | 0.0 mi | 0 | $0 | 127 |
0% excess
|
| 22 | Steven Bionelli | 24 | 94 | $63 | 3.9 mi | 3.9 mi | 93 | $62 | 3.9 |
99% excess
|
| 23 | Angel Rios | 1 | 84 | $56 | 84.2 mi | 0.0 mi | 0 | $0 | 84 |
0% excess
|
| 24 | Todd Fogiel | 1 | 70 | $47 | 70.1 mi | 0.0 mi | 0 | $0 | 70 |
0% excess
|
| 25 | Tim Dinh | 5 | 54 | $36 | 10.9 mi | 10.8 mi | 54 | $36 | 10.8 |
100% excess
|
| 26 | Judith Alvarez | 12 | 33 | $22 | 2.8 mi | 0.0 mi | 0 | $0 | 2.8 |
0% excess
|
| 27 | Jason Morris | 1 | 26 | $17 | 25.5 mi | 0.0 mi | 0 | $0 | 26 |
0% excess
|
| 28 | David Cavaco | 1 | 22 | $15 | 21.6 mi | 0.0 mi | 0 | $0 | 22 |
0% excess
|
| 29 | Tim Holman | 1 | 13 | $9 | 12.7 mi | 0.0 mi | 0 | $0 | 13 |
0% excess
|
| 30 | Chane Lacy | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|