# InformationalNew AIAG PFMEA Process - Excel Template Attached

#### bobdoering

Trusted Information Resource
Here is an Excel template I put together. It has not been rigorously tested - so any improvements are appreciated. Automatically calculates Action Priority (AP)

#### Attachments

• VDA AIAG FMEA.xlsx
53.3 KB · Views: 4,354

#### bobdoering

Trusted Information Resource
Might need a CAD plotter to print out one of these PFMEAs!

#### bobdoering

Trusted Information Resource
This rev has a few more functional bonuses - such as color coded priorities, etc.

#### Attachments

• Copy of VDA AIAG FMEA.xlsx
53.5 KB · Views: 2,963

#### Bill Levinson

##### Industrial Statistician and Trainer
The new AIAG manuals are definitely worth reading; there have been significant changes since the 1990s. Guidance on the occurrence and detection ratings is better, and they also look at severity ratings for the process (e.g. potential risk to workers, continuity of operations) as well as the product.

#### toniriazor

##### Involved In Discussions
Hello all,
can someone please explain what is the main reason to replace RPN with Action priority ? How Action Priority is better than RPN ?

#### Bill Levinson

##### Industrial Statistician and Trainer
Hello all,
can someone please explain what is the main reason to replace RPN with Action priority ? How Action Priority is better than RPN ?

RPN is the product of three ordinal numbers. A failure mode with severity = 10, occurrence 4 and detection 5 has a RPN of 200, as does one with S=4, O=5, and D=10. The latter can at most annoy the customer while the former can kill him. Action Priority gives the severity the biggest weight, followed by occurrence, and finally detection. This stresses that it is best to eliminate or mitigate the failure effect, next best to prevent it, and finally to detect it before it can actually cause trouble.

One thing I am uncomfortable with is the proposition that you can have a S=10 failure mode with a Low action priority with O and D ratings of greater than 1 (although they must be relatively low).

#### toniriazor

##### Involved In Discussions
hello again thanks for info.
at the company where I work we are far from using new PFMEA approach and far from replacing RPN with AP.

How exactly will this become mandatory? Maybe update of customer specific requirements ? Any thoughts about this ? How in the past such transition was managed ?

#### Pau Calvo

##### Involved In Discussions
Hello,

I have been hearing the transition to AP for the last few years in some seminars regarding FMEA.
In my actual company, Tier 2, none of the customers have required the implementation yet but in a previous company that I have work a customer ask for this evaluation even before the last version of FMEA handbook was released.

It would depend of how many new projects, how many customers make the transition and how often you review and update the FMEA that you will reach the point to change the FMEA evaluation for all the customers.

My recommendation is to follow your customer requeriments and have a template prepared with the new evaluation method and a Action Plan of implementation.