The Elsmar Cove Forum Calculating PPM for a Supplier on a Specific Defect - Excel .xls Spreadsheet Wanted
 Forum User Name Keep Me Logged In Password
 Register Photo Albums Blogs FAQ Social Groups Calendar Search Today's Posts Mark Forums Read

 Elsmar Cove Forum Sidebar @import url(http://www.google.com/cse/api/branding.css); Custom Search Monitor the Elsmar Forum Monitor New Forum Posts Follow Marc & Elsmar Elsmar Cove Groups Sponsor Links Donate and \$ Contributor Forum Access Sponsored Links Courtesy Quick Links Links that Elsmar Cove visitors will find useful in your quest for knowledge: Howard'sInternational Quality Services Atul'sSymphony Technologies Marcelo Antunes'SQR Consulting Bob Doering'sCorrect SPC - Precision Machining NIST's Engineering Statistics Handbook IRCA - International Register of Certified Auditors SAE - Society of Automotive Engineers Quality Digest Portal IEST - Institute of Environmental Sciences and Technology ASQ - American Society for Quality
 Thread Tools Search this Thread Rate Thread Content Display Modes
#1
31st August 2006, 10:12 AM
 jkittle Involved - Posts   Registration Date: May 2005 Location: North Carolina Posts: 165 Thanks Given to Others: 23 Thanked 8 Times in 8 Posts Karma Power: 49 Karma: 50
Calculating PPM for a Supplier on a Specific Defect - Excel .xls Spreadsheet Wanted

My boss wants me to calculate the PPM for a supplier on a specific defect.

Does anyone have an Excel spread sheet to do this?

#2
31st August 2006, 10:26 AM
 Jim Wynne Cross Forum Moderator   Registration Date: Jan 2005 Location: Southeast Wisconsin Posts: 13,387 Thanks Given to Others: 1,804 Thanked 5,400 Times in 3,458 Posts Blog Entries: 2 Karma Power: 1451 Karma: 39444
Re: Calculating PPM

Using a spreadsheet seems like overkill; in its simplest (and most misleading) form, PPM is calculated as a proportion of a small population projected onto a larger one. If you have a 1000-piece population and 10 defectives, 1% of the population is "bad." 1% of 1,000,000 is 10,000. So the formula would be 10/1000*1,000,000 =10,000 PPM.

Note that if you don't have evidence to support the contention that the defect rate will remain constant through the production of 1mm pieces, there's no good reason to use PPM as a yardstick.
__________________
Everyone has a plan until they get punched in the face (Mike Tyson)
#3
31st August 2006, 10:54 AM
 Canonman23 Inactive Registered Visitor   Registration Date: Aug 2006 Location: Massachusetts Posts: 3 Thanks Given to Others: 0 Thanked 0 Times in 0 Posts Karma Power: 28 Karma: 10
Re: Calculating PPM

I have an excel spreadsheet that we use for DPMO.......but the previous post pretty much sums it up and very easily. Just let me know if you'd like a copy of the spreadhseet .

Neil
#4
31st August 2006, 11:00 AM
 jkittle Involved - Posts   Registration Date: May 2005 Location: North Carolina Posts: 165 Thanks Given to Others: 23 Thanked 8 Times in 8 Posts Karma Power: 49 Karma: 50
Re: Calculating PPM

Thank Jim ans Neil.

I would be interested in your DPMO sheet though.

Jerry
#5
31st August 2006, 01:21 PM
 Canonman23 Inactive Registered Visitor   Registration Date: Aug 2006 Location: Massachusetts Posts: 3 Thanks Given to Others: 0 Thanked 0 Times in 0 Posts Karma Power: 28 Karma: 10
Re: Calculating PPM for a Supplier on a Specific Defect - Excel .xls Spreadsheet Wanted

This is an example I have. I've scaled it down and added a little note for comments. Let me know if have any questions.
Neil
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
 DPMO Example.xls (23.0 KB, 705 views)
#6
31st August 2006, 01:41 PM
 Jim Wynne Cross Forum Moderator   Registration Date: Jan 2005 Location: Southeast Wisconsin Posts: 13,387 Thanks Given to Others: 1,804 Thanked 5,400 Times in 3,458 Posts Blog Entries: 2 Karma Power: 1451 Karma: 39444
Re: Calculating PPM for a Supplier on a Specific Defect - Excel .xls Spreadsheet Wanted

Quote:
 In Reply to Parent Post by Canonman23 This is an example I have. I've scaled it down and added a little note for comments. Let me know if have any questions. Neil
Can you explain your algorithm? For example, you show "Monthly hardware number of completions"= 88, and "Quantity of fallouts" = 6, and then in your formula the two are added together. Aren't the number of fallouts already included in the 88 "completions"? In other words, are you saying that there were 88 units and 6 of them failed, or are you saying that there were 94 units total?

If we take the former as correct (6 of 88 failed) and there are 44 opportunities per unit (88 * 44), this means that there were 3872 opportunities and 6 actual failures. DPMO should be 6/3872*1000000=1550 (rounded) rather than the 1451 you give. Or did I miss the bus?
__________________
Everyone has a plan until they get punched in the face (Mike Tyson)
#7
31st August 2006, 02:03 PM
 Canonman23 Inactive Registered Visitor   Registration Date: Aug 2006 Location: Massachusetts Posts: 3 Thanks Given to Others: 0 Thanked 0 Times in 0 Posts Karma Power: 28 Karma: 10
Re: Calculating PPM for a Supplier on a Specific Defect - Excel .xls Spreadsheet Wanted

My mistake.......(thats what I get for multi-tasking!). It is :
Rejects*1,000,000/(#Lots Produced*OFD)
OFD = Opportunity For Defects [in this case it was 44]

Thanks for catching that and the real number is rounded to 1550. We actually produce several product lines and for right or wrong they all get averaged together so the formula gets a little muddy (not that I'm making excuses)
Neil
#8
31st August 2006, 02:06 PM
 Jim Wynne Cross Forum Moderator   Registration Date: Jan 2005 Location: Southeast Wisconsin Posts: 13,387 Thanks Given to Others: 1,804 Thanked 5,400 Times in 3,458 Posts Blog Entries: 2 Karma Power: 1451 Karma: 39444
Re: Calculating PPM for a Supplier on a Specific Defect - Excel .xls Spreadsheet Wanted

No problem--I just wanted to make sure it was clear for the OP, and that it wasn't me
__________________
Everyone has a plan until they get punched in the face (Mike Tyson)

 The Elsmar Cove Forum Calculating PPM for a Supplier on a Specific Defect - Excel .xls Spreadsheet Wanted

Do you find this discussion thread helpful and informational?

 Bookmarks

 Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 Thread Tools Search this Thread Search this Thread: Advanced Forum Search Display Modes Rate Thread Content Linear Mode Rate Thread Content: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Forum Posting Settings You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

 Similar Discussion Threads Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote sxbalasu Supplier Quality Assurance and other Supplier Issues 41 24th January 2013 11:20 AM kedarg6500 Capability, Accuracy and Stability - Process, Machine, etc. 5 25th April 2010 07:27 AM chiefexec Excel .xls Spreadsheet Templates and Tools 11 23rd April 2007 04:59 PM s-bell Excel .xls Spreadsheet Templates and Tools 9 7th November 2003 08:42 AM Marc Capability, Accuracy and Stability - Process, Machine, etc. 8 17th January 2001 03:34 PM

The time now is 09:33 PM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.