Go to primary content
Oracle® Retail Analytic Parameter Calculator for Regular Price Optimization User Guide for the RPAS Fusion Client
Release 16.0
  Go To Table Of Contents
Contents

Previous
Previous
 
 

4 Analysis and Approval Task

After the batch processes are run, self-elasticities are generated. The Analysis and Approval task enables you to review the calculation results, approve, and override the elasticities. When you access the task, a workbook wizard is displayed that enables you to select and review all or group of items at specific price zones (locations).

Accessing the Analysis and Approval Task

To access the Analysis and Approval task, perform the following steps:

  1. Log on to APC-RPO. For more information, see Logging On to APC-RPO.

  2. In the taskflow, click the Create New Workbook icon in the Analysis and Approval task.

    Figure 4-1 Analysis and Approval Task

    Surrounding text describes Figure 4-1 .

    The Workbook Wizard is displayed.


    Note:

    To open an existing workbook, click the Show List of All Workbooks icon next to the task or step you want. The Open Workbook window is displayed and enables you to open an existing workbook.

  3. In the Workbook Wizard, from the Available Items area, select the items you want by holding down the Ctrl or Shift keys, and click Add. You can click Add All to select all the items.

    Or, drag and drop the positions to the Selected Items area.

    Click Next.

    Figure 4-2 Workbook Wizard - Merchandise Selection

    Surrounding text describes Figure 4-2 .
  4. The RHS-Merchandise Selection step is displayed. From the Available Items area, select the items you want by holding down the Ctrl or Shift keys, and click Add. You can click Add All to select all the items.

    Or, drag and drop the positions to the Selected Items area.


    Note:

    The RHS hierarchy is a duplicate of the merchandise hierarchy set up to support cross-item elasticity.

    Click Next.

    Figure 4-3 Workbook Wizard - RHS-Merchandise Selection Step

    Surrounding text describes Figure 4-3 .
  5. The Location Selection step is displayed. From the Available Items area, select the price zones you want, and then click Finish.

    Figure 4-4 Workbook Wizard - Location Selection Step

    Surrounding text describes Figure 4-4 .

    The workbook opens at the Data Preprocessing and Transformation Analysis Step.

Data Preprocessing and Transformation Analysis Step

The Data Preprocessing Analysis step includes one view that displays the results of the historical data preprocessing:

Data Preprocessing Analysis View

This worksheet displays the results of the historical data preprocessing. It includes information at the POS intersection, without the calendar, to highlight the information filtered out at successive steps in preprocessing.

Figure 4-5 Data Preprocessing Analysis View

Surrounding text describes Figure 4-5 .

Table 4-1 describes the measures in this view:

Table 4-1 Measures in the Data Preprocessing Analysis View

Measure Measure Description

Num price data pts.

Number of price data points prior to any filtering.

Num price data pts retained as constant price periods.

Number of price data points retained as constant price periods.

Num price data pts after filtering out price data < 0.

Number of price data points after filtering out price data less than zero (0).

Num price data pts after filtering out gross sales/gross units varies too much from price.

Number of price data points after filtering out the gross revenue/gross units varying too far from price.

Num price data pts after filtering out data that varies too far from min or max price.

Number of price data points after filtering out the data that varies too far from the minimum or maximum price.

Num price data pts after filtering cumulative sales

This is a reporting measure that displays the number of data points available after the cumulative sales filter has been applied.

Num price data pts after filtering average sales

This is a reporting measure that displays the number of data points available after the average sales filter has been applied.

Num price data pts after filtering price deviation

This is a reporting measure that displays the number of data points available after the price deviation filter has been applied.

Num price data pts after preprocessing.

Number of price data points after filtering out stock outs. This is the final step in the preprocessing and represents the final count of price data points.


After you reviewed the preprocessing parameters, continue to the Regularized and Escalation Analysis Step.

Regularized and Escalation Analysis Step

The Regularized and Escalation Analysis step provides information on the regularized and escalated elasticities. The worksheets in this tab display information at the item and price zone intersection. It contains two views:

Final Self Elasticity View

This view displays the self elasticity data of items in each location.

Figure 4-6 Final Self Elasticity View

Surrounding text describes Figure 4-6 .

Table 4-2 describes the measures in this view:

Table 4-2 Measures in the Final Self Elasticity Worksheet

Measure Measure Description

Final Self Elasticity

Final calculated self elasticity at the item/price zone intersection.

Selected Location Profile

Displays the selected location profile level.

Standard Error

Standard error at the final level.

T-Statistic

The t-statistic measure represents the ratio of the elasticity value and its standard error. For instance, if the elasticity value is -.0.04 and the standard error is 0.0023, the t-statistic is
-0.04/0.0023 = -17.4.

T-statistics are at the final level.


After reviewing final self elasticity parameters, continue to the Escalation Level Elasticity View.

Escalation Level Elasticity View

This view provides information on the regularized elasticities at the base escalation level intersection (for example, item and price zone).

Figure 4-7 Escalation Level Elasticity View

Surrounding text describes Figure 4-7 .

Table 4-3 describes the measures in this view:

Table 4-3 Measures in the Escalation Level Elasticity Worksheet

Measure Measure Description

Escalation Elasticity

Elasticity values by escalation level.

Escalation Standard Error

Elasticity standard error values by escalation level.

Escalation Elasticity T-statistic

Elasticity t-statistics values by escalation level.

Escalation Location Profile Value

Location profile values by escalation level.


After reviewing escalation level elasticity parameters, continue to the Cannibalization Analysis Step.

Cannibalization Analysis Step

The Cannibalization Analysis step provides information on the calculated market share and cannibalization effects. It includes two views:

Market Share View

The Market Share view provides information on the calculated market share effects. It displays information at the item and price zone intersection.

Figure 4-8 Market Share View

Surrounding text describes Figure 4-8 .

Table 4-4 describes the measures in this view:

Table 4-4 Measures in the Market Share View

Measure Measure Description

Market Share

Market share relative to the other items within the class.


After reviewing the market share, continue to the Cannibalization Elasticity Analysis View.

Cannibalization Elasticity Analysis View

The Cannibalization Elasticity Analysis view provides information on the calculated cannibalization effects. It displays information at the cross-item elasticity intersection.

Figure 4-9 Cannibalization Elasticity Analysis View

Surrounding text describes Figure 4-9 .

Table 4-5 describes the measures in this view:

Table 4-5 Measures in the Cannibalization Elasticity Analysis View

Measure Measure Description

Cross-Item Elasticity (Cannibalization)

The cross-item elasticity (cannibalization).

Approved Cross-Item Elasticity (Cannibalization)

The approved cross-item elasticity (cannibalization).

Archived Cross-Item Elasticity (Cannibalization)

The last approved cross-item elasticity (cannibalization).


After reviewing and editing the cannibalization elasticity analysis parameters, continue to the HALO Elasticity Analysis Step.

HALO Elasticity Analysis Step

The HALO Elasticity Analysis step provides information on the calculated HALO effects. It includes one view:

HALO Elasticity Analysis View

This view displays information at the halo effect intersection.

Figure 4-10 HALO Elasticity Analysis View

Surrounding text describes Figure 4-10 .

Table 4-6 describes the measures in this view:

Table 4-6 Measures in the HALO Elasticity Analysis View

Measure Measure Description

HALO Type Cross-Item Elasticity

The calculated HALO type cross-item elasticity.

HALO Elasticity Standard Error

The standard error in the calculation of the HALO cross-item elasticity.

HALO Effective Data Point Count

The number of data points used in the calculation.

Approved HALO Type Cross-Item Elasticity

The approved HALO type cross-item elasticity.

Last Approved HALO Type Cross-Item Elasticity

The last approved HALO type cross-item elasticity.


After you have reviewed the HALO elasticity analysis parameters, continue to the Anchor and Min/Max Price Analysis Step.

Anchor and Min/Max Price Analysis Step

The Anchor and Min/Max Price Analysis step includes one view:

Anchor and Min/Max Price Analysis View

The Anchor and Min/Max Price Analysis tab provides information on the historical anchor, and minimum and maximum ticket price.

Figure 4-11 Anchor and Min/Max Price Analysis View

Surrounding text describes Figure 4-11 .

Table 4-7 describes the measures in this view:

Table 4-7 Measures in the Anchor and Min/Max Price Analysis View

Measure Measure Description

Historical anchor price.

The calculated historical anchor price.

Minimum historical ticket price.

The calculated minimum historical ticket price.

Maximum historical ticket price.

The calculated maximum historical ticket price.

Max Price % Down

Displays the maximum percent price drop that happened in the price history.

Max Price % Up

Displays the maximum percent price increase that happened in the price history.