Cost Breakdown by Facility and Department

Summary/Use Case

Report Summary

This report provides a list of all the amounts of all of the costs that could be associated with a motor pool reservation. The report filters bring in vehicles that have filled in return date, meaning the vehicle reservation is completed and costs should be finalized, as well as pull in reservations that have been cancelled and have a cancellation fee.

Use Case

• Calculate the motor pool costs/fees (by individual costs or total) per facility and/or department over a range of dates

• Identify deleted transactions and if there were any costs associated with them

• Use alongside billing for motor pool costs

Location: Where to Find it

Reports > RTA Standard Reports > Motor Pool > Cost Breakdown by Facility and Department

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

Data Filter List

Report Output and Data Elements

When the report runs, you will see the report is grouped/sorted by Facility > Department > Vehicle > Reservation Number. The costs of individual reservations are given, as well as totals on the department and facility levels. Vehicle reservations that return a blank in the ‘Return Date’ field are cancellations and may have incurred a cancellation fee, if your organization charges for that.

Report Output:

Report Data Elements List