Use this program to Produce a report of Time and Mileage revenue for rates which include taxes and/or coverages. The inclusive items are separated out from the gross amount in order to determine the actual net time and mileage revenue generated.

To access the Net Time and Mileage Report program, type REVLESS (RET) at any menu "OPTION:" field or the appropriate line number on the Additional Accounting Programs Sub-menu of the Rental Accounting menu. The screen will then display:

OPTION: __ REVENUE LESS INCLUSIVE REPORT

1 Start DBR Date 05-07-04
2 Start DBR Time 0000
3 End DBR Date 05-07-04
4 End DBR Time 2359
5 Location TUS
6 Cvg1 Rate
7 Cvg2 Rate
8 Cvg3 Rate
9 Cvg4 Rate
10 Detail/Summary D
11 Print/Display P Printer: /dev/tty


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


Enter Data as follows:

1. START DBR DATE

Enter the. starting DBR date. Press RET to default to today's date.

EXAMPLE: Type 040104 (RET).

2. START DBR TIME

Enter the starting DBR time. Press RET to default to midnight.

EXAMPLE: Press (RET)

3. END DBR DATE

Enter the Ending DBR date. Press RET to default to today's date.

EXAMPLE: Type 043004 (RET)

4. END DBR TIME

Enter the ending DBR time. Press RET to default to 11:59 p.m.

EXAMPLE: Press (RET)

5. LOCATION

Enter either a location code, a Group Code, or press RET to default to ALL locations.

EXAMPLE: Type TUS (RET)

Notes on Fields 6 - 9: Allocation of Coverage Rates

Coverage Rates. For rates where coverages are included, use these fields to enter the dollar amount that should be allocated to the coverage. The system will multiply the number of inclusive rental days by the amounts entered in these fields. Along with inclusive taxes, the resulting product will be deducted from Gross T & M in order to arrive at Net T & M.

For example, assume a rate of $50 a day includes LDW (Coverage 1) and LIS (Coverage 3). It is determined that from the $50 rate, $9.00 a day be allocated to LDW and $4.00 a day to LIS. Therefore, $9.00 is entered in Field #6 and $4.00 in Field #8. The following calculations will be performed to find the net T & M on a 5-day contract:


   Gross T & M:  $50 x 5 days =	        			$250.00
	Coverage 1:   $9.00 x 5 days =	        		    45.00
	Coverage 3:   $4.00 x 5 days =	        		    20.00
	Deduct:  Total inclusive coverages			 -  65.00
Net T & M              						 $185.00

6. CVG1 RATE

Enter the amount to allocate to CVG1 on inclusive rates.

EXAMPLE: Type 9.00(RET)

7. CVG2 RATE

Enter the amount to allocate to CVG2 on inclusive rates.

EXAMPLE: Type 4.50 (RET)

8. CVG3 RATE

Enter the amount to allocate to CVG3 on inclusive rates.

EXAMPLE: Type 4.00(RET)

9. CVG4 RATE

Enter the amount to allocate to CVG4 on inclusive rates.

EXAMPLE: Type 2.00(RET)

10. DETAIL/ SUMMARY

Enter 1 alpha character to select the report format:

D = Detailed Report

S = Summary Report

EXAMPLE: Type D (RET)

11. PRINT/ DISPLAY

Enter:

P = Print a hard copy of this report on your terminal's assigned printer.

D = Display this report on your terminal screen.

EXAMPLE: Type P (RET)


The screen will then display:

OPTION: __ REVENUE LESS INCLUSIVE REPORT

1 Start DBR Date 04-01-04
2 Start DBR Time 0000
3 End DBR Date 04-30-04
4 End DBR Time 2359
5 Location TUS
6 Cvg1 Rate 9.00
7 Cvg2 Rate 4.50
8 Cvg3 Rate 4.00
9 Cvg4 Rate 2.00
10 Detail/Summary D
11 Print/Display P Printer: /dev/tty


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

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


Notes on Inclusive Taxes

When taxes are included in a rate, they are also extracted by this program. As an example, assume a tax rate of 10 percent on a tax inclusive rate of $40 per day. The calculations to allocate the tax for a 4-day contract are as follows:


Gross T & M:  $40 x 4 days =				$160.00
	Tax Rate:  10%
	Gross T & M divided by 110% =			$145.45  (Net T & M)
	10% Tax allocation					$  14.55