Comparative labor report that allows the user to select up to four LMS or Budget datasets to compare to the LMS actuals dataset. The report contains regular hours, overtime hours, total costs for each level of the labor structure chosen from the Filter tab. The report will also display productivity and/or labor costs percent for each level based on selections from the Display tab. KBI information for each dataset can also be displayed at the top of the report based on selections made on the KBI tab.
Options for the Budget Labor Summary By Day screen
Option | Description | Notes |
---|---|---|
Filter tab | ||
Filter Selection By | Filters the tree menu by either divisions, departments, or jobs. | |
Group Report Output By | Determine how the data is grouped/summarized: division, department, or job. | |
Job / Select | Tree menu and check boxes for all organization layers (divisions, departments, and jobs) at the property. Select check boxes to indicate which jobs will be included in the report. | |
Display tab | ||
Start Date | Start date of the period that the report covers. | |
End Date | End date of the period that the report covers. | |
Base Dataset: | Dataset against which the Comparative Datasets are compared. The base dataset is hard coded to use LMS Actuals. | READ-ONLY. |
Comparative Dataset #1 to #4 | Dataset(s) to which the Base Dataset is compared. You can select up to four datasets. | |
Scheduled and Projected Rates based on | Options for the dataset wage rates that will be used to calculate costs for the scheduled and projected datasets. This selection is relevant only if scheduled or projected datasets are selected as comparative datasets. | Default: LMS Actuals. |
Display Productivity | When selected, the report will include column for each dataset that displays the productivity for each level of the labor structure included in the report. Variance columns will display the difference between actual productivity and that of the comparative datasets. | |
Display Labor Cost Percent | When selected, the report will include column for each dataset that displays the labor cost percent for each level of the labor structure included in the report. Variance columns will display the difference between actual labor cost percent and that of the comparative datasets. | |
KBIs tab | ||
Select / KBIs | Select the KBIs to be included in the report. | |
Select All | Click to select all KBIs check boxes. | |
De-Select All | Click to clear all KBIs check boxes. |
Running the Report
- In the toolbar, click the Report icon ( ).
- From the drop-down list, select Budgeting > Comparative > Budget Labor Summary By Day.
The Budget Labor Summary By Day report screen and dialog box appear. The Filter tab is select by default. - From the Filter Selection By drop-down list, select the whether you want to filter the tree menu by division, department, or job.
- From the Group Report Output By drop-down list, select the whether you want to group information by division, department, or job.
- Select the appropriate organization levels in the tree menu.
- Click the Display tab.
- In the Start Date field, type the start date of the period that the report covers.
- In the End Date field, type the end date of the period that the report covers.
- From the Comparative Datasets #1 to #4 drop-down lists, select the appropriate datasets.
- From the Scheduled and Projected Rates based on drop-down list, select the appropriate value.
- Click the KBIs tab.
- Select any or all of the KBI(s).
- Click OK.
- Indicate where you want the report saved.
- Click Save.
The report appears.