Travel & Margin Analysis

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

WOs Analyzed

504

Total Travel Cost

$100,781

150,420 miles

Avoidable Cost

$75,590

112,820 excess miles

Optimal Cost

$25,192

If closest tech always used

Avg Excess / WO

223.8 mi

$149.98 per WO

Median Excess

23.6 mi

Outlier Rate (>50mi)

41.3%

208 WOs

From 31 WOs with expense data

Total Expenses

$25,417

Labor - Travel

$18,096

Mileage

Lodging

$3,222

Airfare

$1,352

Car Rental

$398

Per Diem

$1,175

Meals

$458

Other

$715

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
FCO	504	223.8 mi	112,820	$75,589

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
FCO P	343	308.6 mi	105,862	$70,928
Preventive Maintenance P	108	34.8 mi	3,755	$2,516
Repair R	29	83.5 mi	2,421	$1,622
PM P	13	51.3 mi	667	$447
Installation P	9	12.8 mi	116	$78
New Hire Training P	1	0 mi	0	$0
Training 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)
TX	84	1018.8 mi	903.9 mi	75,927	$50,871	67 (79.8%)
FL	23	481.8 mi	429.1 mi	9,868	$6,612	17 (73.9%)
KS	12	613.3 mi	419.5 mi	5,034	$3,373	12 (100%)
MA	9	362.3 mi	329.6 mi	2,966	$1,987	3 (33.3%)
OK	6	436.2 mi	395.1 mi	2,371	$1,589	2 (33.3%)
TN	32	212.8 mi	71.6 mi	2,293	$1,536	16 (50%)
PA	39	86.7 mi	53.6 mi	2,091	$1,401	12 (30.8%)
SC	6	361.8 mi	235.9 mi	1,415	$948	3 (50%)
VA	30	82.5 mi	47.1 mi	1,413	$947	16 (53.3%)
MD	29	83.1 mi	48.6 mi	1,408	$943	17 (58.6%)
WV	11	228.2 mi	103.3 mi	1,136	$761	8 (72.7%)
NY	56	54.4 mi	16.2 mi	908	$608	2 (3.6%)
CT	14	105.8 mi	61.6 mi	863	$578	9 (64.3%)
NJ	50	42.5 mi	17.2 mi	858	$575	3 (6%)
AL	6	199.3 mi	142.7 mi	856	$574	1 (16.7%)
NC	7	195.5 mi	116.5 mi	815	$546	7 (100%)
MI	4	292.9 mi	154.9 mi	620	$415	2 (50%)
DC	9	100.8 mi	61.6 mi	555	$372	5 (55.6%)
GA	7	135.7 mi	74.7 mi	523	$350	1 (14.3%)
DE	5	94.2 mi	62.7 mi	314	$210	3 (60%)
VT	5	216.8 mi	46.8 mi	234	$157	1 (20%)
MO	1	435.9 mi	173 mi	173	$116	1 (100%)
OH	15	78.4 mi	6.3 mi	94	$63	0 (0%)
KY	4	191.1 mi	19.2 mi	77	$52	0 (0%)
CA	1	62.8 mi	8.7 mi	9	$6	0 (0%)
IN	6	30.2 mi	0 mi	0	$0	0 (0%)
LA	8	269.1 mi	0 mi	0	$0	0 (0%)
NH	16	129.2 mi	0 mi	0	$0	0 (0%)
Tx	9	13.9 mi	0 mi	0	$0	0 (0%)