The Labor Actual vs Scheduled - Beta report compares actual worked hours against the hours that were scheduled for a location as well as specific punch details for the specified date range. This report helps users understand and analyze labor variances to improve scheduling accuracy and better meet the future business needs of each location.
Article Topics
Navigation
- In the Reports section of the left navigation pane, select My Reports.
The My Reports screen appears. - At the top of the My Reports screen, select Labor.
The screen generates a list of reports in alphabetical order. - Locate the Labor Actual vs Scheduled - Beta.
- Select Customize to adjust the report parameters and run the report.
Report Parameters
| Field | Description | |
| 1 | Filter By | Location reporting category by which to filter the report. Options in the Filter By menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories. |
| 2 | Filter | Allows users to apply one or more filter options from the location reporting category that they selected in the Filter By menu. The selected filters determine which locations appear in the generated report. For example, if Filter By is set to Region, the Filter menu might include options such as North, South, East, and West. A user can select West to display all locations belonging to this reporting category. Options that appear in the Filter menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories. |
| 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 | Include Penalties In Costs | If set to Yes, rule-based earnings are included in calculated labor costs. |
| 7 | Identify Minors | If set to Yes, the word 'Minor' appears next to all employees who are under a certain age. |
| 8 | View options | Provides the user with options to select, save, edit, or delete a report view. For more information about these controls, see My Reports: Using My Reports. |
| 9 | Run | Generates the report. The green arrow button opens a drop-down from which users can Export, Email, or Print the report.  |
Report Columns
| Column | Description |
| Collapsed | |
| Location | Location where the data was recorded. |
| Actual Hrs | Total number of actual hours worked at the location. |
| Sched Hrs | Total number of scheduled hours at the location. |
| 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 Hours | 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. |
| 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. |
| 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. |
| 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. |
| Expanded | |
| Job | Job for which the 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 data was recorded. |
| Act Start | Time when the employee punched in to the job. |
| Act End | Time when the employee punched out of the job. |
| Act Hrs | Number of actual hours the employee worked the job on the given date. |
| Sch 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. |
| Sch 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. |
| Sched Hrs | Number of hours the employee was scheduled to work the job on the given date. |
| 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 $ | Cost of actual labor for the employee. |
| Sched $ | Cost of scheduled labor for the employee. |
| 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. |
| OT Hrs | Number of overtime hours the employee worked. |
Note: Labor Hours and Labor $ values will not consider any hours or dollars associated with employees who have the Exclude Labor Hours and Exclude Labor $ checkboxes checked on their employee record.
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.