During the months of August and September I will hit the road and visit anybody interested between New York and Seattle, Miami and Montana for a guided two day workshop using your SAP system.


if you want to:


- have a new look at your master data settings that support your planning process (lot sizing, MRP type, safety stocks, strategy etc.)

- connect the sales department with the production planners using availability checking rules, demand smoothing and the use of the appropriate strategy groups

- measure the performance of your supply chain (inventory efficiency, production line efficiency, planning efficiency, forecast accuracy, service levels and fill rates)

- introduce a more effective materials planning process with exception monitoring, range of coverage planning and demand / supply balancing

- use SAP ERP to implement lean principles like 'pull' through Kanban, sequencing and heijunka leveling, line balancing and conWIP procedures

- create a more agile supply chain with demand driven planning and execution of a product mix

- automate your procurement and replenishment process

- empower your user community with education on all standard replenishment strategies, planning strategies and production scheduling procedures

- implement decision systems and analyze your inventories and products on a regular basis for more efficient planning


...then you want to have me drop by. I will spend two fun filled days having a quick look at the state of your SAP supply chain and quickly move into sessions with your planners, buyers, materials controllers and management to make valuable recommendations and also get some quick wins on the low hanging fruit.


Often it just takes a bit of change in thinking and perception (through eye opening explanations on how this stuff works) that makes a big difference. There is so much potential in the use of all these, mostly hidden, standard functions in SAP and it often just takes someone pointing you in the right direction.


please drop me an email to uwe@bigbytesoftware.com and I will send you the details and start the conversation

To kill some time before the next episode of Game of Thrones airs, I'd like to write about the undeniable fact that, at least from what I have seen, not very many SAP using companies connect the plan with the schedule. For all of you who do, I profoundly apologize and ask you to please share your successes in this forum so that we all get a better grip on this dilemma. 

 

In every supply chain there are three phases: the planning phase, usually done by Sales & Operations Planning, where we estimate and try as best as we can to come up with a senseable plan to make and buy in the right quantity at the right place at the right time (the right product). 

 

Then there is the scheduling phase. Here we committ to the plan (usually a shorter time frame). We send out purchase orders to the vendor and turn planned orders into production orders which will be scheduled on the line.   

 

At last there is the actuating phase where things are actually happening. Goods receipts, confirmations, kanban containers are emtied and components are consumed. 

 

Of course, the ultimate goal is to align all three of these phases as close as possible. But if we're not able to align the plan with the schedule, then there is no way that what's actually happing is near anything we tried to anticipate. 

 

So... Before you wonder why this stupid SAP system does not help you out, check on the alignment between S&OP and the production schedule for the lines. 

 

Every company I have seen has good service levels, decent inventories and availability. Otherwise they would be out of business. The question is always: how much manual effort do you have to go through to stay in business? And to what degree are you letting SAP do the heavy lifting?

 

You probably heard it a million times: "don't work in silos". Well... don't do it! Let your planners work with your schedulers so that the line won't be dark and full of errors but "bright and beautiful and full of hope" (as Melisandre would say). 

 

Here are a few thoughts and ideas on how to improve on that interface:

 

1. Create a statistical work center for every one of your lines. Make sure the uptime for the line is maintained in it for at least the planning horizon. Then make sure that your planners use that uptime to check their planned numbers for feasability on the line. Im standard S&OP there are great ways to do that. 

 

2. Make sure the schedulers don't schedule the line for 100% (or even beyond). Variability happens and a line scheduled at capacity has no agility tat all. 

 

3. Classify the products you run on the line and assign them to either MTO, MTS or FTO (finish to order) and stick with it! What that means is that you can't designate an item to be MTO and then have somebody put a forecast on it or check the availability without replenishment lead time. But you have to know that what's MTO today might be MTS tomorrow. Perform a classification regularly (in another blog post I mentioned Marc Hoppes Monitors and simulation tools which cover white spots in the SAP functionality)

 

4. Put KPIs in place that track the difference between plan, schedule and actual and have the planners meet with schedulers to discuss. This is not about blaming each other. After all it is impossible to have a perfect plan (the forecast is always wrong, right). The exception messages in MD06 and MD07 together with the traffic lights provide a beautiful basis for a regular meeting like that; if fully understood and rightly used. 

 

Like with other aspects in life, it is important to talk with each other and to fully understand the tools we have at our disposal. My suggestion is to make sure everybody knows as much as possible about all the features and functions available in SAP and how to fine tune them. But regular meetings are imperative. If the planner does check with the scheduler and vica versa, then the line might be running bright and your production schedulers (usually the people who take the blame) won't experience any terrors. 

Standard S&OP uses information structure S076 which is delivered with level-by-level planning and some standard characteristics and macros. It is also based on a product group hierarchy which you can set up to your liking, however, you can only use product groups in the hierarchy and material master records with their plant code on the lowest level of the hierarchy. Should you desire anything different from these defaults, you should opt for Flexible Planning where, as the name implies, there are many flexible options.

 

The product group hierarchy is maintained in MC84, MC85 and MC86 and contains all products which need to be forecasted. You can maintain a product group hierarchy and the planning figures are aggregated and disaggregated throughout the hierarchy using proportional percentage values. These proportional values may be set manually or automatically using past historical data.

 

product groups.png

Typically a product group represents all MTS and FTO members produced on one given production line. This will eventually ensure a smoothing of the production program for this line. Note that there will be MTO products as well to be scheduled on the line. Therefore, and for a number of other reasons, the line should never be planned to 100% of its capacity.

 

After the hierarchy is setup, the plan can be put together. Planning with product groups happens in MC82 for the active version.

 

s076 planning table.png

In the planning table for information structure S076, you can generate a sales forecast based on historical consumption, any characteristic from the SIS, a budget from COPA or maintain your own figures manually. Another option is to import that sales figure from a spreadsheet or other external system.

Next you should maintain ‘Target Days of Supply’. This is the number of days of inventory coverage your plan wants to have in inventory as a safety over and above your planned sales. Since your sales will never be the same as what your forecasted them to be, this inventory coverage will cover the variability in your sales process. Should you maintain 5 days of supply for the end of every period, then you can cover additional sales for an extra 5 days. You may also just simply set a target stock level to be in safety inventory at the end of the period.

Once you run the macro to create the production program based on Target Day’s of Supply, the system calculates what needs to be produced in order to cover the projected sales and still have some safety in inventory to counter any variability.

Now you can see your projected production program – still within the planning part; we can’t execute on this yet - that needs to be executed to make sure we can produce all product group MTS member’s forecast and carry some safety stock. This production program should now be checked against available capacity on the line. As mentioned above, it makes sense to set up product groups which contain all MTS members that are run on one particular production line. This gives us the ability to now check on that line’s capability to execute the production requests and meet the projected sales.

As you can see in figure ??, there is a display for the capacity balance in every period at the bottom half of the screen. The available capacity (in this example, hours) are taken from a statistical work center which was maintained for this production line and the capacity load comes from the orders that were created using a rough-cut planning profile (acts like a routing) and the figures in the line ‘Production’. Using these two values, the utilization is calculated and displayed for every period in question. Since the production schedulers maintained their future available capacity in the statistical work center, the planner can now see the feasibility of her plan, given the planned available capacity. Here is where sales planning must come to a consensus with the production planners. 

Should there be over utilization, one can discuss moving production quantities into earlier periods with under capacity or the possible addition of capacity (more workers or another line) to meet growing sales. In case of under capacity, you might consider using the line for partial production of products from another product group.

Note that one should never plan for 100% utilization. Variability in form of a difference between forecast and actual sales or a line being down and even preventive maintenance can be buffered by open capacity. Also consider that not all products that are manufactured at this line are included in the product group. There might be some MTO items which are naturally not planned with a forecast. These MTOs should be planned by reserving some capacity, so that any sales order dropping in for any MTO product can be included in the weekly schedule. More about that when we discuss ‘Product Wheel’ scheduling.

After the plan is smoothed in its first iteration, we need to hand it over to operational scheduling. This is done via ‘Transfer of Demand’ where further smoothing happens and actual orders are generated by MRP using lot sizing procedures, lead times and detailed or finite available capacity. During the transfer of demand, the strategy group[1] plays an important role.

When demand is transferred, through a forecast or a sales order, the strategy which is set in the material master’s MRP3 screen, determines the requirements type. And the requirements type controls the actions executed in operational planning and execution. As an example it may call for consumption of a forecast when a sales order is entered. Or it may generate a customer specific section in the stock / requirements list, so that product inventory can be managed for each customer separately. Another strategy, 50 and 52, governs that any planned orders generated by MRP to fulfill a forecast requirement, is of a statistical nature and may only be executed (turned into a committed order) when a sales order comes in[2].

In either case, after demand is transferred into operational planning, the MRP run determines net requirements, explodes the Bill of Material, places secondary requirements and generates all necessary supply elements (order proposals) using lot sizing rules and lead times from the material master. Sales &Operations Planning has ended. The plan is actuated and material planners and production schedulers take over.

All this happens on a periodic basis, meaning that there is agreement on what period the S&OP planner looks at. Most likely there is a short term plan, a middle term and a long term plan. The short term plan is transferred to MRP and the S&OP planner continues working with the long and middle term plans which, at some point in time, will turn into the short term plan and eventually become operational.


 


[1] I call it the strategy group because that is what SAP labels it on the MRP3 screen. And what is maintained there is a actually a group of strategies. During demand transfer the system picks the main strategy from the strategy group. Therefore what actually is being used is the strategy.

[2] The statistical order transfers secondary demand down to the raw material so that the procurement of such can be executed ahead of time