Projected Available Vehicles Report

Location

REPORTS > Counter Reports

Purpose

The Projected Available Vehicles Report provides, for any future time period, the total number of vehicles that are available/prep'd or on rent. Those which are On Order will appear on the In-Fleet line. Those which are due to be grounded will appear on the Out-Fleet line.

The next section will display the number Out (On Rent), and the number of Due Backs. The next lines will show the number of reservations, then the number of Due Backs based on reservations. The In/Out Today will total just the previous four lines. You can then see the number of Overbookings, and a total Available Balance.

Options

Class Details – The report can show each class in a separate section or combine all classes in a Summary.

Hourly Breaks – You can choose three mid-day breakpoints for availability. The starting date will include these breakpoints.

Outlook – The report can be run for five, seven, or ten days into the future.

Include open out of service status repair orders – If this box is checked, vehicles on repair orders that are due back will be shown on the report.

Include open out of service / unavailable status non-revenue movement tickets

List cars at other locations – If this box is checked, a list of owned vehicles at other locations is printed at the end of the report.

List foreign cars at selected locations – If this box is checked, a list of foreign vehicles at the locations you have selected is printed at the end of the report.

Print only balance lines – If this box is checked, the balance for each day will be shown, omitting the details for In-Fleet, Off-Fleet, Due Backs, etc.

Exclude overdue reservations (no-shows at runtime) - If this box is checked, it will not take overdue vehicles into account for the calculation.

No-Show Factor – The percentage of expected no-show reservations. Entering a value here will increase the number of available vehicles as this percentage of reserved vehicles will be removed from the calculation.

Data Selection

This report calculates each column based on the balance of the previous column. For the first column, the number of available vehicles are calculated by the following rules:

• The vehicle’s class is selected in the Class list.
• The vehicle’s status is of a "Prep’d" or "On Rent" type.
• The vehicle’s owning location is selected in the reporting lists.
• The vehicle’s product is selected in the Product list.
• If a vehicle’s expected out-of-service date is within the report’s date range, it is not included.
• If an on-order vehicle’s expected in-service date is within the report’s date range, it is included.

The report then calculates the number of reservations and subtracts them from the number of vehicles. The number of due backs are calculated then added to the number of vehicles, giving a balance of vehicles for the column. That balance is transferred to the beginning of the next column, and the process is repeated.

If a no-show factor has been entered, the number of reservations are reduced by that factor to account for the expected number of no-shows.