Fuel By Customer and Vehicle
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) |
---|---|---|---|
Facility | Equal To | 1 - 99999 | 1 |
Customer | Is Between | blank to "zzzzzzzzzz" | blank to "zzzzzzzzzz" |
Department Number | Is Between | blank to "zzzzzz" | blank to "zzzzzz" |
Date | Is Between | Any Date Range | First and Last Day of Previous Month |
Report Output and Data Elements
When the Fuel By Customer and Vehicle 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. |