Travel & Margin Analysis

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

Tech Placement Detail →

WOs Analyzed

147

Total Travel Cost

$23,493

35,064 miles

Avoidable Cost

$20,014

29,871 excess miles

Optimal Cost

$3,479

If closest tech always used

Avg Excess / WO

203.2 mi

$136.15 per WO

Median Excess

40.7 mi

Outlier Rate (>50mi)

44.2%

65 WOs

Actual Travel Expenses

From 38 WOs with expense data

Total Expenses

$4,774

Labor - Travel

$3,294

Mileage

Lodging

$470

Airfare

Car Rental

Per Diem

$150

Meals

Other

$861

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,774

38 WOs with expenses

Billed to Client

$2,359

49.4% recovery rate

Margin Gap (Unbilled)

$2,415

Cost absorbed internally

Avg Expense / WO

$126

Avg billed: $62

Internal Cost

$4,774

Billed

$2,359

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)	21	13	$3,294	$2,015	$1,279	61.2%
Other Expenses	25	24	$861	$0	$861	0%
Lodging	3	3	$470	$344	$125	73.3%
Per Diem	5	5	$150	$0	$150	0%

Expenses by Vertical

Vertical	WOs	Internal Cost	Billed	Gap	Recovery
FCO	39	$4,774	$2,359	$2,415	49.4%

Expenses by Order Type

Order Type	WOs	Internal Cost	Billed	Gap	Recovery
FCO	30	$2,523	$964	$1,559	38.2%
Repair	9	$2,251	$1,395	$856	62%

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