Hours Variance Analysis

Owned by Julie Leake (Unlicensed)
Last updated: Jul 05, 2019 by mhigginbotham (Unlicensed)

The Hours Variance Analysis identifies those departments in which actual hours worked are more or less than the acceptable variance from standard hours. This report allows you to determine which divisions/departments/jobs have unacceptable variances, why, and what will be done to correct it. Information for this report comes from the standard and actual hours for the week.  

Click the image to view a sample report.

Key Information

  • Displays division, department, and labor categories ONLY when there are quality or cost concerns i.e. when worked or paid hours vary too much from standard hours.
    • Quality concern: when actual worked hours for the week are below the established standard variance.  
    • Cost concern: when paid hours for the week are above the established standard variance.  
  • Suggests possible causes of the problem by analyzing the relationship between actual and forecasted volumes, scheduled and paid hours, and paid and worked hours.  
  • Allows you to establish a corrective action format that can be used to ensure proper staff scheduling.

Report Options

OptionDescription

Mode                         

Determine whether the information is filtered by Division/Department or by Operating Code.

  • Division/Department—Display employees by Division(s) and Department(s).
  • Operating Code—Generate a report that displays operating codes. For example, chefs from three different departments can be included in the report as compared to having to look at three different department reports.

Start Date/End Date

Designate the period to be included in the report. Dates can be entered manually or you can use the forward/backward arrows to find the appropriate time start date.

Running the Report

To run the report:

  1. Choose Labor from the Reports menu.
  2. Click Analysis and select Hours Variance Analysis. The Options dialog box appears.
  3. Select either Division/Department or Operating Code.
    • If Division/Department is selected, choose a Division and Department.
    • If Operating Code is selected, choose the appropriate code.
  4. Enter the Start Date/End Date by entering a date, clicking on the calendar icon and selecting a date, or using the date forward and date backward arrows.
  5. Click the Run icon. The report is displayed.

Report Terms & Definitions

For both Cost Concern Areas and Quality Concern Areas:

TermDefinition

Action Taken

Provides a space in which to make notes about the action to be taken to rectify the problem.

Correction Due Date

Provides a space to note the date as to when the problem is to be resolved.

Follow-up Date

Provides a space to note the date on which to follow up on the resolution of the problem.



Related topics: