Travel & Margin Analysis

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

WOs Analyzed

182

Total Travel Cost

$19,695

29,395 miles

Avoidable Cost

$18,496

27,606 excess miles

Optimal Cost

$1,199

If closest tech always used

Avg Excess / WO

151.7 mi

$101.63 per WO

Median Excess

32.5 mi

Outlier Rate (>50mi)

38.5%

70 WOs

From 77 WOs with expense data

Total Expenses

$17,286

Labor - Travel

$15,716

Mileage

Lodging

$537

Airfare

Car Rental

Per Diem

$275

Meals

Other

$758

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
Project	71	303.9 mi	21,575	$14,455
FCO	111	54.3 mi	6,031	$4,041

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Upgrade P	71	303.9 mi	21,575	$14,455
Repair R	57	75.7 mi	4,315	$2,891
FCO P	24	32.9 mi	791	$530
Preventive Maintenance P	21	31.7 mi	665	$446
PM P	6	38.6 mi	232	$155
Installation P	3	9.7 mi	29	$19

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)
FL	73	318.2 mi	311.1 mi	22,711	$15,216	42 (57.5%)
NJ	36	76.9 mi	67.5 mi	2,430	$1,628	13 (36.1%)
NY	55	32.0 mi	22.9 mi	1,257	$842	2 (3.6%)
PA	11	95.2 mi	77.1 mi	848	$568	10 (90.9%)
MD	2	136.0 mi	99.6 mi	199	$133	2 (100%)
VA	1	139.4 mi	115.5 mi	116	$78	1 (100%)
CT	1	104.2 mi	44.8 mi	45	$30	0 (0%)
NC	1	18.0 mi	0.0 mi	0	$0	0 (0%)
MA	1	35.0 mi	0.0 mi	0	$0	0 (0%)
AL	1	23.3 mi	0.0 mi	0	$0	0 (0%)