Labor with/without Wages

The Labor without Wages and Labor with Wages data sets enable you to create drilldown tabs for labor and operational analysis. These data sets include Sales per Hour Worked, Sales per Labor Hour, Scheduled Labor Dollars %, and more. The Labor without Wages and Labor with Wages data sets contain the same data elements; however, Labor with Wages contains five more data elements that report wage data. Using the security rights provided for each of the data sets, you can provide access to sensitive wage information to only the people who need it.

Labor with Wages contains the following additional data elements:

•	Overtime Pay Rate

•	Total Weeks Paid

•	Unpaid Break Hours

•	Year to Date Hours

•	Year to Date Pay

Labor with/without Wages contains some of the following ‘group by levels’: Area, Store, Date, Employee Name, Employee Detail, and more. Refer to the following table for a list of ‘group by levels’ associated with the data elements.

Labor with/without Wages 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
Average Wage Rate	The average dollar per hour ((Regular Pay + Overtime Premium) / (Total Hours + Overtime Hours)).	Area, Region, Store Group, Store, Employee Job Code, Date
Birthday	The birthday of the selected employee, as configured in Aloha Manager	Employee Detail
Break Time Average	The average break time taken by all employees for the selected store(s).	Area, Region, Store Group, Store, Employee Job Code, Date
Break Time Count	The total count of all breaks taken by all employees for the selected store(s).	Area, Region, Store Group, Store, Employee Job Code, Date
Break Time Modification Count	The total count of modifications made by a store manager.	Area, Region, Store Group, Store, Employee Job Code, Date
Cash Tips	The amount of cash tips declared by the employee(s).	Area, Region, Store Group, Store, Employee Job Code, Date, Job Code, Employee Name
Check Average	The per person average dollar amount based on the “Check Average Method” selected from Company Setup in Aloha Insight divided by the number of guests.	Area, Region, Store Group, Store, Date, Day Part, Hour, Revenue Center, Employee Name
Check Count	The total number of checks during the specified period.	Area, Region, Store Group, Store, Date, Day Part, Hour, Revenue Center, Employee Name,
City	The city of the selected employee, as configured in Aloha Manager.	Employee Detail
Country	The country of residence 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 Group, Store, Employee Job Code, Date, 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 Group, Store, Employee Job Code, Date, Job Code, Employee Name
Employee Count	The total number of employees that clocked in during the selected period.	Area, Region, Store Group, Store, 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 Job Code, Employee Name, Employee Detail
Employee Name (last, first)	The name of the selected employee, as configured in Aloha Manager. (last, first)	Employee Job Code, Employee Name, Employee Detail
Employee Nickname	The nickname of the selected employee, as configured in Aloha Manager.	Employee Name, Employee Detail
Guest per Labor Hour	The average number of guests per labor hour. (Guest Count / Labor Hours.)	Area, Region, Store Group, Store, Date, Day Part, Hour, Revenue Center, Employee Name
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.	Employee Job Code, Job Code
Labor %	The total labor percent. [(Labor Dollars / Net Sales) * 100].	Area, Region, Store Group, Store, Date, Day Part, Hour, Revenue Center, Employee Name
Labor Dollars	The total amount of all labor dollars (Regular Labor Dollars + Overtime Labor Dollars).	Area, Region, Store Group, Store, Employee Job Code, Date, Day Part, Hour, Job Code, Revenue Center, Employee Name
Labor Hours	The total number of all labor hours (Regular Labor Hours + Overtime Labor Hours).	Area, Region, Store Group, Store, Employee Job Code, Date, Day Part, Hour, Job Code, Revenue Center, Employee Name
Other Wages	The wages paid to the selected employee(s) for pay other than regular or overtime wages.	Area, Region, Store Group, Store, Employee Job Code, Date, Job Code, Employee Name
Overtime Labor %	The percent of overtime labor spent for a net sales dollar. [(Overtime dollars / Net Sales) * 100].	Area, Region, Store Group, Store, Date, Day Part, Revenue Center, Employee Name
Overtime Labor Dollars	The total amount of all overtime labor dollars. This amount does not include regular labor dollars for zero rate employees if ‘Exclude Hours from Zero Rate Employees’ is enabled in Company Setup.	Area, Region, Store Group, Store, Employee Job Code, Date, Day Part, Job Code, Revenue Center, Employee Name
Overtime Labor Hours	The total number of overtime labor hours. This number does not include regular labor hours.	Area, Region, Store Group, Store, Employee Job Code, Date, Day Part, Job Code, Revenue Center, Employee Name
Overtime Pay Rate (Labor with Wages)	The overtime pay rate for the selected employee.	Employee Name
Paid Break Hours	The total number of hours in paid breaks.	Area, Region, Store Group, Store, Employee Job Code, Date, Day Part, Job Code, Employee Name
Pay Rate	The regular pay rate for the selected employee.	Employee Name
Phone Number	The phone number of the selected employee, as configured in Aloha Manager.	Employee Detail
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, Employee Job Code, Date, Day Part, Job Code, Revenue Center, Employee Name
Regular Labor Hours	The total number of all regular labor hours. This number does not include overtime labor hours or labor hours for zero rate employees if ‘Exclude Hours from Zero Rate Employees’ is enabled in Company Setup.	Area, Region, Store Group, Store, Employee Job Code, Date, Day Part, Job Code, Revenue Center, Employee Name
Revenue Name	The revenue center name, as configured in Aloha Manager.	Revenue Center
Sales per Hour Worked	Net sales divided by the total labor hours from the selected period.	Area, Region, Store Group, Store, Date, Day Part, Hour, Revenue 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
Sales per Labor Hour	The net sales to labor dollar. Total net sales divided by total labor dollars for the selected period.	Day Part, Hour, Revenue Center
Scheduled Labor Dollars	The total scheduled labor dollars not including overtime, as scheduled in Aloha Back-of-House.	Area, Region, Store Group, Store, Employee Job Code, Date, Job Code, Employee Name
Scheduled Labor Dollars %	The scheduled labor percent. [(Scheduled Labor Dollars / Net Sales) * 100].	Area, Region, Store Group, Store, Date, Employee Name
Scheduled Labor Hours	The total scheduled labor hours not including overtime, as scheduled in Aloha Back-of-House.	Area, Region, Store Group, Store, Employee Job Code, Date, Job Code, Employee Name
Scheduled versus Actual Labor Dollars	The variance between the scheduled and the actual labor dollars. (Scheduled Labor Dollars – Labor Dollars)	Area, Region, Store Group, Store, Employee Job Code, Date, 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
Time In	The time the employee clocked in to the Aloha POS system.	Employee Name
Time Out	The time the employee clocked out of the Aloha POS system.	Employee Name
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 Group, Store, Employee Job Code, Date, Job Code, Employee Name
Tippable sales by Tip % Threshold	The tippable sales multiplied by the Tip % Threshold, as defined in System Setup > Company Setup > Sales Calculations tab.	Area, Region, Store Group, Store, Employee Job Code, Date
Total Weeks Pay (Labor with Wages)	The total amount of all labor dollars (by employee for the company week. Regular Labor Dollars + Overtime Labor Dollars)	Employee Detail
Unpaid Break Hours (Labor with Wages)	The total number of hours in unpaid breaks.	Area, Region, Store Group, Store, Employee Job Code, Date, Day Part, Job Code, Employee Name
YTD Hours (Labor with Wages)	The total number of all labor hours for the selected employee for the calendar year. (Regular Hours + Overtime Hours)	Employee Detail
YTD Pay (Labor with Wages)	The total amount of all labor dollars for the selected employee for the calendar year. (Regular Labor Dollars + Overtime Labor Dollars)	Employee Detail
Zip Code	The zip code of the selected employee, as configured in Aloha Manager.	Employee Detail