Marketing Sales Analysis

Make the following selections from the menu to display this page:

Reports—Retail Reports—Marketing Sales Analysis

The Marketing Sales Analysis Report shows sales amounts in relation to a tenant's rent for commercial properties (property type 6-Standard Commercial). Tenants are sorted by sales category and suite number. In addition to the property total, a total by sales category is also provided.

ClosedSelection Criteria

Select Properties

Click to select properties from the Select Properties tab. The report runs for all selected properties.

Include Previous Tenant

Click the check box to include previous tenants on the report. (The label for this field may differ based on field names assigned.)

Ranking Groups

If ranking groups are used, the report calls for which ranking groups to include. Make your selections from the grid.

Ranking

The ranking group code.

Ranking Group

The description of the ranking group.

Ranking Period

The period in which the group was last ranked.

Selected?

Click the box to select a single ranking group. Or, click the header to select all ranking groups at once.

ClosedReport Details

Note Note

This topic provides report details for commercial properties only; that is, properties with the property type set to 6-Standard Commercial.

Suite

The building + suite number. For instance, 0001-101.

Name

The tenant's name or business name. For instance, Susan Smith or Smith Shoes.

Monthly Rent

The monthly rent amount. The sum of all charges for the month.

Square Footage

Property default square footage for this suite.

Percent of GLA

System-calculated amount.
Calculation: Tenant property default square footage from the suite file / the total property default square footage of the property / ranking group X 100

Sales MM-YYYY

Sales amount reported in month equal to the as of date.

Sales MM-YYYY

Sales amount reported in month equal to the as of date.

% Diff

System-calculated amount.
Calculation: (Total sales amount reported in the as of month - total sales amount reported 12 months prior to the month the report is being run as of) divided by the total sales amount reported 12 months prior to the month the report is being run as of.

Rent Sales

System-calculated amount.
Calculation: Monthly rent / Current month's sales X 100

% of Sales

System-calculated amount.
Calculation: Tenant's current month sales / the property or ranking group's current month sales X 100

Sales Eff Ratio

System-calculated amount.
Calculation: Percent of Sales / Percent of GLA

YTD Sales YYYY

Sum of tenant's sales for each of the months in the prior year, up to the month that is equal to the month the report is being run as of.

YTD Sales YYYY

Sum of tenant's sales for each of the month in the current year, up to the month that is equal to the month the report is being run as of.

YTD % Diff

System-calculated amount.
Calculation: Tenant's YTD sales / the property or ranking group's YTD sales X 100

YTD Rent/Sales

System-calculated amount.
Calculation: Tenant's monthly rent amount X number of months that have elapsed in the year for which the report is being run as of / the YTD sales for the current year.

YTD % of Sales

System-calculated amount.
Calculation: Tenant's YTD sales for current year / the property or ranking group's YTD sales for current year X 100

YTD Sales Eff Ration

System-calculated amount.
Calculation: YTD percent of Sales / Percent of GLA

 

ClosedTo Display the Marketing Sales Analysis

  1. From the eSite menu, select Reports—Retail Reports—Marketing Sales Analysis.
  2. Click Select Properties. Select the properties for which you want to print the report and click Done.
  3. If you want to include previous tenants on the report, check the Include Previous Tenants check box.
  4. Select the information you want to see on the report (refer to the Selection Criteria for this report).
  5. Select a Report Format option: Acrobat Reader (default), Crystal Viewer, Excel.
  6. Click Display. If you selected the printing option, Excel, you are prompted to open or save the report Excel file. Otherwise, the report opens in your preferred format.

See Also

Retail Reports Overview

Reports Overview

Report Printing Options

Select Properties

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.