Sales vs. Plan

Technical Name: 0RC_C02_Q0001

Based on the InfoCube: 0RC_C02

Use

This query is designed to show how the retail store, district, region and company are performing according to the predetermined sales plan by day. The query shows the raw figures, variance and percentage difference between the key figures. It enables the user to analyze key figures at all levels of time reporting as well as at the business indicator level.

Reporting is usually done on a daily basis. Primary target groups for this report: store management; field management; corporate executives.

Filter

InfoObject

Description

0RC_BUS_ID__0RC_EX_TOT

Exclude from total

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 the net plan sales

Sales - Net Plan

Difference between actual sales and the net plan 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 the planned sales. If no actual sales is available, projected sales equals 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