Executive Comparison Crosstab Report

Executive Comparison Crosstab Report

Executive Comparison Crosstab Report Overview

The "Executive Comparison Crosstab Report" combines data from various areas such as sales, cycle counts, and the time clock to show an overview of a given location by weekly period.

1. Reaching the "Executive Comparison Crosstab Report" 

To reach the "Executive Comparison Crosstab Report," follow the steps below (see Figure 1.0):
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reports
  4. Step 4: Choose Sales Reports
  5. Step 5: Choose Executive Comparison Crosstab


                                                                                          Figure 1.0
  1. See Figure 1.1. You will see many types of sales reports that will be useful to your retail business.
  2. By clicking the "Choose Report" drop-down selection, you will see the different types of sales reports.

                                                                         Figure 1.1

You will see the "Report Data is Empty" message initially. You need to select the date range to generate the "Executive Comparison Crosstab Report." See Figure 1.2.


                                                                               Figure 1.2

2. Generating the "Executive Comparison Crosstab Report" 

To generate the "Executive Comparison Crosstab Report," follow the steps below (see Figure 2.1): 
  1. Select the number of weeks to display the executive comparison crosstab for that number of weeks.

                                                                                    Figure 2.1

The following data gets fetched in report format when you click on the "Generate Report" button in the top right corner; "Executive Comparison Crosstab" will be displayed as highlighted in Figure 2.2.


                                                                                   Figure 2.2

Fields:
  1. Customer Count: It represents the total number of transactions completed at the store during the week.
  2. Inventory Shrink: It is calculated by subtracting the manual inventory count from the recorded inventory cost in the system. This data is sourced from cycle counts and reflects inventory shrinkage in terms of cost.
  3. Labor Hours: It displays the total hours worked by employees during their shifts, based on time clock records.
  4. Profit: It is determined using the formula: Profit = Revenue - Cost of Items Sold.
  5. Sales Dollars: It represents the total revenue generated from completed sales transactions.
  6. Total: It displays the overall total sales amount.