Tools to Prioritize Six Sigma Projects
Six Sigma – iSixSigma › Forums › Old Forums › General › Tools to Prioritize Six Sigma Projects
- This topic has 45 replies, 38 voices, and was last updated 13 years, 4 months ago by
Ruddy.
-
AuthorPosts
-
January 22, 2002 at 5:31 pm #28579
Pete ZeidlerParticipant@Pete-ZeidlerInclude @Pete-Zeidler in your post and this person will
be notified via email.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 !
0January 23, 2002 at 3:14 am #71423Hi,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.
0January 23, 2002 at 4:52 pm #71436
Pete ZeidlerParticipant@Pete-ZeidlerInclude @Pete-Zeidler in your post and this person will
be notified via email.Sridhar….your response is an excellent suggestion and does indeed help….thank you for taking the time to respond !
Pete0January 24, 2002 at 1:03 pm #71467
Dr AntonyParticipant@Dr-AntonyInclude @Dr-Antony in your post and this person will
be notified via email.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
UK0January 24, 2002 at 2:00 pm #71474Hi Antony,
can you send me your mail id, i will send you one paper and an excel sheet to do prioritization using AHP.
sridhar
0January 24, 2002 at 2:42 pm #71478I too would be interested in a copy of the paper and the Excel document, would you kindly send it to the email address above.
Thanks0January 24, 2002 at 2:53 pm #71479
AnonymousParticipant@AnonymousInclude @Anonymous in your post and this person will
be notified via email.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 !”
0January 24, 2002 at 2:59 pm #71480
Patrick McDermottParticipant@Patrick-McDermottInclude @Patrick-McDermott in your post and this person will
be notified via email.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 results0January 24, 2002 at 2:59 pm #71482Sridhar,
could you send me the AHP files as well.
Thanks,
-Todd0January 24, 2002 at 3:23 pm #71486Sridhar,
Would you, please, send me the AHP files as well?
My e-mail address is [email protected]
Thank you very much, Best Regards,0January 24, 2002 at 3:41 pm #71489Sridhar,
Would you, please, send me the AHP files as well?
My e-mail address is [email protected]
Thank you very much, Best Regards,0January 24, 2002 at 4:29 pm #71495
B. BanthiaParticipant@B.-BanthiaInclude @B.-Banthia in your post and this person will
be notified via email.Would you please send me also a copy of paper and Excel document regarding AHP. Thanks.
0January 24, 2002 at 6:53 pm #71505
Pete ZeidlerParticipant@Pete-ZeidlerInclude @Pete-Zeidler in your post and this person will
be notified via email.Thanks for the “hoke-pokey” method…it makes a great deal of sense !
0January 24, 2002 at 6:54 pm #71506
Pete ZeidlerParticipant@Pete-ZeidlerInclude @Pete-Zeidler in your post and this person will
be notified via email.This “Pugh” method sounds great..I will do some research on it, and thanks !
0January 24, 2002 at 7:11 pm #71508Please also send me a copy of the AHP materials.
Thanks.0January 24, 2002 at 7:28 pm #71511
Bill BeardParticipant@Bill-BeardInclude @Bill-Beard in your post and this person will
be notified via email.Sridhar,
Would you, please, send me the AHP files as well?My e-mail address is [email protected]
Thank you very much, Best Regards,0January 24, 2002 at 8:10 pm #71513
Mark AeiltsParticipant@Mark-AeiltsInclude @Mark-Aeilts in your post and this person will
be notified via email.Please email me copies of the materials. thanks
0January 24, 2002 at 10:19 pm #71518
I would also like a copy of the AHP excel spreadsheet.
Thank You
[email protected]0January 25, 2002 at 1:26 am #71520
karyeng liewParticipant@karyeng-liewInclude @karyeng-liew in your post and this person will
be notified via email.hello,
i would also like a copy of the excel spreadsheet.
thank you.0January 25, 2002 at 3:17 am #71524Hi,
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
0January 25, 2002 at 4:02 am #71525
sarah snyderMember@sarah-snyderInclude @sarah-snyder in your post and this person will
be notified via email.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.
sarah0January 25, 2002 at 5:24 am #71528
Ravi VijParticipant@Ravi-VijInclude @Ravi-Vij in your post and this person will
be notified via email.Hi Sridahar,
I would also like to have the AHP files Please.
Can you mail me at [email protected]
thanks
Ravi0January 25, 2002 at 2:23 pm #71539
AnonymousParticipant@AnonymousInclude @Anonymous in your post and this person will
be notified via email.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.
0January 25, 2002 at 4:17 pm #71543Anthony 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]0January 25, 2002 at 10:55 pm #71556Would you kindly send me a copy of it as well?Thanks,Brad
0January 26, 2002 at 6:03 pm #71577
Joshua SimParticipant@Joshua-SimInclude @Joshua-Sim in your post and this person will
be notified via email.Hi Sridhar
Can you send a copy of the spreadsheet too? Thanks!
Joshua
[email protected]
0January 26, 2002 at 7:07 pm #71578Sridhar,
Could you kindly e-mail the AHP material to [email protected]
Your support is greatly appreciated0January 27, 2002 at 6:23 am #71583
k.bhadrayyaParticipant@k.bhadrayyaInclude @k.bhadrayya in your post and this person will
be notified via email.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
0January 28, 2002 at 3:42 pm #71613
Paul MatsumotoParticipant@Paul-MatsumotoInclude @Paul-Matsumoto in your post and this person will
be notified via email.It seems this is very popular. Would you please send the AHP paper and Excel sheet to me as well. Thank you very much.
0January 30, 2002 at 9:05 pm #71681
Kevin StancoParticipant@Kevin-StancoInclude @Kevin-Stanco in your post and this person will
be notified via email.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]0January 31, 2002 at 8:58 pm #71714I’d like to get a copy of the AHP article and spreadsheet as well
Thanks
[email protected]0February 1, 2002 at 8:18 am #71730dear 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]0February 6, 2002 at 8:08 pm #71848Sridhar,
Could you please send me the copies of the AHP files.
Best Regards,
Mark0February 6, 2002 at 8:38 pm #71849
SchultzParticipant@CharlieInclude @Charlie in your post and this person will
be notified via email.Sridhar,
Please send me the AHP file.
Thanks,
Charlie0February 6, 2002 at 8:46 pm #71851
William MusterMember@William-MusterInclude @William-Muster in your post and this person will
be notified via email.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.
william0February 11, 2002 at 4:22 pm #72054
Laura CoteParticipant@Laura-CoteInclude @Laura-Cote in your post and this person will
be notified via email.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!0February 11, 2002 at 4:34 pm #72055
Hamdi A. SaidParticipant@Hamdi-A.-SaidInclude @Hamdi-A.-Said in your post and this person will
be notified via email.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,
Hamdi0February 11, 2002 at 8:59 pm #72061
Mark BeffelParticipant@Mark-BeffelInclude @Mark-Beffel in your post and this person will
be notified via email.Could I get information also – we are just getting started with project selection. thank you
0February 11, 2002 at 9:42 pm #72063
GaylordParticipant@GaylordInclude @Gaylord in your post and this person will
be notified via email.Hi Hamdi and Sridhar, may I have copies of the AHP files too?
Thank you! My e-mail is [email protected]
Gaylord
0March 18, 2002 at 10:06 pm #73347
Jim deVriesParticipant@Jim-deVriesInclude @Jim-deVries in your post and this person will
be notified via email.Sridhar,
Thanks for your openess and support. Could you also please send me the paper?
Jim
[email protected]
0March 18, 2002 at 10:13 pm #73348They’re posted here:
https://www.isixsigma.com/forum/showmessage.asp?messageID=85890March 18, 2002 at 11:13 pm #73354
VicbrazilMember@VicbrazilInclude @Vicbrazil in your post and this person will
be notified via email.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
0November 8, 2003 at 3:25 pm #92276What is the rationale for going through pairwise? What determines where you place the value vs. it’s reciprocal?
0January 9, 2004 at 9:52 am #94099Sridhar,
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]0April 30, 2005 at 11:51 pm #118688
BenjaminParticipant@CharlesInclude @Charles in your post and this person will
be notified via email.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?
0January 27, 2009 at 12:42 pm #180228Dear 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.
Michael0 -
AuthorPosts
The forum ‘General’ is closed to new topics and replies.