The Labor Cost Analysis report provides a detailed breakdown of employee labor costs, hours worked, and sales performance within a selected time period in the Salido Bridge. While the Labor Summary offers high-level aggregates, this report lists labor data by employee and job position, allowing managers to evaluate labor efficiency, compare labor cost against net sales, and identify where staffing costs are outpacing revenue.
This report allows you to:
- Compare worked hours, payroll cost, and net sales for each employee in a single report.
- Evaluate labor efficiency using the Labor % of Sales metric.
- Organize labor data dynamically by employee, location, job position, or position category.
Filtering the Labor Cost Analysis Report
You can adjust the filters at the top of the page to refine your results for the entire report.
- Location: Select a Location (or location group) by ticking the box next to the desired location from the drop-down menu. You can also select All Locations (the default).
- Report View: Select a saved Custom View or the default Base Report from the drop-down menu. You can also create a new Custom View from this menu. For instructions, please see the article: How to Customize Reports in the Bridge.
- Date: Select a predefined date range (like Year to Date) or select a custom date range using the date picker.
Interacting with Report Sections
The report includes a set of controls to customize its appearance and export its data.
- Download: Click the Download icon (downward arrow) to export the data from the report as a CSV, Excel file, or download the entire report as a PDF.
-
Gear Icon Options: Click the Gear icon (⚙) to open a menu with additional report controls:
- Report Style: Change the grid's density. Options include Regular (the default), Compact, and Large.
- Schedule Report: Open the scheduling window to configure daily, weekly, monthly, or annual reports.
- Full Screen: Expand the report to fill the screen.
- Sort Columns: Click any column header, or its three-dot menu, to sort the data in ascending or descending order.
- Reorder Columns: Click and drag a column header to a new position in the grid.
- Column Options: Click the three-dot menu on a column header to open more options, such as pinning or autosizing the column.
Note: Making changes to options will activate the SAVE CHANGES button. These grid customizations can only be saved to a Custom View. If you are currently in the Base Report view, clicking SAVE CHANGES will prompt you to create a new Custom View to save your changes.
Understanding the Metrics
The Labor Cost Analysis report organizes specific labor and sales data points into defined columns to provide a clear view of labor efficiency. You can enable or disable these columns to tailor your view.
- Employee: The name of the staff member included in this row of labor data.
- Job Position: The job position the employee was clocked in under for the shift(s) included in this row (e.g., Server, Bartender, General Manager).
- Location: The specific restaurant location where the labor was recorded.
- Position Category: The broader classification the job position belongs to (e.g., Front of House, Back of House).
- Total Hours: The total number of hours the employee worked across all included shifts, displayed in HH:MM format.
- Avg Hours/Shift: The average length of a single shift, calculated by dividing Total Hours by the number of shifts.
- Regular Rate: The employee's standard hourly pay rate for the position.
- Labor Cost: The total cost of regular labor for the row, calculated as Total Hours multiplied by Regular Rate.
- Net Sales: The total net sales generated during the employee's shift(s), used to calculate labor efficiency.
- Labor % of Sales: The percentage of Net Sales consumed by Labor Cost, calculated by dividing Labor Cost by Net Sales.
- Overtime Hours: The number of hours worked beyond the standard overtime threshold.
- Overtime Rate: The employee's pay rate for Overtime Hours.
- Overtime Labor Cost: The total cost of overtime labor, calculated as Overtime Hours multiplied by Overtime Rate.
- # of Shifts: The total number of individual shifts included in the row.
- GL Number: The General Ledger number associated with the employee's position, used for accounting and payroll exports.
- Payroll ID: The unique identifier assigned to the employee in the connected payroll system.
- Last Name: The employee's last name.
- First Name: The employee's first name.
Grouping Options
By default, the report groups data by Employee. In addition to the columns above, you can further organize the report data by adding the following fields to the Row Groups section:
- Location
- Position Category
- Employee
- GL Number
- Job Position
To apply a grouping, follow this step:
1. Click and drag the desired field from the columns panel into the Row Groups section
Recommendation: For a shift-by-shift breakdown of the underlying time card data behind these labor costs, please visit the companion guide: Understanding the Time Card Detail. To configure the overtime thresholds and rates referenced in this report, please see: How to Set Up Overtime Monitoring in a Labor Report.
Comments
0 comments
Please sign in to leave a comment.