Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
81
Total Travel Cost
$13,267
19,801 miles
Avoidable Cost
$8,847
13,204 excess miles
Optimal Cost
$4,420
If closest tech always used
Avg Excess / WO
163.0 mi
$109.22 per WO
Median Excess
8.5 mi
Outlier Rate (>50mi)
14.8%
12 WOs

Actual Travel Expenses

From 32 WOs with expense data
Total Expenses
$11,270
Labor - Travel
$9,927
Mileage
$105
Lodging
$0
Airfare
$0
Car Rental
$91
Per Diem
$100
Meals
$0
Other
$1,047

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)
$11,270
32 WOs with expenses
Billed to Client
$3,382
30% recovery rate
Margin Gap (Unbilled)
$7,888
Cost absorbed internally
Avg Expense / WO
$352
Avg billed: $106
Internal Cost
$11,270
Billed
$3,382

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) 122 67 $9,927 $3,263 $6,664 32.9%
Other Expenses 22 19 $1,047 $119 $928 11.3%
Mileage 2 1 $105 $0 $105 0%
Per Diem 2 2 $100 $0 $100 0%
Car Rental 2 2 $91 $0 $91 0%
Lodging 1 1 $0 $0 $0 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 16 $6,761 $1,408 $5,352 20.8%
EMS 10 $3,016 $1,955 $1,061 64.8%
Kiosk 43 $970 $0 $970 0%
Animal Health 1 $523 $19 $504 3.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 26 $6,611 $2,604 $4,008 39.4%
Inspection 3 $3,051 $224 $2,828 7.3%
Preventive Maintenance 36 $1,179 $555 $624 47.1%
Repair/PM 2 $429 $0 $429 0%
Connectivity 1 $0 $0 $0 0%
Installation 2 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed