Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
58
Total Travel Cost
$3,803
5,677 miles
Avoidable Cost
$2,679
3,998 excess miles
Optimal Cost
$1,124
If closest tech always used
Avg Excess / WO
68.9 mi
$46.19 per WO
Median Excess
2.0 mi
Outlier Rate (>50mi)
12.1%
7 WOs

Actual Travel Expenses

From 3 WOs with expense data
Total Expenses
$769
Labor - Travel
$165
Mileage
$0
Lodging
$394
Airfare
$0
Car Rental
$0
Per Diem
$125
Meals
$0
Other
$86

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)
$769
3 WOs with expenses
Billed to Client
$181
23.5% recovery rate
Margin Gap (Unbilled)
$589
Cost absorbed internally
Avg Expense / WO
$256
Avg billed: $60
Internal Cost
$769
Billed
$181

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
Lodging 1 1 $394 $0 $394 0%
Labor - Travel (Hours) 2 2 $165 $165 $0 ✓ 100%
Per Diem 3 1 $125 $0 $125 0%
Other Expenses 3 3 $86 $16 $70 18.1%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 2 $704 $181 $524 25.6%
Kiosk 1 $65 $0 $65 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Inspection 1 $524 $0 $524 0%
Preventive Maintenance 1 $181 $181 $0 100%
Repair 1 $65 $0 $65 0%

Monthly Expense Trend — Internal Cost vs Billed