Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
60
Total Travel Cost
$3,734
5,572 miles
Avoidable Cost
$1,978
2,952 excess miles
Optimal Cost
$1,756
If closest tech always used
Avg Excess / WO
49.2 mi
$32.97 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
18.3%
11 WOs

Actual Travel Expenses

From 38 WOs with expense data
Total Expenses
$18,813
Labor - Travel
$16,958
Mileage
$0
Lodging
$1,302
Airfare
$0
Car Rental
$0
Per Diem
$500
Meals
$0
Other
$53

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)
$18,813
38 WOs with expenses
Billed to Client
$2,888
15.4% recovery rate
Margin Gap (Unbilled)
$15,925
Cost absorbed internally
Avg Expense / WO
$495
Avg billed: $76
Internal Cost
$18,813
Billed
$2,888

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) 78 31 $16,958 $2,872 $14,087 16.9%
Lodging 5 5 $1,302 $0 $1,302 0%
Per Diem 11 9 $500 $0 $500 0%
Other Expenses 8 8 $53 $17 $36 31.4%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 38 $18,813 $2,888 $15,925 15.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 25 $13,549 $2,173 $11,376 16%
Inspection 8 $2,813 $0 $2,813 0%
Preventive Maintenance 4 $1,736 $0 $1,736 0%
Installation 1 $715 $715 $0 100%

Monthly Expense Trend — Internal Cost vs Billed