Manager’s Forecasted Sales

Technical Name: 0RC_C05_Q0004

Based on InfoCube: Sales2 info cube (0RC_C05)

Use

This query is used to verify how StaffWorks and the manager using this software are performing their forecasting activity. To write an optimal schedule, StaffWorks must receive as input an accurate forecast of the business expected in the upcoming period. The software will provide a forecast and the manager can change the forecast figure. This query allows upper management to review how the stores are modifying the forecast and how StaffWorks is forecasting. By reviewing this performance, corporate management will be able to evaluate the manager’s understanding of store business properly and to provide additional training to users making incorrect changes to the system.

Rows

InfoObject

Description of the InfoObject (or restriction or calculation formula)

0RC_RT_FWK

Retail Fiscal Week

0RC_STORE__0RC_GEOLEV3

Region

0RC_BUS_ID

Business Indicator

Columns

InfoObject

Description of the InfoObject (or restriction or calculation formula)

0RC_MNGFCST

Manager’s Forecast

0RC_SYSFCST

System Forecast

0RC_TYSALES

Sales

0RC_PLSALES

Planned Sales

0RC_ADJSALE

Adjusted Sales

0RC_C05_CK312

Manager vs. Projected Sales

0RC_C05_CK314

Manager vs. Planned Sales

0RC_C05_CK008

Manager vs. System Sales

0RC_C05_CK313

System vs. Projected Sales

0RC_C05_CK300

Projected Sales