Labor Hour Distribution

Technical Name: 0RC_C01_Q0004

Based on the InfoCube: 0RC_C01

Use

This query demonstrates to a user exactly what percentage of labor hours is being targeted to specific areas within the store. The report indicates deviations such as one store placing 5% of their hours in a high margin area while another is placing 25% of their hours in this same area. Often companies use certain percentages as standard rules as to what figures signify a store being run correctly.

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

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)

Percent Contribution

Number of total hours compared with the number of aggregated hours

Total Hours

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

Aggregated Hours

Sum of total hours over the furthest right drilldown. In the standard drilldown this will be total hours added together for all departments.

Scheduled Percent Contribution

Number of scheduled hours compared with the number of aggregated scheduled hours

Scheduled Hours

Number of hours scheduled that are not unpaid breaks. Includes all scheduled hours (regular, overtime, vacation, and so on). Equals the total workload plus the number of overstaffed hours minus the number of understaffed hours.

Aggregated Scheduled Hours

Sum of scheduled hours over the furthest right drilldown. In the standard drilldown this will be scheduled hours added together for all departments.