Vehicle Cost Per Mile Report – Step-by-Step Outline
Accessing the Report
Navigate from Work Orders to the Reporting Dashboards within the reporting suite.
Multiple dashboards are already available, and users can create unlimited custom dashboards.
Using the Dashboards
Select the dashboard labeled "Equipment" (or any other).
Customize panels:
Create unlimited panels.
Resize, drag and drop.
Add single metrics, visualizations, or table panels.
Share dashboards:
Send to individuals or multiple people.
Schedule recurring reports via email.
Opening the Vehicle Cost Per Mile Report
Choose the report labeled "Transportation Vehicle Per Mile Cost".
Select a date range (e.g., last month).
Filtering the Data
Apply filters for:
Campus
Equipment
Work order categories
Equipment categories (tagged as "vehicle")
Viewing and Interpreting the Data
Example used: Bike Station equipment (tagged as a vehicle).
Data displayed includes:
Equipment name
VIN number / Unique ID
Labor hours & labor cost
Inventory cost
Vendor cost
Fuel usage (gallons)
Miles logged
Gallon cost total
Total cost of equipment over selected timeframe
Gas mileage (miles / cost)
Customizing the Table View
Columns can be:
Rearranged
Hidden or shown based on preference
Understanding the Final Metric
Cost per Mile is calculated and displayed:
Helps determine how much a vehicle is costing per mile during the selected timeframe.
Send Report
Schedule to send the report to yourself or other users automatically