Travel & Margin Analysis

Quantify excess travel cost and identify optimization opportunities across your field service operation

WOs Analyzed

996

Total Travel Cost

$161,819

241,521 miles

Avoidable Cost

$151,430

226,015 excess miles

Optimal Cost

$10,389

If closest tech always used

Avg Excess / WO

226.9 mi

$152.04 per WO

Median Excess

6.8 mi

Outlier Rate (>50mi)

35.3%

352 WOs

From 111 WOs with expense data

Total Expenses

$43,387

Labor - Travel

Mileage

Lodging

$13,824

Airfare

$9,485

Car Rental

$4,698

Per Diem

$3,500

Meals

Other

$11,880

Cost Overview Actual Expenses Cost Breakdowns Coordinator Analysis Tech Utilization Quick Wins Coverage Gaps Low Hanging Fruit

Coordinator Travel Cost Impact

Ranked by total avoidable cost. Use this to identify coaching opportunities and best practices from top performers.

#	Coordinator	WOs	Avg Actual Dist	Avg Excess	Total Excess Miles	Avoidable Cost	Outliers (>50mi)	Outlier Rate
1	Laura Hill	543	235.2 mi	226.9 mi	123,221	$82,558	160	29.5%
2	Melissa Owens	234	208.0 mi	176.0 mi	41,181	$27,591	80	34.2%
3	Rhea Berry	85	184.7 mi	170.1 mi	14,456	$9,686	29	34.1%
4	Matthew Bateman	58	233.7 mi	210.1 mi	12,186	$8,165	28	48.3%
5	Brandi Alvarez	19	517.8 mi	500.3 mi	9,506	$6,369	18	94.7%
6	Abby Jinerson	19	469.1 mi	460.5 mi	8,749	$5,862	16	84.2%
7	Jennifer Johnson	12	433.1 mi	421.5 mi	5,058	$3,389	10	83.3%
8	Mark Franks	13	158.9 mi	150.2 mi	1,953	$1,309	3	23.1%
9	Stephanie Ramen	7	131.7 mi	123.9 mi	867	$581	2	28.6%