Travel & Margin Analysis

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

Tech Placement Detail →

WOs Analyzed

Total Travel Cost

$7,548

11,266 miles

Avoidable Cost

$5,427

8,101 excess miles

Optimal Cost

$2,121

If closest tech always used

Avg Excess / WO

1,350.1 mi

$904.57 per WO

Median Excess

1,358.6 mi

Outlier Rate (>50mi)

100%

6 WOs

Actual Travel Expenses

From 6 WOs with expense data

Total Expenses

$8,650

Labor - Travel

$7,930

Mileage

Lodging

$140

Airfare

Car Rental

$58

Per Diem

$250

Meals

Other

$272

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)

$8,650

6 WOs with expenses

Billed to Client

$2,375

27.5% recovery rate

Margin Gap (Unbilled)

$6,275

Cost absorbed internally

Avg Expense / WO

$1,442

Avg billed: $396

Internal Cost

$8,650

Billed

$2,375

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)	18	6	$7,930	$2,375	$5,555	29.9%
Other Expenses	4	2	$272	$0	$272	0%
Per Diem	6	3	$250	$0	$250	0%
Lodging	2	2	$140	$0	$140	0%
Car Rental	2	1	$58	$0	$58	0%

Expenses by Vertical

Vertical	WOs	Internal Cost	Billed	Gap	Recovery
FCO	6	$8,650	$2,375	$6,275	27.5%

Expenses by Order Type

Order Type	WOs	Internal Cost	Billed	Gap	Recovery
FCO	6	$8,650	$2,375	$6,275	27.5%

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