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.

9 Create Merch Plan Task

The Planner role is usually associated with the merchandise planner in the merchandise planning organization. During the pre-season, the Planner receives department targets from the Planning Manager. The Planner references those targets when creating the subclass merch plans.

The Planner will start pre-season activity with the Create Merch Plan task. This task belongs only to the merch Planner role. It includes the following steps:

  • Create Plan Step

  • Review and Reconcile Step

  • Review and Submit Plan Step

  • In-Season Review and Reforecast Step

  • In-Season Review and Reconcile Step

  • In-Season Review and Submit Plan Step

The Planner must complete the first three steps in the Create Merch Plan task for all subclasses in the department in order to create plans and submit them for approval to the Planning Manager. The fourth and fifth steps are used during in-season planning.

The available tasks depend on your user role.

Create Plan Step

To create the plan, the basic approach is to complete the following steps within the views provided in the Create Plan step:

1. The first time you begin the Create Plan step for a particular season, department, and channel, you will want to first review the Targets to understand the department totals you need to produce. The Targets are easily reviewed in the Review and Reconcile step > Review with Target sub-step.

Because you have not seeded any plans, the Wp versions of the plan will be irrelevant in the Target review. Another option you may prefer is to initially seed the entire department to generate the base Wp version for initial comparison against Targets.

2. Select the VAT rate and/or local currency rate for planning.

3. Seed the plan using Last Year (LY), Forecast (Fcst), or Portfolio Optimization data to create a base plan.

4. In Sales/Markdowns, plan the sales, markdowns, returns, and so on, you are projecting. Use forecasted sales and Ly as a guide.

5. Plan the required inventory and receipts.

6. Review the Gross Margin results.

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.

At any point during planning a Brick and Mortar or Direct channel, you can click Refresh Fulfillment to get the updated cross-channel plan values. These updates will show cross-channel fulfillment and returns impacts such as buy-online, pickup in store; buy online, return to store, and so on.

Seed Plan Sub-Step

The first action that the Merch Plan users complete when creating a new plan is to seed the plan with the Initialize view.

Initialize 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 plan’s 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’s performance, forecast (plus last year’s performance), 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 task. You can also choose what locations and products to seed.

Table 9-1 Merch Plan Measures

MeasureDescription
Seed SourceThe 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. Alternatively, choose the Blank option if you do not want to seed
the working plan.
Seed InfoIncludes 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’s (LY) or Forecast (Fcst) data. You can also choose the blank option if you
do not want to seed the working plan returns.

There are two ways you can seed. You can seed each level individually, or you can seed several levels at once by changing the dimension level shown in the view.

Seeding One Level at a Time

To seed one target at a time, you set the seed source information. Then, to seed the next department in the Product hierarchy within the current channel, complete the following steps:

1. Click the dimension whose value (position) you want to change.

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).

In the cost method of planning, many companies do not plan markdowns, but planning both promotional and markdowns offers a guide to make decisions and keep aging inventory from becoming an issue.

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 use this view to review sales units, Average Unit Retail (AUR), and the Average Unit Cost (AUC).

Direct

This measure profile contains the KPIs for direct-to-consumer channels.

Fulfillment Planning

This measure profile is focused on planning returns which result from Online purchases which are returned to the store. Often a significant portion of those returns are then sent back to the Online Fulfillment warehouses. These returns are rightfully attributed to the Direct channel and impact the net sales.

The restocking costs associated with such returns are reflected in the net gross margin of the Direct channel.

Fulfillment Ly

This measure profile is used to review last year’s financials for sales returns and returns back to online.

1. Salesand Markdowns
vy
£6
Glendar &GAProduct
(0_Measure(1.SalesandMar…»2[<]Brick&Mortara©
>
[x30018ShortSlee

Measure

Calendar

2/11/2023

tT

2/18/2023
+


2/25/2023
tT

3/4/2025
3/
T


11/2023
3/18/2025
¢
tT
Wp Sales R63,495.63126,997.90126,954.22126,958.33126,945.73
127,073.16
Fest SalesR76,316.91152,634.48152,580.38152,586.01152,567.62
152,723.10
WpSalesRvar Fest%-16.8%-16.8%-16.8%-16.8%-16.8%
-16.8%
LySalesR57,723.30115,452.64115,412.93115,416.66115,405.21
115,521.05
Wp Sales R var Ly %10.0%10.0%10.0%10.0%10.0%
10.0%
MPWp SalesR contrib Prod%3.1%5.8%5.3%48%5.8%
6.0%
MP Ly SalesR contrib Prod %2.9%5.3%48%44%5.3%
5.5%
MPWp SalesR contrib Time %1.0%1.9%1.9%1.9%1.9%
1.9%
MPLySalesRcontribTime%0.9%18%18%18%18%
18%
:} W/F-SalesandMarkdowns
vy
£€f
Calendar&0Location
#&f
Product
~

(0
Measure(Default)


wa
[<Brick&Mortar



©
>
ie30018Short SleeveTees


Calendar


2/11/2025

2/18/2023



2/25/2025a
3/4/2023

3/11/2023
MeasureTT‘i
T
sp
Wp W/F
Sales R
38,426.0674,264.4774,103.24
74,134.21
74,170.03
LyW/F Sales R34,932.7867,513.1567,366.58
67,394.74
67,427.30
WpW/F SalesRvar Ly%10.0 %10.0 %10.0 %
10.0%
10.0%
Wp W/F
Net Sales R
38,426.0674,264.4774,103.24
74,134.21
74,170.03
WpW/F NetSales R%100.0 %100.0 %100.0 %
100.0%
100.0%
LyW/F NetSalesR34,932.7867,513.1567,366.58
67,394.74
67,427.30
LyW/FNetSalesR%100.0 %100.0 %100.0 %
100.0 %
100.0%
WpW/FNetSalesRvarLy%10.0%10.0%10.0%
10.0%
10.0%
> Local -SalesandMarkdow
ns [< Brick&Mor
tar
>
[<

3018Short SleeveTe
es
>
Calendar2/12/20222/19/2022
2/26/20223/5/2022
Measure
Wp Sales LR0.000.000.000.000.00
LySalesLR0.000.000.000.000.00
Wp Sales LR var Ly%0.0%0.0%0.0%0.0%0.0%
WpNetSales LR0.000.000.000.000.00
Ly NetSalesLR0.000.000.000.000.00
Wp NetSales LR var Ly%0.0%0.0%0.0%0.0%0.0%
Wp Markdown POS LR%0.0%0.0%0.0%0.0%0.0%
WpMarkdown POSLR0.000.000.000.000.00
LyMarkdown POSLR0.000.000.000.000.00
Wp Markdown POS LR var Ly
ov
0.0%0.0%0.0%0.0%0.0%
WpMarkdown Perm LR0.000.000.000.000.00
LyMarkdownPermLR0.000.000.000.000.00
Note

The adjustments you made to the Sales and Markdowns view are visible in this view if you have clicked Calculate.

There are several measure profiles available to guide you through various approaches to planning inventory and receipts:

  • Cost (Default)

The Cost 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

The most important asset metrics are inventory units and inventory cost because these metrics impacts cash flow. In this view, you can directly maintain EOP inventory, Average Unit Cost, plus shrink, Mark Out of Stock (MOS), and Move to Clearance (MOC) in terms of units.

  • Fulfillment Planning

This measure profile focuses on planning the impacts of Buy Online, Pickup in Store and Buy in Store, and Ship to Customer. These fulfillment methods are relevant because inventory is planned for a channel based on its projected sales. When the sales are attributed to one channel but fulfilled by another, the fulfillment channel’s inventory must reflect the increased inventory need (increased OTB).

  • Fulfillment Ly

This measure profile is used to review last year’s fulfillment metrics in relation to planning the correct placement of inventory by channel.

:} 1.Receiptsand Inventory
vy
£€
Glenda&3Location
gy2
(0Measure(1
.Retail)
+ 2
<
Brick&Mortar
©
>
MeasureCalendar 2/11/2023
T
2/18/2023
‘i
2/25/2023 a
T
3/4/2025
T
3/11/2025
T
WpBOP R4,329,510.684,285,696.274,197,158.004,538,224.604,450,132.20
LyBOPR3,810,227.453,730,575.833,577,772.964,265,484.194,105,086.84
Wp ReceiptsR0.000.00429,446.470.000.00
Wp ReceiptsMU %0.0%0.0%50.0%0.0%0.0%
Ly Receipts R0.000.00429,446.470.000.00
Ly Receipts MU %0.0%0.0%50.0%0.0%0.0%
Wp ReceiptsR var Ly%0.0%0.0%0.0%0.0%0.0%
Wp Net SalesR38,426.0674,264.4774,103.2474,134.2174,170.05
LyNetSalesR34,932.7867,513.1567,366.5867,394.7467,427.30
1. GrossMargin
vy
6
Calendar &
———SE———_——————————E
BG



AllDimensions


ooMeasure(Default)
+ #
«Brick&Mortar
MeasureCalendar2/11/2025
T
2/18/2025
T
2/25/2023
t
3/4/2023
tT
3/11/2025
qt
WpGMR16,907.0432,187.2532,014.5431,814.6531,823.61
WpGM R%44.0%43.3%43.2%42.9%42.9%
LyGMR15,370.0329,261.1229,104.1328,922.4128,930.55
LyGMR%44.0%43.3%43.2%42.9%42.9%
WpGMR varLy%10.0 %10.0 %10.0 %10.0%10.0%
WpVendorFundsR0.000.000.000.00

LyVendor Fu

nds R
0.000.000.000.000.00
Wp RoyaltiesR2,254.424,402.974,460.894,522.944,509.48
LyRoyaltiesR2,049.474,002.704,055.354,111.764,099.53

|o
Calendar|||<Bno|ce
@>)||<S|OMBOTSKE|TTES
@>|| |---|---|---|---|---|---|---|---|---| |we|2/11/2023|,|2/18/2023
.|
2/25/2023|
‘|
3/4/2023
ui|

3/11/2023|*| ||
WpGM LR
||||||||| ||WpGMLR%||||||||| || WpGMLRvarLy%||||||||| |WpNetGM LR
||||||||| ||WpNetGMLR%||||||||| || WpNet GM LR varLy%||||||||| |WpNetSalesLR|||||||||

~ Reviewwith Target
6
Calendar
#& OG
——_TO
AllDimen

sions
Locat
ion#

Produc
t wf

(U0
Measure(Default)
+
#

<
Brick
&Mortar ©>
Calendar1/7/2023
1/1
4/20231/21/2023
1/2
8/20232/4/2023
Measure
Wp Sales R176,922.48159,215.19212,860.69230,046.50244,784.52
TgtSales R0.000.000.000.000.00
Wp Sales RvarTgt%0.0%0.0%0.0%0.0%0.0%
Wp NetSalesR157,981.6693,966.34125,927.83136,369.17144,390.01
Tgt NetSalesR0.000.000.000.000.00
Wp NetSalesR var Tgt%0.0%0.0%0.0%0.0%0.0%
WpMarkdownPOSR66,143.0065,120.0068,200.0076,100.0069,125.00
WpMarkdown POSR%41.9%69.3%54.2%55.8%47.9%
TgtMarkdownPOSR0.000.000.000.000.00

If targets are not published yet, the Tgt measures have no values. If targets have been published or republished by the Merch Planning Manager since you last reviewed them, click the refresh button to reload the latest values. A refresh will reload all data in the workspace to the last committed version, so you must commit all of your plan work first, or it will be reverted to the last point of commit.

Next Steps

If you are reviewing your plans completed thus far but have not completed all subclasses in the department, you must repeat the Create Plan step until the plans for all subclasses within the department/channel are fully built out.

If you have just completed a pre-season plan for the first time:

1. No Location Plans exist yet, so you skip the Review with Location Plan sub-step.

2. Expand the list of steps and select Review and Submit Plan, then choose the sub-step: Submit and Copy Approved Plan.

Follow the necessary actions to submit your plan to the Planning Manager for approval. You may wish to now get started on Location Plan creation however, if the Planning Manager requires the plan to be adjusted, this may impact the work you started on your Location Plans.

If you are adjusting a pre-season plan that has already been submitted for approval:

1. If location plans are created, perform the Review with Location Plan sub-step to understand the implications to Location Plans.

2. Expand the list of steps and select Review and Submit Plan, then choose the sub-step: Submit and Copy Approved Plan.

Follow the necessary actions to submit your plan to the Planning Manager for approval.

3. Perform the Create Location Plan task to make adjustments to any Location Plans that have been started.

Review with Location Plan Sub-Step

This sub-step is performed anytime you make adjustments to the merch Plan after location plans have been created.

Review with Location Plan View

In the Review with Location Plan view, you directly compare Wp (working merch plan) to the current location plan. By comparing the merch plan to the location plan metrics, you can better understand where there are misalignments that need to be corrected. There are several variance measures that quickly guide you to areas of difference.

» Reviewwith Location Plan
6
Calendar
0


L
ocation # G


oO
Measure(1.Wp/LPCp)0
[
< Brick&Mortar©
>
[< 500W
Calendar1/7/20231/14/20231/21/20231/28/2023
2/4/2023
2/11/2023
Measure
WpSalesR176,922.48159,215.19212,860.69230,046.50
244,784.52
204,263.47
LPCpSalesR194,610.62175,359.29234,857.78254,136.25
270,251.31
202,654.67
Wp Sales RvarLPCp%-9.1%-9.2%9.4%-9.5%
94%
08%
WpNetSalesR157,981.6693,966.34125,927.83136,369.17
144,390.01
121,407.33
LPCp Net Sales R173,632.37103,495.60138,923.01150,639.37
159,411.47
120,448.38
WpNet Sales R var LPCp%-9.0%-9.2%9.4%-9.5%
-9.4%
08%
WpMarkdownPOSR66,143.0065,120.0068,200.0076,100.00
69,125.00
0.00
WpMarkdown POSR%41.9%69.3%54.2%55.8%
47.9%
0.0%
LPCpMarkdownR0.000.000.000.00
0.00
0.00
LPCp Markdown R%0.0%0.0%0.0%0.0%
0.0%
0.0%
WpMarkdown POSRvarLP0.0%0.0%0.0%0.0%
0.0%
0.0%

There are several measure profiles in this view to quickly guide you to the plans you wish to review:

  • Wp/LPCp

This measure profile shows the key Working Plan metrics for comparison with Location Plan, Current Plan metrics. Current Plan is a version of the plan that is approved in-season (and is actualized for elapsed/historical periods).

  • Wp/LPOp

This measure profile shows the key Working Plan metrics for comparison with Location Plan, 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.

Review and Submit Plan Step

This step is performed when you are ready to submit your working plan to the Planning Manager for approval.

Review Plan Sub-Step

When you believe you are ready to submit your working plan to the Planning Manager for approval, first use the Review Plan view to make sure the plan meets expectations.

There are several measure profiles in this view to quickly guide you to the plans you wish to review:

  • Wp/Ly (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 Plan step.

  • Wp/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).

  • Wp/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.

Submit Plan Sub-Step

This sub-step is performed when you have built a pre-season Merch Plan for all subclasses in a department for a given channel and period. Submitting a plan copies the merch plans you built in the Wp measures to the Waiting Approval (Wa) measures, and then commits then to the database.

Once committed, the Planning Manager can retrieve those plans and take action reviewing and approving them in the Create Merch Plan Targets Task. The Wa measures are shown in the Submitted and Approved view. These measures initially have zero values.

After the Merch Plans are submitted in this step, those measures are populated with the Wa information.

As a result of completing submission of the plan, the Wp Submit and Wp Submit Info measures are cleared, the Wp Approval Status is set to Submitted, and the Wa Submit Info measure is populated. In addition, your working plan is copied into a Waiting for Approval (Wa) plan.

Submitted and Approved Plan View

In this view, you can verify the plan that is awaiting approval.

In-Season Review and Reforecast Step

The Planner uses the Create Merch Plan task during the In-season to review plans and compares those plans to the season actuals. Planners can make adjustments in the views within the In-season Review and Reforecast step. .

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.

Sales and Returns Sub-Step

After the Pre-season plan, review the Sales Return plan during the In-season process for those departments against targets. This has similar views and measures as Sales and Returns steps from the Pre-season step..

  • Sales and Markdown

  • Local – Sales and Markdown

  • Returns Maintenance Setup

  • W/F Sales and Markdown

Gross / Net Margin Sub-Step

The Planner can use this sub-step to review the margins against the target during the Inseason process. This step has similar views and measures as the Gross / Net Margin sub-step from the Pre-season step.

  • Gross margin

  • Local – Gross Margin

  • W/F Gross Margin

Inventory / Receipts / OTB Sub-step

This step can be used to review the inventory and receipts during the In-season planning. This step has similar views and measures as Inventory / Receipts from pre-season step. Additionally, this sub-steps also has OTB view and projection view.

  • Receipts and Inventory

  • Move to Clearance

  • Open to Buy

  • Weekly In-season Projection

¥ OpentoBuy
6
Calendar BG
Location# Z
o
Measure(Default)

[<
_
Brick&Mortar
>

[< 3018Sh
Calendar 1/21/20231/28/2023
2/4
/20232/11/2023
2/18/2023
2
/25/2023
Measure
WpBOP R
1,224,800.71
1,197,661.681,408,828.491,381,660.30
1,359,726.27
1,316,681.88
Wp Net Sales R
9,490.55
9,465.569,435.9110,548.41
20,734.58
20,690.53
WpMarkdown POS R
5,246.15
5,853.855,317.310.00
0.00
0.00
WpMarkdown POS R%
55.3%
618%56.4%00%
0.0%
0.0%
WpMarkdown Perm R
1,594.64
1,562.591,606.05953.91
2,235.68
2,298.29
WpMarkdown Perm R%
0.1%
0.1%0.1%0.1%
0.2%
0.2%
Wp Receipts R
0.00
118,246.840.000.00
0.00
118,246.84
Wp ReceiptsMU%
0.0%
50.0%0.0%0.0%
0.0%
50.0%
Cp Receipts R
0.00
120,442.920.000.00
0.00
120,105.02
CpReceiptsMU%
0.0%
50.0%0.0%00%
0.0%
50.0%

Projection View

This view contains three measure profiles for analysis:

  • Default

This measure profile displays Reg+Promo, Clearance, and Net Sales and Markdowns and the corresponding inventory.

  • Direct

Key metrics for e-commerce are displayed including traffic, transactions, and returns.

  • Local Currency

If the Local Currency option is enabled, key metrics are viewed in local currency.

In-Season Review and Reconcile Step

The Planner uses the Create Merch Plan task during the In-season to review and reconcile plans against target and review with location plan.

Review with Target Sub-Step

This sub-step can be performed at any point in the planning process when you wish to get a gauge of how the plans thus far measure up to the targets. This sub-step must be completed before submitting your proposed plan to the Planning Manager.

Review with Target View

The Review with Target view contains the Planning Manager’s Target (Tgt) measures as well as planning (Wp) measures. Use this view to compare the Tgt measures to the corresponding Wp measures. By comparing the targets to the planning metrics, you can better understand what your plan needs to achieve. There are several Tgt-to-Wp variance measures that quickly guide you to areas of difference.

Review with Location Plan Sub-Step

This sub-step is performed anytime you make adjustments to the Merch Plan after location plans have been created.

Review with Location Plan View

In the Review with Location Plan view, you directly compare Wp (working merch plan) to a location plan. By comparing the merch plan to the location plan metrics, you can better understand where there are misalignments that need to be corrected. There are several variance measures that quickly guide you to areas of difference.

There are several measure profiles in this view to quickly guide you to the plans you wish to review:

  • Wp/LPCp (Default)

This measure profile shows the key Working Plan metrics for comparison with Location Plan, Current Plan metrics. Current Plan is a version of the plan that is approved In-season (and is actualized for elapsed/historical periods).

  • Wp/LPOp

This measure profile shows the key Working Plan metrics for comparison with Location Plan, 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.

In-Season Review and Submit Plan Step

Use this sub-step is to review the core plan and submit the plan.

Review Plan Sub-step

Use the Review Plan sub-step to review your core plan metrics with the current plan, the original plan, and last year’s actuals.

Review Plan View

There are several measure profiles in this view to quickly guide you to the plans you wish to review:

  • Wp with Ly (Default)

This measure profile shows the main Working Plan metrics for comparison with last year metrics.

  • Wp with Cp

This measure profile shows the main Working Plan metrics for comparison with Current Plan metrics. The Current Plan is a version of the plan that is approved.

In-season (and is actualized for elapsed/historical periods).

  • Wp 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.

Submit Plan Sub-Step

Use this sub-step is to submit, approve, and verify the plan.

Submit and Approve Plan View

In this view, you can submit the completed merch plans for approval by the Planning Manager. You can also view the approval status of a submitted plan in the Wp Approval measure. If the status is rejected, you need to go back to In Season Review and Re-project to make adjustments. After you have completed your adjustments, you will have to resubmit the plan. This copies the adjusted Wp to Wa for the Planning Manager to approve.

Once approved, perform the following steps to copy the approved plan.

Submit a Plan

To submit a plan for approval by the Planning Manager:

1. Select the check mark in the Wp Submit measure.

2. Optional: Enter information about the working plan in the Wp Submit Notes field.

3. A success message is displayed. Click OK to close it.

Note

The planning manager determines the point when the pre-season planning process has been finalized and will lock down Op. When locked, you will only be able to submit for approval and promotion to Cp.

As a result of completing submission of the plan, the Wp Submit and Wp Submit Info measures are cleared, the Wp Approval Status is set to Submitted, and the Wa Submit Info measure is populated. In addition, your working plan is copied into a Waiting for Approval (Wa) plan.

Submitted and Approved Plan View

In this view, you can verify the plan that is awaiting approval.


In this guide