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 | Ronnie Salone | 157 | 6,178 | $4,139 | 39.4 mi | 0.7 mi | 110 | $74 | 39.4 |
2% excess
|
| 2 | Charles Sellon | 4 | 4,420 | $2,961 | 1105.1 mi | 1090.3 mi | 4,361 | $2,922 | 1105 |
99% excess
|
| 3 | Minh Huynh | 2 | 2,204 | $1,477 | 1102.2 mi | 1086.8 mi | 2,174 | $1,457 | 1102 |
99% excess
|
| 4 | Jon Kuehl | 3 | 1,205 | $807 | 401.8 mi | 395.3 mi | 1,186 | $795 | 401.7 |
98% excess
|
| 5 | Scott E Yelverton | 1 | 1,105 | $740 | 1105.0 mi | 1100.4 mi | 1,100 | $737 | 1105 |
100% excess
|
| 6 | Saul Morales | 1 | 1,012 | $678 | 1012.0 mi | 1007.3 mi | 1,007 | $675 | 1012 |
100% excess
|
| 7 | Carlos Puebla | 1 | 1,009 | $676 | 1009.4 mi | 652.8 mi | 653 | $438 | 1009 |
65% excess
|
| 8 | Philmon Mehari | 1 | 995 | $667 | 995.0 mi | 638.4 mi | 638 | $427 | 995 |
64% excess
|
| 9 | Ryan Lewis | 1 | 911 | $610 | 911.3 mi | 542.6 mi | 543 | $364 | 911 |
60% excess
|
| 10 | Bruce Ballard | 1 | 889 | $596 | 889.1 mi | 532.5 mi | 532 | $356 | 889 |
60% excess
|