Travel & Margin Analysis

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

WOs Analyzed

314

Total Travel Cost

$8,716

13,008 miles

Avoidable Cost

$8,062

12,033 excess miles

Optimal Cost

$654

If closest tech always used

Avg Excess / WO

38.3 mi

$25.67 per WO

Median Excess

4.3 mi

Outlier Rate (>50mi)

5.4%

17 WOs

From 5 WOs with expense data

Total Expenses

$255

Labor - Travel

Mileage

Lodging

Airfare

Car Rental

Per Diem

Meals

Other

$255

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	314	38.3 mi	12,033	$8,062

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Repair R	312	38.6 mi	12,028	$8,059
Inventory P	1	4.3 mi	4	$3
Acct. Management 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)
MI	13	653.6 mi	612.1 mi	7,957	$5,331	13 (100%)
MA	296	8.5 mi	7.3 mi	2,159	$1,447	0 (0%)
NY	3	326.5 mi	315.4 mi	946	$634	3 (100%)
AL	1	974.6 mi	942.1 mi	942	$631	1 (100%)
NH	1	38.8 mi	28.2 mi	28	$19	0 (0%)