Travel & Margin Analysis

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

Tech Placement Detail →

WOs Analyzed

Total Travel Cost

$8,512

12,704 miles

Avoidable Cost

$2,057

3,070 excess miles

Optimal Cost

$6,455

If closest tech always used

Avg Excess / WO

32.7 mi

$21.88 per WO

Median Excess

19.6 mi

Outlier Rate (>50mi)

13.8%

13 WOs

Actual Travel Expenses

From 35 WOs with expense data

Total Expenses

$4,997

Labor - Travel

$2,170

Mileage

Lodging

$1,775

Airfare

Car Rental

$30

Per Diem

$800

Meals

Other

$221

Cost Overview Actual Expenses Cost Breakdowns Coordinator Analysis Tech Utilization Quick Wins Coverage Gaps Low Hanging Fruit

Billable vs Internal Cost — Margin Gap

Compares what was billed to clients against what we actually paid for travel expenses. The gap represents unbilled internal cost.

Internal Cost (What We Paid)

$4,997

35 WOs with expenses

Billed to Client

$2,217

44.4% recovery rate

Margin Gap (Unbilled)

$2,780

Cost absorbed internally

Avg Expense / WO

$143

Avg billed: $63

Internal Cost

$4,997

Billed

$2,217

Expense Breakdown by Category

Internal cost vs billed amount by expense type. Negative margin = we paid more than we billed.

Category	Lines	WOs	Internal Cost	Billed to Client	Margin Gap	Recovery %
Labor - Travel (Hours)	54	46	$2,170	$1,395	$775	64.3%
Lodging	11	9	$1,775	$822	$953	46.3%
Per Diem	21	16	$800	$0	$800	0%
Other Expenses	19	18	$221	$0	$221	0%
Car Rental	1	1	$30	$0	$30	0%

Expenses by Vertical

Vertical	WOs	Internal Cost	Billed	Gap	Recovery
FCO	58	$4,997	$2,217	$2,780	44.4%

Expenses by Order Type

Order Type	WOs	Internal Cost	Billed	Gap	Recovery
FCO	16	$3,023	$1,878	$1,146	62.1%
Preventive Maintenance	39	$1,515	$0	$1,515	0%
Installation	3	$459	$340	$120	74%

Travel & Margin Analysis

Actual Travel Expenses

Billable vs Internal Cost — Margin Gap

Expense Breakdown by Category

Expenses by Vertical

Expenses by Order Type

Monthly Expense Trend — Internal Cost vs Billed