Store Schedule Summary

Technical Name: 0RC_CM01_Q0003

Based on the InfoCube: 0RC_MC01

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.

This may be the most powerful report in the system. Many clients have flash sales data and fewer have flash labor. However, virtually no client has future week sales, labor and coverage information.

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

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_DEPART

Department

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

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

Manager vs. Store Planned Sales

Percentage of total store sales forecast by the store manager compared with total store planned sales

Total Store Manager's Sales

Amount of sales forecast by the store manager

Total Store Planned Sales

Amount of planned store sales, forecast by the company

Scheduled Hours vs. Store Workload

Percentage of scheduled hours compared with the workload

Scheduled Hours

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

Total Workload

Total amount of workload

Scheduled Pay

Amount of scheduled wages

Scheduled Average Hourly Rate

Scheduled pay divided by scheduled hours

Edits per 100 Scheduled Hours

Ratio of manually editing the scheduling data generated by the SAP StaffWorks system per one hundred scheduled hours

Rule Violations per 100 Scheduled Hours

Ratio of rule violations committed per one hundred scheduled hours

Schedule Effectiveness

The number of effective hours compared with the scheduled hours (minus the scheduled event hours) plus understaffed hours. This value is used as a general measure of schedule quality. A rating of zero would indicate the worst possible schedule where all shifts were scheduled outside the workload. A rating of 100 would indicate a perfect schedule with all shifts scheduled exactly within the workload.