Labor Summary Report (Excel)

Owned by Julie Leake (Unlicensed)
Last updated: Jan 30, 2020 by Former user (Deleted)

The Labor Summary Report is very similar to the Weekly Labor Summary Report in that it provides a summary of the key performance information for each position, but instead of displaying weekly data, the data is displayed for the configured Planning Period Type (monthly, semi-monthly, bi-weekly, weekly). The report makes it easy to see how performance balances out over the course of the period.

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

  Click image to view a full sized screen shot.

Key Information

  • Provides a summary section which gives you the totals for the department, division, and property as appropriate.
  • Provides a 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.  
  • Excludes the sub-grouping display of data but does not affect the processing by job, when using the Summarize By option.

Report Options

Click image to view a full sized screen shot.

OptionDescription
Daily Hours / Weekly Hours / Weekly FTEs 

Display units as hours in a daily format, hours in a weekly format, or 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.

Planning Period End Date

Select to display the last day that data should be collected for the report.


Note: The choices in the drop-down menu are based on the Planning Period Type you selected: Monthly, Semi-monthly, Bi-Weekly or Weekly.

Scheduled Hours               

Adds a column to the report that lists scheduled hours.

Display Standards-Based KBI's

Select to include all Standards-Based KBI's in the report. The information displayed is the total workload calculated from the KBI values actualized for a past period, not including adjustments made for minimum shifts, lunch breaks, and other schedule-specific rules.

Display Non-Productive HoursSelect to not include Non-productive hours in the report. Non-productive hours are the total net hours scheduled to an associate, less adjustments made for Breaks and other schedule-specific rules that are NOT attributable directly to the productivity based workload (i.e. based on overhead hours like training). 
Display KBI VarianceDisplays all KBI variances in the report. Variances are the percent of increase or decrease of actual worked hours over the standard hours.

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.
  • Summarize by—Choose how the information will be displayed.

Display Additional KBIs

Select additional KBIs to be included in the report.

Running the Report

To run the report:

  1. Choose Excel Reports from the Reports menu.
  2. Click All Excel  and select Labor Summary. The Options dialog box appears.
  3. Select a Planning Period End Date.
  4. Select or de-select Scheduled Hours, Display Standards-Based KBIs, Display Non-Productive Hours and/or Display KBI Variance, as desired.
  5. Select a Mode.
    • If Division/Department is selected, choose the appropriate Division,  Department and Summarize By options.
    • If Operating Code is selected, choose the approriate operation.
  6. Select any Additional KBIs that you want to include in the report.
  7. Click OK. The report opens in Excel.