You must make the following settings in your system before you can use the average retail key figure:
Actual data for calculating Average Retail can be updated in a maximum of two database currencies. This is particularly useful if you have two planning scenarios within your company for which you require two database currencies.
Your company may, for example, use two scenarios when planning: one scenario for the US market, one scenario for the European market. The first scenario uses US$ as database currency, and the second uses €, the Euro. In this case, select both database currencies for the planning scenarios as the database currency for updating your planning data. You can use both database currencies when entering data for planning.
If you only require one database currency, one of the database currencies used for updating must be the same as the database currency for the planning scenario.
If you choose to use RIS, make the following settings in Customizing for Merchandise and Assortment Planning under Average Retail Parameters.
If this is the case, the average retail price that has already been calculated is stored in a database table. When you enter planning, the stored average retail price is uploaded, taking the selected data into consideration. Performance is improved when this method is used instead of RIS.
Note that the standard system does not contain a method for calculating and storing average retail prices.
Implementing average retail in manual planning:
In addition to the settings detailed above, the following information should be taken into consideration at implementation during manual planning:
Average retail is integrated using the additional key figure in the planning layout. In your planning layout, enter the following:
Quantity = value / average retail
Value = quantity * average retail
Implementing average retail in automatic planning:
When implementing average retail if you use RIS, it may be useful to use automatic planning.
In addition to implementing average retail in manual planning that enables you to be able to see the results of the calculation, you can also calculate the average retail key figure using automatic planning. This is particularly useful if you are handling large volumes of data as you can run automatic planning in the background.
The following scenario is possible:
The following info structures are delivered as standard and provide the actual data for calculating average retail:
In addition to the settings detailed above, the following information should be taken into consideration at implementation during automatic planning: