Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
134
Total Travel Cost
$3,398
5,072 miles
Avoidable Cost
$2,207
3,294 excess miles
Optimal Cost
$1,191
If closest tech always used
Avg Excess / WO
24.6 mi
$16.47 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
4.5%
6 WOs

Actual Travel Expenses

From 6 WOs with expense data
Total Expenses
$10,465
Labor - Travel
$1,235
Mileage
$0
Lodging
$4,934
Airfare
$1,812
Car Rental
$1,310
Per Diem
$675
Meals
$0
Other
$500

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)
$10,465
6 WOs with expenses
Billed to Client
$3,513
33.6% recovery rate
Margin Gap (Unbilled)
$6,953
Cost absorbed internally
Avg Expense / WO
$1,744
Avg billed: $585
Internal Cost
$10,465
Billed
$3,513

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 3 3 $4,934 $493 $4,441 10%
Airfare 2 2 $1,812 $989 $823 54.6%
Car Rental 3 3 $1,310 $177 $1,133 13.5%
Labor - Travel (Hours) 122 79 $1,235 $1,235 $0 ✓ 100%
Per Diem 15 4 $675 $175 $500 25.9%
Other Expenses 5 3 $500 $444 $56 88.9%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Bed Services 80 $10,465 $3,513 $6,953 33.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Cross-Training 2 $7,199 $0 $7,199 0%
Repair 49 $3,242 $3,513 $271 108.4%
Preventive Maintenance 29 $25 $0 $25 0%

Monthly Expense Trend — Internal Cost vs Billed