Travel & Margin Analysis

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

Tech Placement Detail →

WOs Analyzed

Total Travel Cost

$964

1,439 miles

Avoidable Cost

$510

761 excess miles

Optimal Cost

$454

If closest tech always used

Avg Excess / WO

84.5 mi

$56.64 per WO

Median Excess

23.2 mi

Outlier Rate (>50mi)

44.4%

4 WOs

Actual Travel Expenses

From 5 WOs with expense data

Total Expenses

$528

Labor - Travel

$155

Mileage

Lodging

$162

Airfare

Car Rental

Per Diem

$175

Meals

Other

$36

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)

$528

5 WOs with expenses

Billed to Client

$317

60% recovery rate

Margin Gap (Unbilled)

$211

Cost absorbed internally

Avg Expense / WO

$106

Avg billed: $63

Internal Cost

$528

Billed

$317

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 %
Per Diem	4	2	$175	$0	$175	0%
Lodging	1	1	$162	$162	$0 ✓	100%
Labor - Travel (Hours)	1	1	$155	$155	$0 ✓	100%
Other Expenses	4	3	$36	$0	$36	0%

Expenses by Vertical

Vertical	WOs	Internal Cost	Billed	Gap	Recovery
FCO	5	$528	$317	$211	60%

Expenses by Order Type

Order Type	WOs	Internal Cost	Billed	Gap	Recovery
Installation	4	$373	$162	$211	43.4%
FCO	1	$155	$155	$0	100%

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