Travel & Margin Analysis

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

WOs Analyzed

199

Total Travel Cost

$7,442

11,107 miles

Avoidable Cost

$3,751

5,599 excess miles

Optimal Cost

$3,691

If closest tech always used

Avg Excess / WO

28.1 mi

$18.85 per WO

Median Excess

0.0 mi

Outlier Rate (>50mi)

17.6%

35 WOs

From 115 WOs with expense data

Total Expenses

$46,016

Labor - Travel

$43,018

Mileage

Lodging

$1,609

Airfare

Car Rental

$50

Per Diem

$875

Meals

Other

$464

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
Healthcare Provider	199	28.1 mi	5,599	$3,751

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Repair R	134	23.0 mi	3,080	$2,064
Inspection P	33	50.2 mi	1,655	$1,109
Delivery P	5	59.7 mi	299	$200
Misc. Inspection P	11	22.0 mi	242	$162
Preventive Maintenance P	8	23.8 mi	190	$127
Evaluation P	1	90.4 mi	90	$60
Installation P	3	7.4 mi	22	$15
Calibration P	1	10.0 mi	10	$7
Removal P	1	10.3 mi	10	$7
Cross-Training P	1	0.0 mi	0	$0
Support R	1	0.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)
IN	5	301.3 mi	268.5 mi	1,343	$900	1 (20%)
MS	15	133.4 mi	78.2 mi	1,173	$786	15 (100%)
FL	25	46.3 mi	25.6 mi	640	$429	6 (24%)
OH	12	74.2 mi	43.5 mi	522	$350	4 (33.3%)
MO	4	116.3 mi	92.2 mi	369	$247	2 (50%)
KY	3	156.0 mi	99.6 mi	299	$200	2 (66.7%)
TX	17	44.4 mi	14.7 mi	250	$168	1 (5.9%)
KS	1	203.9 mi	190.6 mi	191	$128	1 (100%)
VA	1	173.6 mi	166.6 mi	167	$112	1 (100%)
MI	4	74.2 mi	34.9 mi	139	$93	1 (25%)
NC	5	65.3 mi	25.1 mi	125	$84	1 (20%)
GA	14	36.9 mi	7.9 mi	111	$74	0 (0%)
MA	4	53.5 mi	25.0 mi	100	$67	0 (0%)
NY	11	33.7 mi	5.2 mi	57	$38	0 (0%)
CA	38	11.0 mi	1.5 mi	56	$38	0 (0%)
PA	3	20.3 mi	10.6 mi	32	$21	0 (0%)
AZ	1	18.8 mi	15.6 mi	16	$11	0 (0%)
NJ	4	17.1 mi	2.5 mi	10	$7	0 (0%)
WI	1	177.2 mi	0.0 mi	0	$0	0 (0%)
DE	2	10.5 mi	0.0 mi	0	$0	0 (0%)
LA	1	52.5 mi	0.0 mi	0	$0	0 (0%)
MD	2	72.7 mi	0.0 mi	0	$0	0 (0%)
MN	1	171.2 mi	0.0 mi	0	$0	0 (0%)
OK	2	18.9 mi	0.0 mi	0	$0	0 (0%)
SC	1	180.2 mi	0.0 mi	0	$0	0 (0%)
TN	1	29.3 mi	0.0 mi	0	$0	0 (0%)
WA	20	15.1 mi	0.0 mi	0	$0	0 (0%)
AR	1	77.3 mi	0.0 mi	0	$0	0 (0%)