Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
9
Total Travel Cost
$213
318 miles
Avoidable Cost
$167
249 excess miles
Optimal Cost
$46
If closest tech always used
Avg Excess / WO
27.7 mi
$18.55 per WO
Median Excess
12.2 mi
Outlier Rate (>50mi)
33.3%
3 WOs

Actual Travel Expenses

From 7 WOs with expense data
Total Expenses
$2,474
Labor - Travel
$2,380
Mileage
$0
Lodging
$0
Airfare
$0
Car Rental
$0
Per Diem
$0
Meals
$0
Other
$94

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)
$2,474
7 WOs with expenses
Billed to Client
$91
3.7% recovery rate
Margin Gap (Unbilled)
$2,383
Cost absorbed internally
Avg Expense / WO
$353
Avg billed: $13
Internal Cost
$2,474
Billed
$91

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) 13 7 $2,380 $0 $2,380 0%
Other Expenses 5 4 $94 $91 $3 96.8%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Animal Health 7 $2,474 $91 $2,383 3.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 2 $1,132 $55 $1,077 4.9%
Installation 1 $714 $0 $714 0%
Repair 2 $390 $36 $354 9.3%
Misc. Inspection 1 $179 $0 $179 0%
Evaluation 1 $60 $0 $60 0%

Monthly Expense Trend — Internal Cost vs Billed