Summary/Use Case
Report Summary
The Fuel By Customer and Vehicle report provides a breakdown of fuel usage and associated costs by customer and vehicle. The data includes details such as fuel quantity, cost, and other expenses incurred for each vehicle within a specified date range.
Use Case
Monitor fuel expenses across different customers and vehicles to identify high-consumption patterns.
Track fuel usage to manage customer budgets effectively.
Analyze fuel costs by vehicle type to assess cost-efficiency.
Support billing and reimbursement processes based on fuel usage per customer.
Ensure accuracy in customer related reporting by isolating fuel-related expenses.
Location: Where to Find It
Reports > RTA Standard Reports > Fuel > Fuel by Customer and Vehicle
Data Filter Prompts
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) | Value (Notes) |
|---|---|---|---|---|
Facility | Equal To | Specific facility ID | 1 | Select the facility to filter data. |
Customer | Is Between | Customer range | “ “ to "zzzzzzzzzz" | Defines the customer range; default is first to last |
Department Number | Is Between | Department range | “ “ to "zzzzzz" | Sets the department range; default is first to last |
Date | Is Between | Date range | 10/01/2024 - 10/31/2024 | Filters the report by date range; default goes from first to last day of last month |
Report Output and Data Elements
When the report runs, users will see a detailed list sorted by customer and vehicle. Key columns include vehicle #, fuel quantity, fuel cost, and total cost. This report helps provide insights into fuel consumption and related costs on a per-vehicle basis, supporting customer-specific analysis.
Report Output
Report Data Elements
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Vehicle # | The unique identifier for the vehicle. |
2 | Miles | The total miles driven by the vehicle. |
3 | MPG | Miles per gallon for the vehicle during the period. |
4 | Fuel Qty | Total fuel quantity used by the vehicle. |
5 | Type | The type of fuel used (e.g., gasoline, diesel). |
6 | Cost | Cost associated with the fuel used. |
7 | Oil Qty | Quantity of oil used, if any. |
8 | Oil Cost | Cost associated with oil usage. |
9 | Other | Any additional costs associated with fuel usage. |
10 | Total Cost | Total of fuel, oil, and other costs for the vehicle. |
11 | Account | Account number for billing or tracking purposes. |