MENU
    Labor Hour and Rate Analysis
    • 09 Jul 2024
    • 2 Minutes to read
    • Dark
    • PDF

    Labor Hour and Rate Analysis

    • Dark
    • PDF

    Article summary

    The Labor Hour and Rate Analysis report is used to examine labor costs by analyzing worked hours and corresponding pay rates. The purpose of this report is to help restaurant managers and owners understand labor expenditures, monitor labor efficiency, and control labor costs. By breaking down labor data, the report assists in identifying trends, spotting potential overstaffing or understaffing issues, and ensuring that labor expenses align with budgetary goals. This detailed analysis supports better scheduling decisions by helping managers prevent overtime or other costly labor penalties.


    1. In the Reports section of the left navigation pane, select My Reports.
      The My Reports screen appears.

    2. At the top of the My Reports screen, select Labor.
      The screen generates a list of reports in alphabetical order.

    3. Locate the Labor Hour and Rate Analysis.

    4. Select Customize to adjust the report parameters and run the report.


    Report Parameters

    Field

    Description

    1

    Filter By

    A list of all filter categories. Filter categories will vary based by report.

    2

    Filter

    A list of filter options, determined by the 'Filter By' category selected (#1).

    3

    Start

    First date to include in the report. The Start and Ends dates create a date range for which data is displayed in the generated report.

    4

    End

    Last date to include in the report. The Start and Ends dates create a date range for which data is displayed in the generated report. 

    5

    Group By

    Determines whether data is grouped by Location or by Employee.

    6

    Job

    Determines which jobs are included in the report.

    7

    Employee

    Determines which employees are included in the report.

    8

    Include Employees

    If Yes is selected, employee names appear below their job titles.
    If No is selected, only the job title is shown.

    9

    Break Page Per Location

    If set to Yes, the report includes a page break after each location, allowing users to more easily separate data when printed or downloaded.

    10

    Identify Minors

    If set to Yes, the word 'Minor' appears next to all employees who are under a certain age.

    11

    Primary Location

    If set to Yes, employees are sorted by primary location. If the employee worked at more than one location, all rows for the employee appear listed below their primary location, and the Location column specifies the actual physical location where the employee worked the shift.

    If set to No, each row for the employee appears ​under the actual physical location where the employee worked the shift.

    12

    View options

    This section provides options to select, save, edit, or delete a report view.

    13

    Run

    Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report.


    Report Columns

    Column

    Description

    Location / Employee

    If Group By Location was selected prior to running the report, this column is labeled Location and displays the name of the location for which data is shown.
    If Group By Employee was selected prior to running the report, this column is labeled Employee and displays the name of the employee for whom data is shown.

    Employee Payroll ID

    Number used to identify the employee in the payroll system.

    Worked Location

    Location where the employee worked the shift.

    This column appears only if the Primary Location parameter is set to Yes.

    Job

    Job that was worked.

    Reg Hours

    Number of hours worked at a regular rate.

    Reg Rate

    Regular rate of pay.

    Reg $

    Amount owed to the employee for hours worked at the regular rate.

    OT Hrs

    Number of hours worked at an overtime rate.

    OT Rate

    Overtime rate of pay.

    OT $

    Amount owed to the employee for hours worked at the overtime rate.

    Total Hrs

    Total number of hours worked.

    Total $

    Total amount owed to the employee.


    Email, Export, or Print the Report

    This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.


    Was this article helpful?