Key Business Driver

Technical Name: 0RC_C02_Q0002

Based on the InfoCube: 0RC_C02

Use

Clients use sales and non-sales data to forecast their business. The non-sales data is typically known as volume or business drivers. In most cases, users of the SAP StaffWorks system define customer count as the key business driver. This report captures how the business driver is performing against budget and against the previous year.

When scheduling it is very important to use a combination of sales and non-sales drivers. If it is known that a grocery store is selling $300 in a quarter hour, this will give an indication of the staffing level. That same grocery store would schedule the registers very differently if it had one customer buying $300 worth of food or 150 customers buying a single cup of coffee at a price of one dollar.

The key configuration element required in the SAP StaffWorks system set-up is that this volume indicator must also be imported as a business indicator and set up as a non-sales indicator in the store master data.

This report is crucial for business analysts as well as for the SAP StaffWorks implementation managers to make sure the stores are properly modeled for staffing.

Reporting is usually done on a daily basis. Primary target groups for this report: all levels of management; software administration; business analysts.

Despite the key figures listing data as 'sales', the key volume drivers may not necessarily be sales data. The term 'sales' is simply a remainder of the information being imported as a business indicator of the SAP StaffWorks system. For example, although the name of the volume driver may refer to currency, it can still be a non-sales volume driver.

Filter

InfoObject

Description

0RC_BUS_ID__0RC_IDGRP

Business indicator group

Free Characteristics

InfoObject

Description

0FISCPER

Fiscal year/period

0CALDAY

Calendar day

0RC_GEOLEV2

Division

0RC_GEOLEV1

District

0RC_STORE

Store

0RC_STORETY

Store type

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

0RC_BUS_ID

Business Indicator

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

Sales vs. Net Plan

Percentage of actual sales compared with net planned sales

Sales – Net Plan

Difference between actual sales and the net planned sales

Sales

Amount of sales

Net Plan Sales

Amount of net planned sales. Includes only planned sales for which corresponding actual sales figures exist.

Adjusted Sales

Adjusted sales of the previous year: auxiliary variable used only to compute the calculated key figure net last year sales. It equals zero if actual sales figures exist or it equals last year's sales if no actual sales exist for the current year.

Projected Sales vs. Plan

Percentage of projected sales compared with planned sales

Projected Sales – Plan

Difference between projected sales and planned sales. If no actual sales is available, projected sales equals planned sales.

Projected Sales

Equals sales where actual sales figures exist. If no actual sales is available, projected sales equals planned sales.

Planned Sales

Amount of planned sales, forecast by the company