Skip to Content
Author's profile photo Ina Glaes

Are you looking for fast business value with SAP Planning for Retail? – PART 3


This is the third and last part of the SAP Planning for Retail rapid-deployment solution blog series (click here for the 1st blog and here for the 2nd blog), and today we take a closer look to the most important steps in the second key process delivered via the package: the merchandise planning.

Let’s start with a short recap:

In the blog about channel financial planning we started with the sales side of the planning, and we ended with the merchandise mix including already inventory related KPI’s on division and department level.

Let’s assume, that the channel financial plan is now agreed on all levels and the next step, the merchandise plan can start.

The goal of the merchandise plan is to provide a plan broken down to the lowest levels of the merchandise hierarchy to build a receipt budget by week that is used for open-to-buy purposes. KPIs include, but are not limited to, markdowns, reductions, and inventory and above/below the line adjustments to gross margin, receipts and inventory. Plans are usually developed in value with average unit retail prices for inventory, receipt and sales added to understand unit volumes at a high level. The sales flavors regular, markdown, promotional and clearance sales KPIs are planned individually including the average retail price of the sales type. In-season plan updates recalculate open-to-buy budgets based on trend. With that the analysis of business trends to identify variances to plan are possible on a weekly basis and allow stakeholders to take action.

Merchandise Planning – OTB and Unit Flow Plan

The merchandise Planning includes several workbooks for the different levels of the article hierarchy. The workbooks look very similar, but addressing different roles in the organization, like VP of Planning, Planning manager, merchandise manager, or however your organization is set up. One very nice feature is, that the solution provides you flexibility depending on your set-up, if you have planners for all the different levels (you remember: division, department, class and subclass), or if you just want to plan for example on division and break it down from there to class and subclass. 

All workbooks consist of two worksheets – one for open-to-buy plan and a second one for the unit flow plan based on average unit costs.

It’s possible to distribute – in case you prefer the top-down approach, or to aggregate data between the different levels via predefined planning functions.

Bildschirmfoto 2013-08-07 um 16.46.08.PNG

Screenshot Merchandise Planning

Assume now, that the first round planning is done on all levels. With the Reconciliation Report, you can reconcile merchandise open-to-buy plans against merchandise financial targets. In case of deviations, the plans can be adjusted accordingly.

And finally, the report allows you to release the Open-to-buy, markdown budget and promotion budget to e.g. ERP for execution. With this step you finished the pre-season part of the planning process.

Bildschirmfoto 2013-08-07 um 16.47.20.PNG

Screenshot Merchandise Reconcilitation

Now time passes by, you are executing on the plan, you are placing purchase orders, getting goods receipts and you are selling your goods. Now you would like to know, how you do against your plan and if you need to take actions to reach your company goals.

You can use the weekly updated in-season plan to review plan versus forecast and to adjust plan accordingly to your corporate objectives, anticipated order deliveries, approved markdowns and promotional activity.

This version, containing the actuals from the already past weeks and adjusted forecast for the remaining weeks of the year is also a very good starting point for next years planning. And so the cycle starts again.

Let me summarize the key advantages of the merchandise Planning. With this process, you are able to reduce need for markdowns, reduce out-of-stock and over stock rates, you are able to analyse business trends weekly to identify variances to plan, and you can react on that!

So, now we covered also the second key process of SAP Planning for Retail rapid-deployment solution and have reached the end of this blog series. I hope you learned a lot about this package and see the benefits like predefined business processes based on industry best practices, fixed scope, fixed time and fixed price, extendible – a perfect starting point for your project in retail planning.

Follow SAP Rapid Deployment Solutions on Twitter: @SAPRDS

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Palani Paramasivan
      Palani Paramasivan

      HI Ina,

      Thanks for writing such a wonderful and informative blog.

      I would like to know how the plans are communicated to the downstream ECC system , however i dont see a Release workbench for budget, assortments, Products release etc, like MAP

      Author's profile photo Ina Glaes
      Ina Glaes
      Blog Post Author

      Hi Palani,

      thanks for your feedback!

      This RDS covers "only" the channel and merchandise planning, but not the assortment planning. So also products release etc. is not part of this package.

      Author's profile photo Former Member
      Former Member

      Thanks much Ina,

      We understand that Planning for Retail now supports Financial & Merchandise plans. But, the SAP note 1820440 clarifies that budget integration to ECC is possible, and the aggregation levels of sales have also been altered based on the new additions from Planing for Retail. So, when a few things have been modified based on inclusions from RDS, is there a reason that assortment planning has been skipped?

      Has SAP implicitly advised not to use Assortment planning and to put forth more focus into financial planning only, or do we expect to see it in the next releases?

      Author's profile photo Ina Glaes
      Ina Glaes
      Blog Post Author

      Hi Raghu,

      thanks for your question.

      SAP Planning for Retail only covers the channel and merchandise planning. The SAP solution for assortment planning is still SAP Merchandise and Assortment Planning (MAP).

      I hope this answers your question.

      Author's profile photo Former Member
      Former Member

      Hi Ina,

      We're working on an engagement with a retail customer that has already purchased SAP Planning for Retail. Now, having placed all resources from the market place, documents into the system landscape, we're now left with identifying the templates/workbooks/test data upon which a sample demo could be executed.

      What we really do find from Solution Manager is the Template Description document, but not the template itself. Could you help us locate these workbooks or templates, or give us a hint about identifying the right point of contact?

      P.S - We've installed all basis settings!

      Thanks & Regards

      Raghu Sharma

      Author's profile photo Former Member
      Former Member

      Hi Ina,

      We're facing one issue - "Could not access system VB3 for data source Financial Plan" when we try to open the workbooks from Netweaver after saving them in SAP netweaver. Could you suggest any solution?

      Thanks & Regards

      Raghu Sharma

      Author's profile photo Former Member
      Former Member

      Hello Ina-    

      Great postings.  I am looking to install Retail Planning - Merchandise Planning but first need to create a Scope document.  Where can I find the scope for the RDS for  Merchandise Planning?