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.
8 Create Merch Plan Targets Task
The Planning Manager owns the target-setting process for the merchandise planning organization. This role is typically aligned with senior or mid-level planning leadership and is responsible for defining the financial direction that planners will use as the basis for their merchandise plans.
The Planning Manager creates merchandise plan targets before the planning period begins. This pre-season activity usually starts two to six months ahead of the season, half, or year being planned. During this time, the Planning Manager establishes high-level financial targets across the relevant merchandise and location scope, giving planners a clear target framework for sales, markdowns, receipts, inventory, and margin planning.
In Modular MFP, pre-season and in-season target activities are organized into separate tasks. The planning manager is presented with the activity Create Merch Target and it consists of two tasks: Create Merch Plan Target Pre-season and Create Merch Plan Target In-season.
Create Merch Targets Pre-Season Task
The pre-season areas are used to create targets and publish them to Merch Planners before the season begins. The in-season area is used after actuals are available and the Planning Manager needs to review performance, update targets, republish revised targets.
The Planning Manager must complete the pre-season target creation and publishing activities before Merch Planners can retrieve the targets and build their plans.
The pre-season task includes the following steps:
-
Create Targets Step
-
Review and Publish Targets Step
-
Review Approved Plan Step
Create Targets Step
The Create Targets step is where the Planning Manager builds the Working Plan target before publishing it as the official Target version
Complete the following steps:
1. Seed the plan using Last Year (Ly), Forecast (Fcst), or Portfolio Optimization data.
2. Review the Portfolio Optimization data and choose to plan with Portfolio Optimization results.
3. Select local currency settings, when local currency planning is provisioned. (Ref: Merch Target Sales & Return Local Currency Module).
4. Set alert thresholds for exception reporting.
5. Plan sales, markdowns, and returns.
6. Plan inventory and receipts to support the sales and markdown target.
7. Review gross margin and adjust the plan until the target supports the intended business outcome.
Tabs and Views in this Step:
-
Seed Plan Tab:
-
Seed Plan view
-
Review Portfolio Optimization view
-
Set Local Currency view
-
Set Alert Threshold view
-
-
Sales & Inventory Tab:
-
Sales and Markdowns view
-
Local - Sales and Markdowns view
-
Receipts and Inventory view
-
Move to Clearance view
-
Gross Margin view
-
Tip
As you build your plan, click Commit when you are satisfied with the intermediate state. This creates a permanent snapshot of the as-is state. This creates a restore point you can revert to if you go down a path that is unsatisfactory.
Seed Plan Tab
The first action in target creation is to seed the plan in the Initialize view. Seeding creates a starting point for the Working Plan target by spreading a selected source across the workspace positions. Before seeding, review the Last Year and Forecast values in the sales and markdown views. If Portfolio Optimization is available, review the Portfolio Optimization output before selecting the seed source.
Seeding is optional. If you do not want the target to be influenced by Last Year, Forecast, or Portfolio Optimization data, you can create the target without seeding and enter the plan manually.
Application Actions
-
Seed: Seed the plan. This copies the seed source into the Wp version.
-
Clear Plan: Clear the seeded data from the Wp version.
-
Receive Portfolio Opt: To retrieve the Portfolio Optimization results for the selected product.
Seed Plan View
With this view, you can choose to seed your plan with Last Year (LY), Forecast (Fcst), or Portfolio Optimization data to create a demand curve on which to spread the new plans initial targets. Or you can instead choose to not seed the plan, which allows you to create a plan that is not influenced by Last Year (LY) performance, the forecast (plus last years performance) result, or Portfolio Optimization results. When seeding the plan, you can choose which
information is seeded. For instance, you can seed just one half or all halves in the workspace. You can also choose what locations and products to seed.
Table 8-1 Seed Plan View Measures
| Measure | Description |
|---|---|
| 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 (LY), Forecast (Fcst), or Portfolio Optimization data output. Or, you can choose the blank option if you do not want to seed the working plan. |
| 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. |
| Seed Returns Setup | Use this option to seed the working plan returns. You can seed the returns values with Last Year (LY) or Forecast (Fcst) data. You can also choose the blank option if you do not want to seed the working plan returns. |
Seeding One Level at a Time
To seed a target, set the seed source for the current product, location, and calendar intersection. Then move through the remaining positions and repeat the selection:
1. Select the Product and calendar Dimension level you want to seed.
2. Select the Wp Seed Source from the picklist of Last Year (LY), Forecast (Fcst), or Portfolio Optimization data.
Note
Before seeding with Portfolio Optimization data, you need to retrieve results from Portfolio Optimization using the Review Portfolio Optimization view.
3. Select Wp Seed Returns Setup to populate returns values. (This is optional Step.)
4. Click Seed from the actions.
5. Review the confirmation message, stating that the data has been successfully seeded. Click OK .
After you have seeded, the view refreshes and the Last Seed Source and Last Seed Date measures contain the source and date of the last seed.
Review Portfolio Optimization View
Use the Review Portfolio Optimization view to review Portfolio Optimization output before using it as a seed source. Select the Boolean for dimension scope and click the custom menu action, Receive Portfolio Opt . After the results are populated against the MPO (Portfolio Optimization) measures, you can proceed with seeding the plan from the Initialize view.
By default, MFP GA receives Net Sales R as output from Portfolio Optimization and it populates MPO Net Sales R in the view. The portfolio optimization results are retrieved at the year level which are then split into weeks using the LY data reference while seeding. You can choose to configure it for Gross Sales Portfolio Optimization output. Module Reference : Merch
| 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 |
| 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/channels that are checked |
Sales & Inventory Tab
The Sales & Markdown sub-step is where the Planning Manager develops and reviews the core target assumptions for sales, markdowns, returns, inventory, clearance movement, and gross margin. Use Forecast and Last Year data as reference points, then adjust the Working Plan to reflect the strategic target for the season.
This tab helps confirm that the sales and markdown target is supported by the right inventory and receipt plan, and that the resulting gross margin meets the intended profitability objective before the target is published.
This tab includes the Sales & Markdown view, Inventory & receipt view, Gross Margin view, and Move to Clearance view. Together, these views help the Planning Manager build a balanced target by aligning sales and markdown expectations with the inventory, return, clearance, and margin outcomes needed to support the plan.
Sales and Markdowns View
In the Sales and Markdowns view, you plan net sales, promotions, and markdowns. Sales are the revenue generated by selling goods or services. Regular priced sales yield the greatest margin, however successful promotions drive more traffic and completion of sales. Though the promotional sale likely includes markdown, the overall increase in sales should outweigh the markdown and drive at good margins. Module Reference : Merch Target Sales & Return & Merch Targe Sales & Returns Unit. For more details on modules, refer to the Oracle Merchandise Financial Planning Cloud Service Starter Kit Guide .
A measure profile is selected by clicking on the Edit View button next to the Measure tile.
The following measure profiles are available:
- Sales and Markdowns (Default)
The measures in this profile represent totals which are not broken down by type of sale such as Promo, clearance, and so on. This view also incorporates the forecast for viewing on top of all Ly actuals.
• Sales by Type
The measures in this profile display and capture sales and returns figures by type of sale: Regular + Promotional, and Clearance. Regular + Promo, and Clearance added together equate to the total sale or total return.
Start by planning the regular sales. Then, using your marketing calendar as a guide, align the promotional sales to the calendar. Refer to the calendar again for the exit weeks for the products, and plan the clearance sales for those weeks.
The planned figures for these sales types populates the Wp Sales R measure.
- Markdowns by Type
Markdown is the difference between the original retail price and the actual selling price. The measures in this profile display and capture markdown figures as a total as well as by sales type: Regular + Promotional, and Clearance. The markdown types added together equate to the markdown (Wp Markdown POS R).
• Units
Some lines of businesses may prefer to build the plan, or at least closely couple the financial plan, by sales in terms of units. You also use this view to review the Average Unit Retail (AUR) to ensure it aligns with your strategic plans for the department.
Follow these steps to basic sales and markdown generation:
1. Using the default measure profile, which is Sales and Markdowns, review and compare the total sales to the forecast and last year.
2. Change the measure profile to Sales by Type.
3. In the Sales by Type measure profile, plan your sales by type. The sales types are Total Sales, Regular + Promo Sales, and Clearance Sales.
Start by planning the regular sales. Then, using your marketing calendar as a guide, align the promotional sales to the calendar. Refer to the calendar again for the exit weeks for the products, and plan the clearance sales for those weeks.
The planned figures for these sales types populates the Wp Sales R measure.
4. Return to the Sales and Markdowns measure and adjust the total Working Plan sales target as needed.
5. Change the measure profile to Markdown by Type And adjust the markdown rates or amounts.
6. Review returns where applicable and confirm that the net sales still align to the required target.
7. Use the Units profile, when provisioned, to validate the unit sales and AUR.
Note
Since sales and markdowns are both planned at the type level, you must first complete the sales by type planning before you can plan the markdowns by type.
Local - Sales and Markdowns View
If the Local Currency option is provisioned, you use this view. The key planning KPIs are available in local currency for cross-referencing and high-level planning. Module reference :
Merch Target Sales & Return Local Currency. For more details on modules, refer to the Oracle Merchandise Financial Planning Cloud Service Starter Kit Guide .
Receipts and Inventory View
Receipts and Inventory is where you will plan Beginning-of-period (BOP)/End-of-period (EOP) inventory, receipts, turn, and so on. This view is frequently planned at a month level. At a month level, EOP is usually targeted to be about the same as BOP and then ramp up for holiday gift giving is factored in. After planning the month, it is wise to review the results at a week level to ensure there are no undesirable anomalies.
Inventory turn is an important indicator of the effectiveness of the planned inventory. It tells you how many times stock is being sold and repurchased over a given period of time. The goal is to increase your turn as much as possible, without having to take markdowns. Turn (Wp CUM Turn R) is reviewed in this workspace view.
Another important indicator is Stock to Sales Ratio. The stock to sales ratio is the proportion of inventory on hand at the beginning of a period (such as a week or month) that will support the planned sales in that period.
If the Stock to Sales Ratio rises, (due to an increase in inventory without an accompanying rise in sales), then you are adding more stock without increasing sales. Unless you are intentionally ramping up stock for holiday, promo, and so on, then it is time to hold off on receipts and work on selling down the quantity on that item. The ultimate goal is to reduce your Stock to Sales Ratio as low as possible, without losing sales. Module Reference : Merch Target Inventory & Receipt; Inventory & Receipt Units. For more details on modules, refer to the Oracle Merchandise Financial Planning Cloud Service Starter Kit Guide .
Note
The adjustments you made to the Sales and Markdowns view are visible in this view after you have clicked Calculate.
Measure profiles help the Planning Manager evaluate inventory from different perspectives. The following measure profiles are available:
- Retail (Default)
The Retail profile is the default profile. The planning is focused on total retail rather than units, and sale type . This profile is the most comprehensive view of variables impacting inventory.
- Inventory by Type
In this profile, you can review and maintain a breakdown of inventory by sales type, Regular + Promo, and Clearance.
- Units
In this view, you can directly maintain EOP inventory, Mark Out of Stock (MOS), and Move to Clearance in terms of units.
Use the following best practices to plan the receipts and inventory:
1. Plan the receipt flow and then evaluate the average inventory and turn.
2. Review the Receipts Markup (MU) for accuracy. Often this will follow the keystone 50%, but many variables can impact the decision on markup-from competitor pricing to freight costs, and overhead operating expense.
| 1. Receip | tsand Inve | ntory | |||||
|---|---|---|---|---|---|---|---|
| Measure | Cal | endar 2/11/2023 ut | 2/18/2023 it | 2/25/2023 tT | 3/4/2023 t | 3/11/2023 tT | 3/18/2023 {5 |
| WpBOPR | 51,768,621.92 | 51,765,408.78 | 51,759,632.96 | 55,682,378.30 | 55,670,301.02 | 55,664,683.25 | |
| LyBOPR | 41,298,877.14 | 40,032,895.48 | 38,572,417.53 | 44,569,794.66 | 42,536,586.87 | 40,964,118.47 | |
| Wp Receipts R | 0.00 | 0.00 | 3,932,315.06 | 0.00 | 0.00 | 0.00 | |
| Wp Receipts | MU % | 0.0% | 0.0% | 50.0% | 0.0% | 0.0% | 0.0% |
| LyReceipts R | 0.00 | 0.00 | 3,932,315.06 | 0.00 | 0.00 | 0.00 | |
| Ly Receipts M | U % | 0.0% | 0.0% | 50.0% | 0.0% | 0.0% | 0.0% |
| Wp Receipts R | var Ly% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
| WpNetSales | R | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 552,507.28 |
| LyNetSalesR | 522,339.25 | 631,714.03 | 749,886.42 | 865,378.16 | 644,704.67 | 552,507.28 |
-
Review & Publish Targets Tab:
-
Review Targets View
-
Publish Targets View
-
-
Published Targets View
Review & Publish Targets Tab
In this tab, review and publish the targets you created in the previous step Publishing a target copies the targets you built in the Wp measures to the target (Tgt) measures, and then commits them to the database. Once committed, Planners can retrieve those targets and take action planning to them.
Application Action
Publish Targets
Moves the Working Plan (Wp) version of the planning data to Target (TG) version for the use in Merch Plan Task.
Review Targets View
Use this view to review the targets created in previous step. If the target needs to be changed, return to the Create Targets step, make the required edits, and then review again.
There are several measure profiles in this view to quickly guide you to the plans you wish to review:
- Default
This measure profile shows the main Working Plan metrics for comparison with last year metrics. This is the profile you will use after initially performing the Create Targets step.
- Tgt with Cp
This measure profile shows the main Working Plan metrics for comparison with Current Plan metrics. Current Plan is a version of the plan that is approved in-season (and is actualized for elapsed/historical periods).
- Tgt with Op
This measure profile shows the main Working Plan metrics for comparison with Original Plan metrics. Original Plan is the plan as it was initially approved-typically it got approved pre-season and stays fixed when the period becomes in-season.
| ~ ReviewTargets | ||||||
|---|---|---|---|---|---|---|
| 6 | Calendar Fy | Locat | ion & GZ | |||
| o | Measure(unsaved) +¥ | #@ | < | Brick& Mortar © | > | |
| Calendar | 1/7/2023 | 1/14/2023 | 1/21/2023 | 1/28/2023 | 2/4/2023 | 2/11/2023 |
| Measure | ||||||
| Wp Sales R | 193,012.28 | 173,547.46 | 232,561.89 | 251,457.36 | 267,665.01 | 222,920.14 |
| LySalesR | 175,465.71 | 157,770.42 | 211,419.90 | 228,597.60 | 243,331.83 | 202,654.67 |
| Wp Sales R varLy% | 10.0% | 10.0 % | 10.0 % | 10.0 % | 10.0% | 10.0% |
| Wp Sales R var Fest% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | -744% |
| Wp NetSales R | 172,351.49 | 102,424.89 | 137,571.56 | 149,059.53 | 157,885.42 | 132,493.22 |
| Ly Net Sales R | 156,683.17 | 93,113.54 | 125,065.05 | 135,508.66 | 143,532.20 | 120,448.38 |
| WpNetSalesR var Ly% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% |
| WpMarkdown POSR | 83,173.53 | 69,309.90 | 65,857.55 | 74,580.55 | 76,549.00 | 0.00 |
| Wp Markdown POSR% | 48.3% | 67.7% | 47.9% | 50.0% | 48.5% | 0.0% |
| Wp Markdown Perm R% | 0.2% | 0.1% | 0.2% | 0.2% | 0.2% | 0.1% |
| Ly Markdown Perm R | 18,876.16 | 15,451.95 | 20,726.15 | 22,678.05 | 23,888.31 | 14,235.53 |
| LyMarkdownPermR% | 0.2% | 0.2% | 0.2% | 0.3% | 0.2% | 0.1% |
One of the key steps of in-season management is reviewing Open to Buy (OTB). OTB is the amount of money budgeted during the in-season to purchase goods that have not yet been received or ordered. The Planner decides in-season how to spend this money to reach strategic targets.
The in-season task includes the following step:
- Update Target Steps
Update Target Steps
Use this step to update the Open to Buy plan and review weekly projections. Planning Manager compare planned and projected inventory levels, evaluate available OTB, and determine whether future receipts should be purchased, reduced, or canceled based on projected sales, markdowns, receipts, and inventory.
Tabs and Views in this Step:
-
Open to Buy tab:
- Open to Buy view
-
Projections tab:
- Weekly In-Season Projections view
Open to Buy Tab
This tab has one view.
Open to Buy View
Use Open to Buy (OTB) to understand the variance between the planned and projected inventory levels. This variance is shown in the Wp OTB R measure. OTB indicate how many additional receipts can be purchased (or canceled) after projected sales and markdowns. Module Reference : Merch Target Inventory & Receipt; Merch Target Inventory & Receipt Units. For more details on modules, refer to the Oracle Merchandise Financial Planning Cloud Service Starter Kit Guide .
Users should understand if their planned receipts keep them on the overall Cp EOP inventory plan. To understand the variance between the Cp EOP inventory plan and the Wp EOP inventory plan, reference the measure Wp EOP R var Cp%.
Use this view to validate what OTB you have available and then start adjusting your plan. Then, confirm that your updates can be obtained given the OTB constraints you may have. Use the following best practices to adjust OTB:
-
To understand the difference between the current approved receipts and the net on order, compare Cp Receipts R to Wp Net On Order R.
-
If receipts are booked for upcoming (non-elapsed) periods, you can enter the Wp Receipt R data into the Wp On Order Adj R to capture the Wp OTB R measure. For example, this may occur if receipts book daily for the retailer, and OTB is completed on a Tuesday. By using the Wp On Order Adj measures, you can capture all receipts for comparing the Net On Order to the Cp receipt plan.
This view has two measure profiles:
- Default
| ¥ OpentoBuy | |||||||
|---|---|---|---|---|---|---|---|
| B | Calendar a | Locat | ion | & | |||
| oO | Measure(unsaved) + | ~ [< | Brick &Mortar © | > | < 500Wom | ||
| Calendar | 1/7/2023 | 1/14/2023 | 1/2 | 1/2023 | 1/28/2023 | 2/4/2023 | 2/11/2023 |
| Measure | |||||||
| WpBOPR | 12,431,354.78 | 11,939,048.97 | 11,614,518.77 | 11,231,774.40 | 13,022,797.90 | 12,572,865.23 | |
| Wp Net Sales R | 172,351.49 | 102,424.89 | 137,571.56 | 149,059.53 | 157,885.42 | 132,493.22 | |
| WpMarkdown POSR | 83,173.53 | 69,309.90 | 65,857.55 | 74,580.55 | 76,549.00 | 0.00 | |
| WpMarkdown POSR% | 48.3% | 67.7% | 47.9% | 50.0% | 48.5% | 0.0% | |
| WpMarkdown Perm R | 21,023.79 | 17,119.08 | 23,136.66 | 24,949.06 | 26,772.69 | 14,265.31 | |
| WpMarkdown Perm R% | 0.2% | 0.1% | 0.2% | 0.2% | 0.2% | 0.1% | |
| Wp Receipts R | 0.00 | 0.00 | 0.00 | 1,097,949.73 | 0.00 | 0.00 | |
| Wp Receipts MU% | 0.0% | 0.0% | 0.0% | 50.0% | 0.0% | 0.0% | |
| CpReceipts R | 0.00 | 0.00 | 0.00 | 1,118,219.18 | 0.00 | 0.00 | |
| CpReceiptsMU% | 0.0% | 0.0% | 0.0% | 50.0% | 0.0% | 0.0% |
-
Review Targets View
-
Publish Targets Tab:
-
Publish View
-
Published Targets View
Review & Re-Project Tab
Use the Review & Re-Project sub-step to compare and update Working Plan targets against Current Plan, Original Plan, and Last Year. This review helps the Planning Manager decide whether the target should remain unchanged or be revised for the current in-season outlook.
Application Action
Publish Targets
Moves the Working Plan (Wp) version of the planning data to Target (TG) version for the use in Merch Plan Task.
This tab has only one view.
Review Targets View
Use the following measure profiles in this view to review and re-project as desired:
- Default
Use this profile to see Wp and Ly values.
- Tgt with Cp
Use this profile to see Wp and Cp values.
- Tgt with Op
Use this profile to see Wp and Op values.
Publish Targets Tab
Perform this tab when you are ready to publish the in-season adjusted targets you created. Publishing a target copies your Wp measure information to the Tgt measures and then it commits those target measures to the database so that Planners can retrieve those targets.
Publish View
To publish the targets, complete the following steps:
1. Place a check mark in the Wp Publish Targets measure to select the halves the that you want to publish.
2. If necessary, enter relevant information in the Wp Publish Notes measure. This is optional.
3. Repeat the steps for other locations and products if necessary.
4. Click Publish Targets .
5. A success message is displayed. Click Dismiss to close it.
After publishing, the view refreshes. Wp Publish Targets and Wp Publish Notes are cleared, Tgt Publish Info is populated, and the Target measures reflect the newly published target values.
| ~ ReviewPlan | |||||
|---|---|---|---|---|---|
| a | Calendar # GZ | Location | |||
| Oo | Measure(1.Default) | w | : [< | Brick&Mortar > | |
| Calendar | 8/13/2022 | 8/20/2022 8/27 | /2022 | 9/3/2022 | 9/10/2022 |
| Measure | |||||
| Tgt Sales R | 0.00 | 0.00 | 0.00 | 0.00 | |
| Wa Sales R | 0.00 | 0.00 | 0.00 | 0.00 | |
| Tgt Sales RvarWa% | 0.0% | 0.0% | 0.0% | 0.0% | |
| Tgt Net Sales R | 0.00 | 0.00 | 0.00 | 0.00 | |
| Wa NetSales R | 0.00 | 0.00 | 0.00 | 0.00 | |
| Tgt Net Sales RvarWa% | 0.0% | 0.0% | 0.0% | 0.0% | |
| Tgt Markdown POSR | 0.00 | 0.00 | 0.00 | 0.00 | |
| Tgt Markdown POS R% | 0.0% | 0.0% | 0.0% | 0.0% | |
| WaMarkdownPOSR | 0.00 | 0.00 | 0.00 | 0.00 |