Feb
26
What is the Role of a Continuous Improvement Consultant in this Economy?
Filed Under Uncategorized | Leave a Comment
I just wanted to take a moment to update you on what we are seeing and doing in this tough economy.
1) We have worked with several folks over the past year just looking for where we could cut costs without sacrificing anything with respect to customers. To that end, I’ve found that the cost of registrations (ISO Quality and Environmental, plus the emerging certifications for carbon credits) vary more than you would suspect. We’ve found up to 20% savings by shopping the registrar. I know some feel strongly about which registrar they use, but at the end of the day the piece of paper hanging on the wall says the same thing. How many of you believe you are a better company because of your continued use of a specific registrar? This is not anything I am doing business on, but if you are interested, tell me who you are using and I’ll tell you if there is an opportunity and make an introduction for you
2) This is not the time to invest in training the masses in programs that promise a nebulous payout in the future. The next quarter is uncertain and you have processes that are not working right because volumes have diminished, people have been moved around, suppliers are struggling, customers are not paying on time, … You need improvement on some critical process now. To that end, we have done more business in the past year fixing specific problems for customers. Some quick examples of what we’ve worked on – field reliability of a critical valve in a heavy duty truck application, financial and physical forecasting for a Fortune 50’s Latin American operations, inventory and customer delivery from a Chinese supply chain, seamless tubing yield issues throughout an automotive supply chain. The annual value of fixing these issues has ranged from about $75K for the valve to >$2 billion for the Latin American operation. Cost has never been more than one-forth of the annual value of the problem and in most cases was less than 5%.
3) We have been working a new model with some old friends from Motorola. I believe it is the natural evolution from Lean and Six Sigma implementations that were heavy on training and heavy on the use of your internal resources. We have been going into companies that are successful, but struggling. Most are in high growth industries and have recently acquired, then integrated two or more companies. They have poorly documented processes, too many SKU’s, bad delivery, and are losing customer business and confidence. We go in with a small team of people and completely analyze the existing situation and formulate and execute a plan to correct it for the customer. We still need resources from the customer, but is on the order of one-twentieth what we asked for in the old model. It is tedious work, but we have focused resources not taking away from the customers focus on the day to day, and everyone participating has ten years or more experience in improving these type problems.
I just wanted you to think about these. I believe 1) just makes sense. 2) and 3) make good sense in this economy – engage outsiders on very specific tasks instead of the shotgun efforts like we’ve done in the past.
Regards,
Dec
21
Tools You should Know - Measurement Systems Formulas
Filed Under Tools you should know | Leave a Comment
These are fairly simple relationships. With the exception of %Tolerance, all the other metrics are just different manipulations of the same numbers.
s2Total = s2parts + s2Measurement System
s2Measurement System = s2Repeatibility + s2Reproducibility
s2Reproducibility = s2Operator + s2Operator*Part
P/T = %Tolerance = 6* sMeasurement System / (USL-LSL)
P/TV = %Study Variation = sMeasurement System / sTotal
%Contribution = s2Measurement System / s2Total
Distinct Categories = Round-down ((sMeasurement System / sparts) * 1.41)
And for Don Wheeler fans -
Discrimination Ratio = Square Root ((s2Measurement System / s2parts) * 2 – 1)
Look at the table showing how the numbers change depending on how much variation the measurement system is contributing and the tolerance. Distinct Categories and Discrimination Ratio are basically the same number. %Study Variation is simply the square root of %Contribution.
| s2Parts | s2MS | Tol | Cp | %Tol | %Study Variation | %Contribution | Distinct Categories | Discrimination Ratio |
| 0.99 | 0.01 | 6 | 1 | 10.0% | 10.0% | 1.0% | 14 | 14.04 |
| 0.97 | 0.03 | 6 | 1 | 17.3% | 17.3% | 3.0% | 8 | 7.98 |
| 0.95 | 0.05 | 6 | 1 | 22.4% | 22.4% | 5.0% | 6 | 6.08 |
| 0.93 | 0.07 | 6 | 1 | 26.5% | 26.5% | 7.0% | 5 | 5.06 |
| 0.91 | 0.09 | 6 | 1 | 30.0% | 30.0% | 9.0% | 4 | 4.38 |
| 0.89 | 0.11 | 6 | 1 | 33.2% | 33.2% | 11.0% | 4 | 3.90 |
| 0.87 | 0.13 | 6 | 1 | 36.1% | 36.1% | 13.0% | 3 | 3.52 |
| 0.85 | 0.15 | 6 | 1 | 38.7% | 38.7% | 15.0% | 3 | 3.21 |
| 0.83 | 0.17 | 6 | 1 | 41.2% | 41.2% | 17.0% | 3 | 2.96 |
| 0.81 | 0.19 | 6 | 1 | 43.6% | 43.6% | 19.0% | 2 | 2.74 |
| 0.79 | 0.21 | 6 | 1 | 45.8% | 45.8% | 21.0% | 2 | 2.55 |
| 0.77 | 0.23 | 6 | 1 | 48.0% | 48.0% | 23.0% | 2 | 2.39 |
| 0.75 | 0.25 | 6 | 1 | 50.0% | 50.0% | 25.0% | 2 | 2.24 |
| 0.73 | 0.27 | 6 | 1 | 52.0% | 52.0% | 27.0% | 2 | 2.10 |
| 0.71 | 0.29 | 6 | 1 | 53.9% | 53.9% | 29.0% | 2 | 1.97 |
| 0.99 | 0.01 | 12 | 2 | 5.0% | 10.0% | 1.0% | 14 | 14.04 |
| 0.97 | 0.03 | 12 | 2 | 8.7% | 17.3% | 3.0% | 8 | 7.98 |
| 0.95 | 0.05 | 12 | 2 | 11.2% | 22.4% | 5.0% | 6 | 6.08 |
| 0.93 | 0.07 | 12 | 2 | 13.2% | 26.5% | 7.0% | 5 | 5.06 |
| 0.91 | 0.09 | 12 | 2 | 15.0% | 30.0% | 9.0% | 4 | 4.38 |
| 0.89 | 0.11 | 12 | 2 | 16.6% | 33.2% | 11.0% | 4 | 3.90 |
| 0.87 | 0.13 | 12 | 2 | 18.0% | 36.1% | 13.0% | 3 | 3.52 |
| 0.85 | 0.15 | 12 | 2 | 19.4% | 38.7% | 15.0% | 3 | 3.21 |
| 0.83 | 0.17 | 12 | 2 | 20.6% | 41.2% | 17.0% | 3 | 2.96 |
| 0.81 | 0.19 | 12 | 2 | 21.8% | 43.6% | 19.0% | 2 | 2.74 |
| 0.79 | 0.21 | 12 | 2 | 22.9% | 45.8% | 21.0% | 2 | 2.55 |
| 0.77 | 0.23 | 12 | 2 | 24.0% | 48.0% | 23.0% | 2 | 2.39 |
| 0.75 | 0.25 | 12 | 2 | 25.0% | 50.0% | 25.0% | 2 | 2.24 |
| 0.73 | 0.27 | 12 | 2 | 26.0% | 52.0% | 27.0% | 2 | 2.10 |
| 0.71 | 0.29 | 12 | 2 | 26.9% | 53.9% | 29.0% | 2 | 1.97 |
| 0.99 | 0.01 | 3 | 0.5 | 20.0% | 10.0% | 1.0% | 14 | 14.04 |
| 0.97 | 0.03 | 3 | 0.5 | 34.6% | 17.3% | 3.0% | 8 | 7.98 |
| 0.95 | 0.05 | 3 | 0.5 | 44.7% | 22.4% | 5.0% | 6 | 6.08 |
| 0.93 | 0.07 | 3 | 0.5 | 52.9% | 26.5% | 7.0% | 5 | 5.06 |
| 0.91 | 0.09 | 3 | 0.5 | 60.0% | 30.0% | 9.0% | 4 | 4.38 |
| 0.89 | 0.11 | 3 | 0.5 | 66.3% | 33.2% | 11.0% | 4 | 3.90 |
| 0.87 | 0.13 | 3 | 0.5 | 72.1% | 36.1% | 13.0% | 3 | 3.52 |
| 0.85 | 0.15 | 3 | 0.5 | 77.5% | 38.7% | 15.0% | 3 | 3.21 |
| 0.83 | 0.17 | 3 | 0.5 | 82.5% | 41.2% | 17.0% | 3 | 2.96 |
| 0.81 | 0.19 | 3 | 0.5 | 87.2% | 43.6% | 19.0% | 2 | 2.74 |
| 0.79 | 0.21 | 3 | 0.5 | 91.7% | 45.8% | 21.0% | 2 | 2.55 |
| 0.77 | 0.23 | 3 | 0.5 | 95.9% | 48.0% | 23.0% | 2 | 2.39 |
| 0.75 | 0.25 | 3 | 0.5 | 100.0% | 50.0% | 25.0% | 2 | 2.24 |
| 0.73 | 0.27 | 3 | 0.5 | 103.9% | 52.0% | 27.0% | 2 | 2.10 |
| 0.71 | 0.29 | 3 | 0.5 | 107.7% | 53.9% | 29.0% | 2 | 1.97 |
Dec
20
Tools You Should Know - Defect Densities and the Poisson distribution
Filed Under Tools you should know, Uncategorized | Leave a Comment
Most are introduced to the ideas of DPU and RTY as part of Six Sigma training. Where
RTY = e-DPU
Most were not exposed to the assumptions behind this or how to use this as an analytical tool.
This relationship is based on defect densities follow the Poisson distribution and this is simply the equation for the Poisson when defects = 0. RTY is the proportion of units that will come through a process with no defects. 1 – RTY is the proportion that comes through a process with 1 or MORE defects. This assumes that the defect density is predictable.
When this idea was first put out as part of a DFA course sponsored by Bill Smith in 1987, several of us took a lot of data to convince ourselves this was true. We found that on our well-controlled processes it was true. What we found was when it was not true, there were always easy fixes possible that followed an idea put out by Juran several decades earlier. That is the idea of splitting the analysis into streams.
How to Find the Expected Defect Distribution –
Find out you DPU for the process you are interested in. Either use a Poisson table from a stat book or Excel.
If you are using a stat book, you’ll find the first column labeled np which is your DPU. Go down until you find the closest match. Then read across. These are cumulative tables so if you want to find the probability of a specific number of defects it will be the probability of that number – the probability of (1- that number).
If you are using Excel (preferred), start by creating a column labeled defects and go from 0 to about 4xDPU (Poisson is skewed right with a fairly long tail). Label the next column expected proportion. Use the fx function (called Paste Function in a mouse over) and go to Statistical – Poission and click on it. The x it asks for is the defect number (cell A2 if you started in the upper left hand corner of the worksheet). The mean is your DPU and for cumulative put false (you will get back the exact probability of the individual defect counts). Fill in actual proportions from your data and compare. A chi-squared test could be applied, but usually the numbers line up nicely or they are way out of wack.
A Hypothetical Example (based on an actual improvement project) –
A process is run making structural components for the automotive industry. Every component has defects, but components with x or less defects are further processed, components with > x defects are scrapped. The scrape rate is high, but more importantly the components that are further processed have defects detected all the way out to the end user.
The process is to run several components of a given length and when enough components are collected, multiple components are put through a heating process where there are multiple locations. The heating process joins together two metal pieces to give the component its structural integrity. No care is taken to know what pieces pass through which location in the oven. After the heating the components are put through a non-destructive test that is looking for voids in the joining process. The number of voids is collected.
It is found that the DPU detected by this test is 20. What the Poisson would predict for this is -
| Defects | Expected Percentage | Expected / 1000 Units | Cumulative Percentage |
| 0 | 0.000000% | 0 | 0.00% |
| 1 | 0.000004% | 0 | 0.00% |
| 2 | 0.000041% | 0 | 0.00% |
| 3 | 0.000275% | 0 | 0.00% |
| 4 | 0.001374% | 0 | 0.00% |
| 5 | 0.005496% | 0 | 0.01% |
| 6 | 0.018321% | 0 | 0.03% |
| 7 | 0.052347% | 1 | 0.08% |
| 8 | 0.130867% | 1 | 0.21% |
| 9 | 0.290815% | 3 | 0.50% |
| 10 | 0.581631% | 6 | 1.08% |
| 11 | 1.057510% | 11 | 2.14% |
| 12 | 1.762517% | 18 | 3.90% |
| 13 | 2.711565% | 27 | 6.61% |
| 14 | 3.873664% | 39 | 10.49% |
| 15 | 5.164885% | 52 | 15.65% |
| 16 | 6.456107% | 65 | 22.11% |
| 17 | 7.595420% | 76 | 29.70% |
| 18 | 8.439355% | 84 | 38.14% |
| 19 | 8.883532% | 89 | 47.03% |
| 20 | 8.883532% | 89 | 55.91% |
| 21 | 8.460506% | 85 | 64.37% |
| 22 | 7.691369% | 77 | 72.06% |
| 23 | 6.688147% | 67 | 78.75% |
| 24 | 5.573456% | 56 | 84.32% |
| 25 | 4.458765% | 45 | 88.78% |
| 26 | 3.429819% | 34 | 92.21% |
| 27 | 2.540607% | 25 | 94.75% |
| 28 | 1.814719% | 18 | 96.57% |
| 29 | 1.251530% | 13 | 97.82% |
| 30 | 0.834354% | 8 | 98.65% |
| 31 | 0.538293% | 5 | 99.19% |
| 32 | 0.336433% | 3 | 99.53% |
| 33 | 0.203899% | 2 | 99.73% |
| 34 | 0.119940% | 1 | 99.85% |
| 35 | 0.068537% | 1 | 99.92% |
| 36 | 0.038076% | 0 | 99.96% |
| 37 | 0.020582% | 0 | 99.98% |
| 38 | 0.010833% | 0 | 99.99% |
| 39 | 0.005555% | 0 | 99.99% |
| 40 | 0.002778% | 0 | 99.997457% |
| 41 | 0.001355% | 0 | 99.998812% |
| 42 | 0.000645% | 0 | 99.999457% |
| 43 | 0.000300% | 0 | 99.999758% |
| 44 | 0.000136% | 0 | 99.999894% |
| 45 | 0.000061% | 0 | 99.999955% |
| 46 | 0.000026% | 0 | 99.999981% |
| 47 | 0.000011% | 0 | 99.999992% |
| 48 | 0.000005% | 0 | 99.999997% |
| 49 | 0.000002% | 0 | 99.999999% |
So a real quick interpretation of this –
1) If I were placing +/- 3s limits on this like an SPC chart, they would be at 8 and 34. On my average daily production of 1,000 pieces, we would expect 2 pieces per day to be beyond the limits. This makes sense.
2) The most likely number of defects in a single piece is 19 or 20 (equal to 8 significant digits), but numbers between 11 and 29 will show up quite often.
3) Most important, I will never expect numbers like 0 – 3 or anything greater than 41. These numbers should occur less than once in our expected annual volumes.
The next thing to do is compare actual defect counts per unit with the theoretical counts –
| Defects | Expected / 1000 Units | Actual / 1000 Units |
| 0 | 0 | 0 |
| 1 | 0 | 0 |
| 2 | 0 | 0 |
| 3 | 0 | 1 |
| 4 | 0 | 4 |
| 5 | 0 | 8 |
| 6 | 0 | 17 |
| 7 | 1 | 29 |
| 8 | 1 | 44 |
| 9 | 3 | 58 |
| 10 | 6 | 70 |
| 11 | 11 | 76 |
| 12 | 18 | 76 |
| 13 | 27 | 70 |
| 14 | 39 | 60 |
| 15 | 52 | 48 |
| 16 | 65 | 36 |
| 17 | 76 | 26 |
| 18 | 84 | 17 |
| 19 | 89 | 11 |
| 20 | 89 | 6 |
| 21 | 85 | 5 |
| 22 | 77 | 3 |
| 23 | 67 | 3 |
| 24 | 56 | 4 |
| 25 | 45 | 4 |
| 26 | 34 | 6 |
| 27 | 25 | 7 |
| 28 | 18 | 10 |
| 29 | 13 | 12 |
| 30 | 8 | 14 |
| 31 | 5 | 17 |
| 32 | 3 | 19 |
| 33 | 2 | 20 |
| 34 | 1 | 21 |
| 35 | 1 | 22 |
| 36 | 0 | 22 |
| 37 | 0 | 22 |
| 38 | 0 | 20 |
| 39 | 0 | 19 |
| 40 | 0 | 17 |
| 41 | 0 | 15 |
| 42 | 0 | 13 |
| 43 | 0 | 11 |
| 44 | 0 | 9 |
| 45 | 0 | 7 |
| 46 | 0 | 5 |
| 47 | 0 | 4 |
| 48 | 0 | 3 |
| 49 | 0 | 2 |
| 50 | 0 | 2 |
| 51 | 0 | 1 |
| 52 | 0 | 1 |
| 53 | 0 | 1 |
| 54 | 0 | 0 |
| 55 | 0 | 0 |
| 56 | 0 | 0 |
| 57 | 0 | 0 |
| 58 | 0 | 0 |
| 59 | 0 | 0 |
| 60 | 0 | 0 |
Wow, something is wrong!
The team is reconvened to go back through the process maps to specifically brainstorm where there is clearly a consistent input at work and where there may be variation across the input. Things like material batches, the front end of the process where the metal pieces are straightened and fixtured to go to the heating process, and the cooling process prior to the non-destructive test. After discussion it is understood that the data is only one days production and the metal supplier was consistent making the front end of the process consistent (relatively speaking). After much discussion, it is agreed to keep track of the position inside the heating process. Long story short, the team finds that the middle 2/3’s of the oven is running at 12 DPU and the outer 1/6 on each side is running at 36 DPU.
The team decides on a containment action to only run in the center 2/3’s of the oven while further studying consistency of the oven.
There is a lot more to the study as the original containment did not work (the physics of it not working made sense), but the team learned to make the containment work achieving 12 DPU but production capacity was reduced. With about $5K worth of modifications, learned to run full loads again at 5 DPU.
Nov
16
A Sense of Urgency?
Filed Under Human Architecture, Leadership, Strategy Execution | 1 Comment
I saw Steve Forbes Friday night and listened to a fairly compelling argument that our current financial crisis is a series of bad decisions. President elect Obama, you should talk to him. The rest of you should find what he has been writing over the past months because his knowledge and depth were wasted on my short-term memory.
Four things that did stick with me –
1) We need a policy of a strong dollar. This is not negotiable.
2) We need to help our domestic auto industry in ways that will help their sustainability. Simple question we all need to understand is why are GM and Ford phenomenally successful outside the US? Forbes made the point that if GM and Ford would close down their US operations they would be seen as world-class companies. Wow – something to think about and it has little to do with unions, although the unions need to get their workers to work more often. Ten percent absenteeism is obscene – if the UAW deals with that they will be seen as more relevant. The work needs to be made more interesting as well, which is on the leadership of GM, Ford and Chrysler.
3) Taxes cannot be raised in a crisis. This means that spending must be cut. This is combination of stopping dumb things like bailouts that don’t address root causes. It also means efficiency in government vs the current placebos. Cut non-entitlement budgets across the board including the Pentagon and hire consultants that know how to implement and advise - instead of the mass training houses. Also buy all managers in government agencies a copy of Kotter’s latest book. Fire all who whine or block instead of seeing the opportunity. Efficiencies will be found and the work will be more interesting.
4) Health care has to be addressed with efficient system wide solutions. Piece-meal solutions will not cut it which means expansion of existing programs won’t do. Forbes’ example was that of medical tourism – why is a flight to Singapore and surgery to have a knee replacement one-fourth the cost of doing it in the US? How can these hospitals offer first class results with infection rates that are nonexistent? Lasik surgery is another example – success rates are up and costs are substantially reduced from a decade ago. Why? Understand the answer and you will be looking at what efficient reform looks like.
Forbes says it is time for Obama to turn into a pragmatic politician to make sure he is there for 8 years. Steve has some good thoughts, take some time to understand them and encourage your government officials to understand them as well. I personally would like to keep a smart person in the White House and have them surrounded by smart people. I don’t want Steve as my President, but I would be impressed if he became a trusted advisor to Obama.
Read what Steve is writing at - http://search.forbes.com/search/colArchiveSearch?author=Forbes
Gary
Nov
10
What’s Important?
Filed Under Human Architecture, irRelevant Reflections | Leave a Comment
With the economic turmoil and the elation and fear to go with the recent elections, we sometimes make things more important than they are.
I listen to Christian radio sometimes and also NPR. I have been intrigued with the absolute negative response to Obama in some circles - the sign of the coming apocalypse because of some of his views. I wonder how that is balanced with the killing going on daily on false premises. I honestly don’t know the answer.
I would never want a child brought into this world that will not be loved often and always. I would not choose to impose my position on anyone, but I see children on a daily basis that are not loved, that are not taught values, that are not taught self worth. Life is tough anyway, and those children don’t have good chances in life - it is not their fault.
Tonight I held and danced with my almost four-week-old niece. I sang Jimmy Buffet songs to her and she cooed and made baby sounds and slept in my arms for more than an hour.
I cried.
Tomorrow is my birthday – what a great birthday present.
Life does not get any better than this.
Gary