Understanding Seasonality Generation

If a lease does not meet the conditions for comparable leases or there is not sufficient sales data to generate future sales estimates, you can define seasonality values to enable the system to create a sales forecast.

A lease is considered comparable if the values for the following fields do not change:

  • The Urban Land Industry (ULI) Code (for example, the Major Merchandise code)

  • Building

  • Unit

  • Area. (square footage)

  • DBA

If any of these conditions change or if insufficient sales data are available to use any of the forecasting methods, the lease is considered noncomparable

To create seasonality values and a default seasonality model, run the Seasonality Generation program (R1547) or create the seasonality values manually in the Seasonality Models program (P1549) and the Seasonality Information program (P15470). You can also to review and revise seasonality values generated by the R1547 program in the P1549 and P15470 programs

The Projected Sales Generation program (R1542) uses a seasonality model to select seasonality values. When forecasting sales, the system uses the model with the lowest line number whose minimum number of tenants is fewer than the number of tenants for whom the sales forecast is run. If none of the seasonality models meet the criteria, the system uses the default model that includes sales for the entire project or building.

The system calculates seasonality values by building and ULI or project and ULI. The system uses this formula to calculate seasonality values: Seasonality (month X) = (Sales (month X this year) × 100) ÷ total sales for current year

The system stores seasonality values in the Sales Seasonality table (F1547).