Inventory Balancing Costs and Benefits in SPP

Background

Various costs are benefits are combined to determine if a product should be repositioned to a new location. I have graphically setup these costs and benefits in the post below.

You can read more about inventory balancing here.

http://www.scmfocus.com/sapplanning/2009/09/30/difference-between-the-snp-deployment-optimizer-and-inventory-balancing/

http://www.scmfocus.com/sapplanning/2010/09/05/spp-img-setup-inventory-balancing/


Inventory Balancing Parameters in SPP

Background

These settings control whether and with what propensity stock is moved between locations.

/N/SAPAPO/RDPLPRF takes us to this screen. This is a profile that can be applied to a inventory balancing. It controls when an item should be considered “in excess” and when when it should be considered “short.”


/N/SAPAPO/RDPLPRFA takes us to a screen where this profile can be assigned to the planning version, area (location). So different profiles can be applied to different locations, meaning that each location can have its own profile, and thus propensity for movement or being relocated.


Serious Problems With Inventory Balancing Configuration in SPP



I did not know I was in for such a perplexing time simply trying to configure something that should be simple.

Background

Inventory Balancing is the movement of inventory which is already in the supply chain in order to more efficiently use already deployed stock. It is one of the most important capabilities of service parts planning, although the functionality is not unique to service parts.

The master data configuration setup does not make a lot of sense, also setting up the necessary relationships is filled with glitches in SPP.

SAP Development

SAP has created one of the worst configuration areas I can ever recall using. It is completely unnecessarily complex and little things, like accepting a dummy location as the top level in the inventory balancing area is a problem. I have had to use mind mapping software just to understand the unnecessarily convoluted connections between objects. It is difficult to see why any of this is necessary. With inventory balancing you simply need to identify the locations for which you want the balancing to occur. That should be a simple list of location. There is no reason to create a dummy location The creation of hierarchies is also unnecessary. Hierarchies are for DRP and setup parents an children, inventory balancing does not work like that – hierarchy is irrelevant, it simply comes down to supply vs. demand with costs limiting the movement of items (transportation, warehouse space savings, etc…). Instead all locations (within the defined group of locations) can send to any other of the locations in the defined group. This is apparent to anyone who understands how stock repositioning is performed.

Difficult to Change

In the screenshot below I am missing a parent dummy location. I would like to add one, and move the SUPPL01 to SUPPL04 underneath it. You can see because every location is listed as the first level of the hierarchy, every location is a inventory balancing area, which is not what we want. However, there is no facility to make this change. So this means I will have to delete these entries and add them again.



When I add them again, I will have to set the level in the hierarchy that I want by entering a value in the level field. So I need to delete all of these entries and re-add. However, there is a problem, the Level field entry does not activate.



How then can a different level in the hierarchy be created? It turns out with a right mouse click on the location (something I remembered doing a year ago when I was configuring this, but forgot).



What I am doing can be so easily represented by a plain CSV file that it is absolutely ridiculous. For companies looking to implement SPP, it should be obvious what this means…..extremely high costs for just elementary setup to be performed. Mind you, we are not into any functionality yet, just trying to setup some elementary network design master data. Don’t agree with me that this setup is onerous, ok let’s move to supersession.

Supersession

I spent several days documenting the supersession functionality which can be seen in the following posts:

http://www.scmfocus.com/sapplanning/2010/09/05/spp-img-setup-supersession/

http://www.scmfocus.com/sapplanning/2009/04/18/spp-supersession/

The configuration complexity with regards to supersession functionality goes on and on. You can read about it these posts above. However, does supersession configuration have to be so circuitous. Lets see how the leader in service parts planning does it. MCA Solutions has the different supersession types (normal, version, exception, included parts explosion), and they have a coding for whether the supersession will be one way or two way. There is not more than a few tables used, and these are all explicitlylaidout in their interface specification. And that makes sense. All that is necessary is a list of parts that have supersession relationships with other parts, some dates which describe when the new part will take over for the part, coding for whether the relationship is one way or two way, and voila, you have the necessary configuration to incorporate supersession into a planning engine. Now of course the planning engine code must act on that configuration, and I am not saying that part is a piece cake, here I am only speaking of the data that is necessary to be setup. Why SAP has turned this basic feature into a two day exercise to document is beyond me.

Conclusion

SAP development needs to clean up SPP because the present design has many area that are illogical and a degree of implementation complexity that can result in aborted go-lives. SAP must understand that location groupings for inventory balancing must be able to be flexibly changed as well as the fact that supersession relationships must be easy to update and change. SPP has problems in other areas such as its leading indicator forecasting (causal forecasting) which has an unresolved issue which has not been addressed.


SPP IMG Setup: Inventory Balancing

Introduction

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

Make General Settings for Inventory Balancing

Confirm stock transport orders: If this indicator is set, the stock transfers are displayed for manual check.

Hierarchy structure for areas: The inventory balancing areas are created as a location hierarchy of the specified hierarchy structure.

Schedule Orders Forwards and Backwards: If you set this indicator, the system schedules stock transport orders (STOs) forwards first, and then backwards. – SAP Help

Below is the screen and also the options for the Hierarchy Structure for Inventory Balancing Areas. As you can see, many of these are related to other module, but for SPP, one of the SPP BODs should be selected. In this case there is only one in the list.


Define Service Profile for Inventory Balancing

Threshold value for cost-benefit analysis: If the benefit of a stock transfer at the specified threshold value is higher than the costs of this stock transfer, the stock transfer is carried out. DRP Service Profile: Inventory balancing uses the DRP matrix for planning calculations. You can assign each inventory balancing service profile a special DRP service profile.” – SAP Help

This connects up the DRP Service Profile with the Forecast Time Series ID, the Cost Benefit Threshold and the Forecast Time Series ID.

Define Warehouse Space Savings Storage Type

With this WSS storage type you can specify the average warehouse utilization and the savings per free-up of a bin for each location from the SAP Easy Access Menu under WSS Storage Type per Location. In the master data you can then assign WSS storage types specified in this IMG activity to location products. – SAP Help


This is a very simple entry, simply naming a storage bin type.


How Does SPP and SNP Handle Soon to Expire Products for Redeployment

Background

I have recently been analyzing using Inventory Balancing functionality in SPP, and the Deployment Optimizer in SNP in order to redeploy inventory. SPP Inventory Balancing is explicitly designed for this, while the SNP Deployment Optimizer is not (rather it is designed to move material out from parent locations to child locations in conditions where there is an overage or underage of material). However, I have been attempting to see if the Deployment Optimizer can be adjusted for this task. What I have found is the redeployment capability is significantly below third party application. And one area that we have analyzed is the ability to redeploy different types of stock differently. In fact, I have not found any evidence that the Deployment Optimizer has been used at any client for redeployment. Some consultants who are not familiar with redeployment like to pretend that deployment and redeployment are the same thing. This is convenient for them if they are SNP consultants as deployment is really all that SAP SNP has to offer.

Here is roughly how deployment is different from redeployment.

Click the image to enlarge.

Soon to Expire Stock
For the category of stock that is coded as “soon to expire” the solution selected must be able to reduce the threshold for redeployment so that the material can be repositioned to a location where it can be consumed rather than written off.

The Burnout Threshold

Other software calls this the Burnout threshold and is easily adjustable. We are not surprised that the SNP Deployment Optimizer does not have this, because it is not designed for redeployment. However, we were surprised to find no such functionality in SPP. The closest that we could find were fields related to the warranty end date, recall start date and the goodwill start date. These fields are related to providing a signal to the system to treat the inventory differently during redeployment. They are not the same as burnout threshold which is a very useful concept that exists in third party applications.


Difference Between the SNP Deployment Optimizer and Inventory Balancing


What Are the Differences?

We were recently asked what are the differences between the deployment optimizer in SNP and inventory balancing in SPP. Before going into to much detail its important to read up on each of these areas of SCM if you are not familiar with them.

Inventory Balancing

http://www.scmfocus.com/sapplanning/2009/04/23/inventory-balancing-in-spp/

Deployment Optimizer

http://www.scmfocus.com/sapplanning/2009/07/30/deployment-explained/

Transportation Lanes

Something which is critical to both is transportation lanes, and their maintenance, for which we have a post on this topic in terms of mass maintenance here.

http://www.scmfocus.com/sapplanning/2008/09/14/snp-transportation-lane-and-transportation-resource-setup/

This makes the deployment optimizer and inventory balancing usable, because they can setup a large number of transportation lanes quickly with mass maintenance. However, they must be changed and adjusted as locations are added or deleted.

Differences

  • SPP Inventory Balancing has more fields that control the redistribution of materials. For instance, the warranty start date and the recall start date as well as the production end date. These are critical for service parts, but much less so for finished goods.
  • SPP inventory balancing can be run from the Planning Service Manager. This is an easy way to schedule services in SPP (but also in other SCM modules).
  • Through the use of the inventory area, SPP can treat multiple locations as a single location.
  • SPP has more ability to set warehouse space savings per location.
  • The deployment optimizer takes into account (capacities such as handling, transportation, storage, capacity) as well a prioritization related to costs and prioritization.
  • Deployment works off of

Open Question

One open question we have is how powerful is inventory balancing compared to the deployment optimizer? Aside from more fields is it more powerful in terms of its ability to see many different locations?