Run a Labor Analysis Report on Business Intelligence

Description: Learn how to run a Labor Analysis report on Business Intelligence (BI).

---

Labor Analysis Report Guide

To run the Labor Analysis Report, log in to Business Intelligence and select Labor/Payroll > Labor Analysis Report.

Purpose of the Report

This report provides a detailed view of your labor deployment for the selected time period.

Key columns include:

• Regular Hours: Total regular hours worked
• Overtime Hours: Total overtime hours worked
• Total Hours: Combined regular and overtime hours
• SLS/Hr (Sales per Hour): Indicates how productive each labor hour was in generating sales

At the bottom of the SLS/Hr column, you’ll find the enterprise-wide average for the selected period.

Reviewing Employee Wages

Another important column is Avg Wge (Average Wage).

To review wage information:

1. Select a specific store.
2. Drill down to Employees.
3. Review each employee’s wage in the Avg Wge column.

This allows you to compare wage distribution and identify cost drivers at the employee level.

Notes: 

• Comparing Store Labor Costs: If two stores have similar sales but one has higher labor costs, the difference may be due to variations in average wages. For example, an older store may have long-term employees earning higher wages.
• Missing Wage Information: To ensure accurate labor reporting:
  • Every employee must have a wage entered in the system
  • Run the report by Employee.
  • Sort the Avg Wge column from lowest to highest.
  • Employees missing wage information will appear at the bottom or show as $0.00.
• Reviewing Hours Detail: If you have questions about an employee’s hours worked:
  1. Select the employee’s name.
  2. Drill down to Hours Detail.
  3. Review clock-in and clock-out times for accuracy.

When used consistently, the Labor Analysis Report helps identify labor inefficiencies, wage-related cost differences, and potential payroll discrepancies.