Travel & Margin Analysis

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

WOs Analyzed

424

Total Travel Cost

$21,838

32,594 miles

Avoidable Cost

$10,735

16,022 excess miles

Optimal Cost

$11,103

If closest tech always used

Avg Excess / WO

37.8 mi

$25.32 per WO

Median Excess

0.0 mi

Outlier Rate (>50mi)

13.4%

57 WOs

From 141 WOs with expense data

Total Expenses

$9,801

Labor - Travel

Mileage

Lodging

$339

Airfare

Car Rental

$204

Per Diem

$475

Meals

Other

$8,783

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	424	37.8 mi	16,022	$10,735

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Preventive Maintenance P	257	45.4 mi	11,670	$7,819
Repair R	74	29.0 mi	2,146	$1,438
Installation P	18	60.6 mi	1,091	$731
Repair/PM R	43	13.8 mi	593	$397
Removal P	19	14.1 mi	268	$180
Connectivity R	12	15.6 mi	187	$125
Relocation P	1	67.0 mi	67	$45

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)
IL	25	471.5 mi	412.6 mi	10,315	$6,911	22 (88%)
OH	114	49.3 mi	22.6 mi	2,576	$1,726	15 (13.2%)
MI	89	52.3 mi	11.5 mi	1,021	$684	10 (11.2%)
IN	69	34.9 mi	8.1 mi	560	$375	1 (1.4%)
WI	4	337.9 mi	127.0 mi	508	$340	3 (75%)
MD	1	369.6 mi	300.6 mi	301	$202	1 (100%)
KY	6	66.9 mi	39.3 mi	236	$158	2 (33.3%)
IA	1	236.5 mi	204.6 mi	205	$137	1 (100%)
WV	6	122.9 mi	23.6 mi	142	$95	2 (33.3%)
MN	97	44.2 mi	1.1 mi	110	$74	0 (0%)
SD	1	216.5 mi	49.2 mi	49	$33	0 (0%)
PA	10	50.5 mi	0.0 mi	0	$0	0 (0%)
KS	1	23.0 mi	0.0 mi	0	$0	0 (0%)