Six Sigma Quality Resources for Software & Information Technology In association withSix Sigma Advantage, Inc. - Six Sigma Third Wave for Software Development
 Main Site > Software / IT Channel > Methodologies  > Financial Analysis Search:
 
 for    
Publications
Marketplace
| iSixSigma
Stuff
| iSixSigma
Blogosphere
| Events
Calendar
| The
Dictionary
| Discussion
Forum
| Find
a Job
| Post
a Job
| Industry
News
| Newsletter
Signup
| Sigma
Calculator
| Online
Surveys
2008 Version! DMAIC Training Slides: 1,176 Slides + Instructor Notes and More for $99.99
iSixSigma Magazine Signup
 iSixSigma Live!  
  Denver Live!
  Summit & Awards
  Most Successful Start-up
  Breakthrough Projects
 Free Newsletters!  
  Sign Up Now!
  Manage Subscriptions
  New To Six Sigma?
  Six Sigma Q&A
  Cert. Practice Test
  Problem Solving Wizard
  ISSSP Info
ISSSP Is The Official Six Sigma Society of iSixSigma
 Channels 
  iSixSigma Main
  Europe
  Financial Services
  Healthcare
  Military
 Quality Directory 
  Recent Articles
  Certifications/Awards
  Consultants
  Culture Evolution
  Methodologies
   BPR
   DMAIC
   Kaizen
   Metrics
   Six Sigma
   TQM
   Work-Out
  News & Events
  Organizations
  Product/Service Guides
  Statistics & Analysis
  Tools & Templates
  Voice of the Customer
  Free Whitepapers
 Related Topics 
  Innovation
  Outsourcing/Offshoring
  Business Process Mgt
 Quick Access 
  Help
  Search
  Advertise Here
  Article Archives
  Newsletter Archives
 User Feedback 
  Please suggest site
  improvements.
 
  [ larger form ]

Calculating COPQ Using Weighted Risk of Potential Failures

Bookmark This Page Bookmark This Page
Email This Page Email This Page
Format for Printing Format for Printing
Cite This Article Cite This Article
Submit an Article Submit an Article
Six Sigma Article Archive Read More Articles
Related Tools & Articles
  • Discussion Forum
    "My Green Belt project is to improve...forecast accuracy (how close we are to predicting a customer's purchase order quantity). I am trying to...set up my COPQ to gauge how an increase in forecast accuracy will increase revenue."

    Contribute to this Discussion

    B
    New from iSixSigmaCost of Poor Quality Reference Guide

    Risk Mitigation Rolling Risk Review

    Cost of Poor Quality (COPQ) Course
    y Pankaj Sharma

    The Cost of Poor Quality (COPQ) – the cost of defects in the current process, product or service – is the initial financial analysis conducted for a Six Sigma project. It is used to justify initiating a project. And, while COPQ does not contribute to the success of any Six Sigma project, it is valuable in prioritizing projects. Various methodologies are used to estimate COPQ, all of which require some initial measurement. The challenge for any estimation comes when no measurements are available at the initiation of the project. But there is an approach to calculating the cost of the existing process using a weighted risk of potential failures.

    At the beginning of Six Sigma projects, most COPQ measurements are determined with an 80 percent confidence level. It is important for Black Belts to rationalize the financial viability of the project to senior management. However, it is common to find that no actual measurements are available at the onset of the project. This makes the COPQ calculation difficult, often resulting in an estimate that has a very small objective component. If Black Belts move the project forward without the financial forecast, they face delays in project completion because of the lack of financial validation.

    Using FMEA to Calculate COPQ

    COPQ also is defined as the current cost of resolving existing failures in a process. This cost is composed of four factors:

    • Probability of occurrence for each possible failure event
    • Potential impact or severity of each failure
    • Current detection provisions in place
    • Resolution cost of a single failure

    The COPQ translates into an estimation of these four components.

     Figure 1: FMEA Worksheet

    Failure Mode and Effects Analysis (FMEA) is a tool used to identify the potential failure modes within a process and to prioritize them based on their severity, occurrence and detection provisions. The Risk Priority Number (RPN) is obtained by estimating the effort required to resolve each incident and the unit dollar cost of such an effort. FMEA is typically used during the Measure or Analyze phase of a DMAIC project, offering a solid basis for estimating COPQ.

    Using FMEA, a Black Belt can lead the project team through the following steps to estimate COPQ.

    COPQ Estimation Process – Step by Step

    Step 1

    Import all process inputs from, I/O into FEMA tool.

    Remove any uncontrolled factors.

    Step 2
    Add any potential failures that are not included in I/O.
    Step 3

    Perform the risk prioritization using the FEMA tool.

    Step 4
    Extract all failures and their RPNs from the FEMA tool.
     
    Estimate average effort and cost/hour to resolve each failure
    Step 5
    Calculate the average cost to resolve any failure.
    Step 6
    Estimate COPQ.
    Step 1: Identify the potential causes of failures using the inputs from an input-output diagram and import them into the FMEA tool. Avoid any initial prioritization of inputs such as through a cause-and-effect matrix, to ensure that all possible failure modes are included in the COPQ analysis. Include only controlled factors (inputs) in the analysis. This is important, as existing costs for uncontrolled factors cannot be calculated with confidence.

    Step 2: After importing the inputs, review the list with the team to ensure all potential failures are identified. Include every possible failure even if the process has not experienced it. If there is a risk for failure, the team must identify it and include the potential cost of failure in the COPQ calculation.

    Step 3: Perform the risk prioritization calculation for each individual potential failure mode by using the FMEA tool. Record the Risk Priority Number values as a calculation of severity, occurrence and detection scores as follows:

    Risk Priority Number = Severity x Occurrence x Detection

    Step 4: Using team inputs and any available estimation tools, calculate the average cost to resolve (ACR) for each potential cause of failure. The cost will be a multiple of estimated effort hours to resolve (EHR) and the average cost per effort hour (ACH). Note that the estimation in this step tends to have a 90- to 95-percent confidence level, which is an acceptable level for isolating the COPQ.

    ACRi = EHRi x ACHi

    Where: ACRi = Average cost to resolve incident i
               EHRi = Effort hours to resolve incident i
               ACHi = Average cost per hour for incident i
                     i = 1 to n (n being the total number of failures)

    Step 5: Calculate the average effort cost required to resolve a random incident by using the weighted average of time to resolve the failure weighted by the risk priority of each failure.

    Weighted Average Cost to Resolve (WACR) = [Sum of (RPNi x ACRi) / Sum of (RPNi)]

    Step 6: Calculate the COPQ for the project by multiplying the random incident cost and the potential reduction in incidents (per year) as identified in the project charter.

    COPQ = WACR x Reduction in Events Due to the Project


    Example Using This COPQ Estimating Process

    A Six Sigma team at a financial services firm was assigned the task to reduce the number of monthly customer trade failures by 200. No data was collected in the past on the primary metric and all the team knew was that there were a large number of trades failing every month. Due to lack of measurements, the team struggled to estimate the COPQ. This financial forecast was extremely important to validate the project and ensure timely completion. Solution: The team used the risk prioritization approach using FMEA to estimate COPQ:

    Step 1: The team used an input-output diagram to identify all potential causes of failure. Four causes were identified which were imported into the FMEA tool.

    Step 2: The team then met for another brainstorming session to identify any additional causes. This resulted in the addition of another cause, bringing the total to five.

    Step 3: Risk Priority Numbers were calculated for all five potential failure causes using the FMEA tool.


    No.


    Potential Causes


    RPN

    Effort Hours
    to Resolve (Hours)

    Average Cost
    Per Hour ($)

    Average Cost
    to Resolve ($)


    RPN x ACR

    1

     Account was set up incorrectly

      21 

      2 

      50 

      100 

        2,100 

    2

     Application is not available

     18

    12

    100

    1200

      21,600 

    3

     Servere is not available

      27

      8

      50

      400

     10,800

    4

     Network is not available

      30

    30

      20

      600

     18,000

    5

     Customer's browser set up incorrectly

      21

      8

       25 

      200

       4,200

     

     

    117

     

     

     

    $56,700 

    Step 4: Next the team reviewed each failure cause and calculated the average cost to resolve it. This was done by estimating the time required to resolve the problem and the average cost per unit of time.

    Step 5: Using the above average cost per event, the weighted average cost to resolve a random event was estimated:

    Weighted Average Cost to Resolve (WACR) = (RPN x ACR) / RPN = 56700/117 = $484.60

    Step 6: Finally, the project COPQ was estimated by multiplying the random incident cost and the potential reduction in incidents (per year).

    Target Reduction in Events Due to the Project = 200
    COPQ = $484.60 x 200 = $96,920

    Conclusion

    The COPQ calculation is summarized as:

    COPQ (annualized) = [Sum of (RPNi x ACRi) / Sum of (RPNi)] x Annual Reduction in Events

    If the Six Sigma project team is struggling to calculate the COPQ and is reaching the end of the Measure phase, an advanced FMEA approach is helpful in obtaining this calculation. This approach lends objectivity to the estimation of COPQ when no measurements are available at the project initiation stage. Additionally, as FMEA offers a structured approach, this calculation method becomes easy to use. When capturing the dependence of any event's cost on its severity, occurrence and the ability to detect it, the derived COPQ offers a closer estimate to the actual project benefit.

    About the Author

    Pankaj Sharma is an assistant vice president at Pershing LLC., a BNY Securities Group company. He has four years of experience in managing enterprise-wide metrics programs and has an MBA in systems/operations. He can be reached at psharma@pershing.com.

     
    Rate This Article:  Current Rating: 4.56
      Poor    Excellent     
              1    2    3     4    5
    Copyright © 2000-2008 iSixSigma – All Rights Reserved
    Reproduction Without Permission Is Strictly Prohibited – Copyright Requests


    Publish an Article: Do you have a Six Sigma tip, learning or case study?
    Share it with the largest community of Six Sigma professionals, and be recognized by your peers.
    It's a great way to promote your expertise and/or build your resume. Read more about submitting an article.


    Download the iSixSigma Toolbar for 1-Click access. Search Your Way. Everyday. Without Delay.
    Get 1-Click iSixSigma access. Search Your Way. Everyday. Without Delay.

    BEST SELLING PRODUCTS (iSixSigma Publications)
    1. 2008 VERSION! Six Sigma DMAIC Training Slides
      The complete Lean Six Sigma DMAIC course prepares participants to perform the role of a LSS Black Belt; covering what’s ...
    2. Certified Lean Six Sigma Black Belt Assessment Exam
      Interested in assessing your knowledge of Lean Six Sigma? Preparing for certifications? Testing your students and traine...
    3. NEW VERSION! Process Management Training Slides
      The OSSS Process Management course is designed in two phases comprised of:352 Powerpoint slidesInstructor notesSlide exp...
    4. NEW VERSION! Six Sigma Black Belt (DMAIC) Training Slides
      The OSSS Six Sigma Black Belt course is comprised of: 1,176 PowerPoint slides, Instructor notes, Slide explanations, 37 ...
    5. Certified Lean Six Sigma Green Belt Assessment Exam
      This assessment exam is useful for students interested in assessing their knowledge of Lean Six Sigma on the Green Belt ...
    6. NEW VERSION! Project Selection Process Pack
      The OSSS Project Selection Process Pack is comprised of:57 PowerPoint slidesInstructor notesSlide explanationsSamples7 T...
    7. Applied Strategy Execution Training Guide
      ĀSE is the Applied Strategy Execution program. It is a structured framework for clearly stating an organization's s...
     

    Six Sigma AdLinks
    Improve IT Projects With Six Sigma. Villanova University.
    iSixSigma Live! Save up to $700
    Lean Office, Lean IT/IS. Act Now and Save.



    Google AdWords
     
    Home | Discussion Forum | Event Calendar | Job Shop
    Link To iSixSigma | Rate This Page | Report A Problem | Free Content For Your Site | Submit Article For Publishing
     Terms of Service. ©2000-2008 iSixSigma. All rights reserved. v3.0lb, 4.1-A-244
    About iSixSigma · Contact Us · Privacy Policy · Site Map
    nogeo