Sales and Labor The Sales and Labor data set combines key sales and labor data elements into one data set allowing you to view this information on one tab. This data set includes shared data elements with other data sets, such as Net Sales, and Labor Dollars; it also includes some unique combined data elements, such as Labor %, and Sales per Labor Dollar. Sales and Labor contains some of the following ‘group by levels’: Area, Store, Date, Employee Name, and more. Refer to the following table for a list of ‘group by levels’ associated with the data elements. Sales and Labor Data Elements Data Element Definition Group By Levels Address The address of the selected employee, as configured in Aloha Manager. Employee Detail Area The area name, as configured in Aloha Insight. Area Birthday The birthday of the selected employee, as configured in Aloha Manager. Employee Detail Budgeted Labor Dollars The total amount of labor dollars budgeted for a specified period. Area, Region, Store Groups, Store, Date Budgeted versus Actual Labor Dollars The difference between the budgeted dollar amount and the actual labor dollar amount including overtime. (Budgeted Labor – Actual Labor) Area, Region, Store Groups, Store, Date Cash Tips The amount of cash tips declared by the employee. Area, Region, Store Groups, Store, Date, Employee Job Code, Job Code, Employee Name Check Average The average check dollar amount based on the “Check Average Method” selected from Company Setup in Aloha Insight divided by the number of checks. Area, Region, Hour, Store Group, Revenue Center, Store, Date, Day Part Check Count The total number of checks during the specified period. Area, Region, Hour, Store Group, Store, Revenue Center, Date, Day Part, Employee Name City The city of the selected employee, as configured in Aloha Manager. Employee Detail Credit Card Tips The total dollar amount of all credit cards tips. Area, Region, Store Groups, Store, Date, Employee Job Code, Job Code, Employee Name Date The date of the selected day of business. Date Date of Hire The hire date of the selected employee, as configured in Aloha Manager. Employee Detail Day Part The day part name, as configured in Aloha Manager. Day Part Declared Tips The total declared tip dollars based on the amount of tips declared upon employee checkout. Area, Region, Store Groups, Store, Date, Employee Job Code, Job Code, Employee Name Employee Count The total number of employees that clocked in during the selected period. Area, Region, Store Groups, Stores, Date Employee Export ID The export ID of the selected employee, as configured in Aloha Manager. Employee Name, Employee Detail Employee ID The employee identification number, as configured in Aloha Manager. Employee Name, Employee Job Code, Employee Detail Employee Name (last, first) The name of the selected employee, as configured in Aloha Manager. (last, first) Employee Name, Employee Job Code, Employee Detail Employee Nickname The nickname of the selected employee, as configured in Aloha Manager. Employee Name, Employee Detail Gross Sales The total amount of item sales including order mode charges, surcharges, and all taxes. Area, Region, Store Groups, Store, Date, Day Part, Hour, Revenue Center Guest per Labor Hour The average number of guest per labor hour. Guest Count / Labor Hours. Area, Region, Store Groups, Stores, Date Day Part, Hours, Rev Center Hour The hour of the day when the selected transaction took place. Hour Job Code ID The job code identification number under which the selected employee worked. Employee Job Code, Job Code Job Code Name The job code name under which the selected employee worked. Job Code, Employee Job Code Labor % The total labor percent. [(Labor Dollars / Net Sales) * 100]. Area, Region, Store Group, Store, Date, Day Part, Hours, Revenue Center Labor Dollars The total amount of all labor dollars (Regular + Overtime). Area, Region, Store Group, Store, Date, Day Part, Hours, Employee Job Code, Job Code, Revenue Center, Employee Name Labor Hours The total amount of all labor hours (Regular + Overtime). Area, Region, Store Group, Store, Date, Day Part, Hours, Employee Job Code, Job Code, Revenue Center, Employee Name Net Sales The total amount of item sales including order mode charges, less surcharges, inclusive tax, comps, and promos. NOTE: The formula can be changed by including or excluding comps and promos in Company Setup. Area, Region, Store Groups, Store, Date, Day Part, Hour, Revenue Center Overtime Labor % The percent of overtime labor spent for the net sales dollar. [(OT dollars / Net Sales Dollars) * 100] Area, Region, Store Group, Store, Date, Day Part, Revenue Center Overtime Labor Dollars The total amount of all overtime labor dollars. The amount does not include regular labor dollars or labor hours for zero rate employees if the Company Setup setting ‘Exclude Hours from Zero Rate Employees’ is selected. Area, Region, Store Group, Store, Date, Day Part, Employee Job Code, Job Code, Revenue Center, Employee Name Overtime Labor Hours The total amount of overtime labor hours. This amount does not include regular labor hours. Area, Region, Store Group, Store, Date, Day Part, Employee Job Code, Job Code, Revenue Center, Employee Name Pay Rate The hourly pay rate for the selected employee, as configured in Aloha Manager. Employee Name Phone Number The phone number of the selected employee, as configured in Aloha Manager. Employee Detail Projected Sales Dollars The total amount of projected sales for a specified time period. Projections are entered through the Sales Projection Wizard. Area, Region, Store Groups, Store, Date Projected vs Net Sales % The percent of the projected versus net sales. [(Net Sales - Projected Sales) / Net Sales] * 100 Area, Region, Store Group, Store, Date Projected vs Net Sales Dollars The difference between the net sales and projected sales. Net Sales - Projected Sales. Area, Region, Store Group, Store, Date Region The region name, as configured in Aloha Insight. Region Regular Labor Dollars The total amount of all regular labor. This amount does not include overtime labor dollars. Area, Region, Store Group, Store, Date, Day Part, Employee Job Code, Job Code, Revenue Center, Employee Name Regular Labor Hours The total amount of all regular labor hours. This amount does not include overtime labor hours or labor hours for zero rate employees if the Company Setup setting ‘Exclude Hours from Zero Rate Employees’ has been enabled. Area, Region, Store Group, Store, Date, Day Part, Employee Job Code, Job Code, Revenue Center, Employee Name Revenue Center Name The revenue center name, as configured in Aloha Manager. Revenue Center Sales per Hour Worked The total number of employees that clocked in during the selected period. Area, Region, Store Groups, Stores, Date, Day Part, Hours, Rev Center Sales per Labor Dollar The net sales to labor dollar. Total net sales divided by total labor dollars for the selected period. Area, Region, Store Group, Store, Date, Day Part, Hour, Revenue Center Scheduled Labor Hours The total scheduled labor hours not including overtime, as scheduled in Aloha Back-of-House (BOH). Area, Region, Store Group, Store, Date, Employee Job Code, Job Code, Employee Name Scheduled Labor Dollars The total scheduled labor dollars not including overtime, as scheduled in Aloha Back-of-house. Area, Region, Store Groups, Store, Date, Employee Job Code, Job Code, Employee Name Scheduled versus Actual Labor Dollars The difference between the scheduled and the actual labor dollars. (Scheduled Labor – Actual Labor) Area, Region, Store Groups, Store, Date, Employee Job Code, Job Code, Employee Name Social Security Number The social security number of the selected employee, as configured in Aloha Manager. Employee Detail State The state of the selected employee, as configured in Aloha Manager. Employee Detail Store Group The store group name, as configured in Aloha Insight. Store Group Store ID The store identification number, as configured in Aloha Insight. Store, Employee Name Store Name The store name, as configured in Aloha Insight. Store, Employee Job Code, Employee Name Straight Sales The total dollar amount of items sold, including inclusive taxes and refunds. Area, Region, Store Groups, Store, Date, Day Part, Hour, Revenue Center Tippable Sales The total dollar amount of tippable sales, which are derived from tippable order modes for employees who are required to declare tips. Area, Region, Store Groups, Store, Date, Employee Job Code, Job Code, Employee Name Total Weeks Pay The total amount of all labor dollars (Regular + Overtime) by employee for the company week. Employee Detail Void Count The total number of all voided items. Area, Region, Store Groups, Store, Date, Hour Void Dollars The total dollar amount of all voided items. Area, Region, Store Groups, Store, Date, Hour YTD Hours The total amount of all labor hours (Regular + Overtime) for the selected employee for the calendar year. Employee Detail YTD Pay The total amount of all labor dollars (Regular + Overtime) for the selected employee for the calendar year. Employee Detail Zip Code The zip code of the selected employee, as configured in Aloha Manager. Employee Detail