Travel & Margin Analysis

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

Tech Placement Detail →

WOs Analyzed

Total Travel Cost

$1,149

1,715 miles

Avoidable Cost

$924

1,379 excess miles

Optimal Cost

$225

If closest tech always used

Avg Excess / WO

197.0 mi

$132.01 per WO

Median Excess

254.0 mi

Outlier Rate (>50mi)

85.7%

6 WOs

Actual Travel Expenses

From 6 WOs with expense data

Total Expenses

$506

Labor - Travel

Mileage

Lodging

$241

Airfare

Car Rental

Per Diem

$250

Meals

Other

$15

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)

$506

6 WOs with expenses

Billed to Client

$241

47.6% recovery rate

Margin Gap (Unbilled)

$265

Cost absorbed internally

Avg Expense / WO

$84

Avg billed: $40

Internal Cost

$506

Billed

$241

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	6	5	$250	$0	$250	0%
Lodging	3	3	$241	$241	$0 ✓	100%
Other Expenses	3	2	$15	$0	$15	0%

Expenses by Vertical

Vertical	WOs	Internal Cost	Billed	Gap	Recovery
FCO	6	$506	$241	$265	47.6%

Expenses by Order Type

Order Type	WOs	Internal Cost	Billed	Gap	Recovery
FCO	4	$451	$241	$210	53.4%
Installation	2	$55	$0	$55	0%

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