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 | Ryan Lewis | 17 | 3,201 | $2,145 | 188.3 mi | 27.3 mi | 464 | $311 | 188.3 |
14% excess
|
| 2 | Patricia Gordon | 14 | 2,027 | $1,358 | 144.8 mi | 13.5 mi | 189 | $127 | 144.8 |
9% excess
|
| 3 | Fady Khouzam | 3 | 1,627 | $1,090 | 542.3 mi | 471.8 mi | 1,415 | $948 | 542.3 |
87% excess
|
| 4 | Bennet O Dartey | 1 | 674 | $452 | 673.5 mi | 579.9 mi | 580 | $389 | 674 |
86% excess
|
| 5 | Alberto Galan | 1 | 568 | $381 | 568.5 mi | 442.7 mi | 443 | $297 | 568 |
78% excess
|
| 6 | Fady Messak | 1 | 515 | $345 | 515.0 mi | 421.6 mi | 422 | $283 | 515 |
82% excess
|