Weekly Labor Summary

Owned by Julie Leake (Unlicensed)
Last updated: Jun 30, 2020 by Frank Gambino

The Weekly Labor Summary provides a day-by-day summary of the key performance information for each position. It does not provide the extensive detail of the Daily Operating Report, nor does it give the broad period-to-date and month-to-date values of the Daily Hours Summary. The Weekly Labor Summary is ideal for senior managers who want to assess day-to-day performance without having to look at a report every day. The report also makes it easy to see how performance balances out over the course of the workweek.

This report shows totals by job per week, and indicates what should have been staffed versus was was actually staffed, as well as what was forecast and scheduled. (Forecast hours come from the original forecast hours that LMS generated based on the forecast volumes for the week.) KBIs associated with that job are also displayed to give you a point of reference.

Click image to view a sample report.

Key Information

  • Provides a summary section which gives you the totals for the department, division, and property as appropriate.
  • Provides a weekly KBI table to view the correlation of the volumes to hours for that department.  
  • Displays queries for each Stat type (Forecast, Scheduled, Actual, Standard), for each job.  
  • Adds up the hours (Reg, OT1, OT2, OT3 and Training) by day and by week.  No overtime rate is applied to the hours as this is just a straightforward outputting of the hours data.  
  • Excludes the sub-grouping display of data but does not affect the processing by job class, when using the Summarize By option.

Report Options

OptionDescriptionNotes

Mode                     

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

  • Division/Department—Display employees by Division(s) and Department(s).
    • Summarize By—Choose the level of detail displayed in the report.
  • 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.

Period End Date

Designate the last day that data should be collected for the report.


Scheduled Hours

Adds a column to the report that lists scheduled hours.


Breakdown Hours

Actual Hours are organized by shift categories.

  • Actual Hours - Regular—Hours in all shift categories that are not tagged as Contract or Training.
  • Actual Hours - Contract—Hours in all shift categories that are tagged as Contract.
  • Actual Hours - Training—Hours in all shift categories that are tagged as Training.
  • Actual Hours - Total—All worked hours in all shift categories.

Show Standard SetIf selected, the report displays which standard set was used for each day of the week to project hours and which standard set was used to used to generate standard hours.Only applicable if dynamically applied standard sets are configured.
KBI VarianceDisplay KBI Variance in the report.
Show Standards Based KBIsDisplay Standards Based KBIs in the report.

Daily Hours

Display units as hours in a daily format.


Weekly Hours

Display units as hours in a weekly format.


Weekly FTEs

Display units as full-time equivalents (divide actual hours by 40) in a weekly format. The resultant value tells you how many people worked in this job (or department or division) if each employee worked 40 hours. If the report period is greater than seven days, 

RMS

will divide the number of days by seven to arrive at a standard week for use in calculating FTE's.


Running the Report

To run the report:

  1. Choose Labor from the Reports menu.
  2. Click Analysis  and select Weekly Labor Summary. The Options dialog box appears.
  3. Select a Mode.
    • If Division/Department is selected, choose the appropriate Division,  Department and Summarize By options.
    • If Operating Code is selected, choose the appropriate operation.
  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. Select or de-select Scheduled Hours.
  6. Select either Daily Hours, Weekly Hours or Weekly FTEs.
  7. Click the Run icon. The report is displayed.

Report Terms & Definitions

TermDefinitionNotes

Department/Division Totals

Summarizes data for the whole division/department.


KBIsActual and forecast KBI for each department.Appears only if Show Standards Based KBIs is selected in the configuration screen.
Standard sets

Standard set used for each day of the week:

  • Projected Std Set—Standard set used to project hours.
  • Standard Std Set—Standard set used to generate standard hours.
Only applicable if dynamically applied standard sets are configured.

Projected

Hours that should be scheduled based on the forecast business volume.


Scheduled

Hours from your schedule.


Actual

Hours that come from your property's Time and Attendance system or employee time records.


Standard

Hours that should have been used based on the actual volumes.


Variance %

Difference between standard hours and actual hours.



Related topics: