The Store Managers Summary report is a weekly analysis of the sales, and labour and inventory costs for each store in your organization. The report provides key details like sales, cash over/short, theoretical inventory costs and an analysis of the labour costs.

The data in this report includes data received from your POS system Point Of Sale system - the system/register used to bill customers and track sales., data entered manually via the Daily Entry pages as well as data pulled from schedules created.

The Store Managers Summary report can be subscribed to by clicking on Subscribe. Click here to learn how to create a subscription.

The following information is displayed in the report for the Area*, Store, Year and Week Ending selected:

  • $ indicates the values in that row are in the currency used by your organization.

  • # indicates the values in that row are a number.

  • % indicates the values in that row are percentages.

  • Adjusted Gross Sales: Sales obtained after subtracting the Tax^ and a few other items* (depending on how your POS is set up) from the gross sales.

    The Cash Sheet > Summary page provides the fields subtracted from the gross sales to arrive at the adjusted gross sales for your organization.

    Adjusted Gross Sales = Gross Sales - Non-Food Sales - Tax^

  • Net Sales: Sales obtained after subtracting deductions from the adjusted gross sales.

    The Cash Sheet > Summary page provides the fields subtracted from the adjusted gross sales to obtain the net sales for your organization.

    Net Sales = Adjusted Gross Sales - Deductions

    OR

    Net Sales = Gross Sales - Non-Food Sales - Tax^ - Deductions

  • Over/Short: The difference between the actual amount received and the expected amount received (based on recorded sales, rebates, bottle deposits, etc.).

    A positive figure indicates that the actual amount received is more than the expected, whereas a negative figure indicates that the actual amount received is less than the expected.

    • The expected amount for the Over/Short calculations can be found on the Cash Sheet > Summary page.

    • The actual amount received for the Over/Short calculations can be found on the Banking Information page.

  • Transaction Count: The total number of transactions recorded for the period.

  • Average Transaction: The average sale value of each transaction for the period.

    Average Transaction = Net Sales / Transaction Count

  • Theo. Food Cost $*: The theoretical cost of all inventory categorized as food and consumed on the day (based on menu item sales).

    This column is displayed only if Food Cost is included in the option selected for the Cost Display on Reports control.

    Click here to learn how to change which costs are included in the report in Inventory Reporting.

  • Theo. Food Cost %*: The percentage of sales that the theoretical cost of the food consumed forms (based on menu item sales).

    This column is displayed only if Food Cost is included in the option selected for the Cost Display on Reports control.

    Click here to learn how to change which costs are included in the report in Inventory Reporting.

    Theo. Food Cost % = Theo. Food Cost $ x 100 / Sales

    The sales amount used in the calculation is that selected in the Theoretical Inventory Cost control.

    Click here to learn how to change the sales amount used in Inventory Reporting.

  • Theo. Paper Cost $*: The theoretical cost of all inventory categorized as paper and consumed on the day (based on menu item sales).

    This column is displayed only if Paper Cost is included in the option selected for the Cost Display on Reports control.

    Click here to learn how to change which costs are included in the report in Inventory Reporting.

  • Theo. Paper Cost %*: The percentage of sales that the theoretical cost of the paper consumed forms (based on menu item sales).

    This column is displayed only if Paper Cost is included in the option selected for the Cost Display on Reports control.

    Click here to learn how to change which costs are included in the report in Inventory Reporting.

    Theo. Paper Cost % = Theo. Paper Cost $ x 100 / Sales

    The sales amount used in the calculation is that selected in the Theoretical Inventory Cost control.

    Click here to learn how to change the sales amount used in Inventory Reporting.

  • Total Theo. Cost $* : The theoretical cost of all category types.

    This column is displayed only if Total Cost is included in the option selected for the Cost Display on Reports control.

    Click here to learn how to change which costs are included in the report in Inventory Reporting.

  • Total Theo. Cost %* : The percentage of sales that the total theoretical cost forms.

    This column is displayed only if Total Cost is included in the option selected for the Cost Display on Reports control.

    Click here to learn how to change which costs are included in the report in Inventory Reporting.

    Total Theo. Cost % = Total Theo. Cost $ x 100 / Sales

    The sales amount used in the calculation is that selected in the Theoretical Inventory Cost control.

    Click here to learn how to change the sales amount used in Inventory Reporting.

  • Total Waste: The total cost of items wasted during the period.

    The wasted items along with their value can be found on the Waste page.

  • Waste Percent: The percentage of sales that the cost of waste forms.

    Waste Percent = Total Waste x 100 / Sales

    The sales amount used in the calculation is that selected in the Waste Cost control.

    Click here to learn how to change the sales amount used in Inventory Reporting.

  • Wage Cost: The total amount spent on wages for the period.

    • Detailed break-up of the wage cost can be found on the Labour Cost page.

    • Only wages of jobs with the Include in Executive Summary control set to Yes are included in the calculation.

      Click here to learn how to select which jobs are included in the calculation of wages in Job Codes.

  • Wage Percent: The percentage of sales that the cost of labour (wages) forms.

    Wage Percent = Wage Cost x 100 / Sales

    The sales amount used in the calculation is that selected in the Labour Cost control.

    Click here to learn how to change the sales amount used in Time Card Reporting.

  • Txn Per Labour Hour: The average number of transactions that were recorded per hour worked by a single person.

    Txn Per Labour Hour = Transaction Count / Actual Hours

  • Sales Per Labour Hour: The average sales that were recorded per hour worked by a single person.

    Sales Per Labour Hour = Adjusted Gross Sales / Actual Hours

  • Target Hours: The total number of labour hours required to meet your store's target SPLH Sales Per Labour Hour. It is the total sales for the period divided by the number of labour hours logged for the same period..

    Target Hours = Net Sales / Target SPLH

    The Target SPLH is that set as the Sales Per Labour Hour control for your store.

    Click here to learn how to change the target SPLH Sales Per Labour Hour. It is the total sales for the period divided by the number of labour hours logged for the same period. in Schedule - Method.

  • Scheduled Hours: Total number of labour hours scheduled for the period using a CLEARVIEW scheduler.

    Only scheduled hours for jobs with the Include in SPLH Calculations and Storefront Labour control set to Yes are included.

    Click here to learn how to select which jobs are included in the calculation of scheduled hours in Job Codes.

  • Actual Hours: The total number of labour hours recorded through time cards.

    Only recorded hours for jobs with the Include in SPLH Calculations and Storefront Labour control set to Yes and time cards with Include in SPLH control set to Yes are included.

    • Click here to learn how to select which jobs are included in the calculation of actual hours in Job Codes.

    • Click here to learn how to select which time cards are included in the calculation of actual hours in Time Card Types.

  • Target Variance: The difference between the actual hours worked and the recommended target hours to meet your store's target SPLH Sales Per Labour Hour. It is the total sales for the period divided by the number of labour hours logged for the same period..

    Target Variance = Actual Hours - Target Hours

  • Cost of Variance: The difference in cost between the actual hours worked and the approximate cost based on the recommended target hours to meet your store's target SPLH Sales Per Labour Hour. It is the total sales for the period divided by the number of labour hours logged for the same period..

    Cost of Variance = Target Variance x Average Wage

    The Average Wage is that selected as the Average Wage control for your store.

    Click here to learn how to change the Average Wage in Schedule - Method.

  • Schedule Variance: The difference between the actual hours worked and the number of hours scheduled using a CLEARVIEW scheduler.

    Schedule Variance = Actual Hours - Scheduled Hours

  • Cost of Variance: The difference in cost between the actual hours worked and the approximate cost based on the number of hours scheduled using a CLEARVIEW scheduler.

    Cost of Variance = Schedule Variance x Average Wage

    The Average Wage is that selected as the Average Wage control for your store.

    Click here to learn how to change the Average Wage in Schedule - Method.

The Store Managers Summary report for your organization may contain additional rows customized for your organization.

TO VIEW A STORE MANAGERS SUMMARY REPORT:

  1. Open the Store Managers Summary page.

  2. Select the Area* and Store for which you want to view the report from the drop-down list(s).

  3. Select the Year that contains the last date of the week for which you want to view the report from the drop-down list.

  4. Select the last date of the week for which you want to view the report from the Week Ending* drop-down list.

  5. Click on the Go button.

Associated Settings

*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.