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 | Mohamed Shareed | 151 | 8,505 | $5,698 | 56.3 mi | 37.6 mi | 5,675 | $3,802 | 56.3 |
67% excess
|
| 3 | Edward Arias | 149 | 8,146 | $5,458 | 54.7 mi | 36.3 mi | 5,412 | $3,626 | 54.7 |
66% excess
|
| 4 | Yves Dessin | 7 | 7,734 | $5,182 | 1104.8 mi | 1097.9 mi | 7,685 | $5,149 | 1104.9 |
99% excess
|
| 5 | David Cavaco | 182 | 7,519 | $5,038 | 41.3 mi | 27.7 mi | 5,034 | $3,373 | 41.3 |
67% excess
|
| 6 | Nick O'Neill | 112 | 5,431 | $3,639 | 48.5 mi | 40.1 mi | 4,489 | $3,008 | 48.5 |
83% excess
|
| 7 | Paul Bonang Jr | 80 | 4,565 | $3,059 | 57.1 mi | 13.5 mi | 1,080 | $724 | 57.1 |
24% excess
|
| 8 | Jason Cunningham | 3 | 4,230 | $2,834 | 1410.1 mi | 1400.2 mi | 4,201 | $2,815 | 1410 |
99% excess
|
| 9 | Erwin Forster | 70 | 4,225 | $2,831 | 60.4 mi | 41.1 mi | 2,877 | $1,928 | 60.4 |
68% excess
|
| 10 | Joseph Anderson | 3 | 3,803 | $2,548 | 1267.6 mi | 1250.5 mi | 3,751 | $2,513 | 1267.7 |
99% excess
|
| 11 | Pete Ramos | 113 | 3,767 | $2,524 | 33.3 mi | 16.8 mi | 1,895 | $1,270 | 33.3 |
50% excess
|
| 12 | Arturo Diaz | 2 | 3,189 | $2,137 | 1594.3 mi | 1589.8 mi | 3,180 | $2,131 | 1594.5 |
100% excess
|
| 13 | Luis Torres | 62 | 2,953 | $1,979 | 47.6 mi | 23.1 mi | 1,433 | $960 | 47.6 |
49% excess
|
| 14 | Taylor Duda | 65 | 2,762 | $1,851 | 42.5 mi | 24.9 mi | 1,618 | $1,084 | 42.5 |
59% excess
|
| 15 | Christopher Carroll | 4 | 2,721 | $1,823 | 680.4 mi | 680.4 mi | 2,721 | $1,823 | 680.3 |
100% excess
|
| 16 | Bernard Thompson | 49 | 2,636 | $1,766 | 53.8 mi | 18.3 mi | 895 | $600 | 53.8 |
34% excess
|
| 17 | David Trost | 92 | 2,365 | $1,585 | 25.7 mi | 11.0 mi | 1,014 | $679 | 25.7 |
43% excess
|
| 18 | Darek Kirkpatrick | 55 | 1,644 | $1,101 | 29.9 mi | 11.2 mi | 615 | $412 | 29.9 |
37% excess
|
| 19 | Darrell Hope | 32 | 868 | $582 | 27.1 mi | 13.5 mi | 433 | $290 | 27.1 |
50% excess
|
| 20 | Hector Castaneda | 5 | 718 | $481 | 143.5 mi | 143.5 mi | 718 | $481 | 143.6 |
100% excess
|
| 21 | Curtis Allen | 11 | 333 | $223 | 30.3 mi | 16.7 mi | 184 | $123 | 30.3 |
55% excess
|
| 22 | Maximilian Tucker | 1 | 263 | $176 | 263.2 mi | 238.1 mi | 238 | $159 | 263 |
90% excess
|
| 23 | Philip Krogstad | 1 | 44 | $29 | 44.4 mi | 19.2 mi | 19 | $13 | 44 |
43% excess
|
| 24 | Kaylee Tran | 2 | 14 | $9 | 7.2 mi | 2.0 mi | 4 | $3 | 7 |
29% excess
|