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.
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.
Row 1: Wrong material grade accepted
RPN 168AP MediumRevised result:RPN 48AP LowRow 2: Diameter oversize
RPN 175AP MediumRevised result:RPN 84AP LowRow 3: Surface hardness below specification
RPN 192AP MediumRevised result:RPN 64AP LowRow 4: Retaining clip missing
RPN 252AP HighRevised result:RPN 36AP LowRow 5: Wrong part label applied
RPN 54AP LowRevised 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.
| # | Process step | Failure mode | S | O | D | RPN | AP | Revised RPN | Revised AP |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Receive steel bar stock | Wrong material grade accepted | 8 | 3 | 7 | RPN 168 | AP Medium | RPN 48 | AP Low |
| 2 | CNC turning: bearing diameter | Diameter oversize | 7 | 5 | 5 | RPN 175 | AP Medium | RPN 84 | AP Low |
| 3 | Heat treatment | Surface hardness below specification | 8 | 4 | 6 | RPN 192 | AP Medium | RPN 64 | AP Low |
| 4 | Assembly: fit retaining clip | Retaining clip missing | 9 | 4 | 7 | RPN 252 | AP High | RPN 36 | AP Low |
| 5 | Pack and label | Wrong part label applied | 6 | 3 | 3 | RPN 54 | AP Low | RPN – | AP – |
How do you fill in an FMEA template?
- List the process steps in order, from receiving material to dispatch. One step can have several rows.
- For each step, list the failure modes: the ways the step can produce a part that does not meet its requirement.
- Write the effect on the next operation, the customer and the end user, and rate severity from the worst credible effect.
- Name the causeand rate how often it occurs with today's prevention controls.
- Record current detection controls and rate how likely they are to catch the failure before the part leaves.
- 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
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.
| Step | Result | |
|---|---|---|
| SeverityPossible injury to the user, with warning | Possible injury to the user, with warning | S = 9 |
| OccurrenceSkipped now and then at changeover | Skipped now and then at changeover | O = 4 |
| DetectionVisual check at final inspection | Visual check at final inspection | D = 7 |
| RPN9 × 4 × 7 | 9 × 4 × 7 | 252 |
| Action priorityS 9-10, O 4-5, D 7-10 | S 9-10, O 4-5, D 7-10 | High |
| After actionClip-sensing fixture + camera check: 9 × 2 × 2 | Clip-sensing fixture + camera check: 9 × 2 × 2 | RPN 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.
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)
| Rating | Level | Typical criteria |
|---|---|---|
| 10 | Hazardous | Affects safe use or breaks a regulation, with no warning |
| 9 | Serious | Affects safe use or breaks a regulation, with warning |
| 8 | Very high | Product does not work; primary function lost |
| 7 | High | Primary function works but at a reduced level |
| 6 | Moderate | Secondary or comfort function lost |
| 5 | Low | Secondary function works at a reduced level |
| 4 | Very low | Fit, finish or noise issue most customers notice |
| 3 | Minor | Fit, finish or noise issue many customers notice |
| 2 | Very minor | Issue only a careful customer notices |
| 1 | None | No 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.
| Rating | Level | Typical criteria |
|---|---|---|
| 10 | Very high | About 1 in 10 or more; no prevention control |
| 9 | Very high | About 1 in 20 |
| 8 | High | About 1 in 50 |
| 7 | High | About 1 in 100 |
| 6 | Moderate | About 1 in 500 |
| 5 | Moderate | About 1 in 2,000 |
| 4 | Moderate | About 1 in 10,000 |
| 3 | Low | About 1 in 100,000 |
| 2 | Very low | About 1 in 1,000,000 |
| 1 | Remote | Cause 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.
| Rating | Level | Typical criteria |
|---|---|---|
| 10 | Almost impossible | No current control, or the failure cannot be detected |
| 9 | Very remote | Random audits or indirect checks only |
| 8 | Remote | Visual inspection by an operator |
| 7 | Very low | Repeated visual inspection |
| 6 | Low | Manual gauging or SPC charting after the operation |
| 5 | Moderate | Gauging at a later station or by the next operation |
| 4 | Moderately high | Gauging at the station, or several layers of checks |
| 3 | High | Automatic detection at the station that stops the part moving on |
| 2 | Very high | Error-proofing detects the cause and stops a defect being made |
| 1 | Almost certain | Defect cannot be made: prevented by design or fixture |
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.
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.
Which calculator should you use next?
Each of these answers a question this result raises. All 11 free manufacturing tools show their formula or method.
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.
Want these numbers live, not once a month?
- Free consultation
- No commitment
- Tailored to your team