Oracle® Retail Merchandise Financial Planning Retail Cloud Service User Guide Release 19.0 F24873-03 |
|
Previous |
Next |
The Location Planner role is usually the same person that generates merch plans in the merchandise planning organization. During the pre-season, the Location Planner generates merch plans and location plan targets. The Location Planner references those targets when creating the department level location plans.
The Planner will start the Create Location Plan task after location targets are published. Location Planning is the process in which planners create the location plans at the store level. These plans are then ultimately compared to and reconciled against the Merch Plan.
This task includes the following steps:
Location Plan creation is important for ensuring that each location's receipts are in-line so that the organization can achieve the plans and targets set forth. Location planning requires a balance and understanding of the store's promotional-nature, seasonality/climate, size, and so on. On top of that, consideration of the events of last year that impact that particular location's sales history become crucial. Examples of significant events that impact the Ly sales history:
Hurricane or other natural disasters that close the store
Competition: competitor opened or closed a store
A remodel or reformat
The first action to take when creating a new plan is to seed the plan.
With this view, you can choose to seed your plan Last Year (Ly), Forecast (Fcst), or Targets (Tgt) data to create a demand curve on which to initially spread the new plan. Or, you can instead choose to not seed the plan, which allows you to create a plan that is not influenced by last year's performance or forecast (plus last year's performance).
Table 11-1 Create Plan - Seed Plan Initialize Measures
Measure | Description |
---|---|
Wp Seed Source |
The seed source used to seed the working plan. Use this option to seed or not seed the working plan. You can seed with Last Year's (Ly) or Forecast (Fcst) data. Alternatively, choose the Blank option if you do not want to seed the working plan. |
Wp Seed Info |
Includes a few pertinent facts about the last time that the Seed custom menu was executed: last seed source concatenated with last seeded date and the last user to seed. If blank, then the given intersection has never been seeded. |
The following table shows a list of measures that are seeded for different seeding options.
Table 11-2 Seeding Options
Seeded Measure | Seed with Version |
---|---|
Wp Sales R |
Ly/Fcst/Tgt Note: Only Target measures corresponding Variance to Ly (var Ly) measures will be seeded. |
Wp Sales U |
Ly/Fcst/Tgt Note: Only Target measures corresponding Variance to Ly (var Ly) measures will be seeded. |
Wp Markdown R % |
Ly/Tgt |
Wp Returns R % |
Ly/Tgt |
Wp Returns AUR |
Ly/Tgt |
Wp Receipts R |
Ly |
Wp Receipts U |
Ly |
Wp Receipts MU % |
Ly |
Wp Shrink R % |
Ly |
Wp Shrink AUR |
Ly |
Wp Shrink MU % |
Ly |
Wp Transfers In/Out R |
Ly |
Wp Transfers In/Out U |
Ly |
Wp W/F Owned by Retailer R % |
Ly |
Wp W/F Markup R % |
Ly |
Wp W/F Markdown R % |
Ly |
The local currency chosen will be applied to the views of local currency found throughout the Create Location Plan task.
After selecting a currency, you can click Calculate to apply the rate. If you have not yet performed a seeding action, the rate will be applied at the time of seeding.
The VAT Rate chosen will be applied as the VAT rate throughout the Create Location Plan task. Ly actuals include VAT therefore the VAT rate is used to calculate values excluding VAT.
After selecting a VAT rate, you can click Calculate to apply the rate. If you have not yet performed a seeding action, the rate will be applied at the time of seeding.
In this view, you set the threshold minimums (mins) and maximums (maxs) that will trigger alert formatting and alerts in the LP: Exceptions dashboard. The following table lists the conditions under which an alert is triggered. Thresholds must be non-zero to trigger alerts.
Threshold | Condition |
---|---|
Wp GM R % Max Threshold | Alert is green when Wp GM R % is greater than the threshold |
Wp GM R % Min Threshold | Alert is red when Wp GM R % is less than the threshold |
Wp Markdown R % Max Threshold | Alert is red when Markdown R % is greater than the threshold |
Wp Markdown R % Min Threshold | Alert is green when Markdown R % is less than the threshold |
Wp Net Sales R Max Threshold | Alert is green when Net Sales R is greater than the threshold |
Wp Net Sales R Min Threshold | Alert is red when Net Sales R is less than the threshold |
Wp Returns R % Max Threshold | Alert is red when Returns R % is greater than the threshold |
Wp Returns R % Min Threshold | Alert is green when Returns R % is less than the threshold |
Wp Sell Thru R % Max Threshold | Alert is green when higher than the threshold |
Wp Sell Thru R % Min Threshold | Alert is yellow when less than the threshold |
Wp Do Not Alert | Prevents alerting of the department/locations that are checked |
After seeding, you can verify the seeded sales and markdown data in this view.
You can verify the seeded sales and markdown data in this view. After you have seeded, develop the sales, and markdown location plan for those departments.
If you are planning a Wholesale/Franchise location, use this view to plan Net Sales. Then use the W/F Sales and Markup View to complete planning.
There are several measure profiles available to logically guide you through the plan variables.
A measure profile is selected by clicking the Edit View button next to the Measure tile.
The following measure profiles are available:
Retail (Default)
The sales measure profile shows the key sales planning metrics including sales, net sales, and returns.
To use the Average Sales/Net Sales/Returns Per Location measures to see averages, you must rollup the Location Dimension to a level above Location. The average calculated is limited to the average of the active locations of the workspace segment. A segment with one location will have an average equal to the Wp. In the same way, a dimension with only a single location which rolls up to it will also have an average equal to the Wp.
Units
The sales measure profile shows the key sales units planning metrics including sales, net sales, and returns.
To use the Average Sales/Net Sales/Returns Per Location measures to see averages, you must rollup the Location Dimension to a level above Location. The average calculated is limited to the average of the active locations of the workspace segment. A segment with one location will have an average equal to the Wp. In the same way, a dimension with only a single location which rolls up to it will also have an average equal to the Wp.
If the Local Currency option is provisioned, the Local Currency view is available. The Local Currency view displays your plan using the local currency conversion set up by the administrator.
If the Wholesale Franchise options are provisioned, this view is available to plan. Wholesale/Franchise sales are typically tracked and managed as a separate channel of a retail business. Use the Wholesale/Franchise Sales and Markdowns view to build your sales, markup, and markdowns that you will make as wholesaler or franchisor.
Inventory & Gross Margin is the third sub-step in Create Plan step.
After you have developed the sales and markdown plan, develop a receipts and inventory plan that can support the sales and markdown plan. The purpose of this step is to ensure that you have a receipt and inventory plan that supports the sales that you are projecting. Like the Plan Sales and Markdowns view, the Plan Receipts/Inventory view contains several Ly metrics that you can reference when setting your targets. Additional measures can be used to adjust your inventory targets.
Use the Gross Margin view to evaluate the gross margin created from your sales and markdown plan and receipts and inventory plan. Determine whether the planned gross margin meets your gross margin goal. If it does not, return to the Plan Sales and Markdown Plan and Plan Inventory and Receipt Plan steps to adjust your receipt markups and receipt flow. When you return to the Plan Sales and Markdowns view, adjust the markdown plans, but do not change the sales. Continue this process until you are satisfied with the gross margin.
If the Wholesale Franchise or Local Currency options are provisioned, then there are additional views to support planning sales and markdowns specifically catered to those options.
The Local Currency Plan view shows the Gross Margin plan using the local currency conversion set up by the administrator.
The W/F Gross Margin view shows planned Wholesale Franchise Gross Margin, if this option is provisioned.
In this step, review and compare your plan to ensure the goals set forth in the merch plan are being met.
Use the MFP OP and the MFP CP measure profiles to reconcile your location plan to the merch plan.
In this step, the location planner can review and approve the created location plan. The Review and Approve step contains two views: Review Plan and Approve Plan.
In this step, review the location plan you created. The purpose of reviewing the plan is so that you can understand the goals that your plan should meet.
Click the Approve Plan button when you are ready to approve the location plan you created. The approved versions will be committed after the process is complete.
Use this step to review the location plan during in-season for On Order and Open to Buy and to update the plan and reapprove if necessary. The Review and Re-Approve step has two views: Review and Re-Project Plan and Approve Plan.
In this view, you can review the On Order and Open To Buy during in-season and adjust planned inventory data as needed and reapprove the CP Plan.