Travel & Margin Analysis

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

WOs Analyzed

202

Total Travel Cost

$16,687

24,905 miles

Avoidable Cost

$9,849

14,700 excess miles

Optimal Cost

$6,838

If closest tech always used

Avg Excess / WO

72.8 mi

$48.76 per WO

Median Excess

0.0 mi

Outlier Rate (>50mi)

9.9%

20 WOs

From 55 WOs with expense data

Total Expenses

$4,925

Labor - Travel

Mileage

Lodging

Airfare

Car Rental

$31

Per Diem

$300

Meals

Other

$4,594

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	202	72.8 mi	14,700	$9,849

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Preventive Maintenance P	145	96.9 mi	14,054	$9,416
Repair R	32	8.7 mi	278	$186
Repair/PM R	14	15.1 mi	212	$142
Installation P	4	38.3 mi	153	$103
Connectivity R	5	0.8 mi	4	$3
Removal P	2	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)
CO	19	575.3 mi	530.1 mi	10,072	$6,748	11 (57.9%)
IL	28	200.8 mi	109 mi	3,051	$2,044	3 (10.7%)
TX	96	56 mi	13.1 mi	1,256	$842	4 (4.2%)
NE	2	178.3 mi	76.6 mi	153	$103	2 (100%)
MO	10	40.9 mi	10.7 mi	107	$72	0 (0%)
AZ	4	20.2 mi	11.5 mi	46	$31	0 (0%)
OK	39	43.1 mi	0.2 mi	9	$6	0 (0%)
KS	3	125.2 mi	2.2 mi	7	$5	0 (0%)
WY	1	71.1 mi	0 mi	0	$0	0 (0%)