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

image-20241104-205635.png

Data Filter Prompts

image-20241104-205706.png

Data Filter List

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

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

image-20241104-210130.png

Report Data Elements

Column Number

Column Title

Data Notes

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.