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 | Nkosi Wilson | 33 | 25,194 | $16,880 | 763.5 mi | 739.7 mi | 24,409 | $16,354 | 763.5 |
97% excess
|
| 2 | Erwin Forster | 176 | 10,038 | $6,725 | 57.0 mi | 27.5 mi | 4,833 | $3,238 | 57 |
48% excess
|
| 3 | Natosha Beierschmitt | 7 | 9,628 | $6,451 | 1375.4 mi | 1334.0 mi | 9,338 | $6,256 | 1375.4 |
97% excess
|
| 4 | Megan Allen | 6 | 9,052 | $6,065 | 1508.7 mi | 1480.7 mi | 8,884 | $5,952 | 1508.7 |
98% excess
|
| 5 | Christopher Carroll | 8 | 8,746 | $5,860 | 1093.2 mi | 1075.8 mi | 8,606 | $5,766 | 1093.3 |
98% excess
|
| 6 | Bernard Thompson | 140 | 8,545 | $5,725 | 61.0 mi | 7.6 mi | 1,065 | $714 | 61 |
12% excess
|
| 7 | James Duff | 11 | 8,189 | $5,487 | 744.5 mi | 727.0 mi | 7,997 | $5,358 | 744.5 |
98% excess
|
| 8 | Scott A Berry | 15 | 6,993 | $4,685 | 466.2 mi | 447.1 mi | 6,707 | $4,494 | 466.2 |
96% excess
|
| 9 | Bryan Rodriguez | 64 | 6,531 | $4,376 | 102.0 mi | 24.9 mi | 1,595 | $1,069 | 102 |
24% excess
|
| 10 | Sean Currie | 4 | 6,516 | $4,366 | 1628.9 mi | 1559.3 mi | 6,237 | $4,179 | 1629 |
96% excess
|
| 11 | Andre Samuda | 284 | 6,244 | $4,183 | 22.0 mi | 6.9 mi | 1,950 | $1,307 | 22 |
31% excess
|
| 12 | Vivian Hyde | 250 | 4,709 | $3,155 | 18.8 mi | 5.7 mi | 1,421 | $952 | 18.8 |
30% excess
|
| 13 | Eric Mancerella | 19 | 4,440 | $2,975 | 233.7 mi | 56.0 mi | 1,065 | $714 | 233.7 |
24% excess
|
| 14 | Fady Messak | 64 | 4,389 | $2,941 | 68.6 mi | 41.0 mi | 2,624 | $1,758 | 68.6 |
60% excess
|
| 15 | Fanfan Siku | 18 | 4,255 | $2,851 | 236.4 mi | 88.6 mi | 1,595 | $1,069 | 236.4 |
37% excess
|
| 16 | Joseph Nuovo | 24 | 4,194 | $2,810 | 174.8 mi | 50.4 mi | 1,211 | $811 | 174.8 |
29% excess
|
| 17 | Philmon Mehari | 65 | 3,938 | $2,638 | 60.6 mi | 14.8 mi | 965 | $647 | 60.6 |
25% excess
|
| 18 | Edward Arias | 81 | 3,799 | $2,545 | 46.9 mi | 21.5 mi | 1,745 | $1,169 | 46.9 |
46% excess
|
| 19 | Rodney Charles | 20 | 3,783 | $2,535 | 189.2 mi | 58.6 mi | 1,172 | $785 | 189.2 |
31% excess
|
| 20 | Davon Cox | 65 | 3,616 | $2,423 | 55.6 mi | 12.8 mi | 833 | $558 | 55.6 |
23% excess
|
| 21 | Alberto Galan | 124 | 3,515 | $2,355 | 28.3 mi | 18.4 mi | 2,279 | $1,527 | 28.3 |
65% excess
|
| 22 | Horace Barnes | 3 | 3,363 | $2,253 | 1121.0 mi | 989.0 mi | 2,967 | $1,988 | 1121 |
88% excess
|
| 23 | Mohamed Shareed | 89 | 3,047 | $2,041 | 34.2 mi | 11.3 mi | 1,010 | $677 | 34.2 |
33% excess
|
| 24 | Taylor Duda | 70 | 2,869 | $1,922 | 41.0 mi | 24.0 mi | 1,679 | $1,125 | 41 |
59% excess
|
| 25 | April Nuovo | 16 | 2,387 | $1,599 | 149.2 mi | 37.1 mi | 593 | $397 | 149.2 |
25% excess
|
| 26 | Shady Messak | 52 | 2,267 | $1,519 | 43.6 mi | 35.0 mi | 1,818 | $1,218 | 43.6 |
80% excess
|
| 27 | Luis Iser | 2 | 2,244 | $1,503 | 1122.2 mi | 1116.7 mi | 2,233 | $1,496 | 1122 |
100% excess
|
| 28 | Fady Khouzam | 59 | 2,144 | $1,436 | 36.3 mi | 16.2 mi | 953 | $639 | 36.3 |
44% excess
|
| 29 | Darek Kirkpatrick | 68 | 2,035 | $1,363 | 29.9 mi | 9.6 mi | 655 | $439 | 29.9 |
32% excess
|
| 30 | Darrell Hope | 93 | 1,889 | $1,266 | 20.3 mi | 3.3 mi | 310 | $208 | 20.3 |
16% excess
|