# FMEA Recommended Actions Tracker Worksheet > Source: https://netray.co/tools/fmea-recommended-actions-tracker-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track each FMEA action with owner, due date, status and before-and-after ratings, with RPN and RPN reduction calculated automatically. ## Category quality ## Industry Manufacturing ## Audience - Quality engineer - Process engineer - Reliability engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Failure mode **Key:** item **Type:** text #### Recommended action **Key:** action **Type:** text #### Owner **Key:** owner **Type:** text #### Due date **Key:** due **Type:** date #### Status **Key:** status **Type:** select **Options:** - Open - In progress - Done - Verified - Cancelled #### S before **Key:** s **Type:** number #### O before **Key:** o **Type:** number #### D before **Key:** d **Type:** number #### RPN before **Key:** rpn0 **Type:** number **Expr:** s * o * d **Format:** integer #### S after **Key:** s1 **Type:** number #### O after **Key:** o1 **Type:** number #### D after **Key:** d1 **Type:** number #### RPN after **Key:** rpn1 **Type:** number **Expr:** s1 * o1 * d1 **Format:** integer #### RPN reduction **Key:** drop **Type:** number **Expr:** s * o * d - s1 * o1 * d1 **Format:** integer **Rows:** **Item:** Bore oversize **Action:** Add automatic tool offset from air gauge **Owner:** Mfg Eng **Due:** 2026-12-05 **Status:** In progress **S:** 8 **O:** 5 **D:** 6 **S1:** 8 **O1:** 3 **D1:** 3 **Item:** Burr in cross hole **Action:** Add borescope check and brush life counter **Owner:** Quality **Due:** 2026-11-28 **Status:** Done **S:** 9 **O:** 4 **D:** 7 **S1:** 9 **O1:** 3 **D1:** 4 **Item:** Wrong tray insert **Action:** Poka-yoke tray by part family barcode **Owner:** Logistics **Due:** 2026-12-12 **Status:** Open **S:** 4 **O:** 6 **D:** 5 **S1:** 4 **O1:** 2 **D1:** 2 **Item:** Chips not removed **Action:** Nozzle pressure monitor with alarm **Owner:** Maintenance **Due:** 2026-11-20 **Status:** Verified **S:** 6 **O:** 5 **D:** 5 **S1:** 6 **O1:** 3 **D1:** 3 **Totals:** #### Total RPN before **Key:** rpn0 **Agg:** sum **Format:** integer #### Total RPN after **Key:** rpn1 **Agg:** sum **Format:** integer #### Total reduction **Key:** drop **Agg:** sum **Format:** integer **Summary:** #### Overall RPN reduction **Key:** pct **Expr:** if(gt(sum_rpn0,0), 100 * sum_drop / sum_rpn0, 0) **Format:** percent **Notes:** Re-score only after the action is implemented and verified. Severity normally changes only if the design or process is changed to remove the effect. Check your own action rules; many customers now require Action Priority rather than RPN thresholds. ## Content **Intro:** An FMEA is only as good as the actions that follow it. This tracker keeps each recommended action, owner and due date next to the before and after ratings, so you can show risk really went down. **Sections:** #### How to use the tracker **Body:** Copy each high-priority failure mode from your FMEA, write the action in specific terms and assign a named owner with a due date. Enter the original S, O and D, then enter the planned or actual new ratings once the action is done. The sheet calculates RPN before, RPN after and the reduction. Update status weekly in your quality meeting. **Bullets:** - One action per row - Use verbs and measurable results - Never re-score before verification - Export for management review #### How RPN is calculated **Body:** RPN is severity times occurrence times detection, each on a 1 to 10 scale, giving a value from 1 to 1000. Prevention actions reduce occurrence; detection actions reduce detection rating. Severity drops only when the failure effect itself is designed out. The tracker shows RPN reduction so you can compare actions, but RPN alone can mislead because different combinations produce the same product. #### RPN versus Action Priority **Body:** The AIAG-VDA FMEA handbook replaced RPN thresholds with Action Priority (high, medium, low), which weights severity first. A failure with severity 9 and low occurrence can matter more than a mid-severity item with the same RPN. Use this tracker for the arithmetic and your Action Priority table for deciding which items need action first. #### Common mistakes **Body:** Closing an action without evidence is the most common failure. Attach the work instruction, gauge study or control plan revision that proves the change. Another mistake is lowering detection by adding inspection when prevention was possible. Finally, avoid actions such as retrain operator without a documented method to verify effectiveness. **Cta:** If actions should flow into ERP change orders and control plans, Netray can wire that in. Ask for a short review. **Faq:** #### When can I change the severity rating? **Answer:** Only when the failure effect changes, for example by a design change or by removing the hazard. Detection and prevention controls do not reduce severity. Many teams lock severity unless engineering confirms a real change. #### Is a lower RPN always better evidence? **Answer:** It is useful, but not sufficient. A drop must be backed by verified controls and, ideally, by data such as lower scrap or better capability. Also check severity first, since a high-severity item may need action even at a low RPN. #### How often should we review actions? **Answer:** Weekly or biweekly during launch, monthly afterward. Overdue items should be escalated to the process owner. Keep closed actions in the file as evidence for audits. #### Can I use this with Action Priority? **Answer:** Yes. Add your AP level in the action text or a separate note, and use the RPN columns for comparison. The sheet does not replace your customer-specific AP table. ## Search terms fmea action tracker excel, fmea recommended actions template, fmea action log, rpn reduction tracker, fmea action plan template, fmea follow up spreadsheet, fmea closure tracking --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json