Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
118
Total Travel Cost
$4,562
6,808 miles
Avoidable Cost
$1,462
2,182 excess miles
Optimal Cost
$3,100
If closest tech always used
Avg Excess / WO
18.5 mi
$12.39 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
9.3%
11 WOs

Actual Travel Expenses

From 12 WOs with expense data
Total Expenses
$9,916
Labor - Travel
$8,021
Mileage
$0
Lodging
$846
Airfare
$0
Car Rental
$0
Per Diem
$425
Meals
$0
Other
$624

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)
$9,916
12 WOs with expenses
Billed to Client
$6,619
66.8% recovery rate
Margin Gap (Unbilled)
$3,297
Cost absorbed internally
Avg Expense / WO
$826
Avg billed: $552
Internal Cost
$9,916
Billed
$6,619

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) 71 41 $8,021 $5,700 $2,321 71.1%
Lodging 7 3 $846 $605 $241 71.6%
Other Expenses 29 19 $624 $39 $585 6.2%
Per Diem 10 4 $425 $275 $150 64.7%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 3 $7,793 $5,835 $1,957 74.9%
Healthcare Provider 1 $814 $784 $30 96.3%
EMS 2 $743 $0 $743 0%
Bed Services 38 $566 $0 $566 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 2 $6,187 $4,185 $2,002 67.6%
Installation 1 $1,605 $1,650 $45 102.8%
Repair 21 $1,309 $0 $1,309 0%
Delivery 1 $814 $784 $30 96.3%
Preventive Maintenance 19 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed