Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
15
Total Travel Cost
$1,907
2,846 miles
Avoidable Cost
$0
0 excess miles
Optimal Cost
$1,907
If closest tech always used
Avg Excess / WO
0.0 mi
$0.00 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
0%
0 WOs

Actual Travel Expenses

From 9 WOs with expense data
Total Expenses
$5,390
Labor - Travel
$83
Mileage
$0
Lodging
$1,113
Airfare
$2,833
Car Rental
$658
Per Diem
$450
Meals
$0
Other
$252

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)
$5,390
9 WOs with expenses
Billed to Client
$4,152
77% recovery rate
Margin Gap (Unbilled)
$1,238
Cost absorbed internally
Avg Expense / WO
$599
Avg billed: $461
Internal Cost
$5,390
Billed
$4,152

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
Airfare 5 3 $2,833 $2,127 $706 75.1%
Lodging 7 6 $1,113 $840 $273 75.4%
Car Rental 9 3 $658 $557 $102 84.6%
Per Diem 12 6 $450 $400 $50 88.9%
Other Expenses 12 6 $252 $228 $24 90.3%
Labor - Travel (Hours) 32 13 $83 $0 $83 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Lab/Power 13 $5,390 $4,152 $1,238 77%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 6 $2,631 $1,630 $1,001 62%
Repair/PM 5 $2,496 $2,496 $0 100%
Repair 1 $237 $0 $237 0%
Overhaul 1 $25 $25 $0 100%

Monthly Expense Trend — Internal Cost vs Billed