Travel & Margin Analysis

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

WOs Analyzed

272

Total Travel Cost

$18,125

27,052 miles

Avoidable Cost

$6,672

9,958 excess miles

Optimal Cost

$11,453

If closest tech always used

Avg Excess / WO

36.6 mi

$24.53 per WO

Median Excess

0.0 mi

Outlier Rate (>50mi)

12.1%

33 WOs

From 171 WOs with expense data

Total Expenses

$40,680

Labor - Travel

$16,742

Mileage

$18,126

Lodging

$1,409

Airfare

$1,160

Car Rental

$484

Per Diem

$900

Meals

Other

$1,858

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

Cost by Vertical

Vertical	WOs	Avg Excess	Total Excess	Avoidable Cost
EMS	272	36.6 mi	9,958	$6,672

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Preventive Maintenance P	108	64.3 mi	6,947	$4,654
Repair R	128	20.4 mi	2,606	$1,746
Evaluation P	29	12.5 mi	362	$243
Inspection P	2	21.8 mi	44	$29
Installation P	5	0 mi	0	$0

States with high avg actual distance may indicate coverage gaps requiring territory realignment or new hires.

State	WOs	Avg Actual	Avg Excess	Total Excess Miles	Avoidable Cost	Outliers (>50mi)
WI	4	1093.4 mi	828.7 mi	3,315	$2,221	4 (100%)
IL	7	667.8 mi	427.9 mi	2,995	$2,007	7 (100%)
OH	187	56 mi	12.8 mi	2,393	$1,603	15 (8%)
KY	39	93 mi	13.3 mi	519	$348	1 (2.6%)
WV	15	153.6 mi	27.1 mi	407	$273	4 (26.7%)
MI	3	130.9 mi	49.6 mi	149	$100	1 (33.3%)
IA	1	256.9 mi	95.6 mi	96	$64	1 (100%)
MD	2	139.9 mi	42.8 mi	86	$58	0 (0%)
IN	2	51.4 mi	0 mi	0	$0	0 (0%)
MO	1	19.1 mi	0 mi	0	$0	0 (0%)
PA	11	50.3 mi	0 mi	0	$0	0 (0%)