Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
215
Total Travel Cost
$10,007
14,935 miles
Avoidable Cost
$4,355
6,500 excess miles
Optimal Cost
$5,652
If closest tech always used
Avg Excess / WO
30.2 mi
$20.26 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
29.8%
64 WOs

Actual Travel Expenses

From 123 WOs with expense data
Total Expenses
$45,544
Labor - Travel
$44,175
Mileage
$0
Lodging
$282
Airfare
$474
Car Rental
$209
Per Diem
$125
Meals
$0
Other
$279

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)
$45,544
123 WOs with expenses
Billed to Client
$10,413
22.9% recovery rate
Margin Gap (Unbilled)
$35,131
Cost absorbed internally
Avg Expense / WO
$370
Avg billed: $85
Internal Cost
$45,544
Billed
$10,413

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) 251 125 $44,175 $10,174 $34,000 23%
Airfare 1 1 $474 $0 $474 0%
Lodging 2 2 $282 $160 $122 56.7%
Other Expenses 23 22 $279 $79 $200 28.3%
Car Rental 5 4 $209 $0 $209 0%
Per Diem 4 2 $125 $0 $125 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 133 $45,544 $10,413 $35,131 22.9%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 98 $33,548 $3,276 $30,272 9.8%
Misc. Inspection 14 $4,200 $2,810 $1,391 66.9%
Delivery 5 $3,990 $1,892 $2,098 47.4%
Evaluation 4 $1,457 $874 $583 60%
Inspection 6 $1,316 $1,158 $158 88%
Installation 2 $529 $61 $467 11.6%
Calibration 1 $298 $298 $0 100%
Preventive Maintenance 3 $206 $45 $161 22%

Monthly Expense Trend — Internal Cost vs Billed