Admin Feedback Review Settings Inventory Portal

Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
7,220
Total Travel Cost
$1,166,029
1,740,342 miles
Avoidable Cost
$748,985
1,117,888 excess miles
Optimal Cost
$417,044
If closest tech always used
Avg Excess / WO
154.8 mi
$103.74 per WO
Median Excess
15.0 mi
Outlier Rate (>50mi)
34%
2,455 WOs

Actual Travel Expenses

From 3,712 WOs with expense data
Total Expenses
$1,502,313
Labor - Travel
$1,117,172
Mileage
$2
Lodging
$145,750
Airfare
$71,319
Car Rental
$30,748
Per Diem
$58,600
Meals
$160
Other
$78,564
Cost Overview Actual Expenses Cost Breakdowns Coordinator Analysis Tech Utilization Quick Wins Coverage Gaps Low Hanging Fruit

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)
$1,502,313
3,712 WOs with expenses
Billed to Client
$831,350
55.3% recovery rate
Margin Gap (Unbilled)
$670,963
Cost absorbed internally
Avg Expense / WO
$405
Avg billed: $224
Internal Cost
$1,502,313
Billed
$831,350

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) 5,919 3,558 $1,117,172 $696,483 $420,689 62.3%
Lodging 885 444 $145,750 $67,851 $77,900 46.6%
Other Expenses 3,210 1,800 $78,564 $6,891 $71,673 8.8%
Airfare 145 108 $71,319 $45,782 $25,536 64.2%
Per Diem 1,391 701 $58,600 $5,500 $53,100 9.4%
Car Rental 212 128 $30,748 $8,844 $21,904 28.8%
Meals 9 3 $160 $0 $160 0%
Mileage 4 4 $2 $0 $2 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 4,589 $1,502,313 $831,350 $670,963 55.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 2,252 $993,582 $507,042 $486,540 51%
Installation 227 $208,211 $167,574 $40,638 80.5%
Preventive Maintenance 1,501 $184,183 $93,919 $90,264 51%
Repair 427 $100,588 $60,528 $40,061 60.2%
Training 10 $10,541 $0 $10,541 0%
PM 170 $5,034 $2,170 $2,864 43.1%
FMI 32097 2 $173 $118 $55 68.1%

Monthly Expense Trend — Internal Cost vs Billed