iSixSigma

Tools to Prioritize Six Sigma Projects

Six Sigma – iSixSigma Forums Old Forums General Tools to Prioritize Six Sigma Projects

Viewing 46 posts - 1 through 46 (of 46 total)
  • Author
    Posts
  • #28579

    Pete Zeidler
    Participant

    We are rolling out a Six Sigma program at my company and I need to find a way to “quantitatively” rank projects as “most worthy” to work on…has anyone developed a tool or matrix that weights various criteria and allows the user to rank various potential projects?
    Thanks in advance for your thoughts !
     

    0
    #71423

    Sridhar
    Member

    Hi,One way of prioritizing is AHP (Analytic Hierarcy Process). The concept is comparing at a time only two characterstics i.e. pair wise comparision. All the pair combinations are compared and given a score on a scale of 1 to 9. Once all the combinations are over then we standardize the scores get the most important ones. One more advantage of this method is you can even test that wether scores are given randomly or any bias was there. If any bias has occurred then you do the whole process agian and rank them.hope this helps you.sridhar Download: Analytic Hierarcy Process (AHP) Explanation (Microsoft Word) Download: Analytic Hierarcy Process (AHP) Template (Microsoft Excel)Viewing Tip: Usually, you can click on a link to view the document — it may open within your browser using the application (in this case either Word or Excel). If you are having difficulty, try right clicking the link and selecting “Save Target As…” or “Save As…” to save it to your computer harddrive.Virus Note: All files are scanned prior to uploading to iSixSigma. No prevention program is entirely safe. FOR YOUR OWN SAFETY, PLEASE:1) Re-scan downloaded files using your personal virus checker before using it.2) NEVER, EVER run compiled files (.exe’s, .ocx’s, .dll’s etc.). If you don’t have a virus scanner, you can get one at many places on the net including McAfee.com.

    0
    #71436

    Pete Zeidler
    Participant

    Sridhar….your response is an excellent suggestion and does indeed help….thank you for taking the time to respond !
    Pete

    0
    #71467

    Dr Antony
    Participant

    Dear Sridhar,
    I agree with your point that AHP is very useful in priortising projects in many areas though it is not widely used in companies. AHP has been widely accepted in management decision making processes and prioritising the product attributes by many marketing departments. I have never made an attempt to apply this techniaue and is very keen to get my teeth into this particular technique. It would be great if you would kindly suggest a couple of excellent books (simple and practical) in this area. If you have any case stduies, please kindly forward me a couple of them.
     
    many thanks Sridhar.
     
    Regards
     
    Dr Antony
    UK

    0
    #71474

    Sridhar
    Member

    Hi Antony,
           can you send me your mail id, i will send you one paper and an excel sheet to do prioritization using AHP.
    sridhar
     

    0
    #71478

    Steelfan
    Member

    I too would be interested in a copy of the paper and the Excel document, would you kindly send it to the email address above.
    Thanks

    0
    #71479

    Anonymous
    Participant

    From the school of keep it simple: Try a Decision Matrix(spreadsheet software would be handy).  It IS simple, while the written directions sound like the lyrics to “the Hokey-Pokey”-just THINK MATRIX:  Your upper management Champions will need to determine 6-8 criteria necessary for all projects,e.g., alignment with Balanced Scorecard, time to completion, savings criteria, resources, CUSTOMER impact, etc. Then give each criterion a rating of importance from 1 to 10(hopefully from the vantage point of the customer). [On the spreadsheet, these will be positioned vertically, left to right across the top, in individual cells with their respective numerical ratings positioned directly underneath.] Now list all of your potential projects on the left hand side from top to bottom(under the criteria). Think matrix. Now, for each cell created by the intersection of a single criterion and a project, place a number(from 1-10 signifying the group consensus on strength of relationship). (You will have as many numbers in the cells to the right of the project as you have criteria). Do this project by project. Then go back to each cell to the right of each project and multiply the number in the cell(strength of relationship) by the corresonding criterion’s rating of importance. Place the product to the cell furthest to the right for that project. You can know rank order the products for the projects to rank order the projects. “And that’s what it’s all about !”
     

    0
    #71480

    Patrick McDermott
    Participant

    An alternative to AHP is to use a Pugh (decision) Matrix.

    Build a team of those who decide which projects will be persued.  Have the team brainstorm on criteria and weight the criteria through multi-voting.  (This is equivalent to the pairwise comparison of critieria done in AHP.)
    Select a project that will act as the baseline.  This project receives a score of 5 for each criteria.  Compare all of the other projects to this baseline and score on a scale of 1 to 9, where 1 = significantly worse, 5 = same and 9 = significantly better.  (This is equivalent to the pairwise comparison of projects within each criteria done in AHP).
    For each project, multiply the score for each criteria by the weight of the criteria and sum the products.
    Pursue those project with the highest total scores.
    Pro’s and Con’s relative to AHP:
    This method is quicker to execute (by approximately a factor of 2) than AHP.
    Some thought must be given when selecting a “baseline” project.  Resolution is quickly lost if the baseline project is at the top of bottom of the scale in a particular critieria, especially for criteria with greater weights.  There is no estimate of consistency of comparisons as provided when using an automated AHP program such as Expert Choice.
    Both methods should give similar results

    0
    #71482

    Taylor
    Member

    Sridhar,
    could you send me the AHP files as well.
    Thanks,
    -Todd

    0
    #71486

    Gaston
    Participant

    Sridhar,

    Would you, please, send me the AHP files as well?
    My e-mail address is [email protected]
    Thank you very much,  Best Regards,

    0
    #71489

    Gaston
    Participant

    Sridhar,
    Would you, please, send me the AHP files as well?
    My e-mail address is [email protected]
    Thank you very much,  Best Regards,

    0
    #71495

    B. Banthia
    Participant

    Would you please send me also a copy of paper and Excel document regarding AHP. Thanks.

    0
    #71505

    Pete Zeidler
    Participant

    Thanks for the “hoke-pokey” method…it makes a great deal of sense !

    0
    #71506

    Pete Zeidler
    Participant

    This “Pugh” method sounds great..I will do some research on it, and thanks !

    0
    #71508

    Marz
    Participant

    Please also send me a copy of the AHP materials.
    Thanks.

    0
    #71511

    Bill Beard
    Participant

    Sridhar,
    Would you, please, send me the AHP files as well?

    My e-mail address is [email protected]
    Thank you very much,  Best Regards,

    0
    #71513

    Mark Aeilts
    Participant

    Please email me copies of the materials.  thanks

    0
    #71518

    Durand
    Participant

     
    I would also like a copy of the AHP excel spreadsheet.
     
    Thank You
    [email protected]

    0
    #71520

    karyeng liew
    Participant

    hello,
     i would also like a copy of the excel spreadsheet.
     thank you.

    0
    #71524

    Sridhar
    Member

    Hi,
         It is very simple but the only disadvantage is you know when you have around 10 things to prioritize you cant compare all the 10 at a time. Thats what we can avoid with avoid. It compares only pair wise and later on you can even check whether any bias is there in this scores. If so do it again until no bias. Yes it also have some disadvantages like if you have more in number to compare you need many more pair wise comparisions then it becomes cumbersome, but still it is useful.
    best regards
    sridhar
     

    0
    #71525

    sarah snyder
    Member

    Sridhar,
    Maybe you ought to download the paper and Excel spreadsheet, as it looks like lots of us are interested. If you’re not inclined to download, could you email them to me as well? Many thanks.
    sarah

    0
    #71528

    Ravi Vij
    Participant

    Hi Sridahar,
    I would also like to have the AHP files Please.
    Can you mail me at [email protected]
    thanks
    Ravi

    0
    #71539

    Anonymous
    Participant

    We were able to prioritize 20 projects using this method(not that 20 was a constraint-that’s how many we had and could have just as comfortably continued had there been more).  The point here isn’t who has or what is THE right method; it’s simply to SHARE methods that have worked in practice.  

    0
    #71543

    O’Connell
    Participant

    Anthony et al,
    We are currently in the process of prioritizing projects here at HI.  Could you please send me the info on AHP and the excel spreadsheet?.  It sounds like an excellent tool.
    Thanks, Brian
    [email protected]

    0
    #71556

    Brad
    Participant

    Would you kindly send me a copy of it as well?Thanks,Brad

    0
    #71577

    Joshua Sim
    Participant

    Hi Sridhar
    Can you send a copy of the spreadsheet too? Thanks!
    Joshua
    [email protected]
     

    0
    #71578

    Kamal
    Participant

    Sridhar,
    Could you kindly e-mail the AHP material to [email protected]
    Your support is greatly appreciated

    0
    #71583

    k.bhadrayya
    Participant

    Dear SridharThank you very much for your voluntary offer to send one paper and an excel sheet to do prioritization using AHP. I am one of the beneficiaries of such discussion forums. Following is my e-mail ID . Please send me the paper and an excel sheet to do prioritization using AHPe-mail: [email protected] again.k.bhadrayya

    0
    #71613

    Paul Matsumoto
    Participant

    It seems this is very popular.  Would you please send the AHP paper and Excel sheet to me as well.  Thank you very much.
     
     

    0
    #71681

    Kevin Stanco
    Participant

    Dear Sridhar
    Thank for your offer to send one paper and an excel sheet on prioritization using AHP.  My email is included as I am interetd as well.
    [email protected]

    0
    #71714

    Sorour
    Participant

    I’d like to get a copy of the AHP article and spreadsheet as well
    Thanks
    [email protected]

    0
    #71730

    Ratan
    Participant

    dear mr. sridhar,
    can u please send any case study on prioritization of various porjects and zeroing down to important ones. i personally decided to use technique of Business Prirotization matrix wherein against each potential CTQ we cut across various business functions and try to see if the particular business function has STRONG/ MEDIUM/ LOW/ NIL correlation and thus the functions which score higer are choosen for further study. The projects touching these important functions are considered for six sigma projects.
    can i have ur comments and also send me the case study if u have any
    regards and many thanks
    ratan
    [email protected]

    0
    #71848

    Mark W
    Participant

    Sridhar,
    Could you please send me the copies of the AHP files.
    Best Regards,
    Mark

    0
    #71849

    Schultz
    Participant

    Sridhar,
    Please send me the AHP file.
    Thanks,
    Charlie

    0
    #71851

    William Muster
    Member

    Sridhar,
    There is obviously a good deal of interest regarding your spreadsheet, and I believe a previous request to post it to this forum. Would you mind posting it to the forum so that we can stop this long thread of “send it to me too please”?
    I would enjoy seeing it also. Thanks for your help.
    william 

    0
    #72054

    Laura Cote
    Participant

    Hi Sridahar,
    I would also like to have the AHP files Please.
    Can you mail me at [email protected] or pehaps post them here for all to share.
    Thanks!

    0
    #72055

    Hamdi A. Said
    Participant

    Hi Sridhar,
    Would you, please, send me the AHP files as well?
    My e-mail address is [email protected]

    Thank you very much. 
    Best Regards,
    Hamdi

    0
    #72061

    Mark Beffel
    Participant

    Could I get information also – we are just getting started with project selection.  thank you

    0
    #72063

    Gaylord
    Participant

    Hi Hamdi and Sridhar, may I have copies of the AHP files too?
    Thank you!  My e-mail is [email protected]
    Gaylord
     

    0
    #73347

    Jim deVries
    Participant

    Sridhar,
    Thanks for your openess and support.  Could you also please send me the paper?
    Jim
    [email protected]
     

    0
    #73348

    Cannizzo
    Participant
    #73354

    Vicbrazil
    Member

    Sridar…..I’d like to get a copy of the AHP article and spreadsheet as well. Were you able to post the AHP article and spreadsheet out on the web? If so, please send the following URL link web site. 

    Thanks VicBrazil

    0
    #92276

    Taylor
    Member

    What is the rationale for going through pairwise?  What determines where you place the value vs. it’s reciprocal?

    0
    #94099

    Subrata
    Member

    Sridhar,
    I read your AHP paper with great interest.  While I was trying to work through the process you described , I am getting a different result than what you have mentioned in the spread sheet. Can you explain how did you get 1/5 (row 1 , col2 ) , 1/7 (row 3 , col 2 ). Appreciate your reply. My email id is [email protected]

    0
    #118688

    Benjamin
    Participant

    I am unable to access Re: Tools to Prioritize Six Sigma Projects by sridhar on Tuesday, 22nd January 2002The post does not appear… just an index to recent posts. But I think I recall something called Analytical Hierarchical Process with pair-wise comparisons from about 20 or 30 years ago. Is that what we are discussing?

    0
    #180228

    Ruddy
    Participant

    Dear Sridhar
    Me Please – Thank you very much for your voluntary offer to send one paper and an excel sheet to do prioritization using AHP. I am one of the beneficiaries of such discussion forums. Following is my e-mail ID . Please send me the paper and an excel sheet to do prioritization using AHP
    e-mail: [email protected]
    Thanks again.
    Michael

    0
Viewing 46 posts - 1 through 46 (of 46 total)

The forum ‘General’ is closed to new topics and replies.