Hi, I am not sure I am in the right forum, I don’t usually venture into automotive but we have a Process FMEA system based on QS9000 which you experienced guys may be able to help me on.
We have a scoring system (severity x occurrence x detection) which gives us an RPN. QS9000 states assessment for preventive action should first be directed at high severity, high RPN. In general practice when the severity is 9 or 10 special attention must be given regardless of RPN. Once 9 and 10s have been addressed then other failure modes are addressed.
I want to be able to put a formula in an access database or Excel spreadsheet to sort the failure modes into the order that they should be addressed – this is not as simple as ranking them in the RPN order as severity should have a greater weight than the rest. Also if severity is 9 o r 10 but detection is 1 should this be at the bottom of the list as detection is certain?
When addressing the 9s and 10s I cannot always reduce the severity – we are a contract manufacturer and usually have no control over design – so these stay at the top of my list even though I have done everything I can to improve detection and reduce occurrence.
I only want my engineers to concentrate on the problems we can prevent (after once determining we can’t improve on some), I don’t want to look at the bottom end of the table where effort far outweighs benefit.
Has anybody got a formula or weighting system and cut off score they use to ensure only the important failure modes are addressed?
I want to make this foolproof for my engineers!
Thanks
We have a scoring system (severity x occurrence x detection) which gives us an RPN. QS9000 states assessment for preventive action should first be directed at high severity, high RPN. In general practice when the severity is 9 or 10 special attention must be given regardless of RPN. Once 9 and 10s have been addressed then other failure modes are addressed.
I want to be able to put a formula in an access database or Excel spreadsheet to sort the failure modes into the order that they should be addressed – this is not as simple as ranking them in the RPN order as severity should have a greater weight than the rest. Also if severity is 9 o r 10 but detection is 1 should this be at the bottom of the list as detection is certain?
When addressing the 9s and 10s I cannot always reduce the severity – we are a contract manufacturer and usually have no control over design – so these stay at the top of my list even though I have done everything I can to improve detection and reduce occurrence.
I only want my engineers to concentrate on the problems we can prevent (after once determining we can’t improve on some), I don’t want to look at the bottom end of the table where effort far outweighs benefit.
Has anybody got a formula or weighting system and cut off score they use to ensure only the important failure modes are addressed?
I want to make this foolproof for my engineers!
Thanks