Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
276
Total Travel Cost
$12,529
18,700 miles
Avoidable Cost
$7,704
11,499 excess miles
Optimal Cost
$4,825
If closest tech always used
Avg Excess / WO
41.7 mi
$27.91 per WO
Median Excess
10.2 mi
Outlier Rate (>50mi)
18.5%
51 WOs

Actual Travel Expenses

From 18 WOs with expense data
Total Expenses
$10,450
Labor - Travel
$4,766
Mileage
$0
Lodging
$2,146
Airfare
$1,225
Car Rental
$891
Per Diem
$725
Meals
$0
Other
$698

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)
$10,450
18 WOs with expenses
Billed to Client
$4,781
45.8% recovery rate
Margin Gap (Unbilled)
$5,669
Cost absorbed internally
Avg Expense / WO
$581
Avg billed: $266
Internal Cost
$10,450
Billed
$4,781

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) 44 15 $4,766 $4,766 $0 ✓ 100%
Lodging 4 2 $2,146 $0 $2,146 0%
Airfare 3 1 $1,225 $0 $1,225 0%
Car Rental 5 2 $891 $0 $891 0%
Per Diem 15 2 $725 $0 $725 0%
Other Expenses 19 6 $698 $16 $682 2.2%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 18 $10,450 $4,781 $5,669 45.8%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Cross-Training 2 $5,547 $495 $5,052 8.9%
Repair 9 $3,613 $3,606 $7 99.8%
Inspection 6 $1,109 $500 $610 45%
Preventive Maintenance 1 $181 $181 $0 100%

Monthly Expense Trend — Internal Cost vs Billed