Quantify excess travel cost and identify optimization opportunities across your field service operation
Ranked by total avoidable cost across five dimensions. Focus on the top items in each category for the highest ROI improvements.
Which service verticals generate the most excess travel? Clinical Education stands out with very high per-WO excess.
| # | Vertical | WOs | Avoidable Cost | Impact | Avg Excess | Outliers | Flew | Actual Expense | Techs |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Bed Services | 398 | $46,957 | 100% | 176.1 mi | 117 | — | $560 | 21 |
States with the highest total avoidable travel cost.
| # | State | WOs | Avoidable Cost | Impact | Avg Excess | Flew |
|---|---|---|---|---|---|---|
| 1 | VA | 244 | $39,041 | 238.8 mi | — | |
| 2 | SC | 32 | $3,472 | 161.9 mi | — | |
| 3 | WI | 3 | $2,165 | 1,077.3 mi | — | |
| 4 | LA | 24 | $612 | 38.1 mi | — | |
| 5 | PA | 25 | $534 | 31.9 mi | — | |
| 6 | FL | 6 | $484 | 120.6 mi | — | |
| 7 | TX | 3 | $375 | 186.3 mi | — | |
| 8 | OH | 25 | $136 | 8.1 mi | — | |
| 9 | AL | 3 | $91 | 45.5 mi | — | |
| 10 | GA | 21 | $46 | 3.2 mi | — | |
| 11 | IA | 11 | $0 | 0.0 mi | — |
Top cities by total avoidable cost. These are your biggest geographic hotspots.
| # | City | State | WOs | Avoidable Cost | Impact | Avg Excess | Flew |
|---|---|---|---|---|---|---|---|
| 1 | Midlothian | VA | 22 | $22,541 | 1,529.3 mi | — | |
| 2 | Wytheville | VA | 8 | $3,109 | 580.1 mi | — | |
| 3 | Galax | VA | 7 | $2,845 | 606.7 mi | — | |
| 4 | Charleston | SC | 25 | $2,638 | 157.5 mi | — | |
| 5 | Portsmouth | VA | 15 | $2,614 | 260.1 mi | — | |
| 6 | Richmond | VA | 79 | $2,504 | 47.3 mi | — | |
| 7 | Wauwatosa | WI | 3 | $2,165 | 1,077.3 mi | — | |
| 8 | Merchanicsville | VA | 46 | $1,460 | 47.4 mi | — | |
| 9 | Newport News | VA | 14 | $1,368 | 145.9 mi | — | |
| 10 | Petersburg | VA | 39 | $1,177 | 45.1 mi | — | |
| 11 | Franklin | VA | 9 | $959 | 159.1 mi | — | |
| 12 | Greenville | SC | 6 | $673 | 167.5 mi | — | |
| 13 | Harahan | LA | 3 | $612 | 304.6 mi | — | |
| 14 | Philadelphia | PA | 23 | $522 | 33.9 mi | — | |
| 15 | San Antonio | TX | 3 | $375 | 186.3 mi | — | |
| 16 | Wilmington | OH | 4 | $136 | 50.9 mi | — | |
| 17 | Andalusia | AL | 3 | $91 | 45.5 mi | — | |
| 18 | Columbus | GA | 21 | $46 | 3.2 mi | — | |
| 19 | Marianna | FL | 5 | $34 | 10.1 mi | — | |
| 20 | Kilmarnock | VA | 4 | $1 | 0.4 mi | — | |
| 21 | Ottumwa | IA | 11 | $0 | 0.0 mi | — | |
| 22 | Shreveport | LA | 20 | $0 | 0.0 mi | — | |
| 23 | West Chester | OH | 20 | $0 | 0.0 mi | — |
Coordinators whose dispatching decisions result in the most excess travel. High avg excess suggests systematic over-dispatching; high WO count with moderate excess suggests volume-driven impact.
| # | Coordinator | WOs | Avoidable Cost | Impact | Avg Excess | Outliers | Flew | Actual Expense | Techs Used |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Laura Hill | 170 | $28,413 | 249.5 mi | 45 | — | — | 13 | |
| 2 | Melissa Owens | 29 | $4,183 | 215.3 mi | 17 | — | — | 6 | |
| 3 | Abby Jinerson | 78 | $3,532 | 67.6 mi | 25 | — | $12 | 6 | |
| 4 | Jennifer Johnson | 8 | $3,359 | 626.6 mi | 8 | — | — | 3 | |
| 5 | Rhea Berry | 43 | $1,838 | 63.8 mi | 7 | — | — | 5 | |
| 6 | Matthew Bateman | 10 | $525 | 78.3 mi | 3 | — | — | 4 | |
| 7 | Kourtney Smith | 14 | $328 | 35.0 mi | 2 | — | — | 2 | |
| 8 | Charles Ramen | 32 | $64 | 3.0 mi | 1 | — | — | 3 |
Techs who consistently travel far beyond the closest available option. High states-served count may indicate a roaming/national tech; high avg excess with few states suggests a misplaced home base.
| # | Technician | WOs | Avoidable Cost | Impact | Avg Actual Dist | Avg Excess | Outliers | Flew | States | Actual Expense |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Fernando Lemos | 18 | $20,920 | 1,743 mi | 1,734.7 mi | 17 | — | 2 | — | |
| 2 | Side Kick Technician | 27 | $7,003 | 395 mi | 387.1 mi | 27 | — | 1 | — | |
| 3 | Christopher Carroll | 16 | $6,414 | 656 mi | 598.3 mi | 16 | — | 1 | — | |
| 4 | Kevin Cogdill | 19 | $2,768 | 232 mi | 217.5 mi | 19 | — | 1 | — | |
| 5 | Rozier Cole | 13 | $2,328 | 303 mi | 267.2 mi | 13 | — | 1 | — | |
| 6 | Kenneth Lancara | 33 | $1,460 | 99 mi | 66.0 mi | 5 | — | 5 | — | |
| 7 | Joe Evans | 10 | $691 | 117 mi | 103.2 mi | 6 | — | 1 | — | |
| 8 | Pete Ramos | 25 | $534 | 47 mi | 31.9 mi | 0 | — | 1 | — | |
| 9 | David Hernandez | 36 | $451 | 33 mi | 18.7 mi | 1 | — | 2 | — | |
| 10 | Carlos Robles | 71 | $319 | 9 mi | 6.7 mi | 0 | — | 1 | — | |
| 11 | Franco Jackson | 22 | $27 | 14 mi | 1.8 mi | 0 | — | 1 | — | |
| 12 | Jon Sanchez | 44 | $1 | 12 mi | 0.0 mi | 0 | — | 1 | — | |
| 13 | Daniel Clark | 21 | $0 | 11 mi | 0.0 mi | 0 | — | 1 | — | |
| 14 | Mark Stelter | 11 | $0 | 38 mi | 0.0 mi | 0 | — | 1 | — | |
| 15 | Xiraiyah Coston | 16 | $0 | 25 mi | 0.0 mi | 0 | — | 1 | — |