Travel & Margin Analysis

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

WOs Analyzed

108

Total Travel Cost

$15,031

22,434 miles

Avoidable Cost

$13,768

20,550 excess miles

Optimal Cost

$1,263

If closest tech always used

Avg Excess / WO

190.3 mi

$127.48 per WO

Median Excess

98.4 mi

Outlier Rate (>50mi)

72.2%

78 WOs

From 16 WOs with expense data

Total Expenses

$941

Labor - Travel

Mileage

Lodging

$415

Airfare

Car Rental

Per Diem

$500

Meals

Other

$26

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
Lab/Power	108	190.3 mi	20,550	$13,769

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Monthly Annuity P	12	859.5 mi	10,314	$6,910
Preventive Maintenance P	49	82.2 mi	4,028	$2,699
Overhaul P	2	1607.2 mi	3,214	$2,153
Repair R	23	85.3 mi	1,963	$1,315
EOQ P	15	59 mi	885	$593
IOQ P	1	73.1 mi	73	$49
Installation P	1	73.1 mi	73	$49
Cross-Training P	2	0 mi	0	$0
Repair/PM R	3	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)	Cost Distribution
TX	108	207.7 mi	190.3 mi	20,550	$13,769	78 (72.2%)