Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
14
Total Travel Cost
$706
1,054 miles
Avoidable Cost
$74
111 excess miles
Optimal Cost
$632
If closest tech always used
Avg Excess / WO
7.9 mi
$5.32 per WO
Median Excess
8.5 mi
Outlier Rate (>50mi)
0%
0 WOs

Actual Travel Expenses

From 14 WOs with expense data
Total Expenses
$7,074
Labor - Travel
$6,161
Mileage
$0
Lodging
$581
Airfare
$0
Car Rental
$0
Per Diem
$150
Meals
$0
Other
$182

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)
$7,074
14 WOs with expenses
Billed to Client
$557
7.9% recovery rate
Margin Gap (Unbilled)
$6,517
Cost absorbed internally
Avg Expense / WO
$505
Avg billed: $40
Internal Cost
$7,074
Billed
$557

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) 30 13 $6,161 $238 $5,923 3.9%
Lodging 3 3 $581 $0 $581 0%
Other Expenses 12 9 $182 $144 $38 79.2%
Per Diem 3 3 $150 $175 $25 ✓ 116.7%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Animal Health 14 $7,074 $557 $6,517 7.9%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Asset Tagging 4 $1,964 $0 $1,964 0%
Inspection 2 $1,369 $0 $1,369 0%
Installation 1 $1,326 $0 $1,326 0%
Misc. Inspection 2 $1,305 $344 $962 26.3%
Repair 3 $777 $175 $602 22.5%
Preventive Maintenance 2 $333 $39 $294 11.7%

Monthly Expense Trend — Internal Cost vs Billed