Net Available Vehicles Report: Difference between revisions

From KB
Jump to navigation Jump to search
BL>Angela
No edit summary
 
m (1 revision imported)
 
(No difference)

Latest revision as of 11:39, 18 September 2024

Locations

REPORTS > Counter Reports

REPORTS > Fleet Reports > Management

REPORTS > Periodic Procedures > Daily


Purpose

The Net Available Vehicles Report provides, for any future time period, the number of vehicles that are ready to rent, reserved, unprepared, and due back. It also provides the net number of available vehicles.


Options

Detail/Summary – The report can show each class in a separate section or combine all classes.
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 Dueback Repair Orders – If this box is checked, vehicles on repair orders that are due back will be shown on the report.
Carry Negative Value – When a column on the report has a vehicle balance that is less than zero, the negative balance can be carried into the next column. Otherwise, the next column begins with a zero balance.
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.
Balance Lines Only – If this box is checked, the balance for each day will be shown, omitting the details for prep’d, due back, etc.
Exclude Overdue Vehicles - 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 "Unprep’d" 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.