Last-Mile Route Profitability
Measure route economics and service using stops, windows, attempts, distance, labor, fuel, tolls, and customer pricing.
Interactive sample in preparation
What you get
A useful first version with the main workflow already mapped out.
- Route contribution analysis
- Stop exception map
- Customer margin table
- Resequencing and cost scenarios
Sample data
Six synthetic months of routes, stops, packages, zones, promised and actual times, attempts, miles, drivers, hours, fuel, tolls, and customer pricing.
Measures included
- On-time rate
- First-attempt success
- Stops per hour
- Cost per stop
- Route contribution
Connect your data
Start with the sample rows, then replace them with the systems you already use.
CSV
File import
Route, stop, package, attempt, time, mileage, and customer-price exports
Postgres
Direct connector
Normalized route, zone, stop, driver, cost, and service facts
Google Sheets
Direct connector
Wage, fuel, toll, capacity, and time-window assumptions
BigQuery
Direct connector
Historical delivery events and high-volume route facts
Make it yours
Describe a change in plain English and keep adapting the tool as the work changes.
- 01Add parcel-size capacity constraints
- 02Compare employed and contracted drivers
- 03Set customer-specific service penalties
Related templates
See all 65Freight Brokerage Load Margin
Protect load margin while improving carrier coverage and shipper service.
Fleet Dispatch & Maintenance
Keep vehicles productive while dispatching work around maintenance and fuel cost.
Boutique Hotel Revenue Pace
Set rate and channel priorities from occupancy, pickup, and net revenue.