Vehicle Audit
Summary/Use Case
Report Summary
The Vehicle Audit report provides an overview of costs and usage metrics for each vehicle within a specific facility over a designated date range. This report is useful for fleet managers to evaluate cost components such as labor, fuel, and parts associated with each vehicle, aiding in expense tracking, budget analysis and calculating total cost of ownership (TCO).
Use Case
Monitor individual vehicle costs for better expense control and forecasting
Analyze labor hours and parts usage to assess maintenance demands
Identify high-cost vehicles for potential replacement or reassignment
Track fuel and lubricant expenses for operational efficiency
Support budget planning by summarizing total vehicle costs over time
Location: Where to Find It
Reports > RTA Standard Reports > Vehicle > Vehicle Audit
Data Filter Prompts
You will be prompted for filtering of the data to specify and narrow down the data that will be pulled. See Data Filter List below for options.
Parameter List
Parameter Name | Value (Default) | Value (Notes) |
|---|---|---|
Please select Customer or Department for grouping (None to skip grouping) | Customer | Allows grouping by Customer or Department If None is selected, Customer and Department groupings/sorts will be ignored and will move to sorting by either Class or Vehicle (dependent on the Class grouping option below) |
Include Class grouping and totals? | False | Determines whether class-level grouping and totals are included If False, the report will default to a list sorted by vehicle If True, the report will contain groupings and totals by Class |
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) | Value (Notes) |
|---|---|---|---|---|
Facility | Equal To | Any Facility Number | 1 | Single Facility |
Customer Number | Is Between | Any Customer Number Range | blank - “zzzzzzzzzzzzzzzz” | Filters by customer number range |
Department Number | Is Between | Any Department Number Range | blank - “zzzzzzzzzzzzzzzz” | Filters by department number range |
Class Code | Is Between | Any Class Code Range | blank - “zzzzzzzzzzzzzzzz” | Filters by vehicle class code range |
Vehicle | Is Between | Any Vehicle Range | blank - “zzzzzz” | Filters by vehicle range |
Date Range | Is Between | Any Date Range | First to Last Day of Previous Month | Filters data by date range |
Report Output and Data Elements
Report Output
The Vehicle Audit Report presents a structured table displaying vehicle-related costs and usage within the specified filters. The report includes columns such as Vehicle, Class, Customer, Department, Units, Labor, Fuel, Lubricant, Fixed Costs, and more. Summarized totals for fleet-wide expenses are included at the bottom.
*If Customer / Department grouping IS included and Class grouping IS NOT included
*If Customer / Department grouping IS included and Class grouping IS included
*If Customer / Department grouping IS NOT included and Class grouping IS included
*If Customer / Department grouping IS NOT included and Class grouping IS NOT included
Report Data Elements
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Vehicle | Unique vehicle identifier |
2 | Class | Vehicle classification code |
3 | Cust | Customer number associated with the vehicle |
4 | Dept | Department number associated with the vehicle |
5 | Units | Total usage units recorded for the vehicle |
6 | Labor | Labor cost associated with the vehicle |
7 | Fuel | Fuel cost for the vehicle |
8 | Lubricant | Lubricant cost for the vehicle |
9 | Wash | Cost for vehicle washing |
10 | Fixed | Fixed costs related to the vehicle |
11 | Misc | Miscellaneous costs related to the vehicle |
12 | Outside | Costs for external services |
13 | Tires | Cost of tires for the vehicle |
14 | Labor | Duplicate column for labor (verify usage) |
15 | Parts | Cost of parts for the vehicle |
16 | Cost / Unit | Cost per usage unit |
17 | Total Cost | Total cost for the vehicle |