Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
83
Total Travel Cost
$23,977
35,787 miles
Avoidable Cost
$21,608
32,251 excess miles
Optimal Cost
$2,369
If closest tech always used
Avg Excess / WO
388.6 mi
$260.34 per WO
Median Excess
304.6 mi
Outlier Rate (>50mi)
97.6%
81 WOs

Actual Travel Expenses

From 29 WOs with expense data
Total Expenses
$24,314
Labor - Travel
$10,236
Mileage
$0
Lodging
$5,523
Airfare
$2,906
Car Rental
$2,337
Per Diem
$1,525
Meals
$0
Other
$1,787

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)
$24,314
29 WOs with expenses
Billed to Client
$28,901
118.9% recovery rate
Margin Gap (Unbilled)
$-4,587
Cost absorbed internally
Avg Expense / WO
$838
Avg billed: $997
Internal Cost
$24,314
Billed
$28,901

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 % Gap Distribution
Labor - Travel (Hours) 51 29 $10,236 $10,236 $0 ✓ 100%
Lodging 5 5 $5,523 $7,561 $2,038 ✓ 136.9%
Airfare 7 5 $2,906 $4,040 $1,134 ✓ 139%
Car Rental 8 5 $2,337 $3,228 $890 ✓ 138.1%
Other Expenses 21 5 $1,787 $1,701 $86 95.2%
Per Diem 33 8 $1,525 $2,135 $610 ✓ 140%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Project 26 $20,668 $25,081 $4,413 121.3%
Bed Services 3 $3,645 $3,820 $174 104.8%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 29 $24,314 $28,901 $4,587 118.9%

Monthly Expense Trend — Internal Cost vs Billed