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:
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.
EXAMPLE: Press (RET) |
|
7. RA TYPE |
This field can be used to do either of the following:
|
|
8. DETAIL/ |
Enter 1 alpha character to select the report format.
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.
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.
|
|
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 Fields 11 and 12 allow you to select which of the four types of rentals listed above will be reported. |
|
11. RAs |
EXAMPLE: Type B (RET). |
|
12. VEHICLES |
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 |
|
13. PRINT GRP SUMM |
EXAMPLE: Type Y (RET). |
|
14. PRINT/ |
Enter:
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:
EXAMPLE: Type B (RET) |
|
17. ZERO TAX RATE RA’S ONLY |
Enter:
EXAMPLE: Type N (RET) |
|
18. LEASE RA'S ONLY |
Enter:
EXAMPLE: Type B (RET) |
|
19. RETAIL/ INS/ WHL |
Enter:
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.