Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
409
Total Travel Cost
$14,954
22,320 miles
Avoidable Cost
$6,502
9,704 excess miles
Optimal Cost
$8,452
If closest tech always used
Avg Excess / WO
23.7 mi
$15.90 per WO
Median Excess
4.8 mi
Outlier Rate (>50mi)
9.5%
39 WOs

Actual Travel Expenses

From 294 WOs with expense data
Total Expenses
$123,923
Labor - Travel
$111,796
Mileage
$0
Lodging
$4,653
Airfare
$1,912
Car Rental
$1,117
Per Diem
$2,125
Meals
$0
Other
$2,320

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)
$123,923
294 WOs with expenses
Billed to Client
$27,441
22.1% recovery rate
Margin Gap (Unbilled)
$96,483
Cost absorbed internally
Avg Expense / WO
$422
Avg billed: $93
Internal Cost
$123,923
Billed
$27,441

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) 665 295 $111,796 $23,601 $88,196 21.1%
Lodging 16 12 $4,653 $2,430 $2,223 52.2%
Other Expenses 112 83 $2,320 $109 $2,211 4.7%
Per Diem 58 37 $2,125 $25 $2,100 1.2%
Airfare 4 3 $1,912 $1,276 $636 66.7%
Car Rental 20 13 $1,117 $0 $1,117 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 303 $123,923 $27,441 $96,483 22.1%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 234 $92,458 $16,668 $75,790 18%
Delivery 15 $13,485 $7,398 $6,087 54.9%
Preventive Maintenance 25 $7,196 $1,068 $6,128 14.8%
Installation 8 $4,842 $595 $4,247 12.3%
Inspection 8 $3,215 $0 $3,215 0%
Evaluation 4 $1,787 $1,057 $729 59.2%
Misc. Inspection 3 $655 $655 $0 100%
Support 6 $286 $0 $286 0%

Monthly Expense Trend — Internal Cost vs Billed