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
$5,607
8,369 miles
Avoidable Cost
$3,733
5,572 excess miles
Optimal Cost
$1,874
If closest tech always used
Avg Excess / WO
371.5 mi
$248.90 per WO
Median Excess
158.6 mi
Outlier Rate (>50mi)
80%
12 WOs

Actual Travel Expenses

From 10 WOs with expense data
Total Expenses
$5,455
Labor - Travel
$1,472
Mileage
$1,725
Lodging
$262
Airfare
$834
Car Rental
$504
Per Diem
$525
Meals
$0
Other
$134

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,455
10 WOs with expenses
Billed to Client
$0
0% recovery rate
Margin Gap (Unbilled)
$5,455
Cost absorbed internally
Avg Expense / WO
$545
Avg billed: $0
Internal Cost
$5,455
Billed
$0

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
Mileage 5 2 $1,725 $0 $1,725 0%
Labor - Travel (Hours) 22 13 $1,472 $0 $1,472 0%
Airfare 1 1 $834 $0 $834 0%
Per Diem 11 5 $525 $0 $525 0%
Car Rental 5 1 $504 $0 $504 0%
Lodging 1 1 $262 $0 $262 0%
Other Expenses 3 3 $134 $0 $134 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 5 $3,458 $0 $3,458 0%
Healthcare Provider 5 $1,522 $0 $1,522 0%
Animal Health 1 $367 $0 $367 0%
Kiosk 4 $108 $0 $108 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 10 $4,219 $0 $4,219 0%
Repair 4 $869 $0 $869 0%
Inspection 1 $367 $0 $367 0%

Monthly Expense Trend — Internal Cost vs Billed