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 | James Duff | 28 | 23,849 | $15,979 | 851.7 mi | 837.2 mi | 23,440 | $15,705 | 851.8 |
98% excess
|
| 2 | Paul Bonang Jr | 202 | 12,056 | $8,078 | 59.7 mi | 6.2 mi | 1,243 | $833 | 59.7 |
10% excess
|
| 3 | Luis Torres | 222 | 11,374 | $7,621 | 51.2 mi | 17.0 mi | 3,784 | $2,535 | 51.2 |
33% excess
|
| 4 | Christopher Carroll | 11 | 10,711 | $7,176 | 973.8 mi | 942.1 mi | 10,363 | $6,943 | 973.7 |
97% excess
|
| 5 | David Trost | 208 | 9,585 | $6,422 | 46.1 mi | 25.2 mi | 5,252 | $3,519 | 46.1 |
55% excess
|
| 6 | Mohamed Shareed | 163 | 8,944 | $5,992 | 54.9 mi | 36.1 mi | 5,892 | $3,948 | 54.9 |
66% excess
|
| 7 | Bernard Thompson | 139 | 8,788 | $5,888 | 63.2 mi | 8.2 mi | 1,141 | $764 | 63.2 |
13% excess
|
| 8 | Edward Arias | 165 | 8,672 | $5,810 | 52.6 mi | 34.1 mi | 5,623 | $3,767 | 52.6 |
65% excess
|
| 9 | Pete Ramos | 214 | 8,295 | $5,558 | 38.8 mi | 17.3 mi | 3,695 | $2,476 | 38.8 |
45% excess
|
| 10 | Erwin Forster | 142 | 7,912 | $5,301 | 55.7 mi | 21.8 mi | 3,090 | $2,070 | 55.7 |
39% excess
|
| 11 | Joseph Anderson | 6 | 7,753 | $5,195 | 1292.1 mi | 1216.0 mi | 7,296 | $4,888 | 1292.2 |
94% excess
|
| 12 | Yves Dessin | 7 | 7,734 | $5,182 | 1104.8 mi | 1097.9 mi | 7,685 | $5,149 | 1104.9 |
99% excess
|
| 13 | David Cavaco | 186 | 7,657 | $5,130 | 41.2 mi | 27.4 mi | 5,097 | $3,415 | 41.2 |
67% excess
|
| 14 | Michael Swingle | 9 | 6,572 | $4,403 | 730.2 mi | 710.3 mi | 6,393 | $4,283 | 730.2 |
97% excess
|
| 15 | Nick O'Neill | 113 | 5,431 | $3,639 | 48.1 mi | 39.7 mi | 4,489 | $3,008 | 48.1 |
83% excess
|
| 16 | Jason Cunningham | 3 | 4,230 | $2,834 | 1410.1 mi | 1400.2 mi | 4,201 | $2,815 | 1410 |
99% excess
|
| 17 | Taylor Duda | 72 | 4,213 | $2,823 | 58.5 mi | 42.3 mi | 3,042 | $2,038 | 58.5 |
72% excess
|
| 18 | Curtis Allen | 154 | 4,110 | $2,754 | 26.7 mi | 9.3 mi | 1,429 | $957 | 26.7 |
35% excess
|
| 19 | Darrell Hope | 144 | 3,868 | $2,592 | 26.9 mi | 8.7 mi | 1,258 | $843 | 26.9 |
33% excess
|
| 20 | Arturo Diaz | 2 | 3,189 | $2,137 | 1594.3 mi | 1589.8 mi | 3,180 | $2,131 | 1594.5 |
100% excess
|
| 21 | Darek Kirkpatrick | 65 | 1,880 | $1,260 | 28.9 mi | 9.8 mi | 636 | $426 | 28.9 |
34% excess
|
| 22 | Mike Huffman | 9 | 1,532 | $1,026 | 170.3 mi | 118.4 mi | 1,065 | $714 | 170.2 |
70% excess
|
| 23 | Jon Kuehl | 3 | 728 | $488 | 242.6 mi | 0.0 mi | 0 | $0 | 242.7 |
0% excess
|
| 24 | Hector Castaneda | 7 | 718 | $481 | 102.5 mi | 102.5 mi | 718 | $481 | 102.6 |
100% excess
|
| 25 | Maximilian Tucker | 2 | 290 | $194 | 145.2 mi | 119.0 mi | 238 | $159 | 145 |
82% excess
|
| 26 | Chris Galasso | 4 | 222 | $149 | 55.5 mi | 43.3 mi | 173 | $116 | 55.5 |
78% excess
|
| 27 | Jim Kingery | 4 | 220 | $147 | 55.0 mi | 54.4 mi | 217 | $145 | 55 |
99% excess
|
| 28 | Shawn Rogers | 2 | 205 | $137 | 102.3 mi | -12.6 mi | 0 | $0 | 102.5 |
0% excess
|
| 29 | Philip Krogstad | 2 | 71 | $48 | 35.6 mi | 9.6 mi | 19 | $13 | 35.5 |
27% excess
|
| 30 | Minh Huynh | 1 | 52 | $35 | 51.9 mi | 43.6 mi | 44 | $29 | 52 |
85% excess
|