Sunday, December 30, 2012

Der Vogt auf Muehlstein

As I am just coming back from Germany, I can't deny that a book, given by my good friend Ulli Nagel has made a very profound impact on me. No wonder... The book was written by Heinrich Hansjakob, a fellow who lived over 100 years ago in the same area of the Black Forest where I was growing up. And 'Der Vogt auf Muehlstein' takes place just uphill from the house I was born; some 200 years removed.

The Muehlstein is a farmer's house overseeing the valleys of Nordrach and Harmersbach and looks all the way out to Strasbourg in France on a good day. It houses a Wirtsstube where many hikers and locals visit and have delicious Speck, sausages and Schnaps in the old 'Stub' (the living room) of the last inhabitant Josef Erdrich. Sadly the "Erdrich Sepp" died two month ago.
the Vogtsbauernhof 'Muehlstein' today

a typical Bauernvesper including Schnaps and Most

Everybody in my hometown and the surrounding villages was shaken by the news. What will happen to one of the most traditional estates the Black Forest ever had? Its history is long and rich and author Heinrich Hansjakob (a pastor in the days of the late 19th century) captured its essence beautifully by retelling the true story of Anna Maria Magdalena Muser, the only daughter of the Bailiff of Muehlstein.

All characters had actually lived and as tragic and sad the story is, as beautifully Heinrich Hansjakob stays true to giving us a wonderful insight into the characters and lives of my ancestors in the last three decades of the 18th century.
Heinrich Hansjakob around 1900

For those of you who speak German,  I urge you to order the book on www.amazon.de. It's a story that will move you. To those who don't understand us, you will have to be content with my recap... but only until I find someone in New York who will make a movie out of this!

And here the story (very short version) goes as much as I can retell it in English...

Magdalene is the fifth child and only daughter of the bailiff of Muehlstein and grows up happy and protected in the 1770s and '80s. She is the most beautiful girl of all the valleys and hills around. Singing was as common in those days in the Black Forest as watching television is today. And Magdalene could sing like a nightingale. Every Sunday the folk would come down to the valley for mass and during spring, summer and fall there were fairs, weddings and festivities all around. In Nordrach, Zell and Entersbach there were many occasions where young folk would meet and sing together. And Magdalene was the best. Especially with the Oelerjok's Hans. When the two performed together, it was like heaven came to earth.

As it turned out the two were also developing a liking for each other but because Hans was the 'middle' son and therefore would never inherit a property, it was clear that there was no future for the two. In those days in the Black Forest you would not marry for love but for protection and support. And every father wanted to marry his daughter into a protected livelihood.

And so it turned out that the 'Hermesbur' Faisst lost his second wife and was on the lookout for another. 53 years of age (Magdalene was 19) and the wealthiest farmer around, he asked the bailiff for the hand of his daughter. Everybody knew of Magdalenes love to Hans but the rules were also very clear: you don't marry for attraction and you do what your father considers best for you..

So it was a no brainer for the Muser Toni to promise his daughter to the old, fat man. But Magdalene refused at first. She just could not give herself up to someone she did not like. Her struggle, however, was impossible to succeed and on January 17, 1785 she was married to the Hermesbur. The wedding celebrations were a last, desperate but hopeless attempt, as Hans showed up singing an ode to his beloved Magdalene. The sad bride herself returned the treat with her own love song to Hans, which she had sung to herself over the past 6 months in despair and desperation. Even her cold hear-ted father and the somewhat simple Hermesbur couldn't hide their emotions. But that night, Magdalene moved in with her new husband and Hans packed his few possessions and left his hometown to never return.
After a few days of stoic reluctance by Magdalene, the Hermesbur threatened to take his wife by force. But Magdalene stood up to the overbearing figure and told him that... "I will be your working mate for the rest of my life, but I will never be your wife." Her willpower was countered with a beating, first by her new husband and later, by her father. Only two months after the wedding, on March 18th 1785, Magdalene died and was buried in Zell under the watch of her remorseful father and an indifferent husband who got remarried only 6 weeks after his third wife's death. He subsequently had another 11 children.

Hans, meanwhile was fighting as a mercenary in France and Austria, unaware of the tragedy that happened to the only woman he ever loved. Years later his younger brother met him by chance at a battle in the Alsace and told him what happened. Hans asked for an 18 hour leave, rode to Zell and visited Magdalene's grave. Without visiting his family, he immediately returned to the fighting front and died in battle the next day.

Magdalenes father, the bailiff of Muehlstein, fell in the winter of 1780 - exactly five years after Magdalenes death - and froze to a miserable death overnight.  (My retelling here does absolutely no justice to Heinrich Hansjakob. If you get a chance, read the book and you will be taken by the rich character descriptions and you can gain a glimpse of the interesting lives of the people of the late 18th century Black Forest)


Today, Magdalenes grave is still maintained by the city of Zell, my hometown. And the Muehlstein house still stands. However, since we now miss the Erdrich Sepp, no one knows if we can ever walk up the mountain again, to relive our past with a traditional meal (Vesper) and Most and Schnaps in the Stube on the Muehlstein.

Time will tell, but until then, I will put that book into my shelf in New York City and know for sure that it helps me to never forget where I am coming from.

Saturday, December 29, 2012

sexy SAP analytics

Just recently I read a comment from a fellow consultant on Twitter. He is mocking his client about their statement that the SAP LIS graphics are not sexy. "I suspect these managers should rather be focusing on the gruesomeness of their inventory levels, rather than “sexiness” of the SAP graphics!", he continues his judgmental ranting.

Really?, I am asking. Is that your idea of using the world's best operations management system? Doing analysis with graphics that look like Keith Richards would have used them in his early school years?

I am sorry, but I have to sympathize with the client. They are absolutely right to ask for a better tool and it is our (the consultants) responsibility to improve on the tools that our clients use. And yes: those tools should have some "sexiness" too! After all we are living in a new world (remember, the Mayan calendar has ended) and one of the important aptitudes of the new age is 'design'! (see my blog about Daniel Pink's Six Aptitudes). There are many better ways to analyze with standard SAP tools and beyond (I have written a number of blogs on the subject and will continue to do so).

In the end it comes down to what our job as a consultant is. It certainly is not to mock the client about wanting the best there is (I should note that the mocker himself ONLY knows the LIS from all the functions in SAP and therefore I understand his defense - but I do not support it). We consultants get around and we see many things. The good ones learn something new every day and aren't afraid to share it widely. The bad ones stick with what they know and mock any progress and the slightest possibility that what was good yesterday might not be so good (for our clients) today.


...and what's wrong with some sexiness in our otherwise prude subject matter?

Wednesday, December 26, 2012

Metaphysics and the SAP supply chain?

When Aristotle took on Metaphysics he wrote about four causes with which an object can be explained; material, efficient, formal and final. A material cause is the stuff a thing or system is made of, the efficient cause is the thing which made it or changes it. The formal cause, and now it gets interesting, is the system's essence or arrangement and the final cause is the purpose of the thing or system.

Now, if operations management with (or without) SAP underlies the still irrefutable laws of metaphysics, then I want to ask the question about how much of the formal and final causes we care about in our efforts to run and continuously improve supply chains. Obviously we do care a lot about the material and efficient causes. As a consequence we pay a lot of attention to the study of business process and product development, but underlying business dynamics and purposeful outcomes fall through the cracks.

All too often we can see slogans, buzzwords, 'philosophies' and entire movements with little or no final or formal goal orientation. Speaking of the goal: Eliyah Goldratt had formulated a final cause with his book 'The Goal' almost 30 years ago. His interpretation of The Goal for a manufacturing operations system (our final cause here) was: "to make money now and in the future". Wallace and Hopp updated this essential purpose by adding "...in ways that are consistent with our core values" in their book 'Factory Physics'.

Once we consider the final cause in our operations management system, we need a way to get there. This is where the formal cause comes into play. The formal cause of a manufacturing operations system is its structure; its underlying principles, governing laws; its essential 'form'. When constructed the right way, it provides a framework of reference, a scientific basis, a guiding model with which policies may be simulated so that we can anticipate what steps need to be taken to achieve The Goal.

Maybe we can now agree that any improvement or change efforts guided by material and effective causes only, may be exclusively driven by experience and guesswork. Once we are adding the final cause to have a purpose to work towards to and a formal cause with a model, where we can practice and simulate policies... then we can develop intuition, anticipate results, measure progress and generally move into a better world.

So please allow me at this point to add my own little 'philosophic' part so that we could say: "...the final cause or essential purpose of a manufacturing operations management system is to make money now and in the future in ways that are consistent with our core values and...the formal cause or scientific basis of a manufacturing operations management system provides us the framework to construct policies to achieve the final cause"

In that sense it might be worthwhile to consider - next to material and effective causes - a well defined goal and employ a scientific approach in any business improvement program. Easier said than done... but what's the alternative? eliminate muda? that's like saying "I want to be a better cook" and does not provide any guidelines or goals on how good you want to become or how you can get there.

Sunday, December 9, 2012

S&OP can be done using ERP only. But! It's very dangerous if your adviser does not know APO

There are people talking at SAP supply chain conferences about how Sales & Operations Planning is playing the most important role in your planning process. I do believe it is important and a good plan for the right product can save you money in inventory holdings and make your customers happy with great service levels and fill rates. It can also reduce noise in the supply chain and, with a good forecast, provide a great tool to anticipate demand and therefore inventory holdings of finished goods, help with decision making in regards to the resources you need to make available and allow you to simulate various version and effects of a corporate supply chain strategy.

The question is how do you get to a good plan in S&OP. For those of you whose company has purchased SAP software, the speaker should lay out good practices (if not the best) and give you valuable insight on how to best use that tool - SAP. And as we all know SAP software is comprised of an S&OP tool in its ERP version but they also sell advanced planning tools with APO. Now, if you get an adviser who tells you to use ERP or another one who tells you to use APO, then you know that neither one understands both. And that is a problem! Because you certainly don't want the knowledge (or lack thereof) of your adviser drive your use of SAP's Sales & Operations Planning.

I agree with the ERP proponents that, without a good basic data setup in ERP, any APO planning process is sub-optimized. So if your company has bought APO, you should make sure that your data basis in ERP is sound before you go use DP or SNP. That is mainly because your history (consumptions, sales etc.) is collected in an info structure in ERP and then loaded into an info cube in BI from where it can be used for Advanced Planning in Demand Planning in APO.

If your company did not make an investment in APO yet, it is an easy sell for the adviser to convince you to make use of ERP's S&OP (granted they know how it works). But beware! there is a lot of potential for a false setup that you will have a very hard time with later... especially when your company thinks about getting APO later. And they should, because in the long run and after getting more and more functions inside of SAP, APO should be the system of choice for your demand planning, distribution planning, production planning and procurement planning.

And if you don't set up your ERP S&OP with APO in mind, you will have a very hard time to make the switch later!

And if your adviser doesn't know APO, you can not setup your ERP S&OP with APO in mind!

Just as an example: in APO the Planner (an object) is independent of the location (plant or DC) whereas the MRP Controller in ERP is plant specific. So the product portfolio design should be setup with this in mind.

Also, in APO there are Characteristics Value Combinations. These are essentially the Planning Hierarchies used in ERP. You really don't want to redesign all that later.

Yes! You need to use what you have today. But! You will also have to prepare for the future. You can not ignore and dismiss what's possible for you tomorrow... just because your consultant doesn't know about it. Don't let anybody tell you that you are not ready for APO. It's like they sell you a Porsche and don't let you drive past second gear.

Wednesday, December 5, 2012

Factory Physics and its possible application in SAP - variability

In previous posts I talked about using science in supply chain optimization. The science I am talking about is often rooted in Factory Physics (based on the great work of Mark Spearman and Wallace Hopp). There are many more, but the three most basic principles in Factory Physics are:

1. Little's Law, which describes working capital performance (WIP = cycle time * throughput)
2. the VUT Equation, which relates capacity, variability and time buffers (CT(q) = V * U *t) and is vital to understand costing implications
3. Variance of Lead Time Demand, which drives inventory and performance (sigma2 = Lead Time sigma2D + Demand Sigma2LT)

These formulas don't need derivation or mathematical explanations, but they describe some basic concepts which we can relate to as we define where we are standing and, maybe even more important, where we want to go in our efforts to optimize our SAP supply chain.

This blog deals with the second of these principles, the VUT formula or Kingman's equation

Variability is an unavoidable fact of life that is best managed through understanding the tradeoffs it presents. Variability is a double-edged sword—it can be good, e.g. having more than one product to offer to your customers, or variability can be bad, e.g. machine breakdowns or order cancellations, late deliveries from your vendors and large differences between forecast and actual sales.

To manage variability we take two steps:

- First, determine the amount of good variability that allows you to stay competitive
- second, use the right combination of buffers - inventory, time, capacity - and take action to reduce it.

As we all know, we can not set demand levels or product offerings at will. But we can look at relationships and their implications (e.g. by use of the VUT formula) and use practical buffer management strategies to get the best possible performance under the given circumstances and external factors. The key to success is understanding the effects of variability on your value stream and managing the trade-offs to your advantage.

To get a better understanding and to gain visibility I suggest to map your operations in an SAP value stream diagram (I have shown examples of the SAP value stream in other blog articles. It is a conventional value stream map that includes information like customizing and basic data settings in SAP). Any value stream is composed of demand and transformation (where transformation breaks down into stocks and flows), where the transformation, in form of stocks and flows i used to meet demand.


 The most profitable situation is when demand and transformation are completely synchronized and demand is met with perfect supply in exactly that quantity of that product at that place on that time. We all know that this never happens. The difference is variability and variability is responsible for the appearance of three buffers.

This is not a bad thing - it's just the way things are. The bad things start to happen when executives and managers expect manufacturing and supply chain operations to behave differently than nature permit. The classic example is scheduling at 100% capacity utilization and expecting to be able to control performance well. Scheduling at 100% capacity only works out when there is zero variability and zero variability only happens at Christmas when the lines are down.

So to optimize your performance you can work with four things: The three buffers inventory, capacity and time and a reduction effort in variability. Now when it comes to using these parameters I want to quote the people from "factory Physics" as they talk about how a scientific basic is needed in today's supply chains:

"More and more, people are realizing that the goals of “eliminate variability” (from Six Sigma) and “reduce waste” (from Lean Manufacturing) are admirable goals but only state the obvious. If “eliminate variability,” is used to mean achieve zero variability, it is an impossible goal. If one accepts that zero variability is not possible so the mantra is changed to “reduce variability,” there still is no good description of what is a reasonable level of variability—as described earlier, some variability is bad and some is good. In the classic Lean Manufacturing approach, “reduce waste” is like saying, “Do the right thing.” It sounds great but doesn’t provide much direction."

I agree that we need to do more than just saying: "let's make things better!". In Factory Physics the answer to how to best optimize buffers and reduce variability is Kingman's equation. The VUT equation states that the cycle time in queue (in front of a production line or the inventory in front of a customer in the DC) is the product of a variability factor(V), times a utilization factor(U), times the effective process time(T).

The VUT is only an approximation but it gives an insight into the relationship of the three buffers and variability. It helps developing an intuition for managers to make better decisions. As an example: The combination of reducing inventory, doing nothing about variability, and expecting on-time delivery to improve or stay the same is a recipe for trouble. I've talked many times about the "unscientific inventory reduction" that some supply chain optimizers suggest. It's a prime example of where optimization projects do not produce results! With a good understanding of Factory Physics principles, your intuition would tell you not to approach inventory reduction goals by just mandating reduced inventory levels. You would accept the goal and then use your understanding of Factory Physics principles to determine what is required to achieve reduced inventory levels and direct your organization on how to proceed most quickly to achieve the inventory reduction goals with no loss in on-time delivery performance.

From Factory Physics: "The VUT equation is very useful since it describes the relationship of the three buffers in succinct form. If we want to have a low time buffer, then either V or U must be small. If V is not small, then U will have to be small. This means that if we have variability and want to have a small time buffer, we will need to have a large capacity buffer in order to keep U small. 
Example: If you are constantly making schedule changes because you allow customers to make changes to their orders at any time, you should also have plenty of extra capacity available or be prepared to ship orders late. What about inventory? 
For WIP we can use Little’s Law and get, WIP = CT x TH = (VUT) x TH. So to keep the inventory (WIP) buffer low we will also have to have a large capacity buffer in the presence of high variability. The VUT Equation combined with Little’s Law shows us that high variability at highly utilized work centers results in both a large time buffer and a large inventory buffer.
.. Example: What if we force WIP to be low? Managers do this all the time by limiting how much WIP is allowed in the system through use of pull systems such as kanban or CONWIP. If the VUT equation is to hold, something has to give. If variability is not reduced and process time is not decreased then U will go down with less WIP in the system. The only way for U to go down is for the throughput to go down. This is exactly what happens in manufacturing plants that are overzealous about reducing WIP. As discussed, such plants go beyond lean and become anorexic. WIP and cycle time will come down but so will output of the plant if variability is not reduced. So if you are making management decisions and you are focusing on reducing WIP, make sure you understand how much WIP is needed to maintain maximum throughput given the variability levels in your operations."

There is a lot of talk out there about the agile supply chain, the demand driven supply chain, real-time response and the lean, waste-less supply chain. i agree wholeheartedly that these are things we need to actualize with tools and functions SAP software provides us with, but look at the big picture and reference your actions to a framework that is based on a solid (scientific) basis. John F. Kennedy once said: “…be aware of the danger—but recognize the opportunity.". All too often you find yourself in an optimization project where you are beeing told about an opportunity in pursuit of better performance but the dangers are irresponsibly ignored. 

If you want to be agile/demand driven/real-time, you are stipulating that you require a very small time buffer and typically executives want this fast response with little or no inventory. If you attempt to have a very small time buffer, very little inventory, and you do not reduce variability, you will need a large increase in your capacity buffer. A large capacity buffer is typically very expensive. If you do not add the necessary capacity buffer, do nothing to reduce variability, and reduce your inventory buffer, the time buffer will increase. This means longer response times, reduction in on-time delivery performance and is typically also very expensive in terms of lost customers. 

to sum it up I want to quote Factory Physics again: "The solution to managing variability in your environment is to determine the amount of “good” variability that is required to be profitable in your market (e.g. range of demand volume, different product offerings, promised lead times, on-time delivery) and then implement and maintain the most profitable portfolio of:
.. buffers (inventory, capacity and time)
.. investment in reduction of “bad” variability (e.g. more fixtures to reduce setup times, stocking replacement parts to reduce downtime, dynamic scheduling, demand shaping).
Too often, executives and managers embark on great challenges or slogan-based initiatives to improve performance without a good understanding of the potential consequences of their actions. For you to be successful as an executive or manager of a manufacturing or supply chain operation, it is vital that you understand these fundamental relationships of Factory Physics principles and manage the tradeoffs proactively."

Now what does all of this have to do with your SAP supply chain? A lot. I am pleading for the use of a scientific basis before ANY optimization effort - whether it is the use of consumption based planning strategies to reduce inventory or the implementation of eKanban and MF50 scheduling to achieve 'pull' - , otherwise you might waste your time, or even worse, spend a ton of money on advisers who sell you their unscientific methodology no matter what your situation is... and ignore variability!

Tuesday, December 4, 2012

what it means to optimize an SAP supply chain

there are quite some different opinions out there about what an effort to optimize the SAP supply chain actually means. In my personal opinion, a process optimization or improvement is a precursor or a by-product of an SAP supply chain optimization... and not the primary goal. Of course things will have to get better when we optimize but in this case, the use of the tool should be improved. And that means:

- a better understanding on how SAP functionality works
- a better understanding about what options are available in SAP
- better use of the SAP system to support the optimized process
- more automation

If we plot this on a matrix, we can see that the process optimization should come first - to improve on your business process - and the SAP supply chain optimization should come afterwards - to have the tool, SAP software, support the optimized processes in the most automated and efficient way.


when I visit customers, I usually see a solid process, highly skilled planners, buyers and schedulers, a very good management team and a company that works very well. And if the aforementioned would not be true, I doubt that that company would still be in business. Come on SAP consultant! Do you really think you can improve your customer's process? the way they have been doing business for years... successfully!  or are you better suited helping them to get it done better using SAP as a tool? to get the most out of the available functionality? I think what is needed here, is an adviser who looks at the process and matches the right functions in SAP so that the process runs more efficient and more automated.

Almost always I see a good business running with a great degree of supply chain excellence .. but the question most likely is: "How hard is it for you - and how much manual effort does it take you - to get there?"

Saturday, December 1, 2012

Living in Tribeca...

It seems to me that over the last 5 years I did not spend a lot of time at home. In fact, looking into it, I spent about 80% of my time travelling. That KPI, I figured, stimulates me to make a point of spending more time at home. After all I live in Tribeca, one of the most featured neighborhoods in movies and books and destination to many tourists visiting New York.

Tribeca stands for TRIangle BElow CAnal street and is a historic neighborhood where, back in the days, most of those loft buildings served as giant refrigerators to store eggs and butter. Then, in the sixties, it went through its own dark ages. The building on the corner of West Broadway and Chambers, which today houses the Cosmopolitan Hotel, served as a halfway house and a place that convicted felons, who were done serving their time, used as a stepping stone to get back into society. Shootouts on West Broadway were as regular as were muggings and even murders.

In the late 70s and 80s the artists moved in, using all those lofty spaces for their studios and Tribeca became a hip spot that not a lot of people knew about. When I moved into the hood in 1997 it was still a deserted place to an onlooker, but it was a great community to the people who lived here. At night you would walk into the Odeon and there were familiar faces everywhere. The 500 feet from my apartment building to Morgans Market, the deli, took me about 30 minutes because I ran into at least 3 friends and neighbors. Everybody in the building would know everybody else who was living here and having my plants watered or the fish fed while I was traveling, did not require the hiring of a personal assistant.

Robert DeNiro had moved into the neighborhood and attracted a lot of his celebrity friends. Tribeca became a place where the hip and famous could live amongst us mere mortal fellow Tribecans without the fear of being stalked or asked for autographs. There was a time when almost the entire Sopranos crew would hang out every Wednesday night and 'Jimmy' Gandolfini would buy you a Jaeger shot while Michael Imperioli talked about how he is bummed out that he will eventually have to move to LA and leave his favorite place to live behind. Robert DeNiro's son ran a bar (more or less) and JFK junior was a regular sight at Bubby's talking to everybody there.



For a while there was a lot of activity on Reade Street. On Holidays or Sundays in July and August the fire department would open up the fire hydrants and that old cliche of children running down the street playing in the cooling water fountains became a reality - only this time it was the adults. On one occasion - right after a Soccer World Cup - we closed down the street, built a soccer field and had a two day tournament going on with an Oktoberfest on the side. Life was good in Tribeca. It was like a small village in the big city.

Then came 9/11. At first, the community became even tighter but in the long run this was a big change - of course! A lot of people moved out and then a lot of people moved in. Today I am sitting at the Cosmopolitan Cafe - as I am writing this - and look out onto a huge construction site (the Chambers Street Water project), people walking by at a rate of approximately 4 per second and there is a stroller invasion that looks for comparison.

There were many changes in Tribeca but the most obvious is the stroller invasion. Don't get me wrong: I love kids, but do I have to duck and dodge through foot traffic to not get rolled over and seriously injured by a horde of very aggresively pushing mothers? Brunch at Blaue Gans on Sunday becomes a kindergarden affair and where there was an adult playground (I am talking about restaurants or watering holes) on every corner 10 years ago, there are kiddy gyms, kids wellness centers, kids party houses and kids entertainment palazzos lined up - 5 in a row - right opposite the entrance to my building.

I am not bitter - no - I embrace the injection of youth and I know that things will always change in New York. But I do get a little nostalgic when I think about what great neighborhood this was - for me! and I realize what's great for me might not be so great for someone else.

Now that I am back here and enjoy being home again, I still love Tribeca. It still has that energy and feel that is hard to explain. But it is different; not better or worse. Just different. And we miss a few... unfortunately we lost some of the best; the ones who were a big part of making what Tribeca was all about. RIP Ralph Cummings and Angelo DiBari. You are being missed.

So today I will explore the new Tribeca. I will go to Whole Foods and buy groceries that will spoil in my fridge... because dinner at Ecco, Blaue Gans, Edwards or the Odeon is way too good to pass on the opportunity to go out to eat and meet people. I will walk around to see what's new, but rest assured, I will turn around before I get north of Canal Street. I will pass by Puffys and the Reade Street Pub because I need to make sure that I don't miss the Saturday afternoon action. And I will certainly run into a few friends and neighbors - maybe not into Kevin Spacey but maybe I see Steve Nash or that guy on 'Breaking Bad'.

Maybe it's not that different after all. In any case: it's good to be back!

Monday, November 26, 2012

Policy setting as the ultimate tool to optimize the SAP supply chain

In my personal opinion policy setting is at the heart of managing a supply chain. A policy is a set of basic data options that drive a strategy previously defined. PD (plan on demand; the MRP type on the first MRP screen in the material master) is not a policy, but with a range of coverage profile, an availability check that checks with replenishment lead time and a lot sizing indicator FX it becomes one. And that policy supports the strategy to replenish deterministically, maintain a dynamic safety stock which adjusts itself to changing demand, brings in the same fixed quantity every time it is ordered and if there is not enough stock, the availability check will quote availability right after the end of the replenishment lead time.

This policy might be assigned to purchased parts that are classified as 'high value, medium variability, short lead times and small in volume or size. Now there is a common understanding on how materials ought to be set up. An understanding that can be agreed to by management of sales, production and procurement; an understanding that can be communicated to every materials planner in your organization. You have defined a strategy and everybody knows what to do. Even the system, because the system is now executing to that strategy using the policy that was set. And since the world is changing, we must check periodically if the policy is still adequate for the given situation and circumstances. 

This is why you should do 4 dimensional planning, where besides the parameters WHEN, HOW MUCH and WHAT PLACE, you have to add the dimension CIRCUMSTANCE. what is the situation at the time when I need 200 kg in Houston? do I have enough capacity? what's my availability situation? what season is it? what's the likely customer behavior at that time? what constraints do we have in the warehouse? in production?

now the questions arises: how can the material planners stay on top of a workload like this? For a planner who has to manage hundreds or even thousands of items, this becomes indeed a problem. And it is the reason why most planners can't adjust the right policy to the right situation at the right time. The Add-On tool MRP Monitor by SAP Consulting provides a solution. Not only does it give you all the functionality to perform an extensive analysis, bit it also allows you to store a policy - with all its basic data settings - which you can update automatically in the material master for a group of materials )e.g. the AXL segment)



Yes, it is not that easy and actually quite demanding to understand all implications of all these policies and then set them to the right situation... and adjust when the situation asks for it. But what Ernest Rutherford said about Physics is equally true for the SAP supply chain: "All of physics is either impossible or trivial.  It is impossible until you understand it and then it becomes trivial"

Sunday, November 25, 2012

Isn't it time to use some Practical S(AP)cience?


"Management is in transition from an art, based only on experience, to a profession, based on an underlying structure of principles and science", wrote Jay W. Forrester in 1961 in his groundbreaking book Industrial Dynamics."... "any worthwhile human endeavor emerges first as an art. We succeed before we understand why" he continues. Then..."the development of the underlying sciences was motivated by the need to understand better the foundation on which the art rested."

Isn't it time to improve the art of SAP supply chain optimization with some science and underlying Laws and Principles to get a foundation and common understanding that we all can reference to? Most optimizers and advisers still just use their experience only and guide the user with intuition (that comes from various degrees of experience and runs the gamut from great to miserable judgement).

Other disciplines like Engineering or practicing Law would not nearly be as advanced would they still rest on the same descriptive transmittal of experience. And advancement in the art of SAP supply chain optimization we need! Wouldn't you agree? "...but without an underlying science, advancement of an art eventually reaches a plateau", Forrester claimed in 1961 and I believe his insights still hold water. He also states: "...companies believe their problems are unique. Because of the lack of a suitable fundamental point of view we fail to see how industrial experiences all deal with the same material, financial  and human factors - all representing variations on the same underlying system." And... "to unify the separate facets of management, selected experiences have been recorded as 'cases' to provide a vehicle to discuss management as an interrelated system. This has been the best method available for integrating management knowledge, although it has been far from adequate."

This still holds true in 2012. Far too often people discredit ideas because they think the solution does not apply in their environment.

Forrester talked about management as a discipline that needed a scientific basis and reference framework. I am talking about managing the SAP supply chain and my perceived opinion to bring some practical science to the table that helps us to better evaluate and fine tune the supply chain and how it is run by SAP settings and functionality. Such a base of practical science would permit experiences to be translated into a common frame of reference from which they could be transferred from the past to the present or from one place to another.

Forrester has succeded in his vision to develop a science for the discipline of management. The topic has been evolving from Forrester through Donella Meadows with 'Thinking In Systems' and more recently John Sterman with his book: 'Business Dynamics: Systems Thinking and Modeling for a Complex World' (both from the MIT Sloan Faculty where Forrester also lectured). Also worth mentioning: 'The Fifth Discipline: The Art and Practice of the Learning Organization' (Senge 1990) is a book by Peter Senge (also a senior lecturer at MIT). His premise is that the fifth discipline, system thinking, combines the other four (personal mastery, mental models, building a shared vision and team learning) to manage and transform companies into learning organizations. Besides Systems and Business Dynamics Thinking (supported by causal loop and stock & flow diagrams) another science has been developed: 'Factory Physics' by Wallace Hopp and Mark Spearman is a book on scientific management of manufacturing dynamics. But the Principles, Laws and Corollaries explained in Factory Physics can easily be applied to the entire supply chain. Wallace Hopp has also written a paper - 'Supply Chain Science' - that translates the Factory Physics principles to a more broad application throughout the entire supply chain.

So its time to use these valuable insights to build a practical science framework for the art of SAP supply chain optimization. Systems Thinking will allow us to pinpoint inefficiencies, foresee the effects of a specific policy and supports good decision making (MTS or MTO? reduce inventory or increase availability? when to order and how much?). Through Systems Thinking the bullwhip effect can be avoided and we're enabled to see the forest again, in spite of all the trees. Factory Physics then strives to apply practical science to help with the definition of various policies. Using Little's Law, Kingman's equation (or VUT formula) and the Variability of Lead Time Demand, we can optimize the combination of buffer usage (time, inventory, capacity), fight variability and optimize our inventory levels for lowest stock with utmost service level performance. We now know where to place WIP buffers to execute the Theory of Constraints for better flow and we can reduce waste, for a lean supply chain, and increase flexibility, for an agile supply chain. A KPI framework can be developed which is based on meaningful and effective measures. This should move us much closer to SAP supply chain excellence than intuition and experience alone.

Everywhere I look, I see the more SAP-experienced person (usually consultants who get around many SAP installations) help the user with a new transaction here and a better lot sizing indicator there. Some consultancies develop methodologies for SAP supply chain optimization and come up with isolated goals (like an inventory reduction or a service level increase or more automation in purchasing). This is all good and experienced advisers are needed to help making the supply chain better. But it is only a small step to the ultimate goal of supply chain excellence. How many optimization projects fail to produce the promised results? We have reached that plateau. Lets improve on the 'art' with the application of practical science and engage in optimization projects that have a solid basis for measurable, positive results as we deal with the complexity of a modern supply chain using an integrated, holistic and factual approach.

John Sterman's Business Dynamics is an excellent reference for the building of models. Business Dynamics By Sterman, John (Google Affiliate Ad)

Saturday, November 24, 2012

Air travel in modern times...

I never flew in the 60s or 70s, but I hear it was a fun thing to do and had a lot of glamour and excitement to it. When I started going on trips that required air travel in the 80s, it was still something I really looked forward to and enjoyed greatly, while I was in the air. In the early 90s I joined the frequent flyer clubs and from then on it was one of my favorite things to do, getting preferred treatment all the way and collecting miles for free trips and upgrades into First Class. The business of supply chain optimization around the world was fun and exciting and not stressful at all.

Fast forward to yesterday: I'm glad its over! Even though I was flying Business First, I did not enjoy yesterdays flight from FRA to EWR. I even dread these things now. I really don't want to get into details - since I know that everybody knows what I am talking about - but flying is not enjoyable or exciting or glamorous anymore.Period.

Just the night before, I saw on TV how the airline industry is supposed to get revived by the Dreamliner, an airplane that Jeff Smisek from United calls the "worlds leading airplane". He talks about the fantastic colors and lighting inside the cabin, the windows darken and lighten by a push of a button and in the bathroom a single button lowers the lid and flushes the toilet at the same time. Wonderful! But the seats are no different! One of the commentators: "you still have only 17 inches to your ass to fly 17 hours to Tokyo, crammed with people left and right to you". Who cares about the lighting when the only thing you have to do on an airplane is staying in your seat? And no one even cares about that... when they configure the seating charts on the new planes.

I am at a point where the only thing that I want to do on an airplane is to sleep. Melatonin is my weapon of choice and if an airplane manufacturer would ask me what to do to build better planes, I would ask for anything that puts me out: release some gas into the cabin that knocks everybody out after 2 minutes, hand out narcotics (legally o course) or lull me into sleep with music... anything that makes me not to experience the flight at all. Isn't that sad? That the product these airlines sell us is so bad that no one wants to experience it? Shouldn't they ask themselves: "why is everybody complaining and what can we do to have happier customers?" But customer satisfaction is very obviously not a thing that they care too much about.

Just this year Continental was taken over by United. I flew regularly on Continental since 1992 and I really don't know if it is United but this year specifically, I have experienced a sharp rise in unacceptable and inconvenient incidents on my trips. Like I said: Its not like it used to be.

On the United program they now give us frequent flyers a contingency of upgrades. Unfortunately they expire at the end of the year but, even worse, they don't just let you upgrade. It's all dependent on whether they can still make money selling the seats. Just now I tried to use one of my global upgrades, but received a message 'no seats available in front cabin'. So out of the 6 global upgrades I had "at my disposal", I have 3 left over which expire on 12/31. And that even though I flew 14 international legs in 2012. So what's the purpose?

You also receive 4 upgrades which you can use within the continental US. Every frequent flyer - whether they fly 25,000 miles a year or 150,000 - will get domestic upgrades. For a flyer like me, who travels between 100,000 and 130,000 miles a year, this means 4 flights in business class and about 35 in coach. Back in the good old "Continental" days, I got upgraded on 95% of my flights. And please don't get me wrong. I don't want to disrespect less frequent travelers, but I wouldn't mind sitting in coach on 2 or 3 round trips a year. However, if you sit on a plane twice a week and you have to work right off the flight, it is a very tiring experience.

enough complaints: I am home now and won't have to travel for 10 days. Yeeha! I am really excited and happy...

...and by the way: George Clooney wouldn't stand a chance accumulating 10 million miles.

Tuesday, November 20, 2012

Inventory projections are an important part of any KPI framework... The LIS is NOT!

I hear many of you asking for future inventory projections, so you can plan supply to variable demand and end up with optimized stock levels, exceptional service levels and good availability.

I believe that this is a very valid request and inventory projections must be part of any KPI framework. But mostly I hear advisers talking about current and past inventory. In some cases a reduction is proposed, so that future inventory is less than it is now (some of these consultancies even want a percentage of the reduction). So what if you need more? Inventory optimization is about striking a balance between availability and surplus (dead stock) and should be checked against future requirements. To just look at dead stock today, does not help you to make decisions about your replenishment, planned consumption, availability and stock level in the future.

Before I go about how to plan for future, optimized stock level, I would like to talk about how NOT to go about them.

You probably heard them... They might have knocked on your door... They might have even made some money wasting your time? I am talking about the LISers. Those people unaware of SAPs new developments (and every adviser should be obliged to be up-to-date on SAP developments) , unaware of BI, BOBJ, Add-On tools or enhancements to measure, monitor and evaluate the SAP supply chain... other than by means of the LIS (the Logistics Information System)

They get excited by a red line on black background or a dual classification that takes about ten minutes to call up and leaves absolutely no room for customization (and looks like crap). They promote using info structures which have no flexibility, are extremely cumbersome to fill and any query on them runs forever. They tell you that SAP does not provide support anymore because the LIS 'just works' (yeah right). But most insanely,they teach you all the tricks on how to get around and spend hours working in the LIS. Who cares?! And who wants to get around in the LIS?

So stop talking about the LIS. SAP doesn't talk about it anymore. And neither does anyone else. If this is your only play, you will not make it through the first quarter.

Future inventories are designed by using a KPI framework in a planning environment. Past consumption is important but so are future projections. Only if you put the two together you can make an assessment whether you need less or more. Availability and agility is as important nowadays as is less waste (in overproduction or excess inventory). But what was true yesterday might not be true today. The LISers look back! and back only... everybody else should use the past to build a better future... where the future should be anticipated with a vision, anticipation and foresight (none of which an LISer possesses).

Marc Hoppe and his team from SAP Consulting have developed an Inventory Cockpit that helps with exactly that. On basis of a customized Material Document Aggregation, which the LIS does not have a chance to do, the Inventory Cockpit provides a multitude of KPIs and measures to determine future inventory levels - amongst many other things.





The final assembly line as the link between Sales and Production

One of my favorite customers makes appliances and components for the consumer products industry.

Today we went live with a new concept linking forecast and customer orders with a production scheduling strategy. The key phrase is "smoothing irregular demand".

Our customer's production plant receives orders from each of the networks DC's as well as direct customer orders. The DCs, of course, take the customer orders and that demand can be quite irregular. Up until now the supply chain acted quite random and planners, schedulers and sales reps had a hard time at work.

This, as I believe, was due to the "order related and oriented" process dominating fulfillment, distribution and production. A sales order from the DC was forwarded to the production plant in the same quantity and then translated individually throughout the BoM. A yellow slip followed the order from the raw material through final assembly to packaging, distribution to the DC and finally the delivery to the customer.

In other words: the sales rep entered an order and the supply chain sprung into action - or should I say: "slipped into desparation and chaos"?

So what do you do? First, we asked the planners in the DC to maintain a forecast (strategy 40 for a VSF that gets consumed by sales orders). All these forecasts caused - through stock transport orders - a cumulated demand in the production facility. After that we let the system generate a repetitive order which covers the total demand and then we split the order through a heijunka strategy into EPEI (every product every day). The resulting schedule was leveled onto the final assembly line, carefully ensuring a maximum 75% utilization. Then the direct customer orders had room to be scheduled directly on the line (strategy 81 ensures the direct creation and scheduling of a repetitive order right out of the sales order).

We chose to do this on the final assembly line because it has ample capacity and very short cycle times. It can also be reset in a haertbeat. But most important it ensures the highest degree of customization.

The next challenge was component availability for final assembly. Here we choose SAPs eKanban. With it you have a full container for X items (regular and high demand) and Event-driven or one-time Kanban for Z items. Using this strategy you can be assured to pull high sellers quickly from the line and quote the customer a true lead time for slow movers.

Back to the DC. Since a forecast VSF was maintained, the DC will now receive regular shipments - on time! - to maintain an inventory. This inventory should be available at the beginning of the period and will be consumed by customer orders throughout the period. Therefore forecast accuracy and inventory responsibility remains in the DC and should be controlled with safety stocks (I recommend a coverage profile for dynamic SS).

The resulting demand in the production facility arrives in a regular fashion and gets further smoothed by Heijunka.

Of course there is a lot of setup required - correct lead times, effective lot sizing, right strategy and the appropriate MRP type and replenishment policy - but absolutely nothing that can't be done with standard SAP. Not one Z setting was used along the way..,

Thursday, November 15, 2012

Increased Profitability requires dealing with conflicting goals...

Have you ever wondered why your 'continuous improvement' program feels like you are moving in circles? This might be because you have to deal with conflicting goals. Only if one identifies a clear direction and strategy, an increase in profitability is possible. So lets see what helps to increase profitability.

On one hand costs need to be reduced and on the other we need to increase income, revenue or sales. To reduce cost, company's usually strive to reduce working capital (work in process, stocks, resources), save on the cost of procurement or production and optimize their planning processes so that they can execute more efficiently. In order to get the expected result one requires low inventories in raw, semi and finished goods, high utilization of resources and less variability in demand and supply.

The other side of the coin is the desired increase in sales which can be achieved by fast response to customers wishes, on time delivery, very high quality with less waste and scrap and the offering of a wide variety of options and customized features in the finished product. Logically this requires ample supply of all variants of the finished good, ample capacity on the production lines so rush orders can be attended to quickly and it results in a lot of variability.


These goals conflict and often companies become bipolar in their efforts of continuous improvement... should we reduce inventory or increase availability?, cut down on our offering of product options or offer more?, fully load our production lines or run them at a fraction of their ability?

The key is to find the perfect balance. Practical science like Factory Physics (based on the book by Mark Spearman and Wallace Hopp) provides a great framework to find that balance. In Factory Physics tools like the flow optimizer or efficiency curve in conjunction with the application of Little's Law, the VUT equation (which relates the three buffers Inventory, Capacity and Time) and the determination of the Variance in Lead Time Demand help a great deal to optimize Capacity, WIP, Inventory and Cash Flow and to determine the policies that support the strategy your company pursues.

It is those policies that we can use in the SAP supply chain. I have written quite a bit about policy setting in previous blogs, and if you read some of it, you know how important I consider them in the pursuit of the optimized SAP supply chain.

It would by far extend the scope of a blog article to describe the details on how to use Factory Physics to derive sensible policies which support strategy, but it is certainly worthwhile to look further into it... in case you were ever confused about what to do to get better results!


Sunday, November 4, 2012

building SAP supply chain KPI's that work and support decision making

In my opinion, good KPIs help you make good decisions. And the decisions you make, can be the setting of a replenishment or planning policy. I've talked about policies in previous blogs and am of the opinion that these are at the center of an effective and automated SAP supply chain. Policies determine the order frequency and lot size of replenishments and, if properly assigned, guarantee a great service level whilst avoiding stockouts.

Therefore it is imperative to have a solid set of KPIs available for your decision making. Here are three very important ones:

DpA - dead stock value as a percentage of average stock. Dead stock is that portion of the inventory that does not get used over a defined period of time. By itself it doesn't mean much. However, if you relate it to your average inventory value, it becomes a good indicator to show that when 75% of your average inventory remains in dead stock, you're not consuming as much as you are bringing in. Dead stock as a percentage of average inventory should not be more than 25-30% and is ideal at around 15%. So when you find yourself above that threshhold, it is time to look for a different replenishment policy - one that works better for that item and helps bringing the inventory down.

FR - fill rate. The fill rate indicates the percentage of sellable product that was delivered to the customer immediately from available inventory. As per that definition, one should not measure the fill rate for MTO or ATO or FTO products since those should never be in free available inventory that can be shipped to the customer (they are made or finished to ORDER). Therefore it is important to segregate the MTS products from the rest and measure only MTS with the KPI "fill rate". Of course the availability check should be set up accordingly. An MTS availability checking rule, in its purest sense, should simply check for available inventory (including safety stock) and if it does not find any, it should not confirm the sales order. Of course in some businesses you may want to look if there is anything in transit or on the production lines and confirm to the expected receipt date. However, for purposes of the fill rate measure, these delayed deliveries degrade the KPI. Only deliveries made immediately and directly out of available inventory account for a good fill rate. This is how you report on how good your planning and forecasting was for Make To Stock products.

FR - Flexibility Rating. Many people call this measure 'Service Level'. I want to call it differently because it rates how flexible a company services their customer's wishes. Make To Order, Assemble To Order or Finish To Order processes strive to react flexibly to fulfill a customer's request. In that case you do not plan an inventory of a certain, specific product ahead of time (with a forecast), but you wait until the customer tells you exactly what they want - and only then you start your production or assembly lines. Therefore one should measure the time it takes to fulfill the request and how well that quoted time is adhered to. To get a good KPI here, you should set an estimated lead time (the total replenishment lead time in MRP3) and the availability checking rule should check with that lead time to quote a delivery date to the customer. The KPI should then  not only show how well we deliver to that quoted lead time, but also give extra points for early delivery.

As you look at these KPIs, you should be able to make conclusions about what policy might work to your advantage (to further automate but also improve on the KPI).

...and since it is a bit of a challenge to get these KPIs out of standard SAP, I want to point out a solution that I am endorsing very much, since I believe it will help you a great deal to construct your own set of KPIs that really work for you: It's a product from Global Software called the Spreadsheet Server and works as an extension to Excel. It's greatest feature is that no extract needs to be generated (as soon as you extract data out of SAP, the data is outdated), but the queries, which you define in Excel, pull the data directly out of the SAP table and leave it there.

...but I let Global Software explain how it works:

"Spreadsheet Server, Powered by the QueryExchange™ works as an intuitive Microsoft® add-in providing live reporting and analysis from SAP into Excel. This empowers end users with the ability to use familiar Excel features and functions to create dynamic dashboard views from SAP. These views can be accessed, automated and presented with our formula driven methodology, including summary balances and detailed drill-downs. The cloud-based QueryExchange™ component of Spreadsheet Server enables user organizations to select and tailor pre-built queries to meet their specific needs. Utilized in the QueryExchange™, the SmartPak™ feature is a way to group pre-configured queries together. Searching by selecting a SmartPak™ gives users a quick and reliable way to access a group of dedicated pre-defined queries. In addition, Spreadsheet Server has the ability to dynamically access the following modules: FI, CO, PCA, SD, MM, PP, QM, PM, HR, PS, New GL, and Special Purpose Ledgers. Spreadsheet Server enhances the SAP financial and operational user experience all while leveraging the significant investments made by the customer in Microsoft Excel."

Friday, November 2, 2012

the traveling supply chain optimizer on two wheels

Since I travel for a living, I thought I might as well have some fun with it. Therefore I got myself a HD Road King Classic and set off on a trip around the country. Just yesterday I concluded the journey in Fort Lauderdale, FL, where Sophie will spend the winter. 6000 miles, starting from Sauk Rapids, MN, she did not have one hiccup and there wasn't a single problem, however, a lot of sights, stories and major fun.


oh... and not a single drop of rain along the entire way, but a cold front in Texas that was chilling to the bone.  As I am getting to it, I will write about the individual segments that I was riding - whenever I had the time - and show some photos that I shot.

Here she is. Fully packed, somewhere along the road.

Saturday, October 20, 2012

on SAP consulting ... and how to use the six aptitudes and more of the right side of your brain

My favorite book right now is Daniel Pink's "A Whole New Mind". A simple book in many ways, and a most profound and well-researched one as well. At about 250 or so pages, it's a quick read. "The future belongs to a different kind of person," Pink says. "Designers, inventors, teachers, storytellers — creative and empathetic right-brain thinkers whose abilities mark the fault line between who gets ahead and who doesn't." Pink claims we're living in a different era, a different age. An age in which those who "Think different" may be valued even more than ever.

"...an age animated by a different form of thinking and a new approach to life — one that prizes aptitudes that I call 'high concept' and 'high touch.' High concept involves the capacity to detect patterns and opportunities, to create artistic and emotional beauty, to craft a satisfying narrative....High touch involves the ability to empathize with others, to understand the subtleties of human interaction..."
— Dan Pink, A Whole New Mind

What I found particularly valuable in Dan Pink's book were the "six senses" or the "six R-directed aptitudes" which Pink says are necessary for successful professionals to posses in the more interdependent world we live in, a world of increased automation and out-sourcing. You can quibble over parts of his book if you like, but I think there is no denying that these six aptitudes are indeed more important now than they ever have been. And I am convinced that us SAP consultants need to apply them more than ever.

Is there a new way of SAP consulting? I am not sure, but what I know is that the old way needs a lot of improvement. Following is more detail on Daniel Pink's six aptitudes - Design, Story, Symphony, Empathy, Play, and Meaning - and me taking a shot on how each may make us a better SAP consultant:


- Design. To many business people, design is something like what roller skates are for a defensive lineman. It's not mission critical. In our field, design is necessary (when we present ideas using slides, show data tables in a spreadsheet or build a model using lego - as I love to do). But most of us decorate instead. There is a difference between design and decoration:

"Decoration, for better or worse, is noticeable,  - sometimes enjoyable, sometimes irritating - but it is unmistakably *there.* However, sometimes the best designs are so well done that "the design" of it is never even noticed consciously by the observer/user, such as the design of a book or signage in an airport (i.e., we take conscious note of the messages which the design helped make utterly clear, but not the color palette, typography, concept, etc.). One thing is for sure, design is not something that's merely on the surface, superficial and lacking depth. Rather it is something which goes "soul deep." 

— Garr Reynolds - author of Presentation Zen

"It is easy to dismiss design — to relegate it to mere ornament, the prettifying of places and objects to disguise their banality," Says Pink. "But that is a serious misunderstanding of what design is and why it matters." Pink is absolutely right. Design is fundamentally a whole-minded aptitude, or as he says, "utility enhanced by significance."

Garr Reynolds says: "Design starts at the beginning not at the end; it's not an afterthought. If you use slideware in your presentation, the design of those visuals begins in the preparation stage before you have even turned on your computer (if you're like me), let alone fired up the ol' slideware application. It's during the preparation stage that you slow down and "stop your busy mind" so that you may consider your topic and your objectives, your key messages, and your audience. Only then will you begin to sketch out ideas — on paper or just in your head — that will soon find themselves in some digital visual form later. Too much "PowerPoint design," as you know very well, is nothing more than a collection of recycled bullets, corporate templates, clip art, and seemingly random charts and graphs which are often too detailed or cluttered to make effective on-screen visuals and too vague to stand alone as quality documentation."

We have to get better at designing our means of teaching, communicating, convincing and presenting of ideas.


- Story: Facts, information, data; it has never been more readily available. Especially in our profession. But we are using it, dealing with it and processing it in a rather boring and unemotional way...says Pink, "What begins to matter more (than mere data) is the ability to place these facts in context and to deliver them with emotional impact." Cognitive scientist Mark Turner calls storytelling "Narrative imagining," something that is a key instrument of thought. We are wired to tell and to receive stories. "Most of our experiences, our knowledge and our thinking is organized as stories," Story" is not just about storytelling but about listening to stories and being a part of stories.

I always get a much better reception if I wrap my advice with a story. Merely explaining the difference between 'pull' and 'push' is not nearly as effective and memorable, as telling the story of how the State of California did not allow train wagons to be pushed by the locomotive anymore. This came after an accident, where a 'pushed' train crashed into a Jeep left on a crossing and had a much more devastating effect than any pulled train could have ever had.

Story can be used for good: for teaching, for sharing, for illuminating, and of course, for honest persuasion.

- Symphony: Focus, specialization, and analysis have been important in the "information age," but in the "conceptual age" synthesis and the ability to take seemingly unrelated pieces and form and articulate the big picture before us is crucial, even a differentiator. Pink calls this aptitude Symphony:

"Symphony...is the ability to put together the pieces. It is the capacity to synthesize rather than to analyze; to see relationships between seemingly unrelated fields; to detect broad patterns rather than to deliver specific answers; and to invent something new by combining elements nobody else thought to pair."

Doesn't this sound like integration? The best consultants can illuminate the relationships that we may not have seen before. They can "see the relationships between relationships." Symphony requires that we become better at seeing, truly seeing in a new way. "The most creative among us see relationships the rest of us never notice," Pink says. Anyone can deliver chunks of information and repeat findings represented visually in spreadsheets and powerpoints, what's needed are those who can recognize the patterns, who are skilled at seeing nuance and the simplicity that may exist in a complex problem.

Symphony in the world of SAP consulting does not mean dumbing down information into soundbites and talking points so popular in our industry To me, Symphony is about utilizing our whole mind — logic, analysis, synthesis, intuition — to make sense of our world (i.e., Sales & Operations Planning), finding the big picture and determining what is important and what is not. It's also about deciding what matters and letting go of the rest. A symphonic approach to our job and our ability to bring it all together for our customer will be greatly appreciated

- Empathy. Empathy is emotional. It's about putting yourself in your customer's shoes. It involves an understanding of the importance of the nonverbal cues of others and being aware of your own. Good consultants have the ability to put themselves in the position of the user. This is a talent, perhaps, more than it's a skill that can be taught, but everyone can get better at this. Everyone surely knows of a brilliant adviser who seems incapable of understanding how anyone could possibly be confused by his (or her) explanation of how to create a production schedule using repetitive manufacturing in SAP — in fact he's quite annoyed by the suggestion that anyone could "be so thick" as to not understand what is so "obvious" to him.

We can certainly see how empathy helps a consultant in the course of an engagement. Empathy allows a consultant, even without thinking about it, to notice when the audience is "getting it" and when they are not. The empathetic consultant can make adjustments based on his reading of this particular Users group. This is important since I have witnessed all too often how advisers impose their strict methodology without even knowing if it can help. As an example, I know of a consulting company which comes into every customer site with the pitch to "reduce 30% of their inventory, increase service levels by 20% and fix their exception handling and the way they do inventory analysis (without knowing the way they do it today)". That kind of behavior has absolutely nothing to do with empathy. It rather is a desperate attempt to get a revenue-rich project when one doesn't care about the customer's real pain and needs.

- Play: In the conceptual age, says Pink, work is not just about seriousness but about play as well. Pink quotes University of Pennsylvania professor, Brain Sutton-Smith who says, "The opposite of play isn't work. It's depression. To play is to act out and be willful, exultant and committed as if one is assured of one's prospects."

Indian physician Madan Kataria points out in Pink's book that many people think that serious people are the best suited for business, that serious people are more responsible. "[But] that's not true," says Kataria. "That's yesterday's news. Laughing people are more creative people. They are more productive people." Somewhere along the line we were sold the idea that a real business project must necessarily be dull, devoid of humor and something to be endured not enjoyed.

Let's employ more lego models, the beer game as a way to visualize the impact of the bullwhip effect and bathtubs to demonstrate Little's Law. It will raise the interest level but, more important, take the seriousness and dullness out and put some fun and smiles in. As Pink points out, "Laughter is a form of nonverbal communication that conveys empathy and that is even more contagious than the yawn..."

- Meaning: I don't want to put too fine a point on this, but performing well on an SAP project, is an opportunity to make a small difference in the world (for your customer, their employees, your fellow consultants). An SAP project gone bad can have a devastating impact on your spirit and on your career. But an optimization which goes insanely well can be extremely fulfilling for you and everybody involved. Some say that we "are born for meaning" and live for self-expression and an opportunity to share that which we feel is important. If you are lucky, you feel passionate about your job. If so, then it's with excitement that you look forward to the possibility of sharing your expertise — your story — with others. Few things can be more rewarding than connecting with someone, with teaching something new, or sharing that which you feel is very important with others.

Frankly, the bar is often rather low. SAP customers are so used to less-than-excellent performance that they've seemingly learned to see it as "normal" even if not ideal. However, if you are different, if you exceed expectation and show them that you've thought about them, done your homework and know your material, and demonstrated through your actions how much you appreciate being there and that you are there for them, chances are you'll make an impact and a difference, even if it's just in the smallest of ways. There can be great meaning in even these small connections

Getting the opportunity to work with SAP users and having the stage to present my ideas, has been most rewarding to me. It's an opportunity to share knowledge and experience, broaden my own network, and it serves as good practice. What could be better?

Thursday, October 18, 2012

building a much better basis for Inventory Analysis with SAP's Add-On "Material Document Aggregation"

have you ever wondered if you can exclude certain movements from your consumption history, when you analyze your inventories? As an example: very often I am asked if we can exclude transfer postings from being included in the consumption history of a material, because it distorts the result.

Well, in standard SAP you have two sources of consumption history. Either table MVER or info structure S031. And neither one lets you exclude certain movements or objects.

This is where Marc Hoppe and his team from SAP Consulting with their Add-On tools come into play again.

With their Add-On tool MRP Monitor comes a Material Document Aggregation tool which can provide the basis for your Analysis. This tool allows you to fill a table with consumption history to your liking. There are many selection criteria as you can see in the screen print below.



But more than that, it also allows you to calculate stock levels and dead stock. It is important that only the movements you selected before, are taken into account to calculate KPIs like average inventory, turns and dead stock. Standard SAP (and those inventory reducing analyzers out there) can't give you this.

Below an explanation on how the MDA stock calculation works.


So when the MDA (Material Document Aggregation) is done, you have a table filled with the consumption history and inventory KPIs that are including only those movements, special stocks, transactions and materials (you can exclude No-Movers or extreme slow movers, materials marked for deletion or zero stock items) that are relevant for your analysis.

This table is usually initialized for a period of two years into the past and then you set up a job that runs every months to append the recent values. 

It is also possible to create several variations of the MDA for ad hoc and What If Analytics.

Once you're done with the MDA, you will have the appropriate data basis to perform Inventory Analysis and Optimization with the Add - On tools MRP Monitor, Inventory Cockpit or Service Level Monitor and much more.