117 Estimated E.P. PSF Generation

This chapter contains these topics:

• Section 117.1, "Per Square Foot Generation Report,"

• Section 117.2, "Per Square Foot Generation Procedures,"

• Section 117.3, "Processing Options,"

• Section 117.4, "Guidelines."

This program lets you estimate the recurring billings for expense participation according to the E.P. setup information and square footage in the log information for the lease, building, or property. It is based on the Tenant/Lease Master file (F1501) and also includes information from the Log Standards Master and Tenant Class Master files (F1503 and F15012, respectively). The system creates the Estimated E.P. Recurring Billing workfile (F1502W).

When you run Estimated E.P. PSF Generation, the system performs the following tasks:

1. Selects the leases that are in effect according to the data selection for the DREAM Writer version and the generation date specified in the processing options.

2. Verifies that the E.P. information set up for each lease is in effect on the generation date. If no information is located, the generation stops for that lease and the system prints an error on the Recurring Billing Per Square Foot Generation report.

3. Selects the annual amount of rent per square foot (PSF) that is in effect on the generation date for each E.P. record being processed. If no amount is located, the generation stops for that record and the system prints an error on the Recurring Billing Per Square Foot Generation report.

   • The rent amount, which is selected from the Log Standards Master file, is identified by the log class specified in the processing options and the E.P. class code. The E.P. class code is the same as the amenity ID. For example, if EP is specified as the log class and CAMS is the class code, the system searches the log information for the log line with EP as the log class and CAMS as the amenity ID.

   Figure 117-1 Property/Building Information screen

   
   Description of "Figure 117-1 Property/Building Information screen"
   
   

   • The Log Standards Master file is first searched according to the lease number and then according to the building or property number (business unit). If no amount per square foot is located, the system performs the same search except with a blank E.P. Class code.

4. Multiplies each annual PSF amount by the square footage defined in the lease. The result is the annual billing amount.

5. Creates the estimated recurring billing for the workfile based on the following information:

   • The annual billing amount

   • The estimated bill code specified for the E.P. record

   • The beginning month and year specified in the processing options

   • The ending date of the related lease

6. Prints the Recurring Billing Per Square Foot Generation report so you can review the information the system generated.

7. Updates the Estimated E.P. Recurring Billing workfile. This is controlled by a processing option.

After you run the generation program, you choose the Estimated E.P. Edit/Update program from the menu and run it in update mode. In the Recurring Billings Master file, the system suspends the old bill code line and adds the new line. It also prints the Estimated E.P./R.B. Edit/Update report, which you can use for review. Note the following:

• For the billing records in the Billings Generation Control Master file (F15011), the related Billing Period field is updated to B (Billed).

• The generation type for estimated E.P. recurring billings is 6.

For an overview of expense participation, see Chapter 100, "Expense Participation Process" and E.P. Process without Calculation Revisions in this guide.

Navigation

Estimated E.P. PSF Generation is a selection on both the Expense Participation (CAM) menu (G1523) and the E.P. W/ Calculation Revisions menu (G15231). You access these menus from the Real Estate Management System menu (G15).

117.1 Per Square Foot Generation Report

Figure 117-2 Recurring Billing Per Square Foot Generation

Description of "Figure 117-2 Recurring Billing Per Square Foot Generation"

117.2 Per Square Foot Generation Procedures

When you choose the program from the menu, the system displays a DREAM Writer version list. From this screen, you can copy, change, or run a version of the program. For an overview of the DREAM Writer facility, see Appendix B, "DREAM Writer Overview" in this guide.

117.3 Processing Options

See Section 186.39, "Recurring Billing Per Square Foot Gen. (P15114)."

117.4 Guidelines

The Log Standards Master file is searched according to three levels in the following sequence: lease, building, and property. In this way, a general amount per square foot can be defined for most leases at the building or property level. For exceptions, a specific amount can be defined at the lease level. If the system does not locate an amount at the lease level, it uses the general amount at the building or property level.