Labor Data

Technical Name: 0RC_C01

Use

Labor is the single largest controllable expense in the retail environment. It is crucial for management to understand how it is being spent across the chain and to use this knowledge to deploy it strategically and advance the goals of the company. The labor InfoCube allows management to monitor store performance and to analyze actual versus scheduled data. By fully understanding this distribution of labor, users can meet customer service and non-sales requirements while still controlling labor costs and ensuring profitability.

This InfoCube contains the following labor-related information:

  • Actual and scheduled working hours (for example, regular working hours, overtime hours)
  • Actual and scheduled payment (for example, regular pay, overtime pay)
  • Workload: expected manpower demand. It is forecast by SAP StaffWorks but can also be adjusted manually by the store manager. It is represented as working time hours at job level.
  • Coverage statistics: reflects the staffing level (understaffing or overstaffing)

The information is presented at the following levels:

  • Store
  • Job: each employee can be assigned a number of different jobs, with one of them defined as his primary job. All data stored within SAP StaffWorks is aggregated in BW at job level.

This InfoCube contains information available in the current extraction file, that is, data delivered from SAP StaffWorks.

SAP StaffWorks uses the following terms when referring to labor and sales key figures:

Term

Description

scheduled hours

Labor representing shifts scheduled by SAP StaffWorks and/or edited by the manager

workload hours

Labor representing the manpower demand for the work to be done. Scheduled hours are the 'supply' ideally placed to cover the workload 'demand'.

actual hours

Labor representing shifts actually worked. In an ideal scenario, the actual hours should be placed exactly where the workload demand is placed and the schedule was created to cover that demand.

planned sales

Budgeted sales figures supplied by the corporate headquarters

system sales

Sales forecast computed by algorithms from SAP StaffWorks

manager sales

Adjustments made by the user to the SAP StaffWorks‘ forecast

actual sales

Sales actually reported on that day. Ideally, it should match the plan, system and manager forecast

In SAP BW, if stores upload data twice for a specific day, the new data is not added to the existing values but the old data is completely replaced by the newest data. For example, if store_1 uploaded $100 for July 10 and business indicator_2 (dairy products), and if the same store then uploads $125 for the same date and business indicator, the update rules for the SAP StaffWorks integration InfoCubes replace the value $100 by $125. BW standard update rules would add both figures together to a total $225.

Comments on queries from InfoCube 0RC_C01:

Some key figures are marked as hidden because they are part of the query definition but are not displayed when you execute the query.

When comparing actual with planned values it can happen that planned values but no corresponding actual figures are available. This may cause problems for interpreting aggregated key figures that compare actual with scheduled data. To solve this problem, the following calculated key figures were introduced:

  • Net Scheduled Hours: only scheduled hours for which corresponding actual hours are available. If no actual hours are available, net scheduled hours equals zero. Net scheduled key figures describe the scheduled value of only those stores that reported information for the particular time period. This will allow users to see only scheduled vs. actual figures for stores that have both scheduled and actual figures. For example, if nine stores reported 100 actual hours for the day and one store was missing, there would be 900 actual hours. If all ten stores in the district had scheduled to work 100 hours, then the actual vs. scheduled figures would be 900 divided by 1000 or 90 % of schedule. This indicates results that are below expectation. However, if you compare the actual vs. the net plan (plan for reporting stores) figures, this would be 900/(1000-100) or 900/900 = 100 % of plan. This indicates good performance. Whenever some stores do not report actual values, the comparison of actual vs. planned figures will be misleading unless they have been 'cleaned' using net plan or projected values.
  • Projected Hours: it equals actual hours where actual hours exist. If no actual hours is available, projected hours equals scheduled hours. Projected key figures are a projection of certain values under the assumption that all stores reported that information for the particular time period. This will allow users to have a best estimate for when a single store or group of stores does not report for a specific time period. Usually, the scheduled data is used as a substitute for actual data to allow this projection. For example, if nine stores reported 100 hours each for the day and one store did not report, the 75 scheduled hours may be substituted for the missing figure to give us a total of 975 projected hours for the day.

The same logic as described for net scheduled hours is implemented for Net Last Year Hours. This includes only those previous year's hours for which corresponding actual hours exist for the current year.

InfoSources

0RC_CI_1 Labor

Characteristics

InfoObject

Description

0RC_STORE

Store

0RC_JOB

Job

0RC_DAYWK

Day of week (Monday, Tuesday...)

Time Characteristics

InfoObject

Description

0CALDAY

Calendar day

0CALWEEK

Calendar year and week

0FISCPER

Fiscal year and period

0FISCVARNT

Fiscal year variant

Key Figures

InfoObject

Description

0RC_TOT_WL

Total workload: the total number of forecast hours. This is the sum of flowed and filler workload.

0RC_FLOW_WL

Flowed workload: workload driven by revenue, customer count or any other variable flowed task defined in SAP StaffWorks. Includes the static workload.

0RC_FILL_WL

Filler workload: the fixed and variable filler hours allocated to the workload. In contrast to static workload that has to be scheduled for certain times (for example, 9 a.m. to 10 a.m.), filler workload refers to non-selling tasks that can be scheduled variably within certain time segments (for example, in the morning). As a rule, filler workload fills the gaps between workload peaks.

0RC_STAT_WL

Static workload: work manually defined by the user. It is constant and independent of revenue, customer count or any business indicator or task defined in SAP StaffWorks (for example, the person who unlocks the store).

0RC_OVRSTFF

Overstaffing: the number of hours in which the total workload is smaller than the number of people scheduled and not on an unpaid break

0RC_UNDSTFF

Understaffing: the number of hours in which the total workload is greater than the number of people scheduled and not on an unpaid break

0RC_EFFHRS

Effective hours: the scheduled hours minus overstaffed hours minus breaks. The values will be zero for events (for example, training or meetings) because these are not scheduled. From the perspective of SAP StaffWorks, effective hours are scheduled hours that match the workload hours. They are a general measure of schedule quality.

0RC_NEFFHRS

Non-effective hours: the sum of overstaffing and understaffing for the day. The values will be zero for events (for example, training or meetings), fixed shift and temporary fixed shift job types, because these are not scheduled. Non-effective hours could, for example, be spent working on the shop floor and be paid while SAP StaffWorks calculated no corresponding demand.

0RC_COREAFT

Core afternoon hours: the number of hours of core coverage as part of the workload for the afternoon segment. Core coverage means that employees with a particular job-specific minimum skill level must be scheduled.

0RC_COREEVN

Core evening hours: the number of hours of core coverage as part of the workload for the evening segment. Core coverage means that employees with a particular job-specific minimum skill level must be scheduled.

0RC_COREMRN

Core morning hours: the number of hours of core coverage as part of the workload for the morning segment. Core coverage means that employees with a particular job-specific minimum skill level must be scheduled.

0RC_PAIDBR

Paid breaks: the number of hours of scheduled paid breaks

0RC_NPAIDBR

Unpaid breaks: the number of hours of scheduled unpaid breaks

0RC_MANEDIT

Manual edits: manual changes to the system-generated staffing schedule. The number of scheduled days (shifts) that have been manually edited for every employee. Edits are attributed to each employee's primary job.

0RC_RULVIOL

Number of employees with violations of scheduling work rules assigned to the primary job

0RC_SCDHRS

Scheduled hours: total number of scheduled hours that are not unpaid breaks. This includes all hours scheduled (regular, overtime, vacation, and so on).

0RC_SCDEHRS

Scheduled event hours: this key figure is the sum of all hours that employees with the selected job as their primary job spend in events (for example, training or meetings).

0RC_SCDOHRS

Scheduled overtime hours: the number of hours that will be paid at a higher rate (at a multiple higher than one), regardless of the reason.

0RC_SCDPAY

Scheduled pay: The total payroll for the scheduled hours. This includes regular, overtime, vacation, and so on.

0RC_SCDEPAY

Scheduled event pay: the total payroll for the scheduled event hours, calculated from scheduled event hours.

0RC_ACTRHRS

Actual regular hours: actual (punched) paid non-overtime hours.

0RC_ACTOHRS

Actual overtime hours: actual paid overtime hours.

0RC_ACTEHRS

Actual event hours: actual hours spent in an event. These hours are assigned to the employee's primary job.

0RC_ACTPHRS

Actual productive hours: within the SAP StaffWorks, hours can be labeled as productive (for example, regular hours) or non-productive (for example, hours spent on vacation). Typically, productive hours are spent in direct support of the store’s operations

0RC_ACTNHRS

Actual non-productive hours: within SAP StaffWorks, these are hours that can be labeled as productive (for example, regular hours) or non-productive (for example, hours spent on vacation). Typically, non-productive hours are not spent in direct support of the store’s operations.

0RC_ACTRPAY

Actual regular pay: total payroll for the actual regular hours, as calculated by SAP StaffWorks.

0RC_ACTOPAY

Actual overtime pay: total payroll for the actual overtime hours, as calculated by the SAP CAMPBELL system.

0RC_ACTEPAY

Actual event pay: the pay for the actual event hours.

0RC_RPFLG

Reporting flag: auxiliary variable indicating whether actual figures are available for the selected day and store.

0RC_LYRPFLG

Last year reporting flag: auxiliary variable indicating whether actual figures are available for the selected day and store in the previous year.

0RC_ADJHOUR

Adjusted hours: auxiliary variable used only to compute the calculated key figures net scheduled hours and projected hours. It equals zero if actual hours exists or it equals scheduled hours if no actual hours exists.

0RC_ADJPAY

Adjusted pay: this is an auxiliary variable used only to compute the calculated key figures net scheduled pay and projected pay. It equals zero if actual pay figures exists or it equals scheduled pay if no actual pay exists.

Restricted Key Figures

InfoObject

Description

Formula / Restriction

No restricted key figures have been preset for this InfoCube

Calculated Key Figures

InfoObject

Description

Formula or Restriction

0RC_C01_CK021

Actual Overtime vs. Total Hours

Percentage of Overtime Hours in (Regular Hours + Overtime Hours + Event Hours)

0RC_C01_CK015

Actual vs. Scheduled Overtime Hours

Percentage of Overtime Hours in Scheduled Overtime Hours

0RC_C01_CK008

Average Hourly Rate

Total Pay / Total Hours

0RC_C01_CK302

Edits per 100 Scheduled Hours

Manual Edits * 100 / NODIM (Scheduled Hours – Scheduled Event Hours)

0RC_C01_CK323

Net Scheduled Average Hourly Rate

Net Scheduled Pay / Net Scheduled Hours

0RC_C01_CK321

Net Scheduled Hours

Scheduled Hours – Adjusted Hours

0RC_C01_CK022

Net Scheduled Pay

Scheduled Pay – Adjusted Pay

0RC_C01_CK016

Overstaffing Percentage

Percentage of Overstaffing in (Scheduled Hours – Scheduled Event Hours)

0RC_C01_CK316

Projected vs. Scheduled Hours

Percentage of Projected Hours in Scheduled Hours

0RC_C01_CK319

Projected vs. Scheduled Pay

Percentage of Projected Hours in Scheduled Hours

0RC_C01_CK318

Projected Average Hourly Rate

Projected Pay / Projected Hours

0RC_C01_CK315

Projected Hours

Total Hours + Adjusted Hours

0RC_C01_CK308

Projected Pay

Adjusted Pay + Total Pay

0RC_C01_CK320

Projected vs. Scheduled Average Hourly Rate

Percentage of Projected Average Hourly Rate in Scheduled Average Hourly Rate

0RC_C01_CK317

Projected vs. Workload Hours

Percentage of Projected Hours in Total Workload

0RC_C01_CK301

Rule Violations per 100 Scheduled Hours

Weekly Rule Violations * 100 / NODIM (Scheduled Hours – Scheduled Event Hours)

0RC_C01_CK018

Schedule Effectiveness

Percentage of (Scheduled Hours – Overstaffing – Understaffing) in Scheduled Hours

0RC_C01_CK011

Scheduled Average Hourly Rate

Scheduled Pay / Scheduled Hours

0RC_C01_CK005

Scheduled vs. Workload Hours

Percentage of Scheduled Hours in Total Workload

0RC_C01_CK019

Selling Hours

Flowed Workload – Static Workload

0RC_C01_CK310

Total Hours

Regular Hours + Overtime Hours + Event Hours

0RC_C01_CK007

Total Pay

Regular Pay + Overtime Pay + Event Pay

0RC_C01_CK017

Understaffing Percentage

Percentage of Understaffing in (Scheduled Hours – Scheduled Event Hours)

Units

InfoObject

Description

0UNIT

Unit of measurement

0CURRENCY

Currency key