Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
6
Total Travel Cost
$2,898
4,325 miles
Avoidable Cost
$2,397
3,578 excess miles
Optimal Cost
$501
If closest tech always used
Avg Excess / WO
596.4 mi
$399.57 per WO
Median Excess
820.8 mi
Outlier Rate (>50mi)
83.3%
5 WOs

Actual Travel Expenses

From 5 WOs with expense data
Total Expenses
$7,510
Labor - Travel
$4,478
Mileage
$0
Lodging
$605
Airfare
$828
Car Rental
$689
Per Diem
$425
Meals
$0
Other
$485

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,510
5 WOs with expenses
Billed to Client
$5,250
69.9% recovery rate
Margin Gap (Unbilled)
$2,260
Cost absorbed internally
Avg Expense / WO
$1,502
Avg billed: $1,050
Internal Cost
$7,510
Billed
$5,250

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) 16 6 $4,478 $3,160 $1,318 70.6%
Airfare 2 2 $828 $1,455 $627 ✓ 175.8%
Car Rental 6 3 $689 $0 $689 0%
Lodging 5 2 $605 $460 $145 76%
Other Expenses 5 2 $485 $0 $485 0%
Per Diem 9 3 $425 $175 $250 41.2%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 3 $5,778 $2,998 $2,780 51.9%
Healthcare Provider 2 $1,732 $2,252 $520 130%
Kiosk 1 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 3 $5,778 $2,998 $2,780 51.9%
Repair 1 $873 $945 $72 108.3%
Delivery 1 $860 $1,307 $448 152.1%
Preventive Maintenance 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed