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.
| Option | Description |
| 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. |
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 Hours | Select 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 Variance | Displays all KBI variances in the report. Variances are the percent of increase or decrease of actual worked hours over the standard hours. |
Mode | Allows you to determine whether the information is filtered by Division/Department or by Operating Code.
|
Display Additional KBIs | Allows you to select additional KBIs to be included in the report. |
Running the Report
To run the report:
- Choose Excel Reports from the Reports menu.
- Click All Excel and select Labor Summary. The Options dialog box appears.
- Select a Planning Period End Date.
- Select or de-select Scheduled Hours, Display Standards-Based KBIs, Display Non-Productive Hours and/or Display KBI Variance, as desired.
- 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.
- Select any Additional KBIs that you want to include in the report.
- Click OK. The report opens in Excel.