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.
Key Information
Report options for the Budget Labor Summary By Day screen
| Option | Description | Notes |
|---|---|---|
| Filter | ||
| Filter Selection By | Allows you to select which divisions, departments and jobs you wish to be displayed on the report. | |
| Group Report Output By | (Is this supposed to be the same as Summarize by?) Allows you to determine how the data is grouped/summarized: division, department or job. | |
| Job Select | Allows you to denote which jobs are to be included in the report. | |
| Display | ||
| Start Date | Start date of the period that the report covers. | |
| End Date | End date of the period that the report covers. | |
| Base Dataset: | Denotes the dataset against which the Comparative Datasets are compared. Base dataset is hard coded to use LMS Actuals. | READ-ONLY |
| Comparative Dataset #1 | Denotes the dataset(s) to which the Base Dataset is compared. | |
| Comparative Dataset #2 | Denotes the dataset(s) to which the Base Dataset is compared. | |
| Comparative Dataset #3 | Denotes the dataset(s) to which the Base Dataset is compared. | |
| Comparative Dataset #4 | Denotes the dataset(s) to which the Base Dataset is compared. | |
| Scheduled and Projected Rates based on | ??? Provides a choice for the dataset wage rates that will be used to calculate costs for the scheduled and projected datasets. Only relevant 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 | ||
| 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
To run 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.