Monday, March 24, 2014

The Sales Order Availability Check: With or Without Total Replenishment Lead Time ?

If you look at the 'Scope of Check' that was setup for your Sales Order Availability Check, you'll see a choice that says: 'Check without RLT?'

Besides the question being a bit confusing (when I check it on, is it with or without RLT??), the decision has many, some hidden, implications. First off: when the choice is checked, your availability check performs its routine without the Total Replenishment Lead Time.

So what is the difference between the two? Let's look at an example:

Assuming you have nothing in inventory today and a customer orders 100 pieces with a desired shipment sometime in the near future. There are 50 pieces coming from the production line BEFORE the customer wants to pick up 100, and 50 coming in AFTER the customer wishes to pick up 100 - the last 50 are coming after the end of the Replenishment Lead Time.

If our sales availability check performs with Total replenishment Lead Time (the option in the 'Scope of Check' is unchecked), the following happens:

The system checks ONLY within the Replenishment Lead Time and ignores all receipts outside of it. It also assumes unlimited availability at the end of the TRLT. Therefore 50 pieces can be confirmed to the customer's requested delivery date and 50 are confirmed just after the end of TRLT.

This has the following implications: First, the sales order will confirm ANY quantity, no matter how crazy the request is, right after the TRLT, and second, it confirms quantities that are not on the schedule or even on the plan at that moment. Only after MRP is run, there will be a planned order to meet the new demand. This is a very unreliable and noisy way to do business and, in my personal opinion, only makes sense of you run MRP every day, or in a Make To Order situation, where there is no stock, nor any receipts.

On the other hand, when you check without Total Replenishment Lead Time, the system checks the entire planning horizon for receipts, but doesn't let you confirm if there aren't any.
Doing this right is imperative to business success, leveling demand, reducing noise in the production program and increasing visibility on what's demanded for the production scheduler and what's available for the customer sales representative.

Sunday, March 9, 2014

Postponement and SAP value stream mapping

Please see a video on Postponement and the introduction of an Inventory / Order interface to increase agility, flexibility and decrease the waste of overproduction.

The video also explains SAP value stream mapping

SAP Postponement and value stream mapping

Sunday, February 9, 2014

Simulations with the SAP Add-On Tool 'Safety Stock and Reorder Point'

Once you set your supply chain policy, you will have to fine tune your master data setup so that it drives good service levels with low inventories. The SAP Add-On Tool "Safety Stock and Reorder Point Simulator' lets you perform an optimization and update material master records collectively

Video: Safety Stock and Reorder Point Simulation

Saturday, February 8, 2014

Inventory Optimization with the SAP Add-On Tool 'Inventory Controlling Cockpit'

Here is an effective way to optimize and analyze your inventories in SP: Use SAPs Add-On Tool Inventory Controlling Cockpit to build hitlists, sort, filter, analyze, graph and optimize .... all in one powerful transaction.

SAP Add-On Tool Inventory Controlling Cockpit

Thursday, January 30, 2014

Getting more Value out of your SAP supply chain

What I recommend to do, and what not to do, when you engage in an SAP Supply chain optimization

So you want to embark on an optimization effort to get more out of your investment in the world’s greatest application software for enterprises?  Great thinking! For many SAP using companies, Go-Live is the end of their efforts to configure and customize the applications. Upgrades and the implementation of new modules is all they think about. There are usually many functions in standard SAP that are untapped and not used during the implementation and sometimes there are mistakes being made and a sub optimized setup results. Training is not finished yet and the competence in the use of the software is low. It’s all human and comes with the territory. You can’t go live with the perfect SAP setup.
That is why you should undertake an effort to get more automation, increase your flexibility in the manufacturing process, enhance visibility into the supply chain and keep your inventories low with great service levels.
But watch out: an SAP supply chain optimization comes in many different facets and in order to get value out of the effort, you must be careful to undertake the right steps, use the right tools and partner with the right consultant.
In the following I have listed Do’s and Do Not’s that come from a long history of optimization work and engaging with many clients from many industries. I’ll break it down into the different parts of an optimization effort.

Defining the Optimization

First and foremost you need to define the individual activities that should lead to value for the business. For that to be possible you will have to measure the existing supply chain, uncover weaknesses and sub optimized states, select the areas of operation, build a sequence of activities and set a benchmark so that you can measure progress.
Do take a benchmark measure before you start the optimization. Know where you are standing, list your inefficiencies and potentials, be honest about your company’s competence with SAP, see how much automation you get out of the system, measure your inventory performance and service levels, evaluate the level of visibility and transparency in the supply chain and try to increase flexibility from the level you are at right now. A good consultant should be able to quickly lay out that benchmark and direct you towards an effective optimization program.
When I start to engage with a new client, I offer them a free visit to personally meet and discuss their SAP and process setup on location. This helps me to understand what they are doing and gives me the opportunity to make some preliminary suggestions, so that the customer may quickly evaluate my level of competence. This helps them to feel comfortable with me… or not.
Do Not buy a so-called wellness assessment that lasts for a week and costs you an arm and a leg. If you get it for free, go for it, but only if they don’t tie up your staff. Exercises like that only help the consultants to sell you on more work, but are of no value to you. It allows the consultant to learn more about your way of using SAP (shouldn’t they know how SAP works best?) and getting paid for it too. They can also find out what they can sell you later down the road. A good, experienced consultant knows what you need to do, by engaging in a conversation with your users. Since experienced consultants know how materials planning, production scheduling and an automated procurement process works best in SAP, they do not have to spend a week at your facility, poking around your productive SAP system without supervision and possibly stirring up emotions and introducing friction when they present pre-mature and possibly false insights into your SAP supply chain to the executives.
Do engage in a modeling exercise to establish a point of reference. Models – I use lego – are a great way to design future, optimized states. You can grab a lego brick and move the inventory / order interface tangibly down the value stream and see the impact. A good model is your best companion throughout the initiative.
Do engage with a partner that is there for the long haul. The people you work with for their deep knowledge with SAP functionality need to learn as much as possible about your business and when they do, you want to have the ability to ask them more questions and bring them in for another week or two to help you with more optimizations. Before you sign up with the consultants, check their ability to sustain relationship with clients for a long time. Beware of the Optimizer who goes from project to project – most of them last for three to nine months before the client sees through the BS – and very rarely gets an added engagement. You want to work with the consultant who has many clients and those clients call upon them over and over again. Make sure you get some references and when you talk to the reference, ask if the consultant is still there and has completed and delivered successfully on optimizations before. Be also aware of the selective reference provision. A good place to start is at the consultant’s website. They usually list all the customers they worked with in the past on a ‘customer reference’ page. Pick 5 to 8 of those listed and ask for references form those companies instead of letting the consultant select the references.
Do not engage with someone who wants to optimize your process – except if you are looking for a process optimization consultant to optimize your business process.  Be clear what you’re looking to do here! This is about getting the most out of SAP functionality and not to completely change your way of business. If your process doesn’t work, chances are you wouldn’t be in business. Now it’s time to evaluate how much manual effort you have to come up with to run the process on SAP, to reduce that effort and make things go smoother and more automated with an increased level of competence… That is what this is all about. And when that advisor tells you that you will have to change your organizational structure or buy the book ‘Who moved my cheese’, then it’s about time to tell them to start their own company and put their money where their powerpoint presentation is.
Most importantly: Do Not engage in a gain share program where you hand the consultant more money based on an inventory reduction! Some of these programs border on fraud in my mind. First of all; an inventory reduction is not always a good thing. Especially when it leads to stock-outs and failed availability checks. Also, there are so many external factors influencing your inventory holdings, that when the value goes down, it’s very difficult to identify whether your consultant deserves credit for it. Maybe the inventory value goes down, because someone in the warehouse scraped obsolete stocks. The parameters with which a gain share is defined, are mostly shady to say the least and often set up in a way, that the consultant has some ‘wiggle room’ when it comes to report on the results. Taking a bunch of materials with inventory out of the MRP Controller key, or including the obsolete items in the initial report but taking them out for the final measurements, are common practices that sometimes happen because the consultants involuntarily mismanage the selection criteria, and sometimes because of a lack of competence when they compare apples with bananas. Sometimes, however, it is downright cheating.
Beware of anyone who wants to make more money that way, and work with those people for whom better inventory levels are a natural by-product of an SAP supply chain optimization.
Do check on the proposed team, resources and consultants! I’ve seen it so often; the sales staff comes in with a team of ‘great talkers’. They sell you an optimization and then you’ll meet a lot of new people at the kick-off meeting and during the project. The bad ones keep on rolling off, only being replaced by worse. Not only may your project be staffed with inexperienced SAP ‘experts’, but on top of everything else they throw in Project Managers, Business Maturity Managers, Thought Leaders (whose thoughts are they leading? And leading where?) and Account Managers.
Do you really need someone to manage these efforts? Do you need all these people? They cost a lot of money for sure. How about consultants that have vast experience with SAP, optimization efforts, understand supply chain theories and principles and know how to effectively apply them… and can manage all the efforts themselves and in collaboration with your team? Do you really need to pay someone an SAP premier consulting rate who does nothing but schedules meetings and manages change or business maturity? Your change? Your business maturity? In an SAP supply chain optimization?

More Effective Materials Planning

Materials Planning is at the heart and soul of the SAP supply chain. It’s where you set up your master data for automation and so that the MRP Run can generate a supply plan with optimum lot sizes and receipt dates from a pure demand point of view. Fine tuning of these supply proposals happens in Purchasing and Production Scheduling but a good setup of your master data and policies will set you up for success with a good basis.
Do learn about policy setting. It is the most important, game changing, cost saving, automating piece of an SAP optimization puzzle. Without regular policy setting you don’t stand a chance in this ever changing world… unless… all your competitors don’t do it either. But you want the advantage and not just go with the rest, right?
Do Not work with someone who tells you that collective updates are bad and you should never get Add-On Tools. SAP has white spots in its functionality and to ignore that, is simply bad. You can’t do an XYZ analysis in standard SAP. Instead of using a spreadsheet, why not using a totally integrated, SAP native MRP Monitor that lets you update the policy as well? Nobody, except for someone who does not want you to succeed and is only interested in their own gain, can possibly deny that the SAP Add-On Tools are absolutely essential for effective Materials Planning.  
Do educate your users in all aspects of effective materials planning, inventory optimization and the way the SAP master data drives automation, integration and visibility or transparency. Run them through hands-on workshops that are driven by experienced consultants and make sure that the knowledge transfer happens. Your users need to come out of this with a feeling of empowerment and not frustration because someone taught them how to set up one materials… and now they’re left with thousands more.
For Inventory Optimization Do Not put all your eggs into the LIS basket. The Logistics Information System is still available in your SAP-Enterprise software. I am not discounting it, since it has a lot of good reports and KPIs. However, it is a product of the 1980’s. It is simple nonsense to build an inventory optimization program around the LIS only. You would have to call up too many transactions, copy and paste data, move it to a different location, create an insanely big number of variants and setup customized info structures to manage data. On top of everything, it is very slow and SAP will never advance it, or ever speed it up with HANA. SAP says: “We do not support the LIS anymore!”. You can still use it, but there will be no new releases or any efforts to make it easier to use. It’s the poor mans (or the ‘stuck in the 80’s ’ mans) reporting and evaluation system.
Some consultants however, still promote it fiercely and try to make you pay… for them to build an inventory evaluation package that will embarrass you when you tell the user that they will have to use this from now on. Do Not, I repeat, Do Not pay someone to move you backwards in time and efficiency in your efforts to get a handle on your inventory controlling. It’s all they know… that’s why they do it.
Do make use of the SAP Add-On Tool MRP Monitor for automated policy setting. It has been proven that effective materials planning, prioritized portfolio management or continuous inventory optimization is not possible without the MRP Monitor. You can simply not keep the most effective replenishment policy updated if you have to manage more than 500 materials. With the MRP Monitor you can classify and segment your materials portfolio and set policy for entire classes. That ensures manageability and saves the materials planners a lot of frustrations.
Do have a look at the Add-On Tools Safety Stock Simulation and Lot Size Simulation. Especially the latter one has an incredible ROI. It allows you to periodically check on the lot size procedure which is used for your purchased or produced parts. It then simulates – for any given demand situation – which lot size procedure produces the least cost to replenish and compares it to the lot size procedure in use. This saves you money every day and it’s easy as pie.

Optimizing Production Scheduling

Do create an SAP value stream map and model your manufacturing environment! Models are a great reference point. And you can touch them and move things around. Once the model is build you can keep on using it forever. Any changes or improvements are documented in the SAP value stream map. Be careful to work on this with someone who has done this before and knows what is important in a value stream map so that you can get the most out of it. In my values stream map I add boxes with SAP information to it. As an example, everywhere there is inventory, there must be an SAP material master record to manage that inventory. Very often we were able to eliminate one of these inventory holding points because we introduced flow with a better scheduling system and the right lot sizing and setup strategies. Those are measurable, real savings and general improvements for your supply chain and very difficult to realize if you don’t model and document your value stream.
Do Not let anyone tell you that you should use only one scheduling system in your value stream. SAP has a number of very effective scheduling options and it is absolutely no problem if your packaging line is run repetitive with a heijunka load leveling profile, while the final assembly line is a takt-based, balanced ‘pull’ system and the fabrication work cells are run with discrete production orders based on reorder levels or even Kanban.
Do work with people who know manufacturing; not only from an SAP perspective. They should know what the difference between ‘pushing’ and ‘pulling’ is (and not only stating that ‘pull’ is better). They should be able to explain the Theory of Constraints and how ‘Drum, Buffer, Rope’ may be used. Buzzwords like ‘heijunka’, ‘takts’, ‘load leveling’ and ‘line balancing’ are used too often, without really understanding when and how to employ them effectively. Dig deeper in your interview to find out if they really know what they are talking about and don’t forget: Your users may need to change the strategies long after the consultants are gone. So either get a good knowledge transfer or team up with consultants that you can, and want to, engage with over a long time… when you need them.
Do use the Add-On Tool ‘Lot Size Optimization’ to find the perfect setups. The tool is mostly understood to produce the least cost replenishment lot size for purchased parts, but it also does find the least cost setup arrangement for produced or fabricated parts.
Do perform scheduling, capacity leveling, sequencing and a collective availability check before you release your order to the production line. Otherwise the hang around unprocessed and hog up capacity and components that could be used much more profitably otherwise. This kind of behaviour destroys flow.
Do Not try to solve ineffective production scheduling with the purchase of APO PP/DS. PP/DS has very good and effective scheduling heuristics but very often a heuristic is not what gives you the optimal sequence for a demand driven production program. Heuristics are approximations and often do not provide the solution to your problem. In most cases that I have seen, the problem lies in the fact that no capacity scheduling, leveling or sequencing is done after the MRP run produces a supply plan under absolutely no consideration of production constraints. The solution to that problem is easily done in ERP, which does by no means insinuate that APO PP/DS isn’t a wonderful scheduling and supply management tool. You just need to implement it for the right reasons.

Automating Purchasing

Do automate your procurement transactions. There are many functions and features in the SAP procurement model that allow you to go above and beyond what you learned or were able to implement at the time of the initial Go-Live.

Sales & Operations Planning in the Integrated Supply Chain

Do evaluate SAP-ERP’s Sales & Operations Planning. With its standard and flexible SOP it provides a multitude of functions that might give you everything you need. Often I hear people say that it runs way too slow. Sometimes there is an easy solution to that problem. It might be that the info structure constantly aggregates and disaggregates up and down the hierarchy because it’s set up with ‘consistent planning’. That costs a lot of resources and takes forever. Using an info structure with delta aggregation solves that problem and makes the planning much easier to handle. All I am saying is that you should see through the maze of opinions about ERP SOP and build your own. It might provide you with a quick and cost effective solution to your planning with the software you already own.
Do perform a rough resource check on your production capabilities and important raw materials availability, before you hand the planned demand into MRP or demand management. If you neglect to do this, you will overwhelm your production scheduler with infeasible quantities and dates.

Try Not To build your planned demand in Excel or an external system. If you must do that, find a way to roughly resource check the planned demand quantities and dates before they become VSFs or LSFs in MD04.

Wednesday, January 22, 2014

cleaning your materials portfolio with the Add-On Tool MRP Monitor

Since I have come across the SAP Add On Tools last spring, we have rolled out many of these tools at 5 very happy customers, whose supply chain runs on SAP. At the center of it all is the MRP Monitor with its invaluable capabilities of segmentation and policy stratification. But there is so much more you can do with it and I wonder every day:

"How can anyone perform effective materials planning without it?"

So let me first address and explain my definition of effective materials planning:

"Effective Materials Planning is the process of maintaining the basic data of a materials portfolio so that it supports automation to keep optimal inventories that provide great service levels at any time under changing conditions"

To perform effective materials management with SAP you should perform tasks in four areas

- Portfolio Management where the planner needs to set up 'swimming lanes' and keep transparency and manageability
- Policy Setting which I consider the heart and soul of any planning system. Maintaining the right policy drives automation and the right inventory levels with optimized replenishment.
- Exception Monitoring to counter variability and the Unforeseeable.
- inventory Optimization to constantly capitalize on opportunities for lowering of cost and increase of availability and service level.

...and without the MRP Monitor
You can’t do selective portfolio management
You can’t set policy for more than one material at a time
Exceptions are not meaningful without good policy and selective portfolio management
Inventory optimization becomes an impossible undertaking

So here I am... In a very cold state, building an effective materials planning system with a client who installed MRP Monitor, Lot Size Simulator, Inventory Controlling Cockpit and the Service Level Monitor... All SAP native Add-On Tools.

The client runs their supply chain on SAP since the mid 90s and has undergone various optimization efforts with various degrees of success. The last one had cost them the price of a Learjet and delivered the value of a holiday trip to Elizabeth, NJ in January. The consulting company promoted and taught exception management with MD06 and a subsequent 'rule' setup in the material master... One item at a time! The fact that each materials controller had to manage about 5000 items didn't deter the 'thought leaders' from the opportunity to run a 6 months, revenue generating 'value' project (value for whom?).

To make a long story short... There were endless workshops on MRP types, lot sizes, safety stocks and various other fields in the MMR - all very important stuff - but nothing that helped managing a large portfolio and setting policy for optimized inventories or great service levels.

Then the client acquired the MRP Monitor! Now we're in the position to get the materials planners to take control over their parts. The first thing we did was to use the MRP Monitor and it's valuable KPIs to sort out the more important parts from the lesser to the least important parts to watch on a daily basis.  First we utilized the Monitors Life Cycle classification to list all items marked for deletion and moved those items into the MRP Controller bucket 'obsolete'. The MRP Monitor has a function with which you can update policy for many materials at the same time. You can also use that function to mass change a large number of materials - as an example: to move all items marked for deletion into the MRP Controller OBS.

the portfolio already shrunk from over 5000 parts to less than 2000.

Then we took one planner's MRP Controller key, listed all items and selected those which did not have one single movement over the past 12 months. (number of movements is a KPI in the MRP Monitor). Out of this list we excluded the 'new parts (again... this is a class provided in the Life Cycle analysis of the MRP Monitor). These non-movers we moved into an MRP Controller bucket "least important items to look at".

Then we moved all items with movements less than 80 per year into another MRP Controller bucket "less important items to look at" and everything else was left in the "important" MRP controller bucket, which by now included less than 500 items.

Now the fun began: Policy Setting! First we called up the MRP Monitor for  the "least important item" - about 3000 parts that had no consumption over the last 12 months. No need for overthinking on policy. Take everything of consumption driven policies to a PD and scratch all safety stocks. As mentioned before, the MRP Monitor allows for mass updates and we simply selected all items in that bucket, set PD, initialized (meaning we set that field to zero) the fields safety stock, safety time and Range of Coverage and so updated 3000 materials with a policy that instantly eliminated all exception messages and plans them only if there is demand. The Materials Planner will look at that bucket only once in a while and more is really not necessary.

Now we went into the bucket "less important items" that contained about 1500 items. Still a lot but manageable. What's of note here is that all the items that can not be classified (and had no movements) are out of the way, so whats left here is not super important but needs to be looked at. Good news is that all these materials have movements and are classified, which means we can set policy by class and segmentation.

And that we did. Now you take your high consumption value, consistent consumption, short lead time items and update them with a reorder policy and a fixed lot size - easily updated with the policy update functionality ion the MRP Monitor. Within hours we updated over 1500 materials with a fitting policy before we directed our attention to the 500 most important parts for that specific Materials Planner.

Again we called up the MRP Monitor Result, this time for the 500 most important parts, parts that have a lot of movement and are classified according to ABC for consumption value, XYZ for consumption consistency, EFG for lengths of replenishment item, UVW for price, LMN for volume or size and a life cycle classification (New, Regular, Obsolete, slow mover, marked for deletion, or dying). Now we will have to pay more attention, these are our movers and shakers and we can look at one segment at a time... and update any policy we'd like. to keep these parts optimized will take longer than before. But that's ok since these are the important parts. we'll also check on these more often and that's ok too. Because they are important.

And that is what Effective materials Planning is all about: separating the important movers and shakers from the bulk that can be set up with a policy that automatically takes care of them. These important 500 materials we need to tweak and pay attention to. they will make our planning or break it.

isn't this so much better than having to look at 5000 items every day? in MD06 or MD07? by the way... when those 'thought leaders' had finally optimized 300 materials after 6 months, the policy didn't fit anymore, the parts were discontinued and there were still 4700 materials left to be optimized.

effective Materials Planning without the MRP Monitor is not possible ! No matter how much money you spend on 'thought leaders'...

Wednesday, December 18, 2013

Safety Stock Simulation and Reorder Point Determination with SAP's Add-On Tool

Are you using automatic safety stock calculation with SAP's forecasting screen in the Material Master Record? As you might know there is a way to have the system calculate the static safety stock value (in the MRP2 screen) based on three influencing factors

1. replenishment lead time - the longer it takes to replenish, the higher the safety stock should be
2. service level - the higher the expected service level, the higher the safety stock should be (it actally grows exponentially with higher service levels)
3. consumption regularity from period to period, expressed by the mean absolute deviation or MAD

the lead time to replenish and the service level setting come from the MRP2 screen in the material master, whereas the MAD is calculated by the material forecast. The material forecast then calculates the safety stock (and a reorder level in case you are using a VM or V2 MRP type) and updates the field "safety stock" in MRP2 every time you run the forecast.

Now... if you are using this type of functionality, you can run the forecast periodically and have the system come up with safety stocks based on one specific service level setting. If yu want some automation and better visibility and results, I suggest you have a look at SAP's safety stock and reorder point simulator.

The tool is integrated with the MRP Monitor and therefore lets you select a group of materials for simulation based on criteria like consumption value, consumption consistency, length of replenishment lead time, slow / fast mover and much more. You then load these materials into the simulator in order to see the simulation results. Besides the ERP method described above, the tool calculates safety stock levels based on an advanced method that takes into consideration variability in lead time and variability in demand additionally to the three factors discussed before. You can then compare the two. But the tool also lets you simulate these two results for various service levels. If you do so you can display a regression graph that shows how the safety stock levels increase gradually with every step up in service levels. As the exponential growths kicks in the curve will become steepe and the jump in safety stock increases becomes more severe. That way you are able to pick the last good service level which produces an optimal safety stock level.

Once that is derived, you can select the optimal service level for every material and update all the material masters with safety stock, service level and reorder points. You acn also pick whether the ERP method or advanced method should be used.



A nice added value is, that you also get KPIs like "safety stock value" and "safety stock coverage in working days", which are not available in the standard.

Monday, December 16, 2013

Bridgestone sues IBM for fraud in SAP project

It is amazing to me that there are still so many failures and misguided SAP projects. Our community has been doing it for over 40 years now and there is really not much that has been changing over the years - in terms of knowing what needs to be done and what is the right thing to do in these implementations and upgrades.

Is it too much to ask a company like IBM to guide the customer in the right direction? They've done it so many times before, have developed countless methodologies, educated thousands of consultants and still... they are not able to help? It's not that IBM stands alone here. And it's not that they charge too little for whatever service they provide. And look in the article, how many more botched, failed, disastrous and fraudulent projects they conducted.

What's really frustrating is that the big companies like Bridgestone feel that they still have to retain giants like IBM, because if one of the little guys fails them, they have no one to sue. How sad is that? Isn't it time that our community provides good services to SAP customers? When does SAP start worrying about who takes on the task of making their software run? Instead of signing up unqualified, uneducated and incapable consultants with shady certifications just because they work for a giant?

If the only decision point for an SAP customer is whether or not the consultant is capable to hash out a 600 million payment resulting from a lawsuit, then we better start thinking about where this will be going?

http://spectrum.ieee.org/riskfactor/computing/it/bridgestone-sues-ibm-for-fraud-in-600-million-lawsuit-over-failed-it-implementation#!

Saturday, December 7, 2013

Measuring supply chain performance and how SAP software can be used to improve the rating

All too often SAP is implemented - and subsequently used - without any clear direction on what is desired to be achieved. The product is primarily acquired, mostly by senior executives to...
- solve broader reaching issues
- standardize
- renew
- make us look better, using the gold standard in IT
... and for a million other reasons. But when does anyone take the time to actually measure where you are and what was achieved with the implementation?

At bigbyte we created the Supply Chain Performance Indicator that looks at ten major measurements to benchmark how well your SAP investment drives your supply chain. Each measurement is supported by various KPIs and the final result - the SCPI or "Skippy" - visualizes the benchmark.

The ten areas of interest are:
1.  Inventory Performance
2.    Service
3.    Automation
4.    Flexibility / Agility
5.    Lean Six Sigma
6.    Cost / Profitability
7.    Visibility / Transparency
8.    Information Maturity / Basic Data
9.    Competence
10. Organizational Support

Inventory Performance
this KPI takes a deeper look into
-      Average inventory holdings
-      Dead stocks and how these relate to the averages and frequency of movements
-      Safety stock holdings and resulting availability and dead stock
-      Inventory turns
-      Categorization (slow movers, new materials, ABC, XYZ)
The measurements may be retrieved with standard SAP LIS transactions, BI (BW) or the use of the Add-On Tools “MRP Monitor” and “Inventory Cockpit”.  To achieve improvements in Inventory Performance, an effort to set meaningful policy, improving forecast accuracy, better planning methods in S&OP and production, a company could raise the benchmark significantly.

Once all reports are in we can perform ‘flow benchmarking’ and determine how well an organization is using inventory to deliver Throughput and short Cycle Times. Flow benchmarking uses Littl's Law to relate Revenue (Throughput) with average Inventory holdings (WIP) and Lead Times (or Cycle Times) and provides an excellent opportunity to calculate a third variable when two are measurable. Flow benchmarking shows how well materials flows and is an excellent tool to set a WIP cap in a pull system.

Service
Service can be measured as to how well customers receive product to their requested delivery date and how well promises are kept. But we can also measure the service level from production to the warehouse and the availability of bulk and packaging material to the packaging line. Of great importance is the consideration of a difference between a Make To Stock rating (the Fill Rate) and the Make To Order rating (Delivery Service, Delivery Ability, Delivery Reliability). The SAP Add-On  'Service Level Monitor' is an excellent tool to categorize and report on these Services.

Automation
The level of automation – using SAP functions – poses lots of improvement opportunities. Be it the automatic conversion of planned orders into a production program, automated procurement of packaging materials or the application of a method to perform regular policy setting and the resulting monitoring of exception messages, Most companies do not make enough use of standard tools available in the SAP functionality. The level of Automation could be greatly increased by implementing some of the advanced, standard functions available in the areas of Sales & Operations Planning, Materials Planning, Production scheduling and Procurement.

Flexibility / Agility
The degree of flexibility becomes apparent when looking at the way the planning (information) and material flow is designed. With the introduction of de-coupling or a inventory/order interface, and the resulting buffering of inventory before the final assembly or packaging lines, such flexibility can be achieved.
Using S&OP functionality with flexible planning of planning hierarchies and performing rough resource checks, the resulting forecast figures can be placed on an inventory point upstream from the final assembly or packaging lines. This would have the effect that the downstream lines can be scheduled with a demand driven ‘pull’ system and the resulting agility will increase service levels and drastically reduce safety stock or days of cover requirements.
The more often used method of placing an unchecked forecast on the finishing lines and the subsequent conveyance of every finished product forecast to the bulk level, leaves very little room for responsiveness to quickly changing demand. Very low flexibility to counteract forecast errors are compensated with changing the forecast of the near future. This poses a number of issues to the production scheduler and the additional problem of ever changing, “un-fixed” stock transport requisitions from the warehouse make it almost impossible to put together an agile production program.

Lean Six Sigma
A lean supply chain is defined by it’s low degree of producing or causing waste. As an example: the waste of overproducing finished goods to the warehouse can be induced by a high forecast error or a faulty transfer of demand. Additionally, ineffective planning procedures may lead to ineffective supply programs that produce lots of waste. Another form of waste lies in long cycle times. If, for example, production orders are released to the shop floor without performing all necessary steps – like an availability check for components, capacity leveling and proper sequencing of jobs – the orders remain on the line unprocessed and block valuable machine time and reserve raw or packaging material that other orders could use.

Six Sigma mostly measures defects and strives to introduce processes that will reduce the number of defects, in order to avoid waste and therefore achieve a lean supply chain with a high six sigma – or low number of defects for high quality in process and product.
A lot more effort is required to truly measure lean six sigma, but a lack of
- fitting scheduling methods
- high forecast errors
- ineffective transfer and placement of demand  
- a good process to re-introduce byproduct into the process
-   recipes with its possibility to perform quantity calculations and batch determination in a lean and effective way-      measuring defects
-      introducing a demand driven flow
lead to lots of waste and defects.

Profitability
Profitability is measured with standard FI and CO reports for Sales, Production and Procurement

Visibility / Transparency
A transparent supply chain is defined by the ability to quickly find inefficiencies and to pinpoint and find areas where exceptions occur. A good system to plan materials with policy setting and exception monitoring is conducive to a high degree of transparency.

Information Maturity / Basic Data
The basic data setup represents the most important driver of accuracy and efficiency for replenishment and planning policies. It also drives automation. Basic data includes material master, routes, work centers, resources and Bills of Material. It needs to be evaluated on a regular basis and changes must be coordinated between the various departments where it has an impact. The sum of all settings in the master (or basic) data represents a policy by which inventories and orders are filled, service levels are met and automation happens.

Very often there is a need for a concerted effort to keep master data clean, up-to-date and effective. A method needs to be put in place by which planners, schedulers and buyers will analyse, evaluate and update policies on a regular and continuous basis.

Competence
SAP usage competence is measured here. How much training for the user was received? What was the level of detail of the training? Is the system perceived to drive value? And is there user acceptance?

But we also need to measure how well general supply chain principles are understood.

Organizational Support
Further evaluations are necessary in order to determine the level of organizational support that is given to the SAP user. We consider of great importance that executives in the company, the people who made the decision to use SAP, are in full support of making the best use of the investment in SAP software. Therefore it’s of great value if the executives get involved to a fairly detailed degree and help support any improvement, sustainability and optimization projects around a better use of SAP software to drive the supply chain. This is a highly underestimated contributor to success.

Once all measurements are in, we can give an overall rating for each of the ten major KPIs and plot a spider diagram as seen below. The red line may depict the current performance, while the green line may give a target that needs to be achieved using various optimization efforts.

some of the optimization efforts that may drive your SAP supply chain towards your perceived targets can be:
- managing inventories using policies and exception monitoring
- optimizing availability checks and transfer of demand
- automating replenishment and procurement
- using better production / capacity scheduling methods
- introducing a system for materials planning & policy setting
- maintaining a usable KPI framework and reporting tools
- performing optimized S&OP and forecasting / rough resource checks
- using more integrated, standard SAP functionality for delivery and distribution

The ratings might not perfectly represent the actual situation - it is an approximation - but it's still so much better that moving in the dark and trying to find that magic handrail to guide you in the, hopefully,  right direction.


Sunday, December 1, 2013

Batch Expiration in MRP

I've come across the problem of batch expiration many times. It is typical for Life Sciences, Consumer Products, Food and Beverage Companies to Batch Manage and Shelf Life manage their materials and products.

During  Material Requirements Planning or Master Production Scheduling (both  Standard and Long-Term Planning), SAP R/3 does not discount the net available batch quantities that  are expiring out into the future (and instead considers them as  available depending on the Inventory Stock categories configured for the  checking rule for MRP). This is a big gap.

Then I saw a solution brief from Vija Pisipaty (IT Sapiens) which addresses the problem in an add-on tool (without any source code modification)  with the following features to overcome the gap:

·       The  solution dynamically takes into consideration the Expiration Date (or any  Batch Date that you desire as key date) of balance quantity of batches  in Inventory after consumption/netting off.
·       The system  calculates the quantity of a batch that will expire on the expiration  date, or that will need to be discounted based on Key date of batch  (e.g. Use By/Last Ship Date).
·       The system reduces the 'Net  Available Material Inventory' per requirement date, by the net quantity  of the batch that whose expiration/key date is less than the requirement  date of the requirement.
·       Batch Numbers of the  expiring/discounted batches and their respective quantities discounted  will be visible in the MRP List and Stock Requirements List.
·       A  custom configuration task is provided whereby the entire functionality  can be turned ON/OFF per "Plant-Material Type-Division" combination or by another combination you desire.
·       The subject functionality scope includes the following Transactions:
o   MD01 - Total Planning (Online) MRP
o   MD02 - Single Item, Multi Level MRP
o   MD03 - Single Item, Single Level MRP
o   MD04 - Stock/Requirements List
o   MD05 - Individual Display of MRP List
o   MD06 - Collective Display of MRP List
o   MD07 - Collective Stock/Requirements List
o   MD41 - Single Item Multi Level MPS
o   MD42 - Single Item Single Level MPS
o   MD43 - Single Item Interactive MPS
o   MDBT - Total Planning (Background Run) MRP
o   MDBS - Total Planning (Background Run) MPS
o   Long term Planiing related Txns - MS01, MS02, MS03, MSBT, MS50, MS05, MS06, MS07


The functionality caters to Unrestricted Stock, Customer Stock, Vendor Consignment Stock and Subcontractor Stock. The solution can also be extended to project Stock. I really like this solution and wanted to spread the word about it, since it represents a big problem for anyone managing batches and planning these in SAP.

please contact Vijay at IT Sapiens directly for any further documentation...mentation...