Actual Labor vs. Schedule

Technical Name: 0RC_C04_Q0001

Based on InfoCube: Labor2 info cube (0RC_C04)

Use

As a rule, retail businesses are evaluated according to their labor performance. This report gives the user an overview of all the time ranges and organizational levels and enables them to monitor data at store level by job and by department. The query compares actual hours and dollars extracted from a time evaluation system against the schedule for a selected store. Thus, a field level manager can see which store has a labor problem as well as which area in the store is causing the problem.

Rows

InfoObject

Description of the InfoObject (or restriction or calculation formula)

0RC_RT_FYR

Retail Fiscal Year

0RC_RT_FWK

Retail Fiscal Week

0RC_STORE__0RC_GEOLEV3

Region

0RC_JOB__0RC_DEPART

Department

Columns

InfoObject

Description of the InfoObject (or restriction or calculation formula)

Hours vs. Net Scheduled

'Total Hours' %A 'Net Scheduled Hours'

Pay vs. Net Scheduled

'Total Pay' %A 'Net Scheduled Pay'

Average Hourly Rate vs. Net Scheduled AHR

'Average Hourly Rate' %A 'Net Scheduled Average Hourly Rate'

0RC_ADJHOUR

Adjusted Hours

0RC_ADJPAY

Adjusted Pay

0RC_SCDPAY

Scheduled Pay

0RC_C04_CK316

Projected vs. Scheduled Hours

0RC_C04_CK319

Projected vs. Scheduled Pay

0RC_C04_CK320

Projected vs. Scheduled Average Hourly Rate

0RC_C04_CK315

Projected Hours

0RC_C04_CK308

Projected Pay

0RC_C04_CK318

Projected Average Hourly Rate

0RC_C04_CK310

Total Hours

0RC_C04_CK307

Total Pay

0RC_C04_CK308

Average Hourly Rate

0RC_C04_CK311

Scheduled Average Hourly Rate

0RC_C04_CK321

Net Scheduled Hours

0RC_C04_CK322

Net Scheduled Pay

0RC_C04_CK323

Net Scheduled Average Hourly Rate