Travel & Margin Analysis

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

WOs Analyzed

285

Total Travel Cost

$22,914

34,200 miles

Avoidable Cost

$13,344

19,916 excess miles

Optimal Cost

$9,571

If closest tech always used

Avg Excess / WO

69.9 mi

$46.82 per WO

Median Excess

0.0 mi

Outlier Rate (>50mi)

8.8%

25 WOs

From 91 WOs with expense data

Total Expenses

$20,141

Labor - Travel

$273

Mileage

Lodging

$5,323

Airfare

Car Rental

$31

Per Diem

$2,925

Meals

Other

$11,588

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	285	69.9 mi	19,916	$13,344

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Preventive Maintenance P	178	105.1 mi	18,713	$12,538
Repair R	61	8.2 mi	503	$337
Installation P	9	39.9 mi	359	$241
Repair/PM R	22	12.7 mi	279	$187
Connectivity R	9	5.7 mi	51	$34
Relocation P	1	10.9 mi	11	$7
Removal P	4	0.0 mi	0	$0
Cross-Training P	1	0.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	43	265.0 mi	174.2 mi	7,489	$5,018	7 (16.3%)
TX	140	55.1 mi	14.2 mi	1,991	$1,334	5 (3.6%)
NE	2	178.3 mi	76.6 mi	153	$103	2 (100%)
MO	18	37.5 mi	6.7 mi	120	$80	0 (0%)
AZ	10	31.5 mi	7.6 mi	76	$51	0 (0%)
OK	40	43.8 mi	0.2 mi	9	$6	0 (0%)
KS	6	97.9 mi	1.1 mi	7	$5	0 (0%)
WY	1	71.1 mi	0.0 mi	0	$0	0 (0%)
FL	3	78.4 mi	0.0 mi	0	$0	0 (0%)
IN	2	50.1 mi	0.0 mi	0	$0	0 (0%)
MN	1	65.2 mi	0.0 mi	0	$0	0 (0%)