Manager's Forecasted Labor

Technical Name: 0RC_C01_Q0002

Based on the InfoCube: 0RC_C01

Use

This report is designed to identify how closely the store manager is adjusting the actual labor usage to the schedule. If there are differences, the scheduling model must change or the manager must do a better job of making employees work according to the schedule.

Often the schedule is accurate, but employees punching in before and after their scheduled time cause the labor budget to be exceeded, especially when this additional time pushes the user into an overtime situation. This causes store management to build a buffer and schedule fewer hours than recommended by the forecasting algorithm. As a result, customer service can suffer when fewer hours than needed are scheduled for shop floor work.

Reporting is usually done on a weekly basis. Primary target groups for this report: field management, system administrators.

Filter

InfoObject

Description

No filter criteria have been preset for this query.

Free Characteristics

InfoObject

Description

0FISCPER

Fiscal year/period

0CALDAY

Calendar day

0RC_GEOLEV2

Division

0RC_GEOLEV1

District

0RC_STORE

Store

0RC_STORETY

Store type

0RC_JOB

Job

0FISCPER enables users to navigate within the fiscal time periods covered by the system. As a rule, these periods are weeks or months, with week usually being used as fiscal period. The query always selects data of the current, the previous and the successive period.

Users can filter one or several fiscal periods by clicking 0FISCPER with the right mouse button and choosing Select filter value.

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CALWEEK

Calendar week

0RC_STORE__0RC_GEOLEV3

Region

0RC_JOB__0RC_DEPART

Department

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

Scheduled vs. Workload Hours

Percentage of scheduled hours compared with the number of total workload hours. Scheduled hours in excess of workload indicate staffing beyond budgeting requirements

Projected vs. Scheduled Hours

Percentage of projected hours compared with the number of scheduled hours. Projected hours equal total hours where total hours exist. If no total hours are available, projected hours equal scheduled hours. Projected hours in excess of scheduled hours may indicate poor schedule enforcement when actual sales are in line with expectations.

Projected vs. Workload Hours

Percentage of projected hours compared with the number of total workload hours. Projected hours equal total hours where total hours exist. If no total hours are available, projected hours equal scheduled hours.

Scheduled Hours

Number of hours scheduled that are not unpaid breaks. Includes all scheduled hours (regular, overtime, vacation, and so on).

Total Workload

Sum of filler and flowed workload

Total Hours

Total number of hours actually worked. Includes all types of hours (regular, overtime, event hours).

Projected Hours

Projected hours equal total hours where total hours exist. If no total hours are available, projected hours equal scheduled hours.