6 Set Initial COE Parameters

The Set Initial COE Parameters task is used to set the Exit Week, Salvage Value % Off, and EOL Sell Thru % measures that are exported to COE in batch processing. These parameters are used by COE in the weekly model run to provide an optimized markdown forecast.

Building the Set Initial COE Parameters Workbook

To build the workbook, perform the following steps:

1. Click the Create New Workbook icon in the Set Initial COE Parameters task.

   Figure 6-1 Create New Workbook Icon

   
   

2. The workbook wizard opens at the Select Price Zone step. Select the price zones that you want to plan and move them to the Selected Items box. Click Next.

   Figure 6-2 Workbook Wizard: Price Zone Selection

   
   

3. The Select Style/Color step of the workbook wizard appears. Select the style-colors you want to plan and move them to the Selected Items box. Click Finish.

   Figure 6-3 Workbook Wizard: Product Selection

   
   

The workbook is built, and the Set Initial COE Parameters View opens.

Maintain Parameters for Clearance Optimization Step

This step has one view: Set Initial COE Parameters. At this step, set the exit week, sell through percentage, and salvage value for each style/color.

Figure 6-4 Set Initial COE Parameters View

Table 6-1 Set Initial COE Parameters View Measures

Measure	Description
COE Initial EOL Exit Week	The Exit Date COE uses to calculate the Recommended Clearance Markdown. This measure is a single hierarchy selection that allows the user to select the week ending date of the exit week.
COE Initial EOL Sell Thru %	The Recommended Sell Thru % used by COE to determine the optimal Recommended Clearance Markdown Price Plan that achieves the desired Sell Thru %.
COE Initial EOL Salvage Value % Off	The percent off the Current Ticketed Retail Price that is used to determine the Salvage Value Price for any remaining inventory at the Exit Date.

After you have entered the values, commit the parameters to the Oracle Retail Predictive Application Server (RPAS) database. Then, the batch process exports these files and transfers them to COE for loading within the COE Business Rules Manager.

Commit Parameters

In the Set Initial COE Parameters view, click Commit in the toolbar. Or, from the File menu, select the Commit option.

Once the commit has occurred, the commit status changes to Committed.