Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
110
Total Travel Cost
$3,736
5,576 miles
Avoidable Cost
$868
1,296 excess miles
Optimal Cost
$2,868
If closest tech always used
Avg Excess / WO
11.8 mi
$7.89 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
2.7%
3 WOs

Actual Travel Expenses

From 44 WOs with expense data
Total Expenses
$5,467
Labor - Travel
$278
Mileage
$0
Lodging
$355
Airfare
$944
Car Rental
$377
Per Diem
$200
Meals
$0
Other
$3,312

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)
$5,467
44 WOs with expenses
Billed to Client
$262
4.8% recovery rate
Margin Gap (Unbilled)
$5,205
Cost absorbed internally
Avg Expense / WO
$124
Avg billed: $6
Internal Cost
$5,467
Billed
$262

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
Other Expenses 41 39 $3,312 $41 $3,271 1.2%
Airfare 1 1 $944 $0 $944 0%
Car Rental 6 2 $377 $0 $377 0%
Lodging 1 1 $355 $0 $355 0%
Labor - Travel (Hours) 141 104 $278 $221 $57 79.4%
Per Diem 6 4 $200 $0 $200 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Kiosk 96 $3,038 $0 $3,038 0%
Healthcare Provider 8 $2,351 $221 $2,130 9.4%
Animal Health 1 $67 $41 $26 61.1%
Lab/Power 1 $11 $0 $11 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Inspection 2 $2,088 $0 $2,088 0%
Repair/PM 16 $1,468 $0 $1,468 0%
Repair 21 $1,290 $156 $1,134 12.1%
Preventive Maintenance 60 $265 $0 $265 0%
Connectivity 4 $217 $0 $217 0%
Evaluation 1 $106 $106 $0 100%
Delivery 1 $34 $0 $34 0%
Support 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed