Weekly Actual to Schedule Analysis

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

The Weekly Actual to Schedule Analysis allows you to compare actual hours to schedule hours, hours and payroll variances, and the number of hours and cost of any Overtime for the week, by job.

  Click image to view a sample report.

Key Information

  • Information for this report comes from forecast and scheduled hours for the week.
  • Displays only those divisions, departments, and labor categories whose scheduled hours are above (cost concern) or below (quality concern) the established variance from forecast hours.
  • Determine which divisions/departments/jobs have unacceptable variances, why, and what will be done to correct it.
  • Suggests possible causes of the problem by analyzing the relationship between actual and forecast volumes, scheduled and paid hours, and paid and worked hours.  
  • Establishes a corrective action format that can be used to ensure proper staff scheduling.

Report Options

OptionDescription

Week End Date

Designate the date range of the forecast period to be included in the report.

Group Report Output by

Determine how the report data is displayed.

Page Breaks

Determine how you wish the pages to break.

Shift CategoriesDetermine which Shift Categories, and corresponding hours, you wish to be included in the report.

Filter by   

Select which division(s), department(s) and job(s) you wish to be displayed in the report. The option you choose will determine the level of detail shown. Selecting Division will only display a list of configured divisions; selecting Department will display all divisions and departments, etc.

Running the Report

To run the report:

  1. Choose T&A from the Reports menu.
  2. Click Wage Analysis and select Weekly Actual to Schedule Analysis. The Options dialog box appears.
  3. Select the Week End Date from the drop-down menu.
  4. Select a method to Group by.
  5. Determine if pages should break, and if so, how you want them to break from the drop-down menu.
  6. Select either Division, Department or Job to Filter by.
  7. Select the Job(s) you wish to include in the report.
  8. Click OK. The report is displayed.

Related topics: