1. Real Estate Management Implementation Guide
  2. Understanding Sales History

Understanding Sales History

The Sales History Inquiry program (P1541B) is an online, date-sensitive program that displays actual sales from the F1541B table and projected sales from the F1542 table. The P1541B displays this information:

  • The start date and end date for the first 12-month cycle, as well as the start date and end date of the subsequent 12-month cycle.

  • Total sales for the first 12-month cycle.

  • Total sales for the second 12-month cycle.

  • Total sales for the 24-month cycle.

  • Sales per square foot for the first 12-month cycle.

  • Sales per square foot for the second 12-month cycle.

  • Sales per square foot for the 24-month cycle.

The system uses these tables in the sales inquiry:

  • Lease Master Header (F1501B).

  • Lease Master Detail (F15017).

  • Tenant Sales History (F1541B).

  • Projected Sales (F1542).

  • Sales History Work File (F1541BW).

  • Real Estate Management Constants (F1510B).

  • Unit Master (F1507).

  • Area Master (F1514).

The system calculates total sales using these formulas for the sales per square foot amounts for the first and second 12-month cycles:

  • Total Sales (12-month) = Sales 1 + Sales 2 + Sales 3 + Sales 4 + Sales 5 + Sales 6 + Sales 7 + Sales 8 + Sales 9 + Sales 10 + Sales 11 + Sales 12

  • Total Square Foot (12-month) = Sq. Ft. 1 + Sq. Ft. 2 + Sq. Ft. 3 + Sq. Ft. 4 + Sq. Ft. 5 + Sq. Ft. 6 + Sq. Ft. 7 + Sq. Ft. 8 + Sq. Ft. 9 + Sq. Ft. 10 + Sq. Ft. 11 + Sq. Ft. 12

  • Total Sales ÷ Sq Ft (12 month) = Total Sales (12month) ÷ Total Sq Ft (12-month)

The system calculates total sales using these formulas for the sales per square foot amounts for the overall 24-month period:

  • Total Sales (24-month) = Sales 1 + Sales 2 + Sales 3 + Sales 4+ Sales 5 + Sales 6 + Sales 7 + Sales 8 + Sales 9 + Sales 10 + Sales 11 + Sales 12 + Sales 13 + Sales 14 + Sales 15 + Sales 16 + Sales 17 + Sales 18 + Sales 19 + Sales 20 + Sales 21 + Sales 22 + Sales 23 + Sales 24

  • Total Square Foot (24-month) = Sq. Ft. 1 + Sq. Ft. 2 + Sq. Ft. 3 + Sq. Ft. 4 + Sq. Ft. 5 + Sq. Ft. 6 + Sq. Ft. 7 + Sq. Ft. 8 + Sq. Ft. 9 + Sq. Ft. 10 + Sq. Ft. 11 + Sq. Ft. 12. + Sq. Ft. 13 + Sq. Ft. 14 + Sq. Ft 15 + Sq. Ft. 16 + Sq. Ft. 17 + Sq. Ft. 18 + Sq. Ft. 19 + Sq. Ft. 20 + Sq. Ft. 21 + Sq. Ft. 22 + Sq. Ft. 23 + Sq. Ft. 24

  • Total Sales ÷ Square Foot (24-month) = Total Sales (24-month) ÷ Total Sq Ft (24-month)

Note: Because total sales and sales per square foot can be weighted differently, they cannot simply be added for the first and second 12-month cycles.