Weekly Projected Schedule Report

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

The Weekly Projected Schedule Report provides a daily summary of projected and scheduled hours and the variance between projected and scheduled hours for the current forecasting week. It also contains total hours for every job within a department.

Click image to view a report sample.

Key Information

  • The information for this report comes from the labor forecast and the department's weekly employee schedule. Average wage information is taken from job configuration.
  • Displays the following:
    • Daily and weekly projected and scheduled payroll hours by job, or department or division, with the appropriate summaries.
    • Daily and weekly scheduled training hours by job, or department or division, with the appropriate summaries.
    • Daily and weekly variances in scheduled hours versus projected hours by the selected level.
    • Daily and weekly forecast and scheduled payroll hours, and variances by division, department, and/or job.
  • This report provides an analysis of how your actual daily and weekly schedules performed against the projected schedules.

Report Options

OptionDescription

Mode

  • Division/Department—Generate a report that displays divisions and departments.
    • Division—Determine whether one specific division or all divisions and departments are included in the report.
    • Department—Determine whether one specific department or all departments in the selected division are included in the report
    • Summarize By—Choose the level of detail to be displayed.
  • 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.

Payroll Costs

View total payroll for projected and scheduled hours.

Period End Date

Designate the period ending date.

Running the Report

To run the report:

  1. Choose Labor from the Reports menu.
  2. Click Planning and select Weekly Projected Schedule. The Options dialog box appears.
  3. Select either Division/Department or Operating Code.
    • If Division/Department is selected:
      • Choose the appropriate Division and Department.
      • Choose the summarization method you want to use, in the Summarize By field.
    • If Operating Code is chosen, select the appropriate code.
  4. Select or de-select Payroll Costs.
  5. Designate the appropriate Period End Date by entering a date or using the calendar or date forward and date backward arrows.
  6. Click the Run icon. The report is displayed.

Report Terms & Definitions

TermDefinition

Scheduled

Displays the hours scheduled for the position after the manager has closed the schedule for the week.

Projected

Displays the hours projected for the position based on the manager’s edited volume forecast.

Actual

Displays the actual business volume.

Variance         

Represents the variance between projected and actual business volume.  A negative number indicates the projection was less than the actual. A positive number indicates the projection was greater than the actual.

Variance %

Displays the variance as a percentage. The variance is the difference between projected volume and actual business volume.

Scheduled Cost

Represents the dollar amounts of the scheduled wages.

Projected Cost

Represents the dollar amounts of the projected wages.


Related topics: