Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
31
Total Travel Cost
$2,278
3,400 miles
Avoidable Cost
$1,661
2,479 excess miles
Optimal Cost
$617
If closest tech always used
Avg Excess / WO
80.0 mi
$53.57 per WO
Median Excess
98.0 mi
Outlier Rate (>50mi)
74.2%
23 WOs

Actual Travel Expenses

From 18 WOs with expense data
Total Expenses
$7,690
Labor - Travel
$7,293
Mileage
$0
Lodging
$276
Airfare
$0
Car Rental
$0
Per Diem
$100
Meals
$0
Other
$21

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)
$7,690
18 WOs with expenses
Billed to Client
$3,089
40.2% recovery rate
Margin Gap (Unbilled)
$4,601
Cost absorbed internally
Avg Expense / WO
$427
Avg billed: $172
Internal Cost
$7,690
Billed
$3,089

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) 31 17 $7,293 $2,903 $4,390 39.8%
Lodging 2 2 $276 $175 $101 63.4%
Per Diem 2 2 $100 $0 $100 0%
Other Expenses 6 5 $21 $11 $10 53.2%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 18 $7,690 $3,089 $4,601 40.2%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 11 $4,484 $94 $4,390 2.1%
Delivery 2 $1,456 $1,440 $16 98.9%
Misc. Inspection 2 $893 $893 $0 100%
Inspection 2 $760 $565 $195 74.3%
Preventive Maintenance 1 $98 $98 $0 100%

Monthly Expense Trend — Internal Cost vs Billed