Use this program to obtain a report of the estimated revenue on Open RAs.

This report lists in detail or summary fashion the estimated revenue on Open RAs that are due to return within the date range requested. The report format is similar to that of the Close section of the Operations DBR. When run in detail, there are 3 lines of data for each RA. The estimated revenue for each RA is reported in various columns such as Time, Kms/Miles, various coverages, fuel, etc. The estimated revenue is calculated through the return date on the RA.

This report is different in nature from the Accrual Report – even though both reports show the estimated revenue on open RAs.

Accrual Report:

Historical in nature

Shows the estimated revenue earned through a particular date.

Open RA Estimate Report:

Looks to the future

Shows the total estimated revenue for the RA.

To illustrate this point, let’s use an example. Assume the following:

The current date is October 1. RA# 1234 opened Sept. 28 and is due to return October 6. (8 day rental)

If the Accrual Report is run with an ending date of September 30, RA# 1234 will be listed. Since 2 of the 8 days have gone by, 25% of its revenue will be reported as having been earned by September 30.

If the Open RA Estimate Report is run for the date range of “Earliest” through September 30, RA#1234 will not be listed. It is not scheduled to close during that time.

However, when the Open RA Estimate Report is run for the October 1 – 7 to get an idea of the revenue that will be generated for the upcoming week, the RA will be included with its estimated revenue for all 8 days. Its closing date of October 6 is within the date range requested.

User tip: All revenue, including voucher revenue, is reported.

To access the Open RA Estimate Report, type OPENRPT(RET) at any menu "OPTION:"field or the appropriate line number on the Month End menu. The screen will then display:

OPTION: __ OPEN RA ESTIMATE REPORT

1 Start Date EARLIEST 17 Zero Tax Rate RA's Only N
2 Start Time 0000 18 Lease RA's Only B
3 End Date 09-20-07 L=Lease, N=Non-Lease, B=Both
4 End Time 2359 19 Retail/Ins/Whl ALL
5 Location TUS (R=rtl,I=ins,W=whl)
6 List by Open or 20 Employee ALL
Close Loc (O/C) O
7 RA Type(s) ALL
8 Detail/Summary D
9 Option Detail N
10 Drawer ALL
11 RAs B (O=owned, F=foreign, B=both)
12 Vehicles B (O=owned, F=foreign, B=both)
13 Prt Grp Summary N
14 Print/Display P Printer: /dev/tty
15 Res Types ALL
16 Airport Commission B
(C=comm, N=non-comm, B=Both)



1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8

Enter data as follows:

1. START DATE

The dates and times entered in Fields 1- 4 is used to select open RAs that are scheduled to close within the date range. The starting date defaults to “Earliest” so that all open RAs due to close through the date/time entered in Fields 3 and 4 are included.

If you don’t wish to use “Earliest”, using your selected date format, enter a Starting DBR Date.

EXAMPLE: Press (RET)

2. START TIME

Using your selected time format, enter the Starting DBR Time if it should be other than 0000 (midnight).

EXAMPLE: Press (RET)

3. END DATE

The dates and times entered in Fields 1- 4 is used to select open RAs that are scheduled to close within the date range. Open RAs that are due to close within the date/time range will be included in the report. Press (RET) to default to today’s date.

EXAMPLE: Type 083107 (RET)

4. END TIME

Using your selected time format, enter Ending DBR Time. Press RET to default to one minute before midnight.

EXAMPLE: Press (RET)

5. LOCATION

Enter:

  1. Up to 6 alphanumeric characters to select a single location.
  2. A Group Name representing several locations (see the Chapter Edit Group Names for a discussion on location groups). Remember, the first character of a Group Name is the plus sign "+". In addition, for this report, a Location Group will trigger "subtotal roll-ups" (if the group contains groups within groups, subtotals will print for each group level). For more information on this feature, refer to the section on Subtotal Roll-Ups at the end of the Edit Group Names chapter.
  3. “ALL” to include all locations.

EXAMPLE: Press (RET)

6. LIST BY OPEN OR CLOSE LOC (O/C)

Enter 1 alpha character to indicate if closed RAs will be selected and grouped by their opening or closing location. Press RET to default to O.

O = Opening Location
C = Closing Location

EXAMPLE: Press (RET)

7. RA TYPE

This field can be used to do either of the following:

1. Enter up to 2 alphanumeric characters to indicate a single RA Type which will limit the report to only those RAs of this type. Press RET to default to ALL Types.

EXAMPLE: Type C (RET)

2. Enter a negative sign followed by a RA Type Code to indicate a single type of RA that is NOT to be reported.

EXAMPLE: Type -C (RET)

8. DETAIL/
SUMMARY

Enter 1 alpha character to select the report format.

D = Detailed Report; 3 or 4 lines of data will print for each RA.
S = Summary Report; total only.

EXAMPLE: Type D (RET)

9. OPTION DETAIL

Enter 1 alpha character to indicate if an optional fourth line of data for option charges should print.

Y = Print the individual option charges on the report.
N = Do not print the optional fourth line of option charge detail.

EXAMPLE: Type Y (RET)

10. DRAWER(S)

Enter up to 3 numeric characters to select the Cash Drawer(s) to appear on the Operational DBR. You may specify up to 6 drawers. Press RET to default to ALL Drawers.

EXAMPLE:

Type 1 (RET)

Type 3 (RET)

FIELDS 11 & 12


Rental operations which are part of a national franchising organization are faced with several types of rental situations. These situations are summarized in the chart below:

Vehicle Ownership                          RA                  Description

Yours Yours Your rental of your vehicle.

Foreign Yours You rented a foreign vehicle. (1)

Foreign Foreign A one-way rental to your location. (2)

Yours Foreign A foreign location rented your vehicle. (3)


Fields 11 and 12 allow you to select which of the four types of rentals listed above will be reported.

11. RAs

O = OWNED. Only your RAs will be reported. One-way rentals from foreign locations to your operation.

F = FOREIGN. Only one way rentals from foreign locations will be reported.

B = BOTH. All RAs will be reported.

EXAMPLE: Type B (RET).

12. VEHICLES

O = OWNED. Only RAs involving your vehicles will be reported. Your use of foreign vehicles and one-way rentals of foreign vehicles to your locations will be excluded.

F = FOREIGN. Only RAs involving foreign owned vehicles will be reported. That is, your rentals of foreign vehicles.

B = BOTH. All RAs regardless of vehicle ownership will be reported.

EXAMPLE: Type B(RET).

Obviously, the combination of responses to Fields 11 and 12 will produce several different kinds of reports. For example:

Type of report                                                         Field 11        Field 12
Foreign use of your vehicles F O
Your use of foreign vehicles O F
Revenue produced by your vehicles B O
RAs that you have written O B

13. PRINT GRP SUMM

Y = In addition to the summary which totals all RAs, additional summary pages will print for each of the four types of contracts outlined in the discussion of Fields 11 and 12 above.

N = Only one summary page which totals all RAs will print for each location.

EXAMPLE: Type Y (RET).

14. PRINT/
DISPLAY

Enter:

P = Print a hard copy of this report on your terminal's assigned printer. See the Edit Terminal Records Chapter for instructions on how to assign printers.

D = Display this report on your terminal screen. See the General Data Entry InstructionsChapter on how to control the screen display.

EXAMPLE: Type P (RET)

15. RES TYPES

This field applies only to a particular CARS+ user and has no relevance to other users

16. AIRPORT COMMISSION

Enter:

C = COMMISSIONABLE. Only RAs which were marked as being airport arrival rentals will be included in the report.

N = NON-COMMISSIONABLE. Only RAs which were NOT marked as being airport arrival rentals will be included in the report.

B = BOTH. All RAs, regardless of airport arrival, will be included in the report.

EXAMPLE: Type B (RET)

17. ZERO TAX RATE RA’S ONLY

Enter:

Y = YES. Only RAs which have no tax charged on them will be included in the report.

N = NO. All RAs, regardless of tax, will be included in the report.

EXAMPLE: Type N (RET)

18. LEASE RA'S ONLY

Enter:

L = LEASE RAs. Only Lease RAs will be included in the report.

N = NON-LEASE. All RAs except for Lease RAs will be included in the report. (Daily rental and Park and Fly RAs)

B = BOTH. Include all RAs.

EXAMPLE: Type B (RET)

19. RETAIL/ INS/ WHL

Enter:

R = RETAIL. Retail will be included in the report.

I = INSURANCE. Only insurance logic RAs will be included in the report.

W = WHOLESALE. Only tour (wholesale logic) RAs will be included in the report.

Or press (RET) to default to ALL RAs.

EXAMPLE: Press (RET)

20 EMPLOYEE

To limit the report to RAs opened by one employee, enter the employee's user code in this field. Otherwise, press (RET) to include transactions done by all employees.

EXAMPLE: Press (RET)

PRESS "F1" AT "OPTION:" TO BEGIN THE REPORT.


This report contains a calculation of rental length called "DBR Days" (or just "Days"). One of two possible formulas are used in CARS+ to calculate this figure. To chose the formula to be used in this as well as over fifty other CARS+ reports, go to Page 5, Field 3 of Edit Miscellaneous Control Fields.