Troubleshooting SNP CTM

Background

CTM has an enormous number of settings. There are more settings and more areas of customization than either the cost optimizer or the SNP heuristic (unlike PP/DS SNP only has two heuristics – one for the initial plan, and one for capacity leveling. The details of some of these settings are explained in this post.

http://www.scmfocus.com/sapplanning/2008/09/18/ctm-profile/

CTM is often considered a constrain based planning modality. For instance, in this exchange on CTM, a statement is made that CTM is simply finite by design.

http://forums.sdn.sap.com/thread.jspa?threadID=785283

In fact, CTM can be run with or without resource constraints. The control for this is in the Basic Settings sub-tab of the Settings tab of the CTM Profile.

When the PPM/PDS box is checked, it excludes any PDSs or PPMs that are in the system, and the system simply no longer creates production orders. Additionally, the External Procurement can also be turned off so that only in-house production is selected.

Turning Off PDSs and PPMs

The reason for this is that PDSs and PPMs can have problems with them that prevent CTM from creating logical output. When essentially you turn off production, you can check to see if CTM provides logical output without the complexity of the PDS/PPM. For instance, on a recent client I did this with another consultant, and still found a problem with CTM not addressing past due supply shortages. This needed to be rectified before we began testing the PDSs/PPMs. Constraint based planning is difficult and there are many business, data maintenance and other technical issues with maintaing both resource information and PDS/PPM information. Most companies that attempt constraint based planning, who do not have significant experience in maintaining this type of information often have to go back to infinite planning. Therefore its important to first be able to run the supply plan in an unconstrained fashion, and then after this is being performed correctly, to migrate to constraint based planning. The SNP Heuristic does not require any resource constraints and is a good place to begin before moving to full constraint based planning.


Resource Variability Capabilities in SCM


Managing Resource Variability

When the topic of resources comes up on projects invariably the question arises how the resource can be made flexible to account for the constantly changing factors in the supply chain.

One way of dealing with constraints that are constantly changing is with the use of capacity variants. Variants allow SCM to modify resource capacity by time of day, by week, or by month. This can help in making the resources “flex” through time to match the reality of the supply chain. Different capacity variants can be used for different planning runs. A second method is using alternate production process models (PPMs) which means using different capacity constraints. Jorg Dickensbach has the following to say on this topic.

In addition to alternative PPMs and PDSs, SCM has the ability to use alternative resources. This allows the system to select from say one machine that is more expensive, but faster vs. a machine which is less expensive but slower. Depending upon the circumstance, either machine can be selected depending upon how it fits the need. - Jorg Dickensbach

Willingness to Maintain the System Master Data?

A second issue which is not very often discussed is how capable companies are in maintaining these constraints. The answer is not very. Most companies I have consulted with basically want the system to maintain itself, and the trend towards outsourcing system maintenance in faraway locations where the individuals are purely technical, and lack business knowledge is only exacerbating the situation. The best systems are those that are self adaptive. I have a video from the CEO Joseph Shamir on this topic from the SCM Focus Inventory Optimization and Multi Echelon site in which I think he expresses very well that clients want in terms of maintainability.

Title: Joseph Shamir of ToolsGroup on What Clients Are Looking For

So we learned from Joseph that demand shaping is one thing that clients are asking for. Also that there is a recognition that many supply chain planning systems end up being difficult to maintain. As a personal comment I think Joseph is absolutely right, and I hold the consulting firms as accountable as the the vendors as many solutions are designed without consideration to whether they will be truly sustainable. Its good to see a vendor with an eye on this issue.

Unfortunately SAP APO/SCM is not there yet. SCM requires a high degree of maintenance in all of its master data.

MDM to the Rescue? (Not Really)

One might ask the question if whether the expense of implementations is actually sucking money away from the maintenance of systems. This could be the topic of a separate article by itself. So while Master Data Management MDM software is selling very well and MDM consultants are doing great, master data is not improving much if at all, (repeated use of the terms “governance” and “taxonomy” do not seem to be magically improving the master data) and the vast majority of MDM projects are simply consulting boondoggles. MDM is known among partners as an excellent way to extract large amounts of money from clients.

See this article on this topic if you are interested in details as to why.

http://www.scmfocus.com/supplychainmasterdata/2010/06/why-software-based-mdm-is-a-consulting-boondoggle/

Secondly, one topic is not discussed with regards to master data maintenance is in many ways getting worse due to outsourcing. Outsourcing of IT is essentially a way to get short term costs reduced, while reducing IT capabilities even more than the cost go down. This means less support for everything and system maintenance is one of them. Its automatic, as soon as outsourcing occurs, the business starts having to perform their own system maintenance. Master data is of course part of this.

Other Methods

Maintenance in SCM can be managed by maintaining Setup Groups and the Setup Matrix in an Excel file and using it for an upload of the Setup Groups to SAP ERP with a CATT via LSMW. Step two is to transfer the Setup Groups to APO with a report, and the third step is to load the Setup Matrix from Excel to APO using the APO loader.

References

http://www.lib.umd.edu/drum/bitstream/1903/7488/4/25813_cov.pdf

Supply Chain Management with APO, Jorg T Dickensbach

http://planettogether.com/capacity-planning.php


Material Constraints in SNP

Infosys Define Material Constraints in SNP

We thought this was a good explanation of how material constraints work. Often PPMs and PDSs are used to describe how resources are constrained, however often left out of the discussion is how material is constrained, which is important for both procurement and for manufacturing.

Well pointed out is that the lead times themselves are one dimension of constraint.

wpid-constraints-infosys-2010-04-29-07-54.jpg

Service Level Planning Across SAP

wpid-servicelevel-2010-04-21-20-40.jpg
Setting Global Service Levels

One of the most important areas of functionality in several service parts planning applications is the ability to perform “global” service level planning. Global service level planning allows the planner to set the same or different service levels for the locations in the network that results in an overall service or availability level for their supply chain network.

Service Parts Software Providers are Leaders in This Area

When researching for this article we performed Internet searches for “service level planning” and Click Commerce, Servigistics, SAP, Oracle. We were surprised to find that this search only came up with any reliability with two vendors MCA and i2. Both i2 SCP and i2 SPP list “service level planning.” in their product attribute lists.

Service Level Planning and Inventory Optimization

Service level planning is also called inventory optimization. This is a confusing area because unfortunately the terms inventory optimization and inventory management are used interchangeably, which is actually false. See this quote for more details. During 2003, more than one hundred SCM solution vendors started promoting “Inventory Optimization”, an application solution described by various analysts as a new frontier in Supply Chain Planning. Beyond the strong marketing message, though, a more careful analysis clearly indicates that only a few are providing some functionality that can be called “Inventory Optimization”. The ability to automatically determine the correct stock levels for multiple SKUs in multiple locations, in such a way that fulfills a global service level target and simultaneously optimizes a desired objective function is a very complex task, and requires a sophisticated technology that no more than half a dozen vendors provide. A more careful analysis, though, has shown a very interesting, if not disappointing, picture of what really happened. In fact, more than 90% of these vendors haven’t actually added any new functionality at all in this area (neither as “inventory planning”, nor as “inventory management”). Most of them have simply renamed the already existing functions they used to call “inventory management” as “inventory optimization”. Many ERP/SCM suites don’t even use the word “inventory management” any more, inappropriately substituting “inventory optimization.

Recent Trends in Optimization: Tools Group

SAP and Service Level Planning The rundown of SAP regarding service level planning is as follows.

SAP ERP

Service level planning at the part level exists on the material master where safety stock can be calculated dynamically. This is a part specific level of availability and does not extend to a broader view of the overall part database service level.

SAP SCM Implicit Methods

  • Capable to Match (CTM) can prioritize requests such that some customers get inventory allocated vs. lower priority customers.
  • In Production Planning and Detailed Scheduling (PP/DS), reservations can be defined on the capacity of resources and they can be made on the basis of profitability and service level agreements.
  • In SNC, a service fill analysis component is now part of the supplier delivery performance rating
  • In Forecast and Replenishment (F&R) the forecast ad estimated safety amounts are based upon both the forecast error and the safety stock.
  • In F&R periods with expected similar patterns can be combined, and separate service levels can be assigned to each ABC classification.
  • In F&R demand influencing factors (DIFs) which are the primary mechanism of forecasting in the module, service level profiles can be setup for the DIFs.
  • Safety stock can be set by service level in the product location master.

Explicit Methods

  • In Service Parts Planning (SPP), target service levels can be set at the location or product location level. As of 7.0, targets can be set depending upon whether the location is an entry, intermediate parent or child location. -Of the major methods in SCM, this is the closest to meeting actual service level planning, however strangely it is not strongly proposed by SAP, even though the functionality brings them closer to being on par with the traditional service parts planning leaders. Secondly, there is a strong trend in companies to move towards service level planning. SPP is one of the few areas that actually does it in an explicit manner.

There is a good reason that several service parts planning applications are built around service level planning. The concept is that with service parts, you are providing a service level to a customer and signing a contract to this effect. Therefore, with service parts planning, service level based planning is explicitly necessary in order to meet the contract terms. However, shouldn’t it be just as important for the company to plan its inventory level based upon service levels as well? For instance, knowing what is a profitable vs. unprofitable in stock position allows a company to know how many financial resources to allocate to inventory and at what level to stop holding inventory. The question of when to stop holding inventory could be answered by the rough average profit margin of the company’s products. This concept is fundamentally different whether one is planning service parts or finished goods. For details on how service level planning interacts with SOP and contract creation and pricing, see this post.

http://www.scmfocus.com/inventoryoptimizationmultiechelon/2009/09/service-level-planning-sop-and-planning-group-interactions/

References

http://www.oracle.com/industries/automotive/learn_mro.pdf


The Rise and Decline for Supply Chain Cost Based Optimization


Cost based optimization has proven much more tricky to implement that originally thought.

Optimization: A Solution That Drove and Industry

In its early years, APO was sold on its ability to perform optimization. This is primarily because it was an industry wide practice to market advanced planning software in this way. In fact, APO or Advanced Planner and Optimizer – had the term directly in its name. The term optimization has two meanings as generally used. One is more of a business use, which basically means to produce the best outcomes. However, in the area of operations research, from where supply chain optimization originates, it has a more specific meaning. For those that did not do work in operations research or advanced mathematics, (which is a sizable portion of the business community and the executives who evaluate SCM) its more technical definition is unknown. For this reason we wanted to explicitly define it here.

“In mathematics, linear programming (LP) is a technique for optimization of a linear objective function… Linear programming is a considerable field of optimization for several reasons. Many practical problems in operations research can be expressed as linear programming problems. Certain special cases of linear programming, such as network flow problems and multi commodity problems. Although the modern management issues are ever-changing, most companies would like to maximize profits or minimize costs with limited resources. Therefore, many issues can boil down to linear programming problems.“ – Wikipedia

However, within optimization itself there are any number of types. The optimizer in most APS applications is a cost based optimizer. Costs for being out of stock, for transportation, storage and so on are entered into the system, and the system attempts to meet all demands at the lowest possible cost. However, inventory optimization (deriving stocking position from service level), duration / time optimization and space optimization for truck loading are all different types of optimization in the supply chain. This article deals exclusively with the issues surrounding cost based optimization.

Linear vs. Discrete Optimization

With cost based optimization, the approach works best in situations that are perfectly “linear,“ that is inputs can be increased or decreased in a continuous fashion. An example of a linear input would be an order quantity. Perfect linear optimization would mean that any order quantity from zero to infinity could be placed and fulfilled. In reality, supply chains are not perfectly linear problems. There is most often a lot size is a discrete value which limits the flexibility of the order quantity. One item may be ordered in units of 50. If 135 units are desired and the current inventory is less than 35, then 150 must be ordered to meet this demand. SCM has a number of techniques, such as lot size, than alter the problem being solved from perfectly linear, to discrete, or what is known as a step function. This is very important to making the resulting recommendation realistic. If discrete optimization is not used, then some type of post processing must be performed to ensure that the order quantities meet with the policies of the company and the limitations of the supply chain.

The Decline of Cost Based Optimization

However, while cost based optimization drove development in SCM at one time, it no longer does. The evidence for this is that cost based optimization is an option in three of the older modules (SNP, PP/DS and TP/VS), but is not an option in any of the newer modules (EWM, SNC, EM, SPP and F&R) Furthermore, the core optimization functionality in SCM has been stabilized for some time. Unfortunately SAP offers no other type of optimization other than cost based optimization, and this is a problem because cost based optimization can no longer be considered either a best practice or leading edge. The following reasons explain why.

  1. Optimization which is more customized for each supply chain area now exists in the products of the best of breed vendors.
  2. Cost based optimization does not have a sufficient number of success stories to be considered by any but the most risk tolerant companies.

SAP has invested a significant amount of effort behind an optimization method which is now an older and higher risk approach to optimizing the various supply chain areas. This makes the suite very vulnerable to the best of breed vendors currently, but this vulnerability is likely to increase as these distinctions between different optimization types become better known.

What is Actually Running the Solution?

There is a story from the client of an advanced planning vendor that the optimizer engine that was running in the background was not operational for a number of days, and no one noticed. This was because the planning was primarily being performed by heuristics that had been custom coded with scripts and the solution was not using the optimizer at all. Whether the client knew the optimizer was not being used is unknown. This is more common than a reading of press releases and industry periodicals in the area would think. While optimization is what sold a lot of supply chain software, but it was not necessarily what the customers of these solutions went live with. As is evident from our example above, this experience is wider than simply SAP SCM.

Why Cost Based Optimization Did Not Fulfill its Promise

If optimization did not “change the world“ of supply chain, the question naturally becomes “Why not?“ While there are a number of reasons, ranging from implementation complexity to vendor approach, however, what is most likely the dominant reason is that cost based optimization was essentially a first attempt by proponents of optimization to apply the technology to business settings. Cost is only one form of optimization, and in this case, the approach was simply overused. There is a saying that when all you have is a hammer, every problem begins to look like a nail.

Conclusion

Cost based optimization is always the most complex and difficult of implementation, and has demonstrated inferior implementability over other forms of optimization. What the past 10 years have demonstrated is that its important to have different types of optimization for different areas of the supply chain.


SNP Configuration Sequence Document

question mark red
This is the sequence which SNP is configured. Currently I have 21 steps documented. There are more to configure, however I will most likely complete the document on my next project

  1. Setup Version
    1. Version URL – http://www.scmfocus.com/sapplanning/2008/05/15/planning-model-and-version/

  2. Setup Model
    1. Model URL – http://www.scmfocus.com/sapplanning/2008/05/15/planning-model-and-version/

  3. Planning Bucket Profile Creation or Evaluation
    1. This can be setup, but will most likely be taken from the standard profiles that ship with SCM. Those available must be declared during to blueprint meetings to see if any are appropriate.

  4. Configure the Planning Object Structure:
    1. Add Characteristics (how are characteristics selected?) – What will SNP be planning? – SNP and DP deeply connected as both use key figures and characteristics.
    2. Setup standard SNP Values
      1. POS URL – http://www.scmfocus.com/sapplanning/2008/07/23/creating-a-planning-object-structure/

    3. Activate the POS
  5. Configure the Planning Areas
    1. Add Key Figures (how are key figures selected?) – What will SNP be planning? Is DP being implemented – shouldn’t these match. -Key Figure URL – http://www.scmfocus.com/sapplanning/2009/07/06/key-figures/
      1. Planning Area URL – http://www.scmfocus.com/sapplanning/2008/01/05/planning-areas/
      2. Activate the Planning Area

  6. Setup Products
    1. Setup output format of product numbers – URL -

  7. Setup Locations
    1. Assign Locations to Model and Verion – URL – http://www.scmfocus.com/sapplanning/2009/09/02/assign-location-to-planning-versions-and-model/

  8. Setup Transportation Lanes
  9. Is Any Aggregationto be Used?
    1. http://www.scmfocus.com/sapplanning/2008/06/08/aggregate-planning/

  10. EvaluateQuotas and Setup ifNecessary
  11. Evaluate Resources and Setup if Necessary
    1. Setup PPMs or PDSs

  12. Define the Planning Books
    1. Planning Book URL – http://www.scmfocus.com/sapplanning/2008/05/28/planning-book/
    2. Which macros should be created – URL -

  13. Determine if Category Groups are to be used
    1. IF YES, create them – URL – http://www.scmfocus.com/sapplanning/2009/08/28/snp-category-groups/

  14. Select SNP Method
    1. Heuristic, CTM, or Optimization (Based upon degree of constraints, based upon uptake by planners, based upon if lowest possible cost is required.)
      1. IF CTM
        1. THEN setup CTM Global Settings – URL – http://www.scmfocus.com/sapplanning/2009/08/30/ctm-global-settings/
        2. THEN setup CTM Time Stream – URL – http://www.scmfocus.com/sapplanning/2009/08/31/ctm-time-stream/
        3. THEN setup CTM Profile – URL – http://www.scmfocus.com/sapplanning/2008/09/18/ctm-profile/
        4. THEN configure the Product Location Master with CTMfields- http://www.scmfocus.com/sapplanning/2009/08/31/ctm-settings-on-the-product-location-master/
        5. Does the client want to categorize supply? – URL – http://www.scmfocus.com/sapplanning/2009/08/31/ctm-supply-categories/ THEN use these supply categories to setup search strategies http://www.scmfocus.com/sapplanning/2009/08/31/ctm-search-strategies/
        6. THEN make key figures available – http://www.scmfocus.com/sapplanning/2009/09/01/ctm-make-key-figures-available/
        7. Do any of the CTM BAPIs apply?

      2. IF Optimizer
        1. THEN setup the Optimizer – URL – http://www.scmfocus.com/sapplanning/2009/07/25/snp-optimizer/
        2. THEN setup the Costs Profile – URL – http://www.scmfocus.com/sapplanning/2009/08/30/snp-cost-profiles/

      3. Heuristic URL – http://www.scmfocus.com/sapplanning/2008/09/21/ppds-and-snp-heuristics/
  15. Is Deployment going is to be used?
    1. If (YES) then:
      1. Deployment URL – http://www.scmfocus.com/sapplanning/2008/09/22/snp-deployment-optimizing-heuristic-and-fair-share/
        1. It optimizer is selected – URL – http://www.scmfocus.com/sapplanning/2009/08/30/snp-deployment-optimizer-profile-configuration/
          1. THEN setup Costs Profile – URL -http://www.scmfocus.com/sapplanning/2009/08/30/snp-cost-profiles/

        2. If heuristics are selected – URL – http://www.scmfocus.com/sapplanning/2009/08/30/snp-deployment-optimizer-profile-configuration/
      2. Possibly user Supply Distribution as well for push -
  16. Is VMI going to be used?
    1. VMI URL – http://www.scmfocus.com/sapplanning/2009/08/30/vmi-in-snp/

  17. Is Characteristic Dependent Planning to be used? (this has not been analyzed)
  18. Configure the CIF
  19. Configuring the Transfer to SAP ERP (or OLTP Systems)
    1. Determine the needs of movement for SNP orders (normal, deployment, TLB, etc.).
    2. URL – http://www.scmfocus.com/sapplanning/2009/08/28/snp-transfer-to-sap-oltp-systems/

  20. Setup the Locations
    1. Only the SNP and General Tab must be set
      1. URL – http://www.scmfocus.com/sapplanning/2009/07/05/location-master/
      2. SNP Tab uses Category Groups

  21. Setup SNP fields on Product Location
    1. Product Location SNP – http://www.scmfocus.com/sapplanning/2008/09/10/product-master-tabs-for-ppds-and-snp/
    2. Tabs are (Administration, Properties, UOM, SNP1 – if using penalty costs, SNP2, Demand, Lot Size, Procurement, GR/GI)
    3. Safety stock
      1. Select between standard and enhanced
      2. Configure Planning Books
      3. Service level based safety stock URL – http://www.scmfocus.com/sapplanning/2009/07/30/service-level-planning/

  22. Setup SNP Global Settings
    1. http://www.scmfocus.com/sapplanning/2009/08/29/snp-global-settings/

  23. Decide on and Setup Number Ranges for Orders