Travel & Margin Analysis

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

Tech Placement Detail →

WOs Analyzed

158

Total Travel Cost

$36,866

55,025 miles

Avoidable Cost

$33,382

49,824 excess miles

Optimal Cost

$3,484

If closest tech always used

Avg Excess / WO

315.3 mi

$211.28 per WO

Median Excess

578.1 mi

Outlier Rate (>50mi)

55.7%

88 WOs

Actual Travel Expenses

From 13 WOs with expense data

Total Expenses

$2,798

Labor - Travel

$2,015

Mileage

Lodging

$237

Airfare

Car Rental

Per Diem

$150

Meals

Other

$397

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)

$2,798

13 WOs with expenses

Billed to Client

$1,322

47.2% recovery rate

Margin Gap (Unbilled)

$1,477

Cost absorbed internally

Avg Expense / WO

$215

Avg billed: $102

Internal Cost

$2,798

Billed

$1,322

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)	6	2	$2,015	$1,085	$930	53.8%
Other Expenses	14	9	$397	$0	$397	0%
Lodging	2	1	$237	$237	$0 ✓	100%
Per Diem	4	2	$150	$0	$150	0%

Expenses by Vertical

Vertical	WOs	Internal Cost	Billed	Gap	Recovery
FCO	13	$2,798	$1,322	$1,477	47.2%

Expenses by Order Type

Order Type	WOs	Internal Cost	Billed	Gap	Recovery
FCO	10	$2,303	$1,085	$1,218	47.1%
Installation	3	$496	$237	$259	47.8%

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