Oracle® Retail Analytic Parameter Calculator for Regular Price Optimization User Guide for the RPAS Fusion Client Release 16.0 |
|
![]() Previous |
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).
To access the Analysis and Approval task, perform the following steps:
Log on to APC-RPO. For more information, see Logging On to APC-RPO.
In the taskflow, click the Create New Workbook icon in the Analysis and Approval task.
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. |
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.
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.
The Location Selection step is displayed. From the Available Items area, select the price zones you want, and then click Finish.
The workbook opens at the Data Preprocessing and Transformation Analysis Step.
The Data Preprocessing Analysis step includes one view that displays the results of the historical data preprocessing:
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.
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.
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:
This view displays the self elasticity data of items in each location.
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 T-statistics are at the final level. |
After reviewing final self elasticity parameters, continue to the Escalation Level Elasticity View.
This view provides information on the regularized elasticities at the base escalation level intersection (for example, item and price zone).
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.
The Cannibalization Analysis step provides information on the calculated market share and cannibalization effects. It includes two views:
The Market Share view provides information on the calculated market share effects. It displays information at the item and price zone intersection.
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.
The Cannibalization Elasticity Analysis view provides information on the calculated cannibalization effects. It displays information at the cross-item elasticity intersection.
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.
The HALO Elasticity Analysis step provides information on the calculated HALO effects. It includes one view:
This view displays information at the halo effect intersection.
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.
The Anchor and Min/Max Price Analysis step includes one view:
The Anchor and Min/Max Price Analysis tab provides information on the historical anchor, and minimum and maximum ticket price.
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. |