MENU
    Labor Actual vs Scheduled - Punch Details
    • 16 Jul 2024
    • 4 Minutes to read
    • Dark
    • PDF

    Labor Actual vs Scheduled - Punch Details

    • Dark
    • PDF

    Article summary

    The Labor Actual vs Scheduled - Punch Details report runs the numbers for each employee's labor punches in a specified date range. This report helps users understand and analyze labor variances, particularly in regards to the actual punch details rather than the simple breakdown of hourly labor.


    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 Actual vs Scheduled - Punch Details.

    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 End fields create a date range for which to include data in the generated report.

    4

    End

    Last date to include in the report. The Start and End fields create a date range for which to include data in the generated report.

    5

    Hide Job

    If set to Yes, the report does not display jobs.

    6

    Employee

    Employees to include in the report.

    7

    Job Code

    Jobs to include in the report, by job code.

    8

    Report Format

    If set to Collapsed, the report appears as a summary with rows that the user can expand to view more detailed information.
    If set to Expanded, the report displays the expanded rows by default, providing the user with a more detailed version of the report.

    9

    Burden

    If set to Yes, burden is included in calculated labor costs. Burden is a configured percentage used to account for other costs related to the employee, such as insurance and other benefits.

    10

    Daily Salary

    If set to Yes, the report displays the manager salary as configured in the Daily Manager Salary field on the Location record.

    11

    Include Penalties in Costs

    If set to Yes, rule-based earnings are included in calculated labor costs.

    12

    Identify Minors

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

    13

    Other Pay

    If set to Yes, the report includes earnings that are not associated with a shift, and the Other Hrs and Other $ columns appear in the report.

    14

    View options

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

    15

    Run

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


    Report Columns

    The calculations for these report columns include updates made for OT Exempt Employees.

    Column

    Description

    Collapsed

    Location

    Location where the punch data was recorded.

    Date

    Date when the punch data was recorded.

    Actual Hrs

    Total number of actual hours worked at the location.

    Sched Hrs

    Total number of scheduled hours at the location.

    Other Hrs

    Number of other hours-based earnings that are not associated with employee shifts.
    This column appears only if the Other Pay parameter is set to Yes.

    Var Hrs

    Difference between actual hours and scheduled hours for the location.

    Var Hrs (%)

    Percentage of variance between actual hours and scheduled hours for the location.

    Actual OT Hrs

    Total number of actual overtime hours worked at the location.

    Actual $

    Cost of actual labor for the location.

    Sched $

    Cost of scheduled labor for the location.

    Other $

    Amount for other labor costs not associated with employee shifts.
    This column appears only if the Other Pay parameter is set to Yes.

    Var $

    Difference between the actual cost and scheduled cost of labor for the location.

    Var $ (%)

    Percentage of variance between actual cost of labor and scheduled cost of labor for the location.

    Labor %

    Actual cost of labor divided by total sales, shown as a percentage.

    % Goal

    Labor percentage goal for the location.

    Var

    Difference between Labor % and % Goal for the location.

    Sales

    Actual amount of sales for the location, for the given timeframe.

    Fore Sales

    Amount of forecasted sales for the location, for the given timeframe.

    Expanded

    Job

    Job for which the punch data was recorded.
    If Hide Job was set to Yes, this information does not appear in the report.

    Employee

    Employee who worked the hours shown.

    Date

    Date when the punch data was recorded.

    Actual Hrs

    Number of actual hours the employee worked the job on the given date.

    Sched Hrs

    Number of hours the employee was scheduled to work the job on the given date.

    Other Hrs

    Number of other hours-based earnings that are not associated with a shift.
    This column appears only if the Other Pay parameter is set to Yes.

    Var Hrs

    Difference between actual hours and scheduled hours for the employee.

    Var Hrs (%)

    Percentage of variance between actual hours and scheduled hours for the employee.

    Actual OT Hrs

    Number of overtime hours the employee worked the job on the given date.

    Actual $

    Cost of actual labor for the employee.

    Sched $

    Cost of scheduled labor for the employee.

    Other $

    Amount owed to the employee for any reason not covered by regular pay, overtime pay, and penalty pay.
    This column appears only if the Other Pay parameter is set to Yes.

    Var $

    Difference between the actual cost and scheduled cost of labor for the employee.

    Var $ (%)

    Percentage of variance between actual cost of labor and scheduled cost of labor for the employee.

    Labor %

    Actual cost of the employee's labor divided by total sales, shown as a percentage.

    Act Start

    Time when the employee punched in to the job.

    Act End

    Time when the employee punched out of the job.

    Sched Start

    Time when the employee was scheduled to punch in to the job. If this cell is blank, the employee was not scheduled to work.

    Sched End

    Time when the employee was scheduled to punch out of the job. If this cell is blank, the employee was not scheduled to work.


    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?