7 Item Planning

During the preseason planning period, the Item Planning workbook allows you to create item plans at the style/color level.

During the in-season planning period, you can use this workbook to reseed the item plan with the accepted price plan you create in the Markdown Planning workbook.

This workbook has six tabs:

Dashboard Tab
Assortment Plan Tab
Item Planning Parameters Tab
Pricing Tab
Item Plan Tab
Review and Approval Tab

Note:

The Dashboard tab is only used for in-season planning.

Below is the general process of creating an item plan:

Optional: Consult the assortment plan created in the Assortment Planning application in the Assortment Plan Tab.
Create a sales and markdown plan in the Item Planning Parameters Tab.
Assign promotions to style/colors and review their promotional impact in the Pricing Tab.
Seed the plan in the Item Planning Parameters Tab.
Review the sales and markdowns plan in the Item Plan Tab.
Create a receipts and inventory plan and calculate the receipt flow in the Item Plan Parameters Tab: Receipt and Inventory Plan.
Review the receipts and inventory plan in the Item Plan Tab: Receipt and Inventory Plan.
Review the entire plan for all key items in the class. Compare it to the MFP targets, and then approve the plan in the Review and Approval Tab.

This process is described in detail throughout this chapter.

Building the Item Planning Workbook

To build the Item Planning workbook, perform the following steps.

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

Figure 7-1 New Workbook Dialog Box

The workbook wizard opens at the Calendar Selection step. Select the weeks that you want to plan. Click Next.

Note:

When choosing the weeks to include in the workbook, ensure that you accommodate for the receipt arrival week, not just the start sell week. For instance, if the start sell week is 1/15/2011, and the receipt time is two weeks, the workbook should start from 1/1/2011.

Figure 7-2 Workbook Wizard: Calendar Selection

The Product Selection step of the workbook wizard appears. Select the styles you want to plan. Click Next.

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

Figure 7-4 Workbook Wizard: Location Selection

The Item Planning workbook is built. Begin at the Assortment Plan Tab.

Assortment Plan Tab

Review the worksheets in the Assortment Plan tab if you have loaded data from the Assortment Planning application. If you do not use Assortment Planning, continue to the Item Planning Parameters Tab.

Assortment Plan Parameters Worksheet

Use the Review Assortment Plan Parameters worksheet to reference the parameters that the Assortment Planning user set for the same style/color you are planning. When seeding your working plan in the Item Plan Parameters Worksheet, you can choose to seed with this Assortment Plan data.

Figure 7-5 Assortment Plan Parameters Worksheet

Table 7-1 Assortment Plan Parameters Worksheet Measures

Measure	Description
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.
Product Cost	The cost of the product.
Product Original Ticket Price	Initial retail of product.
Exit Date	The date that the product should be removed from the sales floor.
Ap Cp Clearance Price Retail	The clearance price set up in Assortment Planning.
Ap Cp Clearance Cost	The clearance cost set up in Assortment Planning.

Assortment Plan Details Worksheet

Use the Review Assortment Plan Details worksheet to see the plan that was created in the Assortment Planning application for the same style/color you are planning.

Figure 7-6 Assortment Plan Details Worksheet

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

Table 7-2 Assortment Plan Details Worksheet 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 Item Plan Parameters Worksheet to set your own parameters.

Item Planning Parameters Tab

Use the worksheets in the Item Planning Parameters tab to create a weekly plan for the style/colors. This tab has three worksheets:

Reference Curves Worksheet
Item Plan Parameters Worksheet
Seed Worksheet

Reference Curves Worksheet

Use this worksheet to review the reference curves you created in the Reference Curves workbook. This worksheet is for reference only. It is provided to help you assign these curves to the style/colors being planned. To edit the curves, return to the Maintain Curve Profiles Worksheet.

Note:

To view the data in the Sales Curve Label and Sales Curve (Default) % measures, ensure that the calendar hierarchy includes the all[Calendar] dimension and that the location hierarchy displays only the all[Location] dimension.

Figure 7-7 Reference Curves Worksheet

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

Table 7-3 Reference Curves Worksheet Measures

Measure	Description
Sales Curve Label	Displays the label for the lifecycle curve. This label is created in the Reference Curves workbook.
Sales Curve (Default)%	Displays percent-to-total sales percentage in the weeks of the curve. This is set in the Reference Curves workbook.
Item Lifecycle Curve	Displays the sales curve for the item.

Next, continue to the Item Plan Parameters Worksheet.

Item Plan Parameters Worksheet

Use this worksheet to set the parameters of the item plan. This creates the weekly sales unit plan.

Figure 7-8 Item Plan Parameters - Sales Parameters Measure Profile

To set the item plan parameters, perform the following steps for each channel:

Ensure that the following measures are shown in the worksheet:
- Wp BOS C
- Wp BOS R
- Wp BOS U
- Wp Sales Net VAT R
Set the Wp BOS C, Wp BOS R, and WP BOS U measures with the beginning of season inventory cost, retail, and units data. (Perform this step only if the style/color is a carryover item or one that is planned to be received before the start of the planning period).
In the # Stores measure, enter the number of stores.
Define the start sell and out of stock weeks in the Start Sell Week and Out of Stock Week measures.
In the Clearance Cadence measure, select the cadence to be applied to the style/color. These cadences are created in the Markdown Parameters workbook.
In the Rate of Sale measure, enter the average units of the style/color that are sold per store, per week. (This is used for baseline sales calculation. It is useful when seeding dales to weeks).
Click Calculate. The Baseline Sales U measure is calculated. This measure displays the baseline sales units for the regular and promotional period.
In the Baseline Sales Curve Selection measure, select the reference curve to apply to the style/color. These reference curves are created in the Reference Curves workbook.
In the Shrink Target %, enter the planned shrink for the style/color. Each week is a planned shrink that is based on a certain percentage of sales for the week.
In the Regular Price, Regular Cost, and Clearance Cost measures, enter the price, cost, and clearance cost of the style/color.
Click Calculate.
In the Salvage Value measure, enter the amount that the style/color is worth in the last week of the salvage period. The salvage period is when the style/color has reached the end of its life. Therefore, the salvage value is the price you can recover by selling this item to a clearance channel.
If you are computing value added tax, edit the Wp Sales Net VAT R measure if needed.

After you have set the parameters, continue to the Seed Worksheet to seed these parameters into the item plan for the style/color.

Note:

If the style/color belongs to a promotion, you should map the promotions to the style/color in the Pricing Tab before seeding.

Seed Worksheet

Use this worksheet to seed the item plan with data. This creates a demand curve on which to spread the initial targets of the item plan. You can seed with any of the following options:

LY: Last year's data.
Adj LY: Adjusted last year's data.
AP: Data from the Assortment Planning (AP) application. If you use AP and you have loaded the AP data into Item Planning, you can review this data in the Assortment Plan Tab.
Parameters: The parameters that you have created in the Item Plan Parameters Worksheet.
Accepted Price Plan: The price plan you create during in-season planning. This price plan is selected in the Review and Approval Tab of the Markdown Planning workbook.

Or, you can instead choose to not seed the plan, which allows you to create a plan manually by keying in sales at a weekly level.

Figure 7-9 Seed Worksheet

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

Table 7-4 Seed Worksheet Measures

Measure	Description
Ly Sls Reg U	The regular units from last year's sales.
Adj Ly Sls Reg U	The adjusted regular units from last year's sales.
Like Item	The style/color that you mapped the current style/color to in the Item and Store Maintenance workbook.
Use History Map	Select this option to use the history of the style that you mapped the current style to in the Item and Store Maintenance workbook.
Mapped Ly Sls Reg U	The regular units from last year's sales of the like item.
Mapped Adj Ly Sls Reg U	The adjusted regular units from last year's sales of the like item.
Wp BOS U	The planned Beginning of Season total units.
Wp Seed	The source used to seed the working plan. Use the dropdown to select the source to use for seeding.

Seeding the Plan

To seed the plan, perform the following steps:

Roll the calendar hierarchy up to year.
Select the style/color you want to seed in the product hierarchy.
In the Wp Seed measure, choose the seed option.
Select Use Hist Map if you want to use the data of the like item shown in the Like Item measure.
When you have selected all the data you want to seed, click Seed in the Planning Actions menu.

Figure 7-10 Seed Option in the Planning Actions Menu
A confirmation message appears, stating that the data has been successfully seeded. Click OK.

Figure 7-11 Seeding Success Message

After you have seeded, continue to the Plan Approval Worksheet to approve the plan.

Pricing Tab

The Pricing tab contains four worksheets that help you map style/colors to promotions:

Promotions Definition Worksheet
Promotions Weeks Worksheet
Promo Mapping Worksheet
Markdown Cadence Worksheet

Use the Promo Mapping Worksheet to map the style/colors and promotions. Use the other worksheets as references about the promotions and markdown cadences.

Promotions Definition Worksheet

Use this workbook to review the lift and the lift override for the promotions. This worksheet is read-only.

Figure 7-12 Promotions Definition Worksheet

Table 7-5 lists the measures available on this worksheet.

Table 7-5 Promotions Definition Worksheet Measures

Measure	Description
Sls Promo Lift U%	The promotional lift. This is the percent of increased sales that must occur to overcome the decrease in price to sell the same dollar amount.
Sls Promo Lift U% Override	The lift entered in this measure overrides the lift calculated in the Sls Promo Lift U% measure.

Promotions Weeks Worksheet

Use this worksheet to review the promotion periods. This worksheet is read-only.

Figure 7-13 Promotions Weeks Worksheet

Promo Mapping Worksheet

Use this worksheet to map the style/color to the promotions it belongs to. Style/colors can belong to more than one promotion, even if the promotions overlap.

Figure 7-14 Promo Mapping Worksheet

To map a style/color to a promotion, click the check box. You may select more than one promotion for a style/color.

Markdown Cadence Worksheet

Use this worksheet to review the markdown cadences you created in the Markdown Parameters workbook. This worksheet is read-only.

Note:

To see the Basis (Year/Item) measure data, ensure that all[Calendar] is displayed in the calendar hierarchy.

Figure 7-15 Markdown Cadence Worksheet

Table 7-6 lists the measures available on this worksheet.

Table 7-6 Markdown Cadence Worksheet Measures

Measure	Description
MD Clr U%	The markdown clearance percentage starting from the week of the year or the style/color's lifecycle.
Basis (Year/Item)	The basis that the cadence is based on. Options are year and item.

Item Plan Tab

The worksheets in this tab display the weekly plan for the sales and markdowns that was created by the parameters you have set so far. Use these worksheets to review the plan.

Item Plan Worksheet
Promo Details Worksheet

Item Plan Worksheet

Use this worksheet to review the weekly plan for the sales and markdowns that has been created by all of the parameters and promotions you have created so far. If you need to adjust the plan, return to the Item Plan Parameters Worksheet to adjust the parameters, seed from parameters in the Seed Worksheet worksheet, and then return to this worksheet to review the results. Continue this process until you are satisfied with the sales and markdown plan.

Figure 7-16 Item Plan Worksheet

Promo Details Worksheet

This worksheet displays the baseline sales and promotional lift units for the style/color. The baseline sales units measure, Wp Baseline Sales U, displays the number of units that would be sold if no promotions existed. The promotional lift units measure, Wp Promo Lift U, displays the number of additional units that would be sold with the promotion. The Wp Sls Promo U measure is the total units that would be sold. It combines the baseline sales units and the promotional lift units.

Figure 7-17 Promo Details Worksheet

Table 7-7 Promo Details Worksheet Measures

Measure	Description
Wp Sls Promo Eligibility	By selecting this boolean, the promotion is being associated to the style/color. You must seed from parameters to apply the promotional details to their style/color plan after selecting this boolean.
Wp Promo Lift U	Displays the number of additional units sold with the promotion.
Wp Baseline Sales U	Displays the number of units sold if no promotions existed.
Wp Sls Promo U	Displays the total units sold. This measure combines the baseline sales units and the promotional lift units.

Once you are satisfied with the sales plan, return to the Item Plan Parameters Worksheet to create the receipt and inventory plan.

Item Plan Parameters Tab: Receipt and Inventory Plan

After you have developed the sales and inventory plan, use the Item Plan Parameters worksheet to create the receipt and inventory plan.

Item Plan Parameters Worksheet: Receipt Parameters Measure Profile

Use the receipt parameters measure profile in this worksheet to develop the receipt and inventory plan.

Figure 7-18 Item Plan Parameters Worksheet: Receipt Parameters Measure Profile

To create a receipt and inventory plan, perform the following steps:

Change the measure profile to Receipt Parameters.
In the Receipt Lead Time measure, enter the number of weeks before the start sell week that you want to schedule receipts.
In the Receipt Frequency measure, enter the number of weeks between each receipt. For example, 1 means that receipts arrive every week. 2 means that receipts arrive every other week.
In the Initial Receipt % measure, enter the percentage of total receipts to be included the first receipt drop.
In the Presentation Min measure, enter the minimum amount of inventory on the sales floor per store. This is used only in the initial receipt and can be thought of as a fixture fill.
In the Safety Stock (Weeks) measure, enter the number of weeks of sales in the future that each receipt drop can fulfill. This safety stock setting applies to all receipt drops except the initial receipt drop. It is based on a future week of sales, not an average week of sales.
In the Sell Thru Reg % measure, enter the target percentage of sales to be reached during the regular and promotional periods. This number is used as a guideline for calculating receipts. For example, if set to 85%, this means that 85% of the style/color is sold during the regular and promotional periods, and 15% is left to be sold during the clearance period.
Select the Flow Receipts check box.
In the Planning Actions menu, click Calculate Receipt Flow.

Figure 7-19 Planning Actions: Calculate Receipt Flow

The Wp Receipts U and Receipt Start Week measures are populated. After you have calculated the receipt flow, continue to the Item Plan Worksheet: Receipts and Inventory Measure Profile to view the receipt and inventory plan.

Table 7-8 Item Plan Parameters Worksheet - Receipt Parameters Measure Profile

Measure	Description
# Stores	The number of stores that sell the style/color.
Start Sell Week	The first week that the style/color is sold.
Wp Sls Reg + Pro U	The combined total of the planned regular and promotional units. This is a calculated measure.
Sell Thru Reg %	The target percentage of sales to be reached during the regular and promotional periods.
Wp BOS U	The planned beginning of season units.
Wp BOS R	The planned beginning of season retail.
Wp BOS C	The planned beginning of season cost.
Receipt Frequency	The number of weeks between each receipt drop.
Initial Receipt %	The percentage of total receipts to be included in the first receipt drop.
Presentation Min	The minimum amount of inventory on the sales floor per store. This is used only in the initial receipt and can be thought of as a fixture fill.
Safety Stock (weeks)	The number of weeks of sales in the future that each receipt drop can fulfill. This applies to all receipt drops except the initial one. It is based on a future week of sales, not an average week of sales.
Receipt Lead Time	The number of weeks before the start sell week that the initial receipt drop arrives.
Flow Receipts	Check this measure to calculate the receipt flow based on the parameters in this worksheet.
Wp Receipt Start Week	The week that initial receipt drop occurs.
Wp EOP U	The planned end of period units. This is a calculated measure.
Wp EOP R	The planned end of period retail. This is a calculated measure.
Wp EOP C	The planned end of period cost. This is a calculated measure.
Wp Cum Avg Inv U	The planned cumulative average inventory units. This is a calculated measure.
Wp Cum Avg Inv R	The planned cumulative average inventory retail. This is a calculated measure.
Wp Cum Avg Inv C	The planned cumulative average inventory cost. This is a calculated measure.
Wp Cum Turn U	The planned cumulative turn units. This is a calculated measure.
Wp Cum Turn R	The planned cumulative turn retail. This is a calculated measure.
Wp Cum Turn C	The planned cumulative turn cost. This is a calculated measure.

Item Plan Tab: Receipt and Inventory Plan

After you have developed the receipt flow, review the receipt and inventory plan in the Item Plan worksheet.

Item Plan Worksheet: Receipts and Inventory Measure Profile

Use this worksheet to review the receipt and inventory plan you created in the Item Plan Parameters worksheet.

Change the measure profile of the Item Plan worksheet to Receipts and Inventory.
Review the receipt units in the Wp Receipt U measure.

Figure 7-20 Item Plan Worksheet: Receipt and Inventory Measure Profile
Return to the Sales and Margin Plan measure profile.
Review the gross margin in the Sales and Margin Plan measure profile. The margin measures are populated now that the receipt markup has been planned.

Figure 7-21 Item Plan Worksheet: Sales and Margin Plan Measure Profile

If you are satisfied with the receipts and inventory plan, continue to the Review and Approval Tab. If not, return to the Item Plan Parameters Worksheet: Receipt Parameters Measure Profile to adjust the plan.

Review and Approval Tab

After you have developed the sales and margin and receipts and inventory plans, 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 worksheet.

This tab contains three worksheets: Plan Review Worksheet, All Measures, and Plan Approval Worksheet.

Plan Review Worksheet

Use this worksheet to compare the plan to the plans created in MFP. Several measure profiles are available for comparison:

Compare to MFP Cost Cp Plan
Compare to MFP Cost Op Plan
Compare to MFP Retail Cp Plan
Compare to MFP Retail Op Plan
Compare to MFP Unit Plan

Figure 7-22 Plan Review Worksheet: Compare to MFP Cost Cp Plan

All Measures

The All Measures worksheet contains all the measures in the workbook; however, only the Wp Ttl Sls U measure is visible in the default measure profile. The purpose of this worksheet is to allow you to create a view of workbook measures that you may not be able to view all at once in other worksheets.

Figure 7-23 All Measures Worksheet

To see the other measures in this worksheet, perform the following steps:

Right-click the Measure dimension tile and click Select Display and Sort Attributes. The All Measures - Measure window appears.
The Tree Options window appears. Click the Show/Hide tab.
Move measures you want to see in the worksheet from the Hidden Measures box to the Visible Measures box.
When finished, click OK.

For more information about hidden and visible measures, see the Oracle Retail Predictive Application Server User Guide for the Classic Client.

Plan Approval Worksheet

After you have reviewed the plans, approve them in this worksheet.

The approval process is self-approved and executed by the item planner. The versions to be updated are determined during the approval process. During preseason, it is recommended that Op and Cp are updated together to ensure synchronization. When in-season planning begins, only the Cp version is updated. If for some reason the Op needs to be updated after in-season planning has begun, you have the option to approve to the Op version only. Note that in this case, only unelapsed time periods are approved from Wp to Op.

By default, all quarters are disabled for Op approval. If the administrator allows users to approve to Op, you can approve the Op.

To approve the plans, perform the following steps:

Use the Wp Approve measure to approve the plan. You can approve just the current plan, just the original plan, or both plans.
Optional: Enter comments in the Wp Approval Comments measure.

Figure 7-24 Plan Approval Worksheet
When ready to approve, click Approve in the Planning Actions menu Figure 7-25.

Figure 7-25 Approve Item Plans Option in the Planning Actions Menu
A success message appears, informing you that the plan was successfully approved. Click OK to close it.

Figure 7-26 Plan Approved Message

The worksheet refreshes and the Wp Approve and Wp Approval Comments measures are cleared. The Wp Last Approval Action measure along with the associated Op and Cp measures are populated (Figure 7-27).

Figure 7-27 Approved Plans

The following table lists the measures available on this worksheet.

Table 7-9 Approval Worksheet Measures

Measure	Description
Wp Approve	Use this measure to approve the plan to the current plan, original plan, or both.
Wp Last Approval Action	Displays the last type of approval for the time period. The choices are Approve Op and Cp, Approve Op Only, and Approve Cp Only.
Wp Approval Comments	Use this measure to enter comments about the plan.
Op Last Approved Date	The date that the last original plan was approved.
Op Last Approved By	The username of the person who last approved the original plan.
Op Last Approved Comments	The comments about the original plan approval made by the user.
Cp Last Approved Date	The date that the last current plan was approved.
Cp Last Approved By	The username of the person who last approved the current plan.
Cp Last Approved Comments	The comments about the current plan approval made by the user.

Committing Targets

To commit your plan, perform the following steps:

Approve your plans using the instructions in Plan Approval Worksheet section.
In the workbook that you have approved the plans, click Commit Now or Commit ASAP in the File menu.

Figure 7-28 Commit a Workbook

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

Dashboard Tab

Once In-Season planning begins, use the worksheets in this tab to review the overall status of each style/color. Until you create and submit an item plan, the dashboard worksheets are empty.

The Dashboard tab has two worksheets: Dashboard Worksheet and Bounds Worksheet.

Dashboard Worksheet

Use the Dashboard worksheet for a quick overview of each style's data.

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

Figure 7-29 Dashboard Worksheet

Table 7-10 lists the measures available on this worksheet.

Table 7-10 Dashboard Worksheet 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 Retail.
Turn Exception	The turn exception that is highlighted per the user-defined upper and lower bound limits.

After you have reviewed the dashboard, continue to the Bounds Worksheet.

Bounds Worksheet

The Bounds worksheet allows you to set the upper and lower bounds for sales, markdown, gross profit, sell through, and turn.

Figure 7-30 Bounds Worksheet

Table 7-11 lists the measures available on this worksheet.

Table 7-11 Bounds Worksheet 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 worksheet 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 worksheet 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 worksheet 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 worksheet 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 worksheet 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 worksheet 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 worksheet 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 worksheet 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 worksheet 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 worksheet 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 worksheet 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 worksheet as an exception.