Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
108
Total Travel Cost
$4,184
6,245 miles
Avoidable Cost
$1,575
2,351 excess miles
Optimal Cost
$2,609
If closest tech always used
Avg Excess / WO
21.8 mi
$14.59 per WO
Median Excess
1.8 mi
Outlier Rate (>50mi)
6.5%
7 WOs

Actual Travel Expenses

From 58 WOs with expense data
Total Expenses
$12,890
Labor - Travel
$11,261
Mileage
$0
Lodging
$893
Airfare
$0
Car Rental
$50
Per Diem
$550
Meals
$0
Other
$136

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)
$12,890
58 WOs with expenses
Billed to Client
$3,170
24.6% recovery rate
Margin Gap (Unbilled)
$9,719
Cost absorbed internally
Avg Expense / WO
$222
Avg billed: $55
Internal Cost
$12,890
Billed
$3,170

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) 90 52 $11,261 $3,082 $8,179 27.4%
Lodging 2 2 $893 $0 $893 0%
Per Diem 13 8 $550 $0 $550 0%
Other Expenses 19 12 $136 $88 $47 65.1%
Car Rental 1 1 $50 $0 $50 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 59 $12,890 $3,170 $9,719 24.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 41 $9,618 $1,884 $7,733 19.6%
Inspection 9 $1,133 $356 $778 31.4%
Misc. Inspection 3 $782 $782 $0 100%
Preventive Maintenance 3 $614 $0 $614 0%
Calibration 1 $594 $0 $594 0%
Evaluation 1 $149 $149 $0 100%
Support 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed