Travel & Margin Analysis

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

WOs Analyzed

331

Total Travel Cost

$16,967

25,324 miles

Avoidable Cost

$10,431

15,568 excess miles

Optimal Cost

$6,536

If closest tech always used

Avg Excess / WO

47.0 mi

$31.51 per WO

Median Excess

0.0 mi

Outlier Rate (>50mi)

23.9%

79 WOs

From 115 WOs with expense data

Total Expenses

$8,104

Labor - Travel

$68

Mileage

Lodging

$486

Airfare

Car Rental

$71

Per Diem

$200

Meals

Other

$7,278

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
Kiosk	331	47.0 mi	15,568	$10,431

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Preventive Maintenance P	227	62.0 mi	14,070	$9,427
Repair/PM R	35	18.3 mi	642	$430
Repair R	58	9.0 mi	521	$349
Connectivity R	6	29.1 mi	174	$117
Installation P	4	25.8 mi	103	$69
Removal P	1	57.5 mi	58	$39

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	97	86.6 mi	59.9 mi	5,808	$3,891	5 (5.2%)
MA	44	148.4 mi	101.2 mi	4,452	$2,983	42 (95.5%)
ME	1	1384.4 mi	1194.4 mi	1,194	$800	1 (100%)
VT	2	743.7 mi	577.9 mi	1,156	$775	1 (50%)
NJ	73	29.0 mi	11.7 mi	856	$574	9 (12.3%)
MI	11	179.8 mi	74.2 mi	816	$547	8 (72.7%)
CT	84	23.3 mi	5.5 mi	460	$308	4 (4.8%)
RI	6	76.9 mi	65.3 mi	392	$263	6 (100%)
IL	1	282.5 mi	249.7 mi	250	$168	1 (100%)
DE	3	51.6 mi	24.6 mi	74	$50	1 (33.3%)
PA	6	49.9 mi	9.8 mi	59	$40	1 (16.7%)
NH	2	132.5 mi	26.0 mi	52	$35	0 (0%)
OH	1	5.7 mi	0.0 mi	0	$0	0 (0%)