7 Monitor and Adjust Item Plans

Use the Monitor and Adjust Item Plans task to adjust the item plan after the season has started. This task has four steps:

Review Performance Dashboard Step
Review Assortment Plan Step
Edit Item Plans Step
Review and Approve Item Plans Step

This task and steps are shown in Figure 7-1.

Figure 7-1 Monitor and Adjust Item Plans Task

Building the Monitor and Adjust Item Plans Workbook

To build the Monitor and Adjust Item Plans workbook, perform the following steps:

Click the Create New Workbook icon in the Monitor and Adjust Item Plans task.

Figure 7-2 New Workbook Dialog Box
The workbook wizard opens at the Calendar Selection step. Select the weeks that you want to plan. Click Next.

Figure 7-3 Workbook Wizard: Calendar Selection
The Product Selection step of the workbook wizard appears. Select the styles you want to plan. Click Next.

Figure 7-4 Workbook Wizard: Product Selection
The Location Selection workbook of the workbook wizard appears. Select the channels you want to plan. Click Finish.

Figure 7-5 Workbook Wizard: Location Selection

The Monitor and Adjust Item Plans workbook is built, and the Dashboard View opens.

Review Performance Dashboard Step

Use the views in this step to review the lifecycle of the style/color as it was setup in the Develop and Approve Item Plans task. This step has two views:

Dashboard View
Bounds View

Dashboard View

Use the dashboard view for a quick overview of each style/color's data.

The exception measures in this view highlight data that falls within or outside of the bounds set in the next view.

Figure 7-6 Dashboard View

Table 7-1 lists the measures available on this view.

Table 7-1 Dashboard View Measures

Measure	Description
Sales Retail	The Retail value of Sales.
Sales Exception	The Sales exception that is highlighted per the user-defined upper and lower bound limits.
Markdown	Total Markdowns Retail .
Markdown Exception	The Markdown exception that is highlighted per the user-defined upper and lower bound limits.
Gross Profit	Gross Profit Retail.
Gross Profit Exception	The Gross profit result that is highlighted per the user-defined upper and lower bound limits.
Gross Profit %	Gross Profit Rate.
Gross Profit Exception	The Gross profit % result that is highlighted per the user-defined upper and lower bound limits.
Sell Thru %	The rate at which sales units are moved through beginning of period inventory.
Sell Thru % Exception	The Sell through % exception that is highlighted per the user-defined upper and lower bound limits.
Turn Retail	Cumulative Turnover representing the frequency which Inventory is sold and replaced over a stated time period.
Turn Exception	The turn exception that is highlighted per the user-defined upper and lower bound limits.

Bounds View

This view allows you to set the upper and lower bounds for sales, markdown, gross profit, sell through, and turn.

Figure 7-7 Bounds View

Table 7-2 lists the measures available on this view.

Table 7-2 Bounds View Measures

Measure	Description
Sales Lower Bound	User-defined sales lower limit. If the sales of any style/color is below this threshold, it is highlighted in the Dashboard view as an exception.
Sales Upper Bound	User-defined sales upper limit. If the sales of any style/color is above this threshold, it is highlighted in the Dashboard view as an exception.
Markdown Lower Bound	User-defined markdown lower limit. If the markdown of any style/color is below this threshold, it is highlighted in the Dashboard view as an exception.
Markdown Upper Bound	User-defined markdown upper limit. If the markdown of any style/color is above this threshold, it is highlighted in the Dashboard view as an exception.
Gross Profit Lower Bound	User-defined gross profit lower limit. If the gross profit of any style/color is below this threshold, it is highlighted in the Dashboard view as an exception.
Gross Profit Upper Bound	User-defined gross profit upper limit. If the gross profit of any style/color is above this threshold, it is highlighted in the Dashboard view as an exception.
Gross Profit % Lower Bound	User-defined gross profit percentage lower limit. If the gross profit percentage of any style/color is below this threshold, it is highlighted in the Dashboard view as an exception.
Gross Profit % Upper Bound	User-defined gross profit percentage upper limit. If the gross profit percentage of any style/color is above this threshold, it is highlighted in the Dashboard view as an exception.
Sell Thru % Lower Bound	User-defined sell through percentage percentage lower limit. If the sell through percentage of any style/color is below this threshold, it is highlighted in the Dashboard view as an exception.
Sell Thru % Upper Bound	User-defined sell through percentage upper limit. If the sell through percentage of any style/color is above this threshold, it is highlighted in the Dashboard view as an exception.
Turn Lower Bound	User-defined turn percentage lower limit. If the turn of any style/color is below this threshold, it is highlighted in the Dashboard view as an exception.
Turn Upper Bound	User-defined turn percentage upper limit. If the turn of any style/color is above this threshold, it is highlighted in the Dashboard view as an exception.

After you have reviewed the dashboard, continue to the Review Assortment Plan Step.

Review Assortment Plan Step

The Review Assortment Plan step has two views:

Assortment Plan Parameters View
Assortment Plan Details View

If you do not use Assortment Planning, continue to the Edit Item Plans Step.

Assortment Plan Parameters View

Review the views in the Assortment Plan step if you have loaded data from the Assortment Planning application.

Figure 7-8 Assortment Plan Parameters View

Table 7-3 lists the measures available on this view.

Table 7-3 Assortment Plan Parameters View Measures

Measure	Description
Product Original Ticket Price	Initial retail of product.
Product Cost	The cost of the product.
Start Sales Date	The date the product is expected to start selling.
Number of weeks at Clearance Price	Number of weeks the item is expected to sell at Clearance Price.
Number of Weeks at Regular Price	Number of weeks the item is expected to sell at Regular Price.
Exit Date	The date that the product should be removed from the sales floor.

Assortment Plan Details View

Use the Assortment Plan Details view to see the plan that was created in the Assortment Planning application for the same style-colors you are planning.

Figure 7-9 Assortment Plan Details View

Table 7-4 lists the measures available on this view.

Table 7-4 Assortment Plan Details View Measures

Measure	Description
Ap Cp Store Count	The number of stores for which this style/color is planned for in the approved plan from the Assortment Planning application.
Ap Cp Clearance Sales Units	Assortment Planning Current Plan Clearance Sales units.
Ap Cp Clearance Sales Retail	Assortment Planning Current Plan Clearance Sales retail.
Ap Cp Ttl Sls U	Assortment Planning Current Plan Total Sales Units.
Ap Cp Ttl Sls R	Assortment Planning Current Plan Total Sales Retail.
AP Cp Gross Margin	Assortment Planning Current Plan Gross Margin.
Ap Cp GM R%	Assortment Planning Current Plan Gross Margin rate.
Ap Cp First Markdown % Off	Initial Markdown Taken expressed as a rate.
Ap Cp Promo Price Change %	Assortment Planning Current Plan Promotional Price Change %.
Ap Cp Perm Price Change %	Permanent Price Change expressed as a rate.
Ap Cp Clearance Price Retail	Assortment Planning Current Plan Clearance Price Change %.
Ap Cp Receipts Units	Receipts expressed as Units.
Ap Cp Receipts Retail	Assortment Planning Current Plan Receipts Retail.
AP Cp Average Recpts Per Str	Assortment Planning Current Plan Average Receipts per store.
AP Cp Receipts AUR	Assortment Planning Current Plan Receipts Average Unit Retail.
Ap Cp BOP Inv Units	The Beginning of Period inventory units from Assortment Planning's current plan.
Ap Cp BOP Inv Retail	The Beginning of Period inventory retail from Assortment Planning's current plan.
Ap Cp EOP Inv Retail	The End of Period inventory retail.
Ap Cp EOP Inv Units	The End of Period inventory units.
AP Cp EopPerStr U%	Assortment Planning Current Plan End of Period Per Store Unit %.

After you have reviewed the parameters from the Assortment Planning application, continue to the Edit Item Plans Step to edit your own parameters.

Edit Item Plans Step

This step has one view: Item Plan. Use this view to review and edit the item plan.

Figure 7-10 Item Plan View

After you are satisfied with the sales plan, continue to the Review and Approve Item Plans Step.

Review and Approve Item Plans Step

After you have edited the sales and margin plan and receipts and inventory plan, compare them to the plans created in the Merchandise Financial Planning (MFP) application. Once you have reviewed the plans, approve them in the Plan Approval view.

This step includes views that are similar to the Review and Approve Item Plans Step in the Develop and Approve Item Plans task. For more information, see Review and Approve Item Plans Step.