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 | Patricia Gordon | 8 | 12,031 | $8,061 | 1503.9 mi | 1018.0 mi | 8,144 | $5,456 | 1503.9 |
68% excess
|
| 2 | Davon Cox | 5 | 9,467 | $6,343 | 1893.3 mi | 1408.4 mi | 7,042 | $4,718 | 1893.4 |
74% excess
|
| 3 | Fady Khouzam | 5 | 6,885 | $4,613 | 1376.9 mi | 1326.1 mi | 6,630 | $4,442 | 1377 |
96% excess
|
| 4 | Bruce Ballard | 5 | 6,388 | $4,280 | 1277.6 mi | 788.6 mi | 3,943 | $2,642 | 1277.6 |
62% excess
|
| 5 | Shady Messak | 2 | 3,742 | $2,507 | 1870.8 mi | 1381.8 mi | 2,764 | $1,852 | 1871 |
74% excess
|
| 6 | Luis Iser | 2 | 3,271 | $2,192 | 1635.7 mi | 1146.8 mi | 2,294 | $1,537 | 1635.5 |
70% excess
|
| 7 | Samuel Biddie | 2 | 2,268 | $1,520 | 1134.0 mi | 645.0 mi | 1,290 | $864 | 1134 |
57% excess
|
| 8 | Rick Charles | 1 | 1,824 | $1,222 | 1823.6 mi | 1334.7 mi | 1,335 | $894 | 1824 |
73% excess
|