Travel & Margin Analysis

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

WOs Analyzed

276

Total Travel Cost

$12,529

18,700 miles

Avoidable Cost

$7,704

11,499 excess miles

Optimal Cost

$4,825

If closest tech always used

Avg Excess / WO

41.7 mi

$27.91 per WO

Median Excess

10.2 mi

Outlier Rate (>50mi)

18.5%

51 WOs

From 18 WOs with expense data

Total Expenses

$10,450

Labor - Travel

$4,766

Mileage

Lodging

$2,146

Airfare

$1,225

Car Rental

$891

Per Diem

$725

Meals

Other

$698

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	276	41.7 mi	11,499	$7,704

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Inspection P	69	52.6 mi	3,628	$2,431
Repair R	152	17.8 mi	2,712	$1,817
Monthly Annuity P	5	428.2 mi	2,141	$1,434
Cross-Training P	6	234.2 mi	1,405	$941
Misc. Inspection P	16	67.7 mi	1,083	$726
Preventive Maintenance P	17	12.9 mi	219	$147
Evaluation P	6	26.8 mi	161	$108
Relocation P	1	148.9 mi	149	$100
Delivery P	3	0.3 mi	1	$1
Installation P	1	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)
NY	31	129.9 mi	114.5 mi	3,550	$2,379	8 (25.8%)
CA	28	57.1 mi	32.9 mi	921	$617	3 (10.7%)
TX	26	61.5 mi	34.4 mi	895	$600	4 (15.4%)
FL	23	64.1 mi	32.8 mi	754	$505	7 (30.4%)
NC	21	61.2 mi	29.1 mi	610	$409	5 (23.8%)
CT	13	62.8 mi	46 mi	599	$401	6 (46.2%)
CO	3	196.9 mi	196.5 mi	590	$395	1 (33.3%)
VA	6	122.9 mi	93.7 mi	562	$377	4 (66.7%)
MA	14	49.4 mi	34.2 mi	479	$321	2 (14.3%)
MI	11	52.6 mi	30.4 mi	334	$224	1 (9.1%)
OH	11	48.5 mi	30.3 mi	333	$223	2 (18.2%)
PA	16	43.8 mi	18 mi	288	$193	1 (6.3%)
IL	3	137.3 mi	92.9 mi	279	$187	2 (66.7%)
GA	9	73.1 mi	30.4 mi	273	$183	1 (11.1%)
KY	2	164.4 mi	128.1 mi	256	$172	2 (100%)
SC	1	187.3 mi	187.3 mi	187	$125	1 (100%)
MD	6	45.4 mi	24.3 mi	146	$98	0 (0%)
AZ	4	71.9 mi	28.8 mi	115	$77	0 (0%)
TN	7	36.3 mi	15.8 mi	111	$74	0 (0%)
AL	6	76.7 mi	9.5 mi	57	$38	0 (0%)
LA	1	125.3 mi	56.1 mi	56	$38	1 (100%)
NJ	6	16.2 mi	8.1 mi	49	$33	0 (0%)
MO	6	29.6 mi	6.6 mi	40	$27	0 (0%)
RI	4	7.3 mi	2.8 mi	11	$7	0 (0%)
IN	1	12.9 mi	4.7 mi	5	$3	0 (0%)
AR	3	77.6 mi	0 mi	0	$0	0 (0%)
DE	3	15.2 mi	0 mi	0	$0	0 (0%)
ID	3	40.6 mi	0 mi	0	$0	0 (0%)
ME	1	234.2 mi	0 mi	0	$0	0 (0%)
NV	2	5.4 mi	0 mi	0	$0	0 (0%)
OR	2	38.8 mi	0 mi	0	$0	0 (0%)
WA	3	12.9 mi	0 mi	0	$0	0 (0%)