6 Set Initial COE Parameters

The Set Initial COE Parameters workbook 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.

Click the New icon in the toolbar.
The New Workbook dialog box appears. On the Item Planning tab, select Set Initial COE Parameters and click OK.

Figure 6-1 New Workbook Dialog Box
The workbook wizard opens at the Price Zone step. Select the price zones that you want to plan. Click Next.

Figure 6-2 Workbook Wizard: Price Zone Selection
The Product Selection step of the workbook wizard appears. Select the style/colors you want to plan. Click Finish.

Figure 6-3 Workbook Wizard: Product Selection

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

Set Initial COE Parameters

In the Set Initial COE Parameters worksheet, set the exit week, sell through percentage, and salvage value for each style/color.

Figure 6-4 Set Initial COE Parameters Worksheet

Table 6-1 Set Initial COE Parameters Worksheet 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 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.
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 %.

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