Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
11
Create Location Plan Task
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:
-
Create Plan Step
-
Review and Reconcile to MFP Step
-
Review and Approve Step
-
In-season Review and Reforecast Step
-
Review and Re-Approve Step
-
All Measures
Create Plan Step
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
Seed Plan Sub-Step
The first action to take when creating a new plan is to seed the plan.
Initialize View
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-2 (Cont.) Seeding Options
| Seeded Measure | Seed with Version |
|---|---|
| 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 |
Note
To clear the seeded data, use the Clear Plan custom menu option.
Select Local Currency View
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.
Select VAT Rate View
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.
Set Alert Thresholds View
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 POS R % Max Threshold | Alert is red when Markdown POS R % is greater than the threshold |
| Wp Markdown POS R % Min Threshold | Alert is green when Markdown POS 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 |
| 1. Plan Sales/Markdowns | ||||
|---|---|---|---|---|
| v | Calendar By | |||
| oO | Measure(1.Retai | l) + | [ « | |
| Calendar Measure | 2/11/2023 T | 2/18/2025 t | 2/25/2023 tT | 3/4/2025 T |
| Wp Sales R | 21,138.85 | 25,758.57 | 30,798.27 | 55,697.99 |
| Fest Sales R | 21,355.47 | 26,009.45 | 351,086.50 | 36,022.55 |
| Wp Sales R var Fest % | -1.0% | -1.0 % | -0.9% | -0.9 % |
| Ly Sales R | 19,217.12 | 23,416.88 | 27,998.43 | 52,452.72 |
| Wo Sales R var Ly% | 10.0 % | 10.0 % | 10.0% | 10.0 % |
| Wp Avg Sales R per Location | 21,138.83 | 25,758.57 | 30,798.27 | 35,697.99 |
| Wp Avg Sales R per Sq M | 13.86 | 16.89 | 20.19 | 23.41 |
| Wop Net Sales R | 12,307.79 | 14,939.97 | 17,862.99 | 20,704.84 |
| Ly Net Sales R | 11,188.90 | 13,581.79 | 16,239.08 | 18,822.58 |
| Wp NetSales R var Ly% | 10.0% | 10.0 % | 10.0% | 10.0% |
| WpAveNetSalesRper | 12,307.79 | 14,939.97 | 17,862.99 | 20,704.84 |
you can reference when setting your targets. Additional measures can be used to adjust your inventory targets.
Gross Margin View
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.
Local Currency Plan View
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.
W/F Gross Margin View
The W/F Gross Margin view shows planned Wholesale Franchise Gross Margin, if this option is provisioned.
Define Location Rollup
The Define Location Rollup view is used to select location attributes to view in an alternate hierarchy. Nested location attribute roll up is provided with three levels. A planner can set up to three different combinations for nested rollup with a maximum of three levels in each combination. Nesting of dynamic attributes is a configurable option. For example: As a first combination, you select Climate as a Level 1, Customer Type as Level 2, and Store Format as Level 3 by clicking the list of attributes available. This allows you to roll up your location by Climate, then Customer Type inside each Climate and then by Store Format inside each customer type. This feature also allows you to view subtotals for each of the levels. You can edit subtotals and spread the values to all the associated child positions.
Perform the following steps to complete this process:
1. Select up to three dynamic location attributes from the list.
2. Run the Refresh Location Rollup Application Action.
3. To view the location attribute:
-
In a view that displays location level, click the Location Hierarchy tile.
-
Select the attribute (Attribute 1 or 2 or 3) that you would like to view in the nested dynamic rollup.
-
Click OK .
ee
| © 1. Review Plan | ||||
|---|---|---|---|---|
| 6 Calendar & G | Product | 0 | ||
| Oo Measure(1.0P)+ | :[<500 Wom | en’sCasualsTra | ditional@> | |
Calendar 1/21/2023 1/2 | 8/2023 | 2/4/2023 | 2/11/2023 | 2/18/2023 2/25/2023 |
| Measure | ||||
| WpNetSales R 5,247.91 | 5,704.02 | 6,069.32 | 5,042.82 | 5,885.82 6,912.87 |
| Op NetSales R 0.00 | 0.00 | 0.00 | 5,042.82 | 5,885.82 6,912.87 |
| Wp NetSales R varOp% 00% | 00% | 00% | 0.0% | 00% 0.0% |
| Wp Markdown POSR% 00% | 0.0% | 0.0% | 0.0% | 00% 0.0% |
| Op Markdown POS R% 00% | 0.0% | 0.0% | 0.0% | 00% 0.0% |
| WpMarkdown POSR 0.00 | 0.00 | 0.00 | 0.00 | 0.00 0.00 |
| OpMarkdown POSR 0.00 | 0.00 | 0.00 | 0.00 | 0.00 0.00 |
| WpMarkdown POSR varOp% 0.0% | 0.0% | 0.0% | 00% | 00% 0.0% |
| WpMarkdown Perm R 977.33 | 1,084.78 | 1,199.97 | 652.75 | 607.49 1,142.80 |
| WpMarkdownPermR% 0.2% | 03% | 0.2% | 0.1% | 0.1% 0.2% |
Review and Reconcile with MFP Sub-step
In this step, review and compare your plan to ensure the goals set forth in the Merch Plan are being met. This sub-step has two views:
-
Review and Reconcile View
-
Define Location Roll up View
Review and Reconcile View
Use the MFP OP and the MFP CP measure profiles to reconcile your location plan to the Merch Plan.
Define Location Roll Up View
The Define Location Rollup view is used to select location attributes to view in an alternate hierarchy. Nested location attribute roll up is provided with three levels. A planner can set up to three different combinations for nested rollup with a maximum of three levels in each combination. Nesting of dynamic attributes is a configurable option. For example: As a first combination, you select Climate as a Level 1, Customer Type as Level 2, and Store Format as Level 3 by clicking the list of attributes available.
This allows you to roll up your location by Climate, then Customer Type inside each Climate and then by Store Format inside each customer type. This feature also allows you to view subtotals for each of the levels. You can edit subtotals and spread the values to all the associated child positions.
Perform the following steps to complete this process:
1. Select up to three dynamic location attributes from the list.
2. Run the Refresh Location Rollup Application Action.
3. To view the location attribute:
-
a. In a view that displays location level, click the Location Hierarchy tile.
-
b. Select the attribute (Attribute 1 or 2 or 3) that you would like to view in the nested dynamic rollup.
-
c. Click OK .
Sales and Returns Sub-step
After pre-season plan, review the sales return plan during In-season. This has similar views and measures as Sales and Returns steps from pre-season step.
-
Plan Sales / Markdown
-
Local – Sales / Markdown
-
W/F Sales and Markdown
-
Define Location Roll up
| © 1. Reviewand Re-Project | Plan | ||||
|---|---|---|---|---|---|
| 6 | Calendar | 7 | Product | ||
Oo | Measure(1.Retail) +» | #7 | < | 500Women’sCasualsTrad | |
| Calendar | 1/28/2023 | 2/4/2023 2/ | 11/2023 2 | /18/2023 2 | /25/2023 |
| Measure | |||||
| WpBOPR | 425,021.63 | 504,034.18 | 488,802.96 | 476,644.89 | 463,203.72 |
| Wp NetSales R | 5,704.02 | 6,069.32 | 5,042.82 | 5,885.82 | 6,912.87 |
| Wp Markdown POSR | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| WpMarkdown Perm R | 1,084.78 | 1,199.97 | 652.75 | 607.49 | 1,142.80 |
| CpMarkdown Perm R | 1,084.78 | 1,199.97 | 652.75 | 607.49 | 1,142.80 |
| WpMarkdown PermR varCp | 00% | 0.0% | 00% | 00% | 0.0% |
| Wp Receipts R | 46,483.14 | 0.00 | 0.00 | 0.00 | 38,974.31 |
| Cp Receipts R | 47,341.32 | 0.00 | 0.00 | 0.00 | 38,974.31 |
| Wp Receipts R varCp% | -18% | 0.0% | 0.0% | 0.0% | 0.0% |
| Wp ReceiptsMU% | 50.0% | 0.0% | 00% | 00% | 50.0% |
| CpReceiptsMU% | 50.0% | 0.0% | 00% | 00% | 50.0% |