| Oracle® Retail Item Planning Configured for COE User Guide for the RPAS Fusion Client Release 14.1 E55951-01 |
|
 Previous |
 Next |
| Oracle® Retail Item Planning Configured for COE User Guide for the RPAS Fusion Client Release 14.1 E55951-01 |
|
Previous |
Next |
During the preseason planning period, use the Develop and Approve Item Plans task to create item plans at the style/color level. This task has five steps:
This task and steps are shown in Figure 7-1.
The following are the general process of creating an item plan:
Optional: Consult the assortment plan created in the Assortment Planning application in the Review Assortment Plan Step.
Create a sales and markdown plan in the Set Up Parameters to Seed Item Plans Step
Assign promotions to style-colors and review their promotional impact in the Assign Pricing Events Step.
Seed the plan in the Set Up Parameters to Seed Item Plans Step.
Review the sales and markdowns plan in the Review and Approve Item Plans Step.
Create a receipts and inventory plan and calculate the receipt flow in the Manage Item Plans and Promotional Lifts Task: Receipt and Inventory Plan.
Review the receipts and inventory plan in the Manage Item Plans and Promotional Lifts Task: Receipt and Inventory Plan.
Review the entire plan, compare it to the MFP targets, and approve the plan in the Review and Approve Item Plans Step.
This process is described in detail throughout this chapter.
To build the Develop and Approve Item Plans workbook, perform the following steps:
Click the Create New Workbook icon in the Develop and Approve Item Plans task.
The workbook wizard opens at the Calendar Selection step. Select the weeks that you want to plan and move them to the Selected Items box. 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. |
The Product Selection step of the workbook wizard appears. Select the styles you want to plan and move them to the Selected Items box. Click Next.
The Location Selection step of the workbook wizard appears. Select the channels you want to plan and move them to the Selected Items box. Click Finish.
The Develop and Approve Item Plans workbook is built.
Review the views in the Assortment Plan step if you have loaded data from the Assortment Planning application. If you do not use Assortment Planning, continue to the Set Up Parameters to Seed Item Plans Step.
Use the Review Assortment Plan Parameters view to reference the parameters that the Assortment Planning user set for the same style/colors you are planning. When seeding your working plan in the Item Plan Parameters View, you can choose to seed with this Assortment Plan data.
Table 7-1 Assortment Plan Parameters View 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. |
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.
Table 7-2 lists the measures available on this view.
Table 7-2 Assortment Plan View Step 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 Units |
The End of Period inventory units. |
|
Ap Cp EOP Inv Retail |
The End of Period inventory retail. |
|
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 Set Up Parameters to Seed Item Plans Step to set your own parameters.
Use the views in the Item Planning Parameters step to create a weekly plan for the style-colors. This step has three views:
Use this view to review the reference curves you created in the Maintain Reference Curves task. This view 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 View.
|
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. |
Table 7-3 lists the measures available on this view.
Table 7-3 Reference Curves View Measures
| Measure | Description |
|---|---|
|
Sales Curve Label |
Displays the label for the lifecycle curve. This label is created in the Maintain Reference Curves task. |
|
Sales Curve (Default)% |
Displays percent-to-total sales percentage in the weeks of the curve. This is set in the Maintain Reference Curves task. |
|
Item Lifecycle Curve |
Displays the sales curve for the item. |
Next, continue to the Item Plan Parameters View.
Use this view to set the parameters of the item plan. This creates the weekly sales unit plan.
To set the item plan parameters, perform the following steps:
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 Maintain Markdown Parameters task.
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 Maintain Reference Curves task.
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 View 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 Assign Pricing Events Step before seeding. |
Item Plan Parameters View - Measure Profiles
Along with the Sales Parameter measures profile, the Item Plan Parameters view also includes the following measure profiles:
Receipt Parameters - See Item Plan Parameters View: Receipt Parameters Measure Profile
Markdown Parameters - See the figure (Figure 7-10).
After you have developed the sales and inventory plan, use the Item Plan Parameters view to create the receipt and inventory plan.
Use the receipt parameters measure profile in this view to develop the receipt and inventory plan.
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 instance, 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.
Click the Calculate Receipt Flow button in the upper right corner.
The Wp Receipts U and Receipt Start Week measures are populated. After you have calculated the receipt flow, continue to the Item Plan View: Receipts and Inventory Measure Profile to view the receipt and inventory plan.
Table 7-4 Item Plan Parameters View - 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 view. |
|
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. |
Use this view 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 Review Assortment Plan Step.
Parameters: The parameters that you have created in the Item Plan Parameters View.
Accepted Price Plan: The price plan you create during in-season planning. This price plan is selected in the Accept Price Plans and Review Impact Step of the Review and Accept Price Plans task.
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.
Table 7-5 lists the measures available on this view.
Table 7-5 Seed View 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 Maintain Item and Store Attributes task. |
|
Use History Map |
Select this option to use the history of the style that you mapped the current style to in the Maintain Item and Store Attributes task. |
|
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. |
Perform the following steps to seed the plan:
Roll the calendar dimension up to year.
Select the style/color you want to seed in the product dimension.
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 the Seed button in the upper right corner.
A confirmation message appears, stating that the data has been successfully seeded. Click OK.
After you have seeded, continue to the Review and Approve Item Plans View to approve the plan.
The Assign Pricing Events step contains four views that help you map style-colors to promotions:
Use the Promo Mapping View to map the style-colors and promotions. Use the other views as references about the promotions and markdown cadences.
Use this view to review the lift and the lift override for the promotions. This view is read-only.
Table 7-6 lists the measures available on this view.
Table 7-6 Promotions Definition View Measures
| Measure | Description |
|---|---|
|
Reference Price Promo Disc R% |
The promotional markdown discount. It represents the temporary reduction to the owned inventory price for promotional purposes. Expressed as a percentage of retail. |
|
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. |
Use this view to review the promotion periods. This view is read-only.
Use this view 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.
To map a style/color to a promotion, click the check box. You may select more than one promotion for a style/color.
Use this view to review the markdown cadences you created in the Markdown Cadence View. This view is read-only.
|
Note: To see the Basis (Year/Item) measure data, ensure that all[Calendar] is displayed in the calendar hierarchy. |
Table 7-7 lists the measures available on this view.
The views in this step display the weekly plan for the sales and markdowns that was created by the parameters you have set so far. Use these views to review the plan:
Use this view 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 View to adjust the parameters, seed from parameters in the Seed View, and then return to this view to review the results. Continue this process until you are satisfied with the sales and markdown plan.
This view 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.
Table 7-8 Promo Details View 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 View: Receipt Parameters Measure Profile to create the receipt and inventory plan.
After you have developed the receipt flow, review the receipt and inventory plan in the Item Plan view.
Use this view to review the receipt and inventory plan you created in the Item Plan Parameters view.
Change the measure profile of the Item Plan view to Receipts and Inventory.
Review the receipt units in the Wp Receipt U measure.
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.
If you are satisfied with the receipts and inventory plan, continue to the Review and Approve Item Plans Step. If not, return to the Item Plan Parameters View: Receipt Parameters Measure Profile to adjust the plan.
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 view.
This step contains three views: Plan Review View, All Measures View, and Review and Approve Item Plans View.
Use this view 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
After you have reviewed the plans, approve them in this view.
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.
When ready to approve, click Approve Item Plans in the upper right corner Figure 7-28.
A success message appears, informing you that the plan was successfully approved. Click OK to close it.
The view 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-30).
Table 7-9 lists the measures available on this view.
Table 7-9 Approval Step 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. |
When you are ready to share your plan with other users, you should commit your workbook to the domain. This shares your plan with others. For more information about committing, see the Oracle Retail Predictive Application Server User Guide for the Fusion Client.
To commit your plan, perform the following steps:
Approve your plans using the instructions in Review and Approve Item Plans View section.
In the workbook that you have published the targets, 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.
The All Measures view 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 view is to allow you to create a view of workbook measures that you may not be able to view all at once in other views.
To see the other measures in this view, perform the following steps:
Click the Measure dimension tile. The All Measures - Measure window appears.
Click the Show/Hide tab.
Move measures you want to see in the view 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 Fusion Client.
