Steve Hunt, LSSBB

Steve Hunt, LSSBB
Whether in DMAIC, Design for Six Sigma (DFSS), Lean projects, or Design of Experiments (DOE), uncertainty and variability lie at the core of any Six Sigma analysis. I'm interested in how Monte Carlo simulation can be used to identify, measure, and root out the causes of variability in production and service processes and designs.

Truly Understanding Hypothesis Testing Concepts: Making a Complex Topic Simple

Friday, February 17, 2012 by Steve Hunt

I attended e-learning micro-event event last week! It’s a great concept being used by Smarter Solutions. The concept is to provide short one hour training classes (“micro-events”) via the web for a very low cost. The micro event I attended was titled, Truly Understanding Hypothesis Testing Concepts: Making a Complex Topic Simple.  It truly lived up to its name; ~67% of the participants went away with a better understanding of Hypothesis testing after the hour.

The micro training event was led by Rick Haynes of Smarter Solutions. Rick is an excellent Lean Six Sigma Instructor, Statistical Consultant, Coach and mentor to process improvement practitioners. Rick did an excellent job using the tools at his disposal (even Monte Carlo Simulation using the @RISK software) to make this truly complex topic “simple”.

Weighted Matrix In case you don’t know, Hypothesis testing is a concept that is taught in Lean Six Sigma and statistics courses. During the event, he walked through the concepts of alpha and beta risk along with power and confidence choices using a completely different method than you would have been taught in a class. Through the use of diagrams and simulations, he made the hypothesis concepts real and understandable. Mr. Haynes, used @RISK was to test the Hypothesis test theory (a t-test), showing how the risk of each hypothesis test decision changed as the initial conditions of the test were changed where most classes just provide graphics and equations.  It was a powerful method to teach statistics.

If you are interested in viewing the recording of the micro training event it can be done so for a micro-charge of less the $25! If you do, please let me know your thoughts.

Free Webcast this Thursday: “How Capable are Your Capability Metrics? Using @RISK to Demonstrate Their Limitations”

Tuesday, February 14, 2012 by Steve Hunt
Join us this Thursday, February 16, 2012, for a free live webcast entitled, "How Capable are Your Capability Metrics? Using @RISK to Demonstrate Their Limitations," to be presented by Rick Haynes.

In the field of Six Sigma, there is a lot of discussion about the applicability of the traditional capability metrics. Cp, Cpk, Pp, and Ppk are very popular in some areas, but not all truly understand what the metric is trying to communicate about the process. In this free live webcast we will take a look at a typical data set to see how the capability index (Cpk) is reported based on different assumptions and calculation methods using risk analysis and Monte Carlo simulation software @RISK.

At the end of this webcast you will fully understand the usage of Cpk in regards to:
  • Normal vs. non-normal data
  • Stable vs. unstable data
  • The uncertainty of capability estimates (confidence intervals)
Join us for this webcast, and you will never be confused or lied to by Cpk!

Rick Haynes has more than 20 years' experience in project management, training, applied statistics, engineering, and customer support. He has taught and certified professionals in all Lean Six Sigma areas. His consulting work has included all facets of business; building corporate performance dash boards, developing the Integrated Enterprise Excellence (IEE) system at a manufacturing firm, development of a process management and control system in a manufacturing firm, quality auditing of construction projects, developing reliability models for equipment failures, facilitating executive strategy development efforts, executive leadership coaching, modeling business performance for predictive analysis, improvement practitioner coach. Professional positions include; manufacturing site engineering manager, US Naval Officer (Submarines), corporate process improvement director, DOE research statistician, chemical process engineer, nuclear engineer.

» Register now (FREE)
» View archived webcasts

Using Monte Carlo Simulation to Understand the Sensitivity of a Complex System

Monday, December 5, 2011 by Steve Hunt
Can averages be a dangerous measurement on which to base your decisions?

According to Britt Calloway, Research and Development Engineer for Bastian Solutions, they can be. In Britt’s case, he used a toy robot to model target throughput of an actual robot in a palletizing operation, and his concerns over uncertainty in this test lead him to @RISK.

Britt discovered that errors in picking up pieces of puzzle parts with his robot arm could drastically affect the cycle time he was measuring. For example, he would bungle the grab for a part, and it would slide away from the robot. He initially thought he would reject the mistakes in the test, but then realized those types of anomalies happen all of the time in the real world, and they would need to be represented as uncertainty in a model using Monte Carlo Simulation.

Britt elaborated . . . “In a robotic palletizing system, there can be box flaps missing, vacuum cups that my need to be replaced, human error, maintenance downtime, and other factors that affect throughput . . . Monte Carlo methods are a way to use engineering insight and more qualitative assessments of your inputs to define a quantitative output.”

Fortunately for Britt, the robot was a toy, but as you can see in his blog, Monte Carlo simulation is no toy when time and money are concerned.

See Britt’s blog here: http://www.bastiansolutions.com/blog/index.php/2011/11/23/the-sensitive-engineer-using-monte-carlo-simulation-to-understand-the-sensitivity-of-a-complex-system/

Smoothing the Rough Places in Supply Chain Management

Monday, June 6, 2011 by Steve Hunt

Recently Software Advice posted a guest blog on supply chain planning by Chad Smith and Carol Ptak  of the Demand DrivenSupply Chain Institute.  Their agenda is to improve the efficiency and agility of supply chains by changing the way manufacturers conceive of Material Requirements Planning.  They believe that conventional ERP software is too generic to account for the complexities of managing materials and scheduling for globally distributed manufacturing operations, and they're looking for a shift in paradigm from "push and promote" to "position and pull," in which at any given moment a multi-layer planning procedure brings demand into full alignment with material requirements.

For Smith and Ptak, the current manufacturing environment is characterized by volatility and variability, and I'd like to add to their excellent discussion the point that  there is a long-established technique for mitigating the risks posed by these forces: Monte Carlo simulation.  Predictive modeling of the risks as they occur in the manufacturing-supply cycle would be a straightforward way to aggress volatility and variability. It would be roughly parallel to the risk analyses we've been applying to value chains for a number of years now.  And, as my customers working in Six Sigma, Design for Six Sigma, and other process improvement efforts have discovered, good tools for doing Monte Carlo in Excel are not hard to come by.  They're now adopting Monte Carlo simulation on a much wider scale, and there's no doubt that this technique could also smooth out the rough places in any demand-driven planning process.

Free Webcast Today! 11:00am - Noon ET: “What Is Our Risk If We Cut Too Deep In Our Workforce?”

Thursday, January 20, 2011 by Steve Hunt
Today from 11:00am to Noon ET, Sandi Claudell will present a free live webcast.

In all businesses there is a certain demand on resources to produce a certain amount of results in a given window of time. Building a car to meet customer demand, answering help lines so no one waits too long or drops off the line, processing invoices, etc.

This is true in healthcare as well. Whether in clinics or Emergency Departments, the concern is:
  1. Are my patients waiting too long to be seen? Perhaps so long that they leave without being seen at all.
  2. Do I have enough staff to handle the load. Do I have the right mix of physicians, nurses and clerks?
  3. Do we have enough rooms to handle the load of patients?

In the discipline of “Lean” there are a few key calculations we use to determine the needed time and resources. One calculation is ‘takt time’ or ‘takt rate’. This is a simple calculation of the number of minutes available divided by the number of patients needing to be seen. Each step in the process cannot take any longer than this unit of time OR you need to double up on the resources. For example, if the takt rate is 15 minutes then the following steps cannot take any longer than 15 minutes each: registration, vitals (blood pressure, weight, etc), initial triage by the nurse, instructions after meeting with the physician and setting up the next appointment. However, if the doctor typically visits with the patient for 30 minutes then we need 2 physicians in this clinic … this way a patient will exit the clinic every 15 minutes.

Another calculation is “Process Lead Time”. This is based upon the ‘exit rate’ and the number of patients waiting to be seen. It calculates how long the last patient will have to wait before entering and/or exiting the process.

One of the biggest push backs I get in healthcare is that each patient is unique and the volumes of patients seen each day varies and is unpredictable.  They are also unclear on just how many doctors, nurses and exam rooms would be required to keep up with the pace of incoming patients.

I used @RISK to determine the number of rooms, nurses, physicians etc. based upon the varying number of patients to be seen each day. This was helpful in determining how to assign exam rooms in corridors and if they need to hire more nurses per shift etc.

This free live webcast will go through the process we used and the graphic outcomes.


» Register now (FREE)
» View archived webcasts

The Summit Looms!

Wednesday, January 5, 2011 by Steve Hunt

IQPC
There's an important event coming up in just a few short weeks--"Profit through Process," the IQPC Lean Six Sigma summit.  The summit is an almost week-long conference in Orlando, January 17 through January 20. IQPC has rounded up about 800 experts to deliver their knowledge, insights, and often inspiration to the folks who attend.   These presenters represent some high-profile companies like BP and PayPal, as well as leading consulting firms.

The sessions have been organized to satisfy the hankerings of everybody in the Six Sigma-process optimization crowd, from the chief quality officer to the Black Belt. And one thing I think will be really productive for the folks who get down to Orlando is the conference's emphasis on integrating a Lean Six Sigma program so that it becomes a living part of the organization.

Eight hundred is a lot of experts, who should have a lot of useful ideas about driving profit through process improvement.  And will be a lot of useful tools to check out.  Which brings me to my role at the summit--how can I sign off on thes blog without putting in a plug for Palisade?  I'll be there with our Monte Carlo software--booth #7--extolling the virtues of Monte Carlo simulation for Lean Six Sigma.  Monte Carlo simulation is a relatively recent addition to the Six Sigma toolkit, and while you may not think risk analysis is central to process optimization, it is really about getting a grip on uncertainty--and you can certainly relate to that.

Please know the IQPC is offering a "Free Hall Pass" for those interested in networking or exploring the latest Lean, Six Sigma & BPM solutions.

Remember, it's January, and you can come to Florida!  Here's the website--www.leansixsigmasummit.com/Event.aspx?id=341814.

I hope to see you there!

Information Rich Data Poor - Data Converted into Information for Hospital Management

Monday, November 22, 2010 by Steve Hunt

A couple of months ago Palisade Partner Ed Biernat and I gave the Times of London our perspective on what kinds of workplaces were promising avenues for expansion of Six Sigma. We pointed out that hospital operations were a field wide open for plowing. We didn't go into the substance of this suggestion, but now MindSpring's Sandi Claudell, a Master Black Belt in Lean Six Sigma, has sent us a richly detailed white paper with an example of process improvement in a hospital emergency department. 


Sandi's white paper is based on one very simple observation: it's much easier and faster for anyone--a nurse working triage or the ORstatistical analysis geek in biostatistics–-to understand numerical trends if they're presented in graphs rather than tables. Hospitals collect huge amounts of data, and often these are not adequately analyzed or--eventually--used. Sandi suggests that changing the way this information is presented will make a difference in how useful the data become.

Taking a few weeks' worth of emergency department data from an east coast hospital, Sandi asked some questions about the patient's experience that would probably be posed in a standard operation research study. Here are a few of them:

  • What was the average amount of time a patient waited inside the emergency department?
  • What percentage of these patients waited behind the national benchmark of 4 hours?
  • How does the hour of a patient's arrival influence how long he or she waits?
  • Does it matter which doctor is running the department?

The various types of graph Sandi uses answer these questions almost immediately--and there are some surprises as you read them. Although it takes a certain amount expertise in statistical analysis to create the graphs, it takes none to read them. There's an old message here, and in this hospital case, it's unavoidable: a picture is worth a thousand words. If you want people in your organization to get real, actionable information from all the data you're gathering, draw a picture with the numbers.

 

If you're interested in taking a look at Sandi's paper and the numerical pictures in it, go to http://sandiclaudell.wordpress.com/2010/11/19/data-converted-into-information-for-hospital-management/

 

Six Sigma in Plain English

Thursday, September 9, 2010 by Steve Hunt

You've probably noticed that as Six Sigma and other lean management strategies have become more widely adopted, the jargon their practitioners use has also multiplied.  Take, for instance, the acronyms JIT, QRM, SIPOC--or even the names of the practices themselves, as in DFSS. So when a collogue contacted me to give me the link to a recent blog he had posted, I was pleased to follow the link and find that what he has produced is a plain English primer and glossary for Six Sigma.  It's a kind of Six Sigma for Dummies.

It's a very worthwhile effort--well organized, clearly written, and it reduces the sometimes gnarly ideas behind lean methods to their simplest formulations. Best of all, here, laid out in tables according to their primary purpose, are all the confusingly similar acronyms we use. QFD, QTQ, DMAIC, DMADV--if you can spell it, he can name it and give you a tight working definition of it.

The author of this useful work, is Stephen Jannise. He heads up Enterprise Resource Planning--ERP, right?-- for Software Advice, a firm that helps other companies select software best suited for their needs. This means he's a friend not only to us at Palisade Corporation but to a number of other developers who produce software, and sometimes jargon, for the Six Sigma market. To read the full article, visit: A Plain English Guide to Modern Manufacturing Methods.

Free Webcast This Thursday: “Assessing Your New Product, Process or Service Introduction Methodology: Is Yours Premier? Does it Enable Six Sigma Performance?”

Monday, August 16, 2010 by Steve Hunt
On Thursday, August 19, 2010, David Roy will present a free live webcast entitled. "Assessing Your New Product, Process or Service Introduction Methodology: Is Yours Premier? Does it Enable Six Sigma Performance? "

As companies make changes to or introduce new Products, Processes or Services, we observe a wide spectrum of methodology; from well defined process with trained resources, effective tools and excellent results - to no process, ad hoc application of tools, and frequent cycles of “Launch and Learn.”

Where does your methodology rank?

In this free live webcast, we will provide a framework for assessing the Process, People, Tools and Results for premier attributes in the New Product, Process, Services Introduction Methodology.


» Register now (FREE)
» View archived webcasts

Oops! Didn’t see that coming! Part 4

Monday, August 9, 2010 by Steve Hunt

This is the conclusion of Dave Roy’s guest blog, we hope you have found them informative. Again, Dave comes to us from SSPI, Six Sigma Professionals, Inc., and taught Jack Welch and his entire staff their Six Sigma Green Belt training. Also, look for Dave’s free live webcast on August 19th, Assessing your New Product, Process or Service Introduction Methodology: Is yours premier? Does it enable Six Sigma performance?



Oops! Didn’t see that coming! Part 4
 

 

As a continuation from the July blog, we are now concluding with the “Optimize” and “Validate” phases of the ICOV (Identify-Conceptualize-Optimize-Validate) framework of a rigorous new design process as explained in “Services Design for Six Sigma – A Roadmap for Excellence”.

 

These phases are important because it allows time and methodology to optimize the design, develop all of the detailed documentation, verify performance and capability under operating conditions and manage an orderly transition to the new state.

 

The Optimize phase consists of a single stage (Design Optimization) and associated Tollgate 5 to validate successful completion of the requirements. 

 

The Design Optimization stage involves completing all of the detailed design documentation, building Prototypes of the design, simulating/analyzing Process Capability, preparing all Control Plans and updating the Design and Process Scorecards.

 

Tollgate 5 Exit Criteria:

o    Agreement that functionality and performance meet the customers’ and business requirements under the intended operating conditions.

o    Approval to proceed with the Validate stage.

 

Formal tools which can be used in this phase are Design Scorecard, Process Management, Mistake Proofing, Simulation, Change Management, Control Plans, Reliability and Robustness.

 

The Validate phase consists of two stages (Verification and Launch Readiness) and associated Tollgates (6 and 7) to validate successful completion of the requirements. 

 

The Verification stage involves developing Pilot plans, Piloting the new design and process and analyzing and making adjustments to achieve the desired functionality and performance under operating conditions.

 

Tollgate 6 Exit Criteria:

o    Agreement that functionality and performance from the pilot meet the customers’ and business requirements under the intended operating conditions.

o    Approval to proceed with the Launch Readiness stage.

 

Formal tools which can be used in this phase are Design Scorecard, Process Management, Mistake Proofing, Change Management, Control Plans, Statistical Process Control (SPC), and Confidence Analysis.

 

The Launch Readiness stage involves developing Pilot plans, Piloting the new design and process and analyzing and making adjustments to achieve the desired functionality and performance under operating conditions.

 

Tollgate 7 Exit Criteria:

o    Agreement that transition plans and training plans have been developed and are executable.

o    Approval to proceed with the Production stage.

 

Formal tools which can be used in this phase are Transition Plans, Training Plans, Process management, Change Management and Control Plans.

 

Following the ICOV model we have now used a formal methodology that allows us to validate performance at progressive economical stages and have improved the ability to detect unknown risks thus avoiding the Oops! Didn’t see that coming!. It should be mentioned that the methodology should be flexible and scalable to adjust for level of invention and risk. A brand new invention (Research & Development) that has never been deployed in similar conditions is much different than implementing a known solution (Application Engineering) under new conditions.

 » Part 1
 » Part 2
 » Part 3
 

 

 

BIO:

 

David Roy is an integral part of the Six Sigma community. He taught GE’s Jack Welch and entire staff Six Sigma, as well as served as Senior Vice President of Textron Six Sigma. He is a Certified GE Master Black Belt, was instrumental in developing GE’s DMADV (DFSS) methodology, and has taught 3 waves of DFSS Black Belts. David holds an BS in Mechanical Engineering from The University of New Hampshire. He is also the co-author “Services Design for Six Sigma – A Roadmap for Excellence”

 

Oops! Didn’t see that coming! Part 3

Monday, July 19, 2010 by Steve Hunt

We are pleased to welcome back to my blog consultant and trainer David Roy from Six Sigma Professionals, Inc.

 

 

Oops! Didn’t see that coming! Part 3
 

 

As a continuation from the June blog, we are now covering the “Conceptualize” phase of the ICOV framework of a rigorous new design process as explained in “Services Design for Six Sigma – A Roadmap for Excellence”.

 

This phase is important because it conceives, evaluates and selects good design solutions through robust process methodology which ensures alignment to the customer and the business needs.

 

Many design solutions skip this phase and become typically named as “Launch and Learn”.

 

The Conceptualize phase consists of two stages and associated Tollgates to validate successful completion of the requirements. 

 

The Concept Development stage involves translating Customer requirements into solution free Functional requirements, developing the System Level Conceptual Design, generating Concepts for required functions, Concept selection and translation of the Functional Requirements to Design Parameters.Click to Enlarge

An example of a Functional Requirement for a Customer Want of “Speedy Service” could be “Speed of Service” and a Design Parameter could be “Waiting Time

 

Tollgate 3 Exit Criteria:

  • Assessment that the Conceptual Development Plan & Cost will satisfy the customer base
  • A Decision the design represents an economic opportunity (if appropriate)
  • Verification adequate funding will be available to perform Preliminary Design
  • Identification of the Tollgate Keeper & the appropriate staff
  • An action plan to continue flow-down of the design Functional Requirements

 

The Preliminary Design stage involves creating the design documentation and configuration management, performing design analysis and testing, translating the Design Parameters into Process Variables and formulating the Production strategy.

An example of further mapping the Design Parameter of “Waiting Time” to a Process Variable could be “Number of Phone Lines

 

Tollgate 4 Exit Criteria:

  • Acceptance of the selected Solution/Design
  • Agreement the Design is likely to satisfy all Design Requirements
  • Agreement to proceed with the next stage of the selected Solution/Design
  • An action plan to finish the flow-down of the design Functional Requirements to design parameters and process variables

 

Formal tools which can be used in this phase are QFD, TRIZ/Axiomatic design, Measurement System Analysis (MSA), Failure Mode effect Analysis (FMEA), Design scorecard, Process mapping, Process management, Pugh Concept Selection, Robust Design, Design Scorecards, Design for X and Design reviews.

 

The next and final blog will cover the Optimize and Validate phases.

 

BIO:

 

David Roy is an integral part of the Six Sigma community. He taught GE’s Jack Welch and entire staff Six Sigma, as well as served as Senior Vice President of Textron Six Sigma. He is a Certified GE Master Black Belt, was instrumental in developing GE’s DMADV (DFSS) methodology, and has taught 3 waves of DFSS Black Belts. David holds a BS in Mechanical Engineering from The University of New Hampshire. He is also the co-author “Services Design for Six Sigma – A Roadmap for Excellence”

 


 » Part 1
 » Part 2


@RISK Six Sigma calculator models the performance of a process with uncertain elements

Thursday, June 17, 2010 by Steve Hunt
Developed using the Six Sigma features of @RISK,
software for risk analysis using Monte Carlo simulation


Palisade’s Six Sigma Calculator allows you to create a function that models the performance of a process with uncertain elements. It allows you to include uncertainty around design factors through the use of probability distributions. It was built by Palisade Custom Development using the @RISK Developer’s Kit (RDK) to perform a Monte Carlo simulation so the following process capability metrics can be calculated: Cpk, Cpk Upper, Cpk Lower, Sigma Level, DPM, Cp, Ppk, Pp.

The RDK is Palisade’s widely-used risk analysis programming toolkit. It uses the features and functions of @RISK for Excel - the industry-leading risk analysis tool for spreadsheets. The RDK allows you to build Monte Carlo simulation models in your own applications using Windows and .NET programming languages, such as C, C#, C++, Visual Basic, or Visual Basic .NET. Examples of programs written in Windows and .NET programming languages are provided.

Palisade Custom Development services are used to build tailored applications for individual client needs using @RISK and other technology.

» Six Sigma Calculator
» More about using @RISK for Six Sigma
» More about using @RISK
» Palisade Custom Development

Oops! Didn’t see that coming! Part 2

Tuesday, June 15, 2010 by Steve Hunt

Guest blogger David Roy Six Sigma Professionals, Inc., and taught Jack Welch and his entire staff their Six Sigma Green Belt training. Dave also has a quick survey for your input on structuring DFSS training. brings us the second installment of his four-part blog. Dave comes to us from SSPI,

 

--Steve Hunt

 
Oops! Didn’t see that coming! Part 2

We’d like to ask for your guidance by completing a short marketing survey to help SSPI structure our training in a way that is most useful to our community. This 8 question survey should take less than 5 minutes, and is anonymous. Your opinions are greatly appreciated.

As a continuation from the May blog, we are now covering the “Identify” phase of the ICOV framework of a rigorous new design process.

This phase is important because it establishes the framework for the concept, establishes the level of rigor required for the project management process, estimates the development cost, collects the Customer and Business requirements and the criteria for success.

 

The level of project management needs to be flexible and scalable depending on the Level of Effort (cost) and the Level of Innovation (risk) of the new concept.

 

Surely a project that will take a month to develop and has been done elsewhere requires less rigor that a concept that will take 3 years to develop and represents a brand new invention which has never been done before.

 

The I phase consists of two Tollgates during which an objective steering committee will decide whether to refine the work in the current phase, proceed or cancel the project. 

 

Tollgate 1 Exit Criteria are:

o     Decision To Collect The Voice Of The Customer To Define Customer Needs, Wants And Delights

o     Verification adequate funding is available to define Customer Needs

o     Identification of the Tollgate Keepers1 leader & the appropriate staff

 

Tollgate 2 Exit Criteria is successful demonstration of:

o     Assessment of market opportunity

o     Command a reasonable price or be affordable

o     Commitment to development of the Conceptual Designs

o     Verification adequate funding is available to develop the Conceptual Design

o     Identification of the Gate Keepers leader (gate approver) & the appropriate staff

o     Continue flow down of CTSs to Functional Requirements

Click to Enlarge 

Formal tools which can be used in this phase are Market/Customer research tools, Product Roadmaps, Process Roadmaps, Technology Roadmaps, Multigenerational plans, Quality Functional Deployment (House of Quality).

 

Market/Customer research tools may include Customer Relationship Management (CRM) Data, Surveys, Focus Groups, Conjoint Analysis and Kano Model Analysis.

 

The next blog will cover the Conceptualize phase

 

 

 

BIO:

 

David Roy is an integral part of the Six Sigma community. He taught GE’s Jack Welch and entire staff Six Sigma, as well as served as Senior Vice President of Textron Six Sigma. He is a Certified GE Master Black Belt, was instrumental in developing GE’s DMADV (DFSS) methodology, and has taught 3 waves of DFSS Black Belts. Dave’s experience includes Product and Transactional so his examples are of interest to all. David holds an BS in Mechanical Engineering from The University of New Hampshire. He is also the co-author “Services Design for Six Sigma – A Roadmap for Excellence”

» Part 1

(Data) Cleanliness Is Next To Godliness

Monday, June 7, 2010 by Steve Hunt

I’m pleased to welcome Palisade Six Sigma Partner Edward Biernat of Consulting with Impact as featured guest blogger. As well as running a successful consultancy, Ed is a noted Six Sigma educator and author.

 

--Steve Hunt

 

 

(Data) Cleanliness Is Next To Godliness

 

I recently had dinner with Eric Alden, a Master Black Belt for Xerox corporation.  Eric had just gotten back from the American Society for Quality’s  (ASQ) headquarters in Milwaukee where he was one of 200 Master Black Belts worldwide that generated the questions for the upcoming ASQ Master Black Belt certification examination (more on that in an upcoming post).  Eric had also recently completed a mini-course for the local ASQ chapter on data integrity.  We shared some war stories and came up with some common threads regarding data integrity.

 

1.       Just because it is a number doesn’t mean it is worth anything.  People get enamored with tons of data from process instrumentation, shop floor collection sources or Excel spreadsheets.  There seems to be a false security with this pile of data, and managers often look to the Black Belt to ‘sort it out’, because with all that data, the answer is in there somewhere.  Many a belt has crashed on the rocky reefs of bad data, often after tons of time and effort (and credibility) were wasted generating false answers.

2.       GIGO.  The Garbage In – Garbage Out philosophy of computing applies especially to existing corporate databases.  Here a few recent examples of GIGO.

a.       A belt wanted to analyze the specific timing of events in shop floor process and had tons of data from the process instrumentation that had times down to the fraction of a second.  After lengthy analysis, they found a significant difference between two shifts and forced the lesser shift to adopt the sequence of the more uniform shift.  After introducing costly production problems and actually hurting the overall process, the sensors were found to be faulty and the overall process subject to human manipulation to generate the ‘pretty charts’ that everyone expected.

b.      Office areas are not immune.  Something as simple as a checksheet to gather data to analyze when a particular computer error occurred can be in question, especially when the clerk fills in the times at the end of the shift from memory rather than logging the event as it occurs.

3.       Good data in bad spreadsheets.  Even if you get good data, having an inexperienced person setting up the spreadsheet can cause problems.  It is analogous to a person using a word processing software and making a table using spaces and tabs.  It looks like a great table until you have to manipulate it.  Then it falls apart.  Problems like merged cells, subtotals, random formula inserted in cells, etc. can make a Belt weep and cause significant errors in the resulting analyses.

4.       Useless manipulation.  Often a big issue is that management wants data sliced a certain way for no good reason.  This sometimes leads to the proliferation of additional spreadsheets or databases that needlessly add to complexity.  (Note: If you have an ERP system like Oracle or SAP, USE IT!  They are designed to house data and protect its integrity.  Plus the data entry screens typically allow for better and more accurate entry.  Few things are more wasteful than entering everything in the ERP system then re-entering it into a spreadsheet to appease a manager’s inability to adapt and change.)

 

What are some tactics for resolving these issues?

1.       On a macro level, start ensuring that the data that your company is collecting is sound data as part of the preparation for a Six Sigma launch, or a part of plain old good business.  Bad data slows down or stops a Six Sigma project dead in its tracks, changing it from getting something done to fixing the data. 

a.       Know catalog your data databases, including the extra ones (Excel, Access) that are usually relied upon but undocumented.

b.      Prioritize the data sources by synchronizing them with your Six Sigma launch sequencing. 

c.       Sample the data to insure its usefulness.  If it is bad, fix it.  This will give teams better data to start off with and will allow time for that data to accumulate for analysis.

2.       For specific projects, conduct a Measurement System Analysis (MSA) on you data sources (This tool is often used in the Measure phase of the DMAIC model).  We often think of MSA’s when it comes to physical measurements.  It is just as critical in the ‘softer’ data. 

a.       Pull the correct sample size.  In StatTools, under  Statistical Inference there is a Sample Size Selection tool that can be used to pull the correct amount of data needed for the analysis.

b.      Pull your data randomly and follow the trail to the actual entry point.  That may mean watching how individuals enter data, probing for special circumstances, etc.

c.       In your analysis, look for random factors such as vacation fill-ins.  Both Eric and I both had several experiences where one person was filling in for someone who is out sick or on vacation and, usually do to inadequate training, varies from the expected process.

3.       Pivot Tables are our friends.  Start today upgrading the skill sets of the people that do the actual data entry and first level analysis.  Train them in how to use tools like Picot Tables that slice the data but leave the actual spreadsheet intact.  The fewer merged cells, etc. that we fight with, the better.

4.       Managers – Trust your Belt.  If they say the data is bad, it probably is.  No matter how much you want an answer today, you may not be able to get one.  The good news is that some processes can be modeled using @RISK to begin improvement that is directionally correct while waiting for the data to compile.  Then the better data can be used to either update or replace the early model.

5.       Go hunting.  Find extraneous datasets and merge them / kill them.  The fewer that are out there, the more likely you will be able to ensure the integrity of those that remain.

 

Remember that data analysis is a funnel.  Tons of data leads to bunches of information which then can help us make some decisions.  Throwing bad data into the system is similar to throwing bad tomatoes into the food distribution system.  The end results can be pretty messy and difficult to clean up. 

 

Also, don’t miss Ed Biernat’s free live webcast DMAIC and Using a Non-Intuition Approach, Thursday, 11AM Eastern Time.

 

Sign up here:

https://palisade.webex.com/palisade/onstage/g.php?d=719996370&t=a

 

 

BIO:

 

Edward Biernat is the president of Consulting With Impact, Ltd., a training, coaching, and consultancy located in Canandaigua, NY that he founded in 1998.

Another take on the BP Oil Spill

Friday, May 28, 2010 by Steve Hunt

We are pleased to introduce you to consultant and trainer Sandi Claudell, today’s featured guest blogger. Sandi is CEO of MindSpring Coaching, and has been a valued Palisade Six Sigma Partner for quite some time. She is a Six Sigma Master Black Belt (Motorola), and is a Lean Master (Toyota Motors - Japan) among other notable achievements.

--Steve Hunt


Part 1: The Platform Disaster

Much has been said about the disastrous BP oil spill in New Orleans. If we use the theory of probability and reliability then have too many different companies responsible for a very complex construction and operation added to the chance of failure.

 

There is probably a cultural issue at work where each entity wanted to give the other what they wanted to hear rather than the truth. (For historic and recent examples: NASA Challenger and recent Toyota Prius problems). When we lose sight of quality and reliability of parts, construction, maintenance, testing under ALL conditions rather than the obvious few, etc. then we run high risks of failure. When you build 100+ wells and avoided disasters  . . . perhaps people fool themselves into thinking there never WILL be a disaster. They don’t look at a model that demonstrates the longer you go without such an event (given the input factors of how each element can and will fail) the closer you come to the event we all want to avoid.

 

They may or may not have used an integrated Systems Design  . . . not simply an engineering system but the system on how individuals work together, communicate with each other, act as a conforming unit or a more self-directed autonomous unit looking for and generating solutions outside the box. A team that is innovative and willing to look at all the possibilities and create a breakthrough design that was / is more mistake proof.

 

If they had used DFSS (Design for Six Sigma) then their designs would be more robust taking into consideration all the necessary safety precautions for human life as well as immediate response to a potential failure. As part of DFSS we use a statistical tool call Design of Experiments (Strategy of Formulations, Central Composites, etc.) where we can try very complex interactions (factors) with minimal effort / cost and maximum statistical accuracy. DoE creates prediction equations that allow us to model and ask questions of what would happen under different conditions. More importantly we can look at many different quality metrics (responses, outcomes, etc.) with the same experimental trial. If we replicate the test then we can even forecast what elements cause variation (very hard to detect in highly complex systems without the use of statistics).

 

If they had used an FMEA (Failure Mode Effect Analysis  . . . a tool used in Six Sigma) then they could have anticipated failures and put error proofing devices in place to detect and/or respond to potential faults BEFORE it is irreversible. If we add a Monte Carlo simulation to potential working conditions then the model forecasts probability plots and identifies key factors that will be critical to success or failure.

 

Perhaps they did indeed use a Monte Carlo using Crystal Ball. It is a good product but if they used Palisade’s @RISK and added some of the other tools provided by Palisade such as RISK Optimizer, Neural Tools, etc. then they could have analyzed the system in other dimensions besides a simple Monte Carlo, thus uncovering weaknesses BEFORE designing and/or building the platform and well.

 

Part 2: Capping the well head

 

In Lean there is a whole discipline called “Error Proofing Devices”. As part of the design effort we need to create first and foremost safety and other devices that prevent the error from occurring in the first place. If that line of defense fails then there should be devices built into the process designed to cap the well if your error proofing fails. If that line of defense fails then there should be a disaster response plan created and practiced and tested to ensure that the spill is repaired immediately.

 

Part 3: Treating the resulting spill

 

Again, Design of Experiments could test different materials, chemicals and methods to find the right combination to contain or otherwise manage the resulting oil spill. Trying one chemical only may be the age old definition of madness . . . trying the same thing over and over again expecting different results. Again, a robust design of experiments could aid in the process of finding a solution that is most effective and with multiple tests on the same samples ensure that is it the most safe for the environment and the population most directly in the path of the oil spill. These tests are ideally run years before such a spill however, doing something now is better than simply standing by and watching it happen.

 

Last but not least:

 

Management (Executives down to line managers) should have coaches. Coaches who can speak to the culture, the systems design, the tools and methods used in Lean Six Sigma and who can verify data analysis and help with the accurate interpretation of the data. These coaches should be independent . . . not a full time employee of the corporation as they are more likely to speak the truth and highlight risks as well as opportunities.

 

Now BP and all the other entities may have done some of what I mentioned above. But I would assume they must have left out one or more of the listed items or we wouldn’t be looking at the oil traveling into the wetlands around New Orleans right now. Hindsight is always brilliant but we can learn from our mistakes. We can create better cultures, systems, error proofing devices, Experimental Designs etc.

 

 

BIO:  

 

Sandi Claudell is CEO of MindSpring Coaching. She is a Master Black Belt in Six Sigma, a Lean Master and has worked as a consultant for many companies to initiate worldwide improvements. For more information or to contact Sandi please visit http://www.mindspringcoaching.com/.

Oops! Didn’t see that coming!

Wednesday, May 12, 2010 by Steve Hunt

We are pleased to introduce you to consultant and trainer David Roy, our first guest blogger in my blog. Dave comes to us from SSPI, Six Sigma Professionals, Inc., and taught Jack Welch and his entire staff their Six Sigma Green Belt training. David’s blog will be the first in a series, and this initial entry also has a quick survey at the end for your input on structuring DFSS training.

--Steve Hunt

 
 

Oops! Didn’t see that coming!

 

How often do we hear these words after we have made a change to product, service or process?

 

We frequently solve one problem only to discover a new problem; or the solution we selected didn’t really resolve the problem.

 

There are many reasons for these surprises. Problem Solving sometimes addresses the symptoms and not the root cause. Useful solutions often have compromising harmful effects that we did not consider.

 

You may now be thinking; “Wow, if everything we do is going to turn out bad let’s not change anything.”   The reality is that change is inevitable. Whether driven by rising customer expectations, innovative new technologies or even variation in inputs over time; change will occur.

 

Managing the design and implementation of these changes requires a more formal methodology than the prominent “Launch and Learn” method.

 

The sophistication of the methodology will vary depending on the magnitude of the risks associated with the change. If we are problem solving for variation in a standard process and trying to regain control simple tools such as Cause and Effect diagram and Failure Mode Effects Analysis and Standard Work may be all that is required.

 

When we start to explore reducing variation or introducing new technologies or process then we need to bring on a Design For Six Sigma (DFSS) methodology which incorporates elements such as Change Management, Robust Design, Reliability, Modeling & Simulation and Piloting & Prototyping.

 

Over the next 4 blogs we will cover the four phases of a DFSS project under the framework of I-dentify, C-onceptualize, O-ptimize, and V-erify or ICOV for short.

We will give a high level look at the steps within these phases and the tools used to reduce the risk of the change and un-intended consequences.

 

On another note, if you are able, we’d like to ask for your guidance by completing a short marketing survey to help SSPI structure our training in a way that is most useful to our community. This 8 question survey should take less than 5 minutes, and is anonymous. Your opinions are greatly appreciated.

http://www.surveymonkey.com/s.aspx?sm=2aQk8QF1eLB5MFQJC1pUXA_3d_3d

 

BIO:

 

David Roy is an integral part of the Six Sigma community. He taught GE’s Jack Welch and entire staff Six Sigma, as well as served as Senior Vice President of Textron Six Sigma. He is a Certified GE Master Black Belt, was instrumental in developing GE’s DMADV (DFSS) methodology, and has taught 3 waves of DFSS Black Belts. Dave’s experience includes Product and Transactional so his examples are of interest to all. David holds an BS in Mechanical Engineering from The University of New Hampshire. He is also the co-author “Services Design for Six Sigma – A Roadmap for Excellence”

 

Profitability Projections in a Manufacturing Environment of High Uncertainty

Monday, April 12, 2010 by Steve Hunt

The other night, I had the opportunity to watch a free webcast titled “Use of @RISK for Probabilistic Decision Analysis of a Manufacturing Forecast in an Environment of High Uncertainty”. This presentation was extremely timely, since many companies are struggling to survive in these challenging economic times. Dr. Jose Briones did an excellent job discussing and illustrating how profitability projections in a manufacturing environment are directly tied to how the sales forecast fits with the capability of the operation, and how different manufacturing capacities and productions rates impact the output of the plant and the allocation of the fixed cost of production.

In the example he presents, a company is trying to decide how best to balance the sales of certain families of products to maximize revenue, maintain a diverse product line, and properly price each individual product based on the impact to the manufacturing schedule and fixed cost allocation.

He spends an appropriate amount of time discussing different input distributions such as the Triangular, Normal, Pert and Gamma distributions as well as sharing his recommendations on when to use them. He also shares his expertise on fixed cost allocation by product and the dangers in using the common method of dividing the fixed cost by the total production, and recommends doing so by allocating the fixed costs based on the projected run time of each product family. Lastly, he spends some time discussing the interpretation of the results, which I feel does a great job wrapping up the information presented in the webcast.
 

Dr. Jose A. Briones is currently the Director of Operations for SpyroTek Performance Solutions, a diversified supplier of specialty materials, BPM software and innovation consulting services. Dr. Briones has a PhD in Chemical Engineering from Clemson University and is a graduate of the Business Administration Program of Wharton Business School. If you have any questions about the webcast, you can contact Jose at Brioneja@SpyroTek.com or through Jameson Romeo-Hall at Palisade Corporation.
 

 

The State of Six Sigma and Process Improvement

Tuesday, February 2, 2010 by Steve Hunt
Two weeks ago, I attended IQPC’s (International Quality & Productivity Center) Lean Six Sigma and Process Improvement Summit in Orlando, Florida. During the past 4 years, I have watched the conference, the attendees, and their projects evolve. The IQPC did an excellent job keeping the quality of the conference at an A+ level despite wrangling with the effects of a down market and near zero travel budgets for many companies. This conference has earned it place as one of the premier Six Sigma events of the year.

With attendance numbers on par with last year (which are only slightly down from a few years ago), the major difference that I noticed was the attendees' passion. As the economy has worsened and media’s perception of Six Sigma waned, practitioners and champions are more passionate and committed now than ever. Perhaps it’s because they still have jobs and their companies understand the value of cost reduction in both their processes and product/ process development programs. They - and the companies who employ them - have every right to be excited and passionate because they are making positive changes to their organizations that will hopefully lead them to recovery and stability faster than others.
 

Many companies, large and small, represented practically every industry. Farmers Insurance and Capital One were two representatives from the insurance and banking industries. Technology and pharmaceuticals were well represented by Seagate, Motorola, Merck and Johnson & Johnson. In addition, the energy sector was well represented, as were the military, aerospace and services sectors. (If you want a complet list of companies attending, it may be available at www.sixsigmaiq.com)

The overriding message heard over and over again, was, “We need to make your Six Sigma deployments stick.” Initially, I found this to be an interesting message since it came from a group of many highly intelligent and motivated individuals who were obviously very successful in doing just that: “Making it Stick”. This message serves as a clarion call for all of us. We need to look for new tools, philosophies and approaches to make our improvement initiative better and “stickier” so that they can pass the test of time.

The highlight of every year is the awards ceremony. There were many great projects honored this year, and congratulations to the winners and everyone who submitted their projects! At the awards ceremony I had the pleasure to meet a great group from the Bahamas Telecommunications Company. They are the pioneers for Lean Six Sigma for their company. (I tried to get them to need an onsite training session in some of the Palisade tools, but have been thus far unsuccessful!) Good luck on your Six Sigma Journey, I hope to see you accepting an award next year!

Free Webcast This Thursday: “Lean Six Sigma: History, Trends and Predictions”

Wednesday, January 6, 2010 by Steve Hunt
On Thursday, January 7, 2010, Ed Biernat will present a free live webcast entitled. "Lean Six Sigma: History, Trends, and Predictions."

Lean and Six Sigma have been buzzwords for more than a decade. Some companies have thoroughly embraced the concepts and toolsets, others have dabbled, and the rest sit on the sidelines wondering, to borrow a phrase from a television ad from the ‘80’s, “Where’s the beef?”

In this interactive webcast, we will briefly review what these strategies entail, who is using them and how, and then we’ll put on our prognosticator’s hat take a look at what the future may hold in store. We will review some of the latest “buzz” on the topic as well as recent research aimed at how well these methodologies are moving off the shop floor into wider application.

Ed welcomes any questions regarding Lean, Six Sigma, or the “new and improved” Lean Six Sigma. Although we will be focusing on the implementation side of the equation, (including the use of Palisade software), the discussion can be as free-ranging as the participants require.

Edward Biernat is the president of Consulting With Impact, Ltd., a training, coaching, and consultancy located in Canandaigua, NY that he founded in 1998. CWI’s client list includes companies ranging from the Fortune 100 to post-startups in the medical device, food and food packaging, steel, automotive, healthcare, and service sectors. He is a graduate of Clarkson University with bachelor degrees in Mechanical and Electrical Engineering, and has held positions in engineering, quality, and management at several New York companies. He is the author of numerous training programs and articles, and has presented at national and international events including the Institute of Industrial Engineers’ Annual Conference and the European Organization for Quality in Brussels, Belgium. Ed also developed part of the curriculum for and presents at the Lean Six Sigma Black Belt certification course at a local college.


» Register now (FREE)
» View archived webcasts