Perimattic
Free Tool

FMEA template and RPN calculator

An editable process FMEA worksheet that calculates the risk priority number and AIAG-VDA action priority for every row. Sort by risk, track actions and revised ratings, then download the worksheet as a CSV for Excel or print it.

Engineer reviewing technical part drawings with a vernier caliper, next to a toolbox and machined parts
Overview

How do you calculate the risk priority number (RPN)?

The risk priority number (RPN) is Severity × Occurrence × Detection, each rated from 1 to 10, so it runs from 1 to 1,000. A failure mode rated S 8, O 4, D 6 has an RPN of 192. Rank by RPN, but act on high severity first; the AIAG-VDA handbook uses Action Priority for that reason.

FMEA worksheet

Fill in your process FMEA

The worksheet opens with a sample machining and assembly PFMEA. Edit it, or clear it and start your own. Your rows are saved in this browser only; nothing you type is sent to a server.

Failure modes
5
Highest RPN
252
High action priority
1
High/Medium with no action
0
  1. Row 1: Wrong material grade accepted

    RPN 168AP Medium
    Revised result:RPN 48AP Low
  2. Row 2: Diameter oversize

    RPN 175AP Medium
    Revised result:RPN 84AP Low
  3. Row 3: Surface hardness below specification

    RPN 192AP Medium
    Revised result:RPN 64AP Low
  4. Row 4: Retaining clip missing

    RPN 252AP High
    Revised result:RPN 36AP Low
  5. Row 5: Wrong part label applied

    RPN 54AP Low
    Revised result:RPN –AP –

Worksheet overview

RPN colour bands used here: 200 and above red, 100 to 199 amber, below 100 green. These cut-offs are a convention, not part of any standard.

FMEA overview with RPN and action priority before and after actions
#Process stepFailure modeSODRPNAPRevised RPNRevised AP
1Receive steel bar stockWrong material grade accepted837RPN 168AP MediumRPN 48AP Low
2CNC turning: bearing diameterDiameter oversize755RPN 175AP MediumRPN 84AP Low
3Heat treatmentSurface hardness below specification846RPN 192AP MediumRPN 64AP Low
4Assembly: fit retaining clipRetaining clip missing947RPN 252AP HighRPN 36AP Low
5Pack and labelWrong part label applied633RPN 54AP LowRPN –AP –
How to use

How do you fill in an FMEA template?

  1. List the process steps in order, from receiving material to dispatch. One step can have several rows.
  2. For each step, list the failure modes: the ways the step can produce a part that does not meet its requirement.
  3. Write the effect on the next operation, the customer and the end user, and rate severity from the worst credible effect.
  4. Name the causeand rate how often it occurs with today's prevention controls.
  5. Record current detection controls and rate how likely they are to catch the failure before the part leaves.
  6. Sort by RPN and action priority, agree actions with an owner and date, then re-rate S, O and D once each action is done.
RPN
Severity × Occurrence × Detection (1 to 1,000)
Revised RPN
Revised S × Revised O × Revised D
Action priority
AIAG-VDA lookup of S, O and D → High / Medium / Low
Worked example

RPN calculator worked example

Row 4 of the sample worksheet: at the assembly step, an operator can skip the retaining clip during a model changeover. The shaft could then slide out and injure the user.

RPN worked example for a missing retaining clip
StepResult
SeverityPossible injury to the user, with warningS = 9
OccurrenceSkipped now and then at changeoverO = 4
DetectionVisual check at final inspectionD = 7
RPN9 × 4 × 7252
Action priorityS 9-10, O 4-5, D 7-10High
After actionClip-sensing fixture + camera check: 9 × 2 × 2RPN 36, Low

Severity stays at 9 because the effect has not changed; the action lowers occurrence and detection. This is why revised severity rarely moves unless the design changes.

Where RPN and action priority disagree

A safety failure rated S 9, O 4, D 2 has an RPN of only 72, yet its action priority is High. A cosmetic issue rated S 3, O 8, D 8 scores 192 but is only Medium. Ranking by RPN alone would put the cosmetic issue first. The worksheet shows both, so you can sort by RPN without losing sight of severity.

Rating scales

FMEA severity, occurrence and detection rating scales

These 1 to 10 scales follow the structure most manufacturers use. The wording is general guidance; write your own criteria for your product and customer, and keep them fixed so ratings stay comparable between rows and between reviews.

Severity (S)

Severity rating scale
RatingLevelTypical criteria
10HazardousAffects safe use or breaks a regulation, with no warning
9SeriousAffects safe use or breaks a regulation, with warning
8Very highProduct does not work; primary function lost
7HighPrimary function works but at a reduced level
6ModerateSecondary or comfort function lost
5LowSecondary function works at a reduced level
4Very lowFit, finish or noise issue most customers notice
3MinorFit, finish or noise issue many customers notice
2Very minorIssue only a careful customer notices
1NoneNo noticeable effect

Occurrence (O)

Example rates per unit or event. Replace them with figures from your own scrap, rework or field data where you have it.

Occurrence rating scale
RatingLevelTypical criteria
10Very highAbout 1 in 10 or more; no prevention control
9Very highAbout 1 in 20
8HighAbout 1 in 50
7HighAbout 1 in 100
6ModerateAbout 1 in 500
5ModerateAbout 1 in 2,000
4ModerateAbout 1 in 10,000
3LowAbout 1 in 100,000
2Very lowAbout 1 in 1,000,000
1RemoteCause prevented by design or by an error-proofed process

Detection (D)

A high number means the failure is hard to catch. Rate the best control already in place, not a planned one.

Detection rating scale
RatingLevelTypical criteria
10Almost impossibleNo current control, or the failure cannot be detected
9Very remoteRandom audits or indirect checks only
8RemoteVisual inspection by an operator
7Very lowRepeated visual inspection
6LowManual gauging or SPC charting after the operation
5ModerateGauging at a later station or by the next operation
4Moderately highGauging at the station, or several layers of checks
3HighAutomatic detection at the station that stops the part moving on
2Very highError-proofing detects the cause and stops a defect being made
1Almost certainDefect cannot be made: prevented by design or fixture
Action priority

RPN vs AIAG-VDA action priority

The AIAG & VDA FMEA Handbook (1st edition, 2019) replaced RPN with action priority (AP) for automotive suppliers. AP is a lookup table covering every combination of severity, occurrence and detection. It gives most weight to severity, then occurrence, then detection.

  • High: act to improve prevention or detection controls, or document why current controls are adequate.
  • Medium: action should be taken, or the reason for not acting documented.
  • Low:action could be taken; it is at the team's discretion.

A few patterns from the table: severity 9 or 10 is High whenever occurrence is 4 or more, unless detection is rated 1 at occurrence 4 or 5. Occurrence 1 is always Low. Severity 1 is always Low. The worksheet applies the full table to every row. The AP values here were checked on 17 November 2026 against a published reproduction of the handbook table and against worked examples; if your customer requires the handbook, confirm critical rows against your licensed copy.

After the FMEA

Turning FMEA actions into controls on the line

Many FMEA actions end in better detection: the D rating falls from 7 or 8 for a visual check to 2 or 3 when a camera or sensor stops a bad part at the station. Intellyx Automated Vision QC does this for surface, presence and dimension checks, and Perimattic's computer vision for manufacturing services build custom inspection stations. To keep FMEAs, control plans, inspection records and corrective actions in one system, see quality management system development.

Where a failure mode is checked by sampling, the AQL sampling calculator gives the sample size and accept and reject numbers. To put a cost on the failures you rank here, use the defect rate calculator, the production cost calculator and the OEE calculator on perimattic.com, or the DPMO & Six Sigma Calculator and Cycle Time Calculator in the Perimattic Intellyx toolkit.

FAQs

Frequently Asked Questions

What is an FMEA template?

An FMEA template is a worksheet with one row per failure mode and columns for the process step, failure mode, effect, severity, cause, occurrence, current controls, detection, RPN, recommended action, owner, due date and revised ratings. Filling it in as a team gives you a ranked list of risks and a record of what you did about each one.

Can I use this FMEA template in Excel?

Yes. Fill in the worksheet on this page, then use Download CSV. The file opens directly in Excel, Google Sheets or LibreOffice with every column, including RPN and action priority, already calculated. In Excel you can then add your own formatting, filters and company header. The worksheet also stays saved in your browser for your next visit.

What RPN value needs action?

No standard sets a universal RPN threshold. Many teams use a cut-off such as 100 or 200, or work on the top 20% of rows, but a fixed threshold can hide serious risks: S 9, O 4, D 2 gives only 72. Always review any severity of 9 or 10 regardless of RPN, which is what AIAG-VDA action priority builds in.

What is the difference between RPN and action priority?

RPN multiplies severity, occurrence and detection, so very different risks can share a score. Action priority, from the 2019 AIAG-VDA FMEA Handbook, looks up each S, O and D combination in a table and returns High, Medium or Low. It weights severity first, then occurrence, then detection, so safety risks are not outranked by frequent minor ones.

What is the difference between a PFMEA and a DFMEA?

A design FMEA (DFMEA) looks at how a product design could fail to meet its function, before it is released. A process FMEA (PFMEA) looks at how each manufacturing or assembly step could produce a defect. The worksheet on this page is laid out for a PFMEA, but the same columns work for a DFMEA if you enter design functions instead of process steps.

How often should an FMEA be updated?

Treat the FMEA as a living document. Update it when the process, product, material, supplier or equipment changes, when a new defect or customer complaint appears, and after each recommended action is completed so the revised ratings reflect reality. Many plants also review high-risk rows at a fixed interval, such as each quarter.

Perimattic Intellyx

Want these numbers live, not once a month?

Perimattic engineers will walk through your plant and show where live OEE, quality and cost data from Intellyx would have the fastest impact, at no obligation.
  • Free consultation
  • No commitment
  • Tailored to your team