Are solar panels a sound investment? A risk analysis case study

Friday, August 27, 2010 by DMUU Training Team
The UK's new coalition government has said that, as part of its 'Green Deal', it will encourage home energy efficiency improvements paid for by savings from energy bills. It seems likely that, in the year that energy regulator Ofgem warned of 20 percent electricity price hikes by 2020, this initiative will include solar panel technology

Currently the UK still lags behind many other countries in Europe and the rest of the world when it comes to harnessing solar power. Not only do we have less hours of sunshine than many regions, but there is a lack of clarity as to the 'payback' time when it comes to users seeing a return on investment.

This is where Palisade customer, the California-based Tioga Energy, makes an interesting case study. Whilst it may seem unfair to compare the UK with the west coast of America when talking about solar-related matters, the sunnier climate does not reduce the need to prove ROI for customers with solar energy agreements.

Tioga Energy provides project financing through its solar Power Purchase Agreements (PPAs), and maintains and operates solar systems on behalf of its customers. Tioga’s offering delivers predictably priced power and enables organisations to to both 'green' their operations and reduce energy costs. To illustrate the benefits of solar, estimating future electricity prices and making comparisons by showing the savings from a new solar system, Tioga enlisted the help of @RISK for risk analysis solutions.

To forecast possible price increases, Tioga Energy inputs California's historical electricity rate data into a quantitative risk analysis model developed using @RISK. This generates a probability distribution for electricity rate rises over the 20-year PPA period, which shows that there is a 25 percent likelihood that price increases will be less than 4.8 percent, and a 25 percent chance that rate rises would be more than 8.7 percent.

The @RISK risk analysis model therefore helps Tioga Energy evaluate the likelihood that a customer will save money for a variety of PPA scenarios (i.e. the rate at which electricity would initially be charged and the amount by which it would then increase each year). It also calculates the magnitude of savings for the different combinations of first year costs and subsequent rises. Consumers are therefore able to better understand the pricing and make an informed decision about whether to sign up for a PPA.

Using historical data and @RISK's risk modelling software capacity, Tioga offers consumers a robust view of the potential benefits of a solar PPA. This enables them to hedge against rising electricity rates, as well as feel confident that they are playing a part in tackling global warming.

» Read the Tioga Energy case study

Craig Ferri
EMEA Managing Director of Risk & Decision Analysis

@RISK Quick Tips: Six Sigma Design of Experiments: Welding

Tuesday, August 17, 2010 by DMUU Training Team
A key application of @RISK is Six Sigma and quality analysis. This model demonstrates how @RISK can be used for a DOE analysis of a welding project.

Suppose you are analyzing a metallic burst cup manufactured by welding a disk onto a ring. You need to make sure weld strength is within safety limits. The model relates the weld strength to process and design factors, models the variation for each factor, and forecasts the product performance in relation to the engineering specifications. @RISK is used to model the variation in each factor, and simulate different outcomes for weld strength. Output includes After Six Sigma statistics for Cpk-Upper, Cpk-Lower, Cpk, and PPM Defects (or DPM). Standard @RISK statistical analysis functions (like RiskMean) are also used.

» Download the example: SixSigmaDOE.xls

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

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 DMUU Training Team
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”

 

@RISK Quick Tips: Use of RiskTheo to Represent Distributions as Discrete Ones

Tuesday, July 20, 2010 by DMUU Training Team
@RISK, risk analysis software using Monte Carlo simulation, has many powerful features that help you create powerful models for decision making under uncertainty.

For example, you can use the RiskTheo function in @RISK to determine the parameters of a discrete distribution based on a continuous one. In this example, the RiskTheo functions of @RISK work out the P10, P50, and P90 percentiles of a continuous distribution (in this case the LogNormal), and the Mean and Standard Deviation of a RiskDiscrete distribution which has these X-values and some assumed probabilities (or weights). It then uses Excel's Solver to work out the probabilities required so that the discrete distribution based on these percentiles and probabilities would have the same mean and standard deviation as the continuous distribution.

» Download the example: CtsToDiscrete.xls
» See "Uses of the RiskTheo functions in
   @RISK to match distributions
"
 » See "DMAIC Failure Rate using RISKTheo" for a
    Six Sigma application of the RISKTheo function

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


Introduction, by Way of Retraction

Friday, July 9, 2010 by Holly Bailey
Just after I posted my last blog questioning a recent Investopedia column in the San Francisco Chronicle, I had a congenial note from the author of that column, David Harper.  His column compared Monte Carlo Simulation with two other methods of calculating Value-at-Risk, and I was concerned that its view of risk and risk analysis techniques was overly simplified. David   was surprised to discover that column had just appeared because he wrote it five years ago!

The five-year lag explains a lot--Monte Carlo simulation was not nearly so widely adopted or carried about by so many software tools as it is today--and I should have suspected the article was a vintage piece before I started carping.

So I happily retract my concerns to introduce to you David Harper, CPA and certified Financial Risk Manager.  In response to my comment about the attitudes and techniques that led to last year's collapse of the financial markets, David says that, now that the black swan has flown, "the crisis should implicate both HistoricalSim VaR and parametric VaR (at least multivariate normal!) and point toward Monte Carlo Sim. I've been thinking for a while that all of this [I think he means lack of accuracy in specifying risk] should really boost Monte Carlo."

Investment commentary is only one of David's activities.  He is the founder of Bionic Turtle, a business devoted to e-learning about financial risk and preparation for the certification exam for financial risk managers. This is a worthy enterprise--I was relieved to discover that there are hoops financial risk managers have to got through to be called that--and for anyone who would like to know more about quantitative techniques for risk analysis, its website is worth prowling. 

Thank you, David, for setting me straight.  

Ensuring water supply when the heavens rarely open, using risk simulation software

Wednesday, July 7, 2010 by DMUU Training Team
Abu DhabiThe UK finally seems to be heading into summer after an unusually long and cold winter.  However, despite the amount of rain that falls on our 'green and pleasant land' (to the extent of major flooding on occasions), one of the anomalies of the UK weather system is that any prolonged warm period seems to be accompanied by the underlying threat of a hosepipe ban.

This is in stark contrast to many regions around the world that, despite seeing far less precipitation, manage a robust water supply.  Abu Dhabi for example has no rain for several months of the year, and relies almost completely on desalinated seawater for its potable water requirements.  The desalination process is challenging in terms of operation, costs, and environmental impact.  Whilst over-production capacity is expensive, at the other end of the scale it is essential that Abu Dhabi has sufficient water production capacity to support the Abu Dhabi government development plan (Abu Dhabi Plan 2030). 

This plan means that the Abu Dhabi Water & Electricity Company (ADWEC) is required by the Regulation and Supervision Bureau (RSB), the regulatory body of Abu Dhabi, to use a risk-based methodology to assess the water demand and required capacity.  As a result ADWEC uses @RISK risk analysis software to help it to forecast as accurately as possible the demand for water and electricity across the Emirate in order to plan for the optimum expansion as well as the efficient and effective use of water production plants.

@RISK enables ADWEC to model all feasible uncertainties in the variables that determine the quantity of water required over specific timescales, such as per capita water consumption rates and the rate of population growth.  The variables input into the @RISK risk simulation software model are based on the water demand categories such as domestic, agricultural and industrial. Factors with inherent uncertainties that affect the demand forecast outcome and must be modelled include: seasonal variation, distillers' unplanned outages, water losses, population growth rates and demand for housing.

By undertaking risk analysis of the variables involved in assessing demand and supply, ADWEC minimises the potential for water production capacity to be over or under deployed.  As a result of using @RISK to assist with its forecasting, planning and management strategies, ADWEC has been able to consistently meet with almost complete accuracy the Abu Dhabi Emirate water demand forecasts.

A useful lesson...

» Read the full ADWEC case study

Craig Ferri
EMEA Managing Director of Risk & Decision Analysis

@RISK Quick Tips: Asset Price Random Walks and Options Valuation.

Tuesday, June 29, 2010 by DMUU Training Team
@RISK risk modeling software is used for a wide variety of applications in financial risk analysis forecasting, investments, and banking. This model is one example of how @RISK can help in risk analysis decision making.

Models of the prices of assets (stocks, property, commodities) very often assume a random walk over time, in which the periodic price changes are random, and in the simplest models are independent of each other. The future price level of the asset may result in some contract or payoff becoming valuable, such as in the case of financial market options. In these cases, the value of the contract (contingent payment or option) is calculated as the average discounted value of the future payoff. In the special case of European options on a traded underlying asset, the value calculated from the simulation may be compared with mathematical formulas that analytically provide the valuation, such as the Black-Scholes equation. In many more complex cases, the pertinent analytic formulas may be unknown or very complex to derive, and one may wish to rely on simulation techniques. This particular model compares the average simulated payoff for European Call and Put options with the Black-Scholes valuation.

» Download the example: AssetPrices.Options.BS.Multi.xls

@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.

Free Webcast This Thursday: “DMAIC and Using a Non-Intuition Approach”

Monday, June 7, 2010 by DMUU Training Team
On Thursday, June 10, 2010, Ed Biernat will present a free live webcast entitled. "DMAIC and Using a Non-Intuition Approach"

Experience is often critical to good decision making.  It helps us see patterns and react quickly.  In that sense it is a strength.  However, if the environment changes radically, and we use the old paradigms to see the new world, bad things can happen.  The Six Sigma DMAIC process is a great tool set for helping us see the world through data and thus helps us adapt through the change.  What is needed is the addition of other tools and insights to help us interpret the analyses correctly.

In this free live webcast, we will review some of the latest research in cognitive psychology and related fields and discuss how to apply these insights into the realm of Lean Six Sigma transformation.  We will challenge the role of intuition as a primary factor in decision-making and, while not removing it entirely from the framework, look to put it into its proper place.  We will also examine some of the biases, both in the data and in our heads, that may lead good people to make bad decisions when the old rules fail to apply in the face of radical change.

» Register now (FREE)
» View archived webcasts

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”

 

The Economics of Supply Chain Risk Management using @RISK

Monday, May 3, 2010 by DMUU Training Team
At the 2010 Palisade Risk Conference in London, David Inbar of Minet Technologies presented a talk on supply chain risk management.

Supply chain risk management is an emerging field which has been growing significantly in importance because of modern management concepts such as lean, globalization and outsourcing. The mutual dependencies and close collaboration in modern supply chains create unique risks and challenges. Supply chain risk management is an economic process and choosing the elements and amount of risk mitigations should be based on economic measures.

Inbar's talk gave an overview of the concepts and process of supply chain risk management, and demonstrated how using Monte Carlo simulation techniques with @RISK risk analysis software adds value to the decision making under uncertainty processes and enables managers to purchase the most cost effective mitigations. Says Inbar, "An organization with the right risk management process can assure peace of mind to customers and supply chain partners."

David Inbar is the founder and managing director of Minet Technologies, a provider of professional services and technologies in supply chain and purchasing. Minet is active in the interfaces between business, processes and technologies in the world of supply chain and purchasing, creating methodologies and delivering projects and solutions.

» View a PDF of the presentation here
» Abstracts and presentations from the 2010 Palisade Risk Conference in London

Palisade is proud to announce our first Health Risk Analysis Forum in San Diego on March 31st 2010

Wednesday, March 10, 2010 by DMUU Training Team



Why attend?

This one-day forum is a great way to find out how others in the Healthcare Industry are using our software, as well as to learn new approaches to the problems Healthcare professionals face every day. We will have six software training sessions, and six real-world case studies presented by industry experts covering risk and decision analysis from all angles specific to the Healthcare sector.

You will also see how new versions of @RISK, PrecisionTree, RISKOptimizer, TopRank, NeuralTools, StatTools, and other Palisade software tools work together to give you the most complete picture possible in your situation.

Who should attend?


Professionals in risk and financial analysis in: Care Equipment & Services, Pharmaceuticals, Biotechnology & Life Sciences, Hospital Care & Management, or related services

How much?


For a limited time, the cost for attending the Health Risk Analysis Forum is has been discounted $100.

$295 covers all sessions, continental breakfast, lunch and a cocktail networking reception. Attendees will also receive a welcome package that includes a 15% discount on their next software purchase.

Please contact Jameson Romeo-Hall at jromeo-hall@palisade.com if you are interested in attending.

Location
The Westin Gaslamp Quarter
910 Broadway Circle
San Diego, CA 92101
(619) 239-2200

Book your room at a discounted rate (subject to availability.)


New business planning – measuring feasibility

Tuesday, February 23, 2010 by DMUU Training Team
The latest Business in Britain survey from Lloyds TSB Commercial shows that the UK's commercial enterprises are regaining confidence.  The six monthly report charts the performance of 1,732 UK companies and their views on prospects for the coming year. Its most recent business confidence shows that expectations for both sales and orders have started to recover. The balance of firms anticipating an upturn in sales has climbed to 21% - from just 1% six months ago.   And hopes for orders are also looking brighter. The balance expecting order levels to rise over the coming six months has climbed to 23%, from just 6% in the last survey.

But companies planning major new business drives for 2010 would do well to follow the example of Thales UK, which uses @RISK  to enable it to assess commercial feasibility of potential new business wins. @RISK's in-depth risk analysis ensures the leading provider of mission-critical electronic information systems for aerospace, defence and security markets around the world, is fully informed when making business-critical decisions.

Thales operates in a highly competitive environment, with technologically advanced countries presenting tough opposition when it tenders for contracts. It must continually develop highly sophisticated equipment that is robust and failsafe to meet the stringent demands of its customers. Bringing products of this calibre to market is costly in terms of time and resource, so for every competitive new business opportunity, Thales must be confident that it has a reasonable chance of success.

Using Monte Carlo analysis to show all potential scenarios and the likelihood that each will occur, @RISK enables Thales to calculate the competitiveness of complex markets, measure probabilities for project costs, quantify rate of return, and even account for the effects of cumulative business, thereby providing decision-makers with the most complete picture possible.  From this risk analysis, Thales can make an informed decision on the commercial viability of the potential new business offered.

Craig Ferri
EMEA Managing Director of Risk & Decision Analysis

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!