SPP IMG Setup: Inventory Planning

Introduction

This post will describe the different settings for inventory planning. All of these settings are underneath the Inventory Planning folder in the IMG under SPP. They are in the same sequence as is found in the IMG.

Define Service Profile for Destocking Decision

Used by PSM during the planning run for dstocking decisions. The planning run determines whether the replenishment indicator is changed for a location product and set to “Non-Stocked”.Very simple entry:

Fields: Service Profile, Time Series ID for Historical Data, Stk New P

Define Service Profile for EOQ/SFT Calculation

Service Profile, Adjust Push, EOQ Per. PL, SFTafterTL, EOQ Per PL, Additional Safety Stock, Actual Forecast, Time Series ID for Forecast Data, Inventory Planning Time Series, Time Series ID for Historical Data, Rounding Profile, DRP PLT, RngBigPack, O DEPT SFT, EOQ VCL = 1, No Man App, Key Figure, An Source.

Define Service Profile for Recommended Storage Quantity (RSQ

Used by PSM during run to determine recommended storage quantity. Stored in product master.

Fields: Service Profile, W Fix Demand, Horizon, Time Series ID for Forecast Data,

Define Service Profile for Cycle Counting Classification

Used by service in PSM for cycle count classification. Relative value of the stock is compared to the stock value for all products at the location.

Fields: Service Profile, Lower Limit %, Upper Limit %

Define Service Profile for ABC Classification

Used by PSM during planning run for ABC classification. ABC is stored in product location master.

Fields: Service Profile, TDL Time Series ID

Define Limit Value for Replenishment Indicator

Stated in terms of a percentage of warehouse stock.

Fields: Attribute, Percentage

Define Exclusion Reasons for Location

Why locations are removed from the stocking de-stocking run. This means that locations can be taken out of the entire process. That is some locations can be run on for stocking and de-stocking, while other locations can determine their stocking more holistically.

The more stocking-de-stocking is used, the better the planning performance however.

SAP Easy Access menu under Advanced Planning and Optimization -> Service Parts Planning (SPP) -> Planning -> Inventory Planning -> Stocking/Destocking -> Location Exclusion Rules.

More details on this can be found here:

http://www.scmfocus.com/sapplanning/2008/09/29/spp-stocking-and-destocking/

Fields: Location Exclusion,Description

Set Up Decision Tables for Stocking/Destocking

Fordefining decision tables for stocking/ destocking

Connected to this view in SAP Easy Access Advanced Planning and Optimization -> Service Parts Planning (SPP) -> Planning -> Inventory Planning -> Stocking/Destocking -> Decision Tables for Stocking/Destocking.

Fields: Table ID, Description, Attribute, Prod Group Type,

Assign Inventory Planning Type to Forecast Strategy

Assigns forecast model types and forecast types to the forecast strategies used in the forecast. The forecast strategy must be determined when creating a forecast. This is where the assignment takes place.

The types are listed below.


SCM-APO Lot Size Definition

What is Covered in this Article? 

  • The definition of lot size.
  • How lot size is used in SCM-APO.
  • What are some approaches to setting lot size.
  • How lot sizes are often set in reality. 

Definition

Lot size is one of the most important concepts in supply chain management. While doing some research I was looking for an online definition of lot size. I was disappointed in what I found, so I thought I would write a post on the topic. Let us start with the definition I developed. As this site is dedicated to software, the definition will have a software orientation or bias. It applies to SAP SCM-APO, but applies equally to any supply planning application.

The lot size is the order batch quantity which is implemented in the system to control and conform production orders and purchase orders to the objectives of the company. The lot size prevents orders from being created in non-economic quantities, and serves to batch orders. - Shaun Snapp

Finding a Good Definition in the Literature

However, it is often beneficial to check several definitions to get a full idea of a topic. Of the books I am familiar with, I like Marc Hoppe’s chapter on lot size in “Inventory Optimization with SAP,” the best.

Hoppe’s Explanation

Hoppe explains the lot size well as a trade-off between inventory management and production or between inventory management and procurement. I have a graphic below, which is a common graphic for lot size it demonstrates the relationship as two points of emphasis fighting against each other, with the best solution being somewhere in the middle.

Understanding The Basic Concept of Lot Size: A Formula of Tradeoffs

Both production and procurement incur costs per procurement order or per manufacturing order. Meanwhile inventory management incurs holding costs for inventory, and of course sales incurs a cost of a lost sale if too little inventory is carried. Because lost sales are not quantified by many companies, this cost tends to get overlooked, however it is a real cost and efforts should be made to quantify its cost. This can be as simple as having order takers enter order requests that are made but can not be fulfilled.

An additional cost which is often not considered is the transportation cost – inventory management cost trade-off. As explained in the book “Managing the Supply Chain,” larger orders incur a smaller per unit transportation cost — generally.

What is Meant by the Term “Economic” with Respect to Lot Size

Generally speaking, when different costs are used to derive a lot size, the lot size is said to be “economic.” This is only one of many ways of determining lot size. Other methods include:

  • ABC Guidelines (where A items may have 1-5 days of supply, while B items may have 20 days of supply – this method is strongly financially driven)
  • Manual discretion

How Lot Sizes are Often Set in Reality

Optimally, and industry is far away from optimality, the lot size – which is the order amount should be determined by the trade-offs between inventory holding costs and production and procurement costs. This is called economic lot sizes rather than deterministic lot sizes. Deterministic is a fancy operations research term meaning predictable or static.

Reality

What happens in reality is quite embarrassing, as executive compensation driven by short-term stock options promotes many companies to run with too inventories that are simply too low, often times justified by Lean consultants as a “best practice” or by various Lean initiates internal to the company. The following post describes some of the problems with the application of Lean to supply planning.

http://www.scmfocus.com/failedsupplychainconcepts/2009/11/does-lean-make-sense-for-supply-chain/

A second reason economic lot sizes are not used is because they are more complex to implement than static lot sizes. While this discussion is outside of the scope of this article, it is important to note that the academic or strictly technical approach to inventory control is not applied at very many companies.

SCM

In SCM-APO as with other supply planning applications, the lot size approach has a tremendous impact on the results of the plan. It is one of the major ways of creating order batches that are economical. I have seen several occasions where an overemphasis on configuration and detailed planning has been placed into SCM, only to have the output disaggregated by overly small lot sizes. It’s important to get the different parties on board with the lot size selected. Lot size discussions and meetings are intensely political, but they must be held. Taking say, just inventory management’s view into account in order to reduce argumentation (which I have seen done) is not going to result in a happy and accepted SCM implementation. In fact, no matter how esoteric and pliant the SCM configuration, without cross departmental agreement on the simple lot size, implementations have a serious problem with buy in.

Dynamic Lot Sizes

Because of the issues related in the paragraph above, dynamic lot sizes make a lot of sense. In fact, unless the project is quite limited in its budget, the only justification for fixed lot sizes I can see are for minimum order quantities (such as pallets) or supplier minimum quantities that are larger than the economic based lead times would recommend. This condition is far more common in service parts, so for finished goods planning, dynamic lot sizes should be the rule.

Economic Lot Sizes

The difference between economic and dynamic lot sizes can be confusing. Both are desirable. However, and economic lot size simply means that the trade offs between inventory and stock out costs and production and procurement costs have been calculated. However, dynamic lot sizes simply mean that the lot size value is changed over time. It does not mean that the lot size was quantitatively determined with any consideration for economic order quantities. The ultimate desired state is to have lot sizes that are both dynamic and economic. One perfect example of the benefit of both economic and dynamic lot sizes is in the event of price changes or temporary discount. Without the ability to have economic and dynamic lot sizes, companies either lose the ability to take advantage of temporary discounts, or must rely upon their planners to manually increase the order quantities.

Lot Size in Cost Optimization

There is a particular way that the lot size can be adjusted in the SNP cost optimizer. Not wanting to make this article too long, I have included the link to how this works in the post below:

http://www.scmfocus.com/sapplanning/2011/11/05/how-soft-constraints-work-with-soft-constraints-days-supply-and-safety-stock-penalty-costs/

Lot Size in SAP ERP and SCM

Both SAP ERP and SCM have lot size fields. Since only critical materials should be planned in SCM, all other non-critical materials will go out on the lot size entered into he SAP ERP Material Master. For those items planned in SCM, the value entered in the Lot Size Unit field of the Product Master overrule any value that is entered in SAP ERP.

Here is the tab for lot size in the SCM Product Master


However, in addition to the Product Master, lot sizes can be set in the PPM.

Fixed lot size: The SNP optimizer considers the value you specified for the fixed lot size as the minimum lot size. Every time the PPM is executed, the PPM output quantity (the output component quantity) corresponds to this fixed lot size. – SAP Help Super Advanced Lot Sizing and SNC

Conclusion

Lot sizes are one of the major master data elements to SAP SNP, and to supply planning and production planning systems generally. At a high level the lot size is a value that prevents the company from procuring or producing in quantities that would not be economic. However, there are a variety of ways of setting the lot size.

References

http://books.google.com/books?id=d9yLF6HG9asC&pg=PA85&dq=lot+size+supply+chain

http://books.google.com/books?id=v3TyIkU5aScC&pg=PA2&dq=lot+size+supply+chain

http://books.google.com/books?id=dUKGHB_YjFQC&pg=PA36&dq=lot+size+supply+chain

http://www.amazon.com/Inventory-Optimization-SAP-Marc-Hoppe/dp/1592290973

http://help.sap.com/saphelp_scm41/helpdata/en/fc/217d3cf7ffd118e10000000a11405a/content.htm

 

SPP Planning Profiles

What Are They?

Profiles are one of the most important configuration items in SPP. They control the data that is selected, the services that are used. Furthermore, SPP profiles are different that other areas of APO-SCM in that they allow you to access functionality outside of SPP. This is quite different from the traditional development path of APO-SCM

Configuration and the PSM

There is a lot to configure just in the profiles related to the Planning Service Manager. The Planning Service Manager is a centralized location where the functionality in SPP is kicked off. The services contain the functionality while the profiles constrain the functionality to specific areas.


The Process Profile sets up what area of SPP or the supply chain is being planned. This is much different than the other modules in APO because SPP can plan across the supply chain aside from production planning.


However, these are just a few of the profiles that have been created. The process profile is built on top of the various planning services. If we create a new process profile we obtain the following.


You can see there are a tremendous number of process profiles to choose from. Each of them are a different way of of controlling the system. There is a lot to discuss here and we will cover in greater detail at a later date.


CIF Change Pointers and Transactions

sap-change-pointers.jpg
CIF Change Pointer The CIF change pointer lists any inconsistent objects it identifies. Here is the path.

Advanced Planning and Optimization – APO Administration – Integration – CIF Compare Reconcile Function – Execute Compare Reconcile

The path for setting background jobs for master data transfer is the following

ECC – System – Services – Jobs – Define Jobs (SM36)

Next enter program RIMODGEN

With master data changes, the system can transfer just the master data records. For a transfer of data changes, you must set in customizing in the SAP ECC system that ALE change pointers are written for master data changes. First you activate change pointers (BD61)

In order to initiate real time transfer of master data change, use the following transaction…

(CFC9)

Integration Model Organization

There should be an organized manner that will make master data integration efficient and concise. SAP recommends organizing the integration models according to the following list:

  1. ATP Customizing and product allocation customizing
  2. Plants
  3. Characteristics and classes
  4. Material masters and characteristics and classifications
  5. MRP area
  6. Planning product
  7. Availability check
  8. Product allocation
  9. Customers and suppliers
  10. Work centers
  11. Production Process Models
  12. Scheduling agreement and contract and purchasing info records

Important Features of the CIF

  • In the CIF you can specify in the integration model that the ATP check in the sales order is to be performed in APO rather than ECC.
  • (PP/DS) The lot size always indicator is set in the APO product master and if you do not set the indicator, a lot for lot order quantity is always used in make to order planning and the system ignores additional constraints. This indicator is transferred via the CIF.
  • When data is brought over to SCM via the CIF it is automatically assigned to the active model (000).
  • Inactive models, including any model that we generate, is only used for strategic planning. Planning that has results CIFed back to ECC is only in the active version, hence the name. Also changes to the inactive models can not be copied to the active model, only changes to the active model can be copied to the inactive.
  • Even small changes to master data are copied over to the receiving system in an incremental fashion. However, this must be configured properly for SAP to do this. Change pointers must be activated in ECC with transaction (BD61).

We can carry out the real time changes for the following master data elements with the transaction (CFC9)

There is a program that will setup auto data movement for when Material Master, Customer Master or the Vendor Master are created or changed.

In the entry screen you should insert (RIMODGEN) for creating integration models, the variant, counter,

Changes to the PPM or production process model can be setup with transaction (CFP3).

Reference

SCM215 Integrated Master Data in SAP SCM

SCM212 Integrated Supply Chain Model

SCM250 PPDS

cif-target-system-settings-in-cif.jpg

cifmodgen-program1.jpg


Resources

Resources
A production resource is one type of resource, however, there are several different types, all of which enable constraint based planning.

General Background on Resources and Constraints

Resources are interesting. They are an approximation of a work center in ECC. However, if you decide to let SCM do the planning, it is not necessary to maintain work centers in ECC. Therefore, you perform your constraining in SCM. This is what resources (and work centers) are. They constrain the capacity of the system. The supply chain system is constrained in real life of course, however, adding resource to the mix allows you to model those real constraints.

To find out more about constraints — the concept that underpins resources, see this post.

http://www.scmfocus.com/sapplanning/2009/06/30/constraints/

Constrains have some natural problems, one of the biggest being that reality moves much more quickly then computer constraints can be updated to reflect reality. Therefore, constrains based modeling will never be perfect, but it is better than non constraining.

Resources in SCM

When one thinks of resources or work centers, production planning immediately comes to mind. However, resources can be setup for storage, handling units and transportation as well. Resource types are described here:

http://www.scmfocus.com/sapplanning/2009/05/02/scm-resource-types/


Different Resources for Different Modules

Different resources apply to differnt modules, although some are used by multiple modules. For instance, PP/DS and SNP share a number of resources. To read how different resources apply to which modules, see this post.

http://www.scmfocus.com/sapplanning/2009/06/30/resources-by-scm-module/

Multi-Mixed Resource

Resources are complex and have a lot of setup in them. Below we have configured a multi-mixed resource for handling. We have created 5 different resources that go to 5 different locations. Notice towards the bottom. This is one of the most important fields to check. “Finite Scheduling” is what calls the resource to use the limits entered to restrict the use of the resource to what is available.

SAP Easy Access –> APO –> Master Data –> Resource –> Resource (aka /n/sapapo/res01)

Here is a production resource.

Here are a series of handling resources.


Bucket Resources

Most of the resources are setup related to a time component. However, the bucket resource constrains quantity. Therefore, a resource could say process 100 packages in a day. Its a different way of modeling.

Resource Downtime

Here you can see we have selected the Downtime tab and we have created a scheduled maintenance (which applies for only the resource I have selected when I create the downtime.). During this time no load can be placed on the resource.

One major issue with this transaction (and we noted it in the post on Transportation Resources) is it can’t find a resource we just created in order to edit it. However, once we goto Locations (/SAPAPO/LOC3) we are able to add the resource to the location.


Managing Resource Complexity

What helps take control of resource complexity is really two things. One is resource types, which are the tabs in the screenshot above. The second is resource capacity variants, which allow the creation of saved variants or versions of configured variants. This way, once a resource variant has been configured and it is the agreed upon way for the company to manage a resouce, it can be used as a template to create future resources.

To read more about capacity variants see this post.

http://www.scmfocus.com/sapplanning/2008/09/19/scm-resourcecapacity-variants/