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 | Yves Dessin | 32 | 18,764 | $12,572 | 586.4 mi | 543.4 mi | 17,389 | $11,651 | 586.4 |
93% excess
|
| 2 | Kenneth Lancara | 53 | 18,229 | $12,213 | 343.9 mi | 301.6 mi | 15,984 | $10,709 | 343.9 |
88% excess
|
| 3 | Marvin Rivas | 27 | 6,847 | $4,587 | 253.6 mi | 4.0 mi | 108 | $72 | 253.6 |
2% excess
|
| 4 | Daniel Clark | 282 | 4,971 | $3,331 | 17.6 mi | 0.0 mi | 0 | $0 | 17.6 |
0% excess
|
| 5 | Jason Cunningham | 82 | 4,683 | $3,138 | 57.1 mi | 8.5 mi | 700 | $469 | 57.1 |
15% excess
|
| 6 | Christopher Womack | 22 | 4,323 | $2,896 | 196.5 mi | 33.1 mi | 728 | $488 | 196.5 |
17% excess
|
| 7 | Xiraiyah Coston | 2 | 2,076 | $1,391 | 1037.8 mi | 1037.8 mi | 2,076 | $1,391 | 1038 |
100% excess
|
| 8 | Minh Huynh | 1 | 1,339 | $897 | 1338.9 mi | 1325.0 mi | 1,325 | $888 | 1339 |
99% excess
|
| 9 | Robert Butler | 3 | 1,007 | $675 | 335.8 mi | 284.3 mi | 853 | $572 | 335.7 |
85% excess
|
| 10 | Michael Swingle | 1 | 427 | $286 | 427.2 mi | 384.3 mi | 384 | $257 | 427 |
90% excess
|
| 11 | Darrell Hendrix | 1 | 414 | $277 | 414.4 mi | 229.5 mi | 229 | $153 | 414 |
55% excess
|
| 12 | Craig Walker | 1 | 186 | $125 | 185.9 mi | 139.3 mi | 139 | $93 | 186 |
75% excess
|
| 13 | Zachary Stieben | 1 | 169 | $113 | 168.9 mi | 162.8 mi | 163 | $109 | 169 |
96% excess
|
| 14 | Christopher Carroll | 1 | 145 | $97 | 145.2 mi | 0.0 mi | 0 | $0 | 145 |
0% excess
|
| 15 | Arturo Diaz | 1 | 125 | $84 | 125.3 mi | 56.1 mi | 56 | $38 | 125 |
45% excess
|