Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
11
Total Travel Cost
$1,071
1,598 miles
Avoidable Cost
$518
773 excess miles
Optimal Cost
$553
If closest tech always used
Avg Excess / WO
70.3 mi
$47.09 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
27.3%
3 WOs

Actual Travel Expenses

From 6 WOs with expense data
Total Expenses
$1,548
Labor - Travel
$935
Mileage
$134
Lodging
$354
Airfare
$0
Car Rental
$0
Per Diem
$25
Meals
$0
Other
$100

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)
$1,548
6 WOs with expenses
Billed to Client
$65
4.2% recovery rate
Margin Gap (Unbilled)
$1,483
Cost absorbed internally
Avg Expense / WO
$258
Avg billed: $11
Internal Cost
$1,548
Billed
$65

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) 22 7 $935 $0 $935 0%
Lodging 1 1 $354 $0 $354 0%
Mileage 2 1 $134 $0 $134 0%
Other Expenses 5 5 $100 $15 $85 14.6%
Per Diem 1 1 $25 $50 $25 ✓ 200%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 2 $950 $0 $950 0%
EMS 2 $506 $15 $491 2.9%
Kiosk 1 $67 $0 $67 0%
Lab/Power 1 $25 $50 $25 200%
Bed Services 3 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 4 $1,030 $15 $1,015 1.4%
Preventive Maintenance 3 $493 $0 $493 0%
Overhaul 1 $25 $50 $25 200%
Cross-Training 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed