Availability by Department and Class

Summary/Use Case

Report Summary

The Availability by Department and Class Report provides a breakdown of vehicle availability by facility, department, vehicle class, and individual vehicle details. This report is essential for fleet managers who need to analyze vehicle usage patterns and availability within specific departments, allowing for better resource allocation and fleet optimization.

Use Case

  • Analyze vehicle availability trends within departments to manage fleet resources effectively.

  • Identify departments with higher vehicle downtime and investigate potential causes.

  • Evaluate class-specific performance and availability in various departments.

  • Support budget planning and resource allocation based on department-level vehicle utilization.

  • Generate detailed departmental reports for audit or internal review purposes.

Location: Where to Find It

Reports > RTA Standard Reports > Vehicle > Availability by Department and Class

image-20241107-190115.png

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

image-20241107-190138.png

Parameter Name

Value (Default)

Please enter an availability start date

Defaulted to start of the previous month

Please enter an availability end date

Defaulted to end of the previous month

Data Filter List

image-20241107-190245.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Facility

Is Between

1 - 99999

1 - 99999

Vehicle

Is Between

blank - zzzzzzzzzz

blank - zzzzzzzzzz

Department Number

Is Between

blank - zzzzzzzzzz

blank - zzzzzzzzzz

Class Code

Is Between

blank - zzzzzzzzzz

blank - zzzzzzzzzz

Report Output and Data Elements

Report Output

The Availability by Department and Class Report provides a detailed view of vehicle availability across various departments, sorted by facility, department, class, and specific vehicle details. The report includes metrics such as vehicle ID, year, make, model, customer, date added to the system, total possible hours, total hours available, total hours unavailable, and availability percentage. Totals are provided at both the department and class levels, which aids in evaluating departmental fleet efficiency and identifying any areas that may need attention regarding vehicle availability.

image-20241107-190341.png

Report Data Elements

Column Number

Column Title

Data Notes

1a

Facility

The facility to which the vehicle is assigned

1b

Department

The department that the vehicle is associated with

1c

Vehicle ID

Unique identifier for the vehicle

1d

Class

Class code and description to which the vehicle is assigned to

2

Year

Manufacture year of the vehicle

3

Make

Vehicle manufacturer

4

Model

Model of the vehicle

5

Customer

Customer ssociated with the vehicle

6

Date Added to System

The date when the vehicle was added to the system

7

Possible Hours Available

Total possible hours within the date range

8

Total Hours Available

Hours the vehicle was available

9

Total Hours Unavailable

Hours the vehicle was unavailable

10

Availability %

Percentage of total hours the vehicle was available