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 | 147 | 46,048 | $30,852 | 313.3 mi | 301.9 mi | 44,373 | $29,730 | 313.3 |
96% excess
|
| 2 | Joe Evans | 151 | 25,808 | $17,291 | 170.9 mi | 160.4 mi | 24,214 | $16,223 | 170.9 |
94% excess
|
| 3 | Yves Dessin | 55 | 19,690 | $13,192 | 358 mi | 349.7 mi | 19,233 | $12,886 | 358 |
98% excess
|
| 4 | Praelow Cameron | 51 | 6,017 | $4,031 | 118 mi | 41.5 mi | 2,115 | $1,417 | 118 |
35% excess
|
| 5 | Ray-Anthony Alston | 216 | 3,939 | $2,639 | 18.2 mi | 3.3 mi | 715 | $479 | 18.2 |
18% excess
|
| 6 | Matthew Sebzda | 131 | 3,072 | $2,058 | 23.5 mi | 12.1 mi | 1,586 | $1,063 | 23.5 |
52% excess
|
| 7 | Kenneth Lancara | 8 | 2,313 | $1,550 | 289.1 mi | 279 mi | 2,232 | $1,495 | 289.1 |
96% excess
|
| 8 | Patricia Gordon | 12 | 1,831 | $1,227 | 152.5 mi | 15.8 mi | 189 | $127 | 152.6 |
10% excess
|
| 9 | Fady Khouzam | 3 | 1,627 | $1,090 | 542.2 mi | 471.8 mi | 1,415 | $948 | 542.3 |
87% excess
|
| 10 | Eric Colon | 20 | 1,174 | $787 | 58.7 mi | 15.8 mi | 316 | $212 | 58.7 |
27% excess
|
| 11 | Ryan Lewis | 5 | 841 | $563 | 168.2 mi | 54.1 mi | 271 | $182 | 168.2 |
32% excess
|
| 12 | Minh Huynh | 1 | 754 | $505 | 754 mi | 750.8 mi | 751 | $503 | 754 |
100% excess
|
| 13 | Xiraiyah Coston | 2 | 754 | $505 | 377.2 mi | 364.9 mi | 730 | $489 | 377 |
97% excess
|
| 14 | Rozier Cole | 18 | 684 | $458 | 38 mi | 0 mi | 0 | $0 | 38 |
0% excess
|
| 15 | Alberto Galan | 1 | 568 | $381 | 568.5 mi | 442.7 mi | 443 | $297 | 568 |
78% excess
|
| 16 | Christopher Morning | 3 | 562 | $377 | 187.3 mi | 187.3 mi | 562 | $377 | 187.3 |
100% excess
|
| 17 | Fady Messak | 1 | 515 | $345 | 515 mi | 421.6 mi | 422 | $283 | 515 |
82% excess
|
| 18 | Todd Fogiel | 2 | 325 | $218 | 162.5 mi | 162.5 mi | 325 | $218 | 162.5 |
100% excess
|