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 | Kevin Cogdill | 252 | 73,901 | $49,514 | 293.3 mi | 281.5 mi | 70,929 | $47,522 | 293.3 |
96% excess
|
| 2 | Joe Evans | 288 | 49,435 | $33,121 | 171.7 mi | 161.0 mi | 46,363 | $31,063 | 171.6 |
94% excess
|
| 3 | Yves Dessin | 76 | 29,100 | $19,497 | 382.9 mi | 374.2 mi | 28,442 | $19,056 | 382.9 |
98% excess
|
| 4 | Praelow Cameron | 62 | 6,997 | $4,688 | 112.9 mi | 38.0 mi | 2,356 | $1,579 | 112.9 |
34% excess
|
| 5 | Ray-Anthony Alston | 385 | 6,669 | $4,468 | 17.3 mi | 2.3 mi | 896 | $600 | 17.3 |
13% excess
|
| 6 | Matthew Sebzda | 148 | 3,393 | $2,273 | 22.9 mi | 11.6 mi | 1,710 | $1,146 | 22.9 |
50% excess
|
| 7 | Eric Colon | 53 | 3,334 | $2,234 | 62.9 mi | 23.0 mi | 1,218 | $816 | 62.9 |
37% excess
|
| 8 | Ryan Lewis | 17 | 3,201 | $2,145 | 188.3 mi | 27.3 mi | 464 | $311 | 188.3 |
14% excess
|
| 9 | Kenneth Lancara | 8 | 2,313 | $1,550 | 289.1 mi | 279.0 mi | 2,232 | $1,495 | 289.1 |
96% excess
|
| 10 | Patricia Gordon | 14 | 2,027 | $1,358 | 144.8 mi | 13.5 mi | 189 | $127 | 144.8 |
9% excess
|
| 11 | Ronnie Salone | 2 | 1,793 | $1,201 | 896.3 mi | 0.0 mi | 0 | $0 | 896.5 |
0% excess
|
| 12 | Fady Khouzam | 3 | 1,627 | $1,090 | 542.3 mi | 471.8 mi | 1,415 | $948 | 542.3 |
87% excess
|
| 13 | Minh Huynh | 2 | 1,543 | $1,034 | 771.7 mi | 751.0 mi | 1,502 | $1,006 | 771.5 |
97% excess
|
| 14 | Rozier Cole | 27 | 1,339 | $897 | 49.6 mi | 12.5 mi | 337 | $226 | 49.6 |
25% excess
|
| 15 | Christopher Morning | 7 | 1,120 | $750 | 160.0 mi | 153.5 mi | 1,074 | $720 | 160 |
96% excess
|
| 16 | Xiraiyah Coston | 2 | 754 | $505 | 377.2 mi | 364.9 mi | 730 | $489 | 377 |
97% excess
|
| 17 | Bennet O Dartey | 1 | 674 | $452 | 673.5 mi | 579.9 mi | 580 | $389 | 674 |
86% excess
|
| 18 | Alberto Galan | 1 | 568 | $381 | 568.5 mi | 442.7 mi | 443 | $297 | 568 |
78% excess
|
| 19 | Fady Messak | 1 | 515 | $345 | 515.0 mi | 421.6 mi | 422 | $283 | 515 |
82% excess
|
| 20 | Todd Fogiel | 2 | 325 | $218 | 162.5 mi | 162.5 mi | 325 | $218 | 162.5 |
100% excess
|
| 21 | Cynthia G Deville | 1 | 119 | $80 | 118.7 mi | 36.1 mi | 36 | $24 | 119 |
30% excess
|