Store Schedule Summary

Technical Name: 0RC_MC02_Q0003

Based on InfoCube: Operational2 info cube (0RC_MC02).

Use

This report is also designed for ‘one-stop shopping’ and provides all major key figures at one glance. However, it adds the schedule information to the query. This allows upper management to see how next week will end, before it begins. They now have a chance to be proactive in solving problems, not just reactive. By running this one report, field management can essentially run the entire chain with significant impact on sales, labor, customer service, employee morale, store appearance, labor contract violations, product usage of the SAP StaffWorks system, profitability and loss prevention.

Rows

InfoObject

Description of the InfoObject (or restriction or calculation formula)

0RC_RT_FWK

Retail Fiscal Week

0RC_STORE__0RC_GEOLEV3

Region

Columns

InfoObject

Description of the InfoObject (or restriction or calculation formula)

0RC_MC02_RK001

Total Store Manager’s Sales

0RC_MC02_RK002

Total Store Planned Sales

0RC_SCDHRS

Scheduled Hours

0RC_TOT_WL

Total Workload

0RC_SCDPAY

Scheduled Pay

0RC_MC02_CK010

Scheduled Average Hourly Rate

0RC_MANEDIT

Manual Edits

0RC_RULVIOL

Rule Violations

Manager vs. Store Planned Sales

'Total Store Manager's Sales' %A 'Total Store Planned Sales'

Scheduled Hours vs. Store Workload

'Scheduled Hours' %A 'Total Workload'

Edits Per 100 Scheduled Hours

'Scheduled Hours' %A 'Total Workload'

Rule Violations per 100 Scheduled Hours

'Rule Violations' * 100 / NODIM ( 'Scheduled Hours' )