# AS9100 Risk and Opportunity Register Worksheet (Clause 6.1) > Source: https://netray.co/tools/as9100-risk-and-opportunity-register-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log risks and opportunities with severity, likelihood and detection scores, calculate a risk priority number and export to Excel. ## Category quality ## Industry Aerospace ## Audience - Quality manager - Operations manager - Management representative ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Risk or opportunity **Key:** item **Type:** text #### Type **Key:** type **Type:** select **Options:** - Risk - Opportunity #### Process **Key:** process **Type:** select **Options:** - Contract review - Purchasing - Production - Inspection and test - Delivery - Configuration management - Calibration - Human resources #### Severity (1-10) **Key:** sev **Type:** number #### Likelihood (1-10) **Key:** occ **Type:** number #### Detection (1-10) **Key:** det **Type:** number **Help:** 10 means the problem is very unlikely to be detected before it reaches the customer #### Priority number **Key:** rpn **Type:** number **Expr:** sev * occ * det **Format:** integer #### Planned action **Key:** action **Type:** text #### Owner **Key:** owner **Type:** text #### Due **Key:** due **Type:** date **Rows:** **Item:** Single source for forged housings **Type:** Risk **Process:** Purchasing **Sev:** 8 **Occ:** 4 **Det:** 5 **Action:** Qualify second source and hold buffer stock **Owner:** Purchasing manager **Due:** 2027-01-31 **Item:** Expired calibration on CMM probe **Type:** Risk **Process:** Calibration **Sev:** 7 **Occ:** 3 **Det:** 4 **Action:** ERP calibration hold on overdue gauges **Owner:** Quality lead **Due:** 2026-12-15 **Item:** Unauthorized drawing revision at the machine **Type:** Risk **Process:** Configuration management **Sev:** 9 **Occ:** 2 **Det:** 6 **Action:** Controlled digital work instructions **Owner:** Engineering manager **Due:** 2027-02-28 **Item:** New customer asks for 5-axis capacity **Type:** Opportunity **Process:** Contract review **Sev:** 5 **Occ:** 6 **Det:** 2 **Action:** Quote capacity with second shift **Owner:** Sales lead **Due:** 2026-11-30 **Totals:** #### Highest priority number **Key:** rpn **Agg:** max **Format:** integer #### Items logged **Key:** rpn **Agg:** count **Format:** integer **Summary:** #### Average priority number **Key:** avg_rpn **Expr:** avg_rpn **Format:** integer **Primary:** true **Notes:** The priority number is severity times likelihood times detection, the same method used in FMEA. Set your own action threshold, such as 100 or more, in your risk procedure. Opportunities use the same scale for effort and benefit if you prefer. ## Content **Intro:** AS9100 clause 6.1 asks you to plan actions to address risks and opportunities, and clause 8.1.1 adds operational risk management. This register gives you a simple scoring model and an Excel export you can bring to management review. **Sections:** #### How to use the register **Body:** List each risk or opportunity against the process it affects. Score severity, likelihood and detection from 1 to 10, and let the sheet calculate the priority number. Sort by the highest numbers, assign an owner and date, and record the action. Revisit the register at least at each management review and after any significant incident or audit finding. **Bullets:** - Tie each item to a process owner - Score using agreed criteria, not gut feel - Record planned action and due date - Review after incidents and audits #### The scoring method **Body:** The priority number multiplies severity, likelihood and detection, giving a range of 1 to 1000. Severity reflects the effect on product, delivery or compliance. Likelihood reflects how often it could occur. Detection reflects how well current controls would catch it. A high detection score means weak controls. The number ranks items, it does not prove anything on its own. #### Operational risk topics for aerospace **Body:** Operational risk management in AS9100 covers areas such as product safety, supplier performance, counterfeit parts, on-time delivery, key resource availability, configuration control and human factors. Make sure your register includes these themes with real examples from your shop, not a generic list copied from a template. #### Common mistakes **Body:** Registers go stale when they are written once for the audit. Other problems include scoring everything as medium, listing risks with no action, and treating opportunities as an afterthought. Keep the list short enough to maintain and link actions to measurable objectives. **Cta:** Netray can help feed live ERP data such as late orders and rejections into your risk review so it reflects the real shop floor. **Faq:** #### Does AS9100 require a risk register? **Answer:** The standard requires you to determine risks and opportunities and plan actions, and to keep documented information where needed. A register is the most common way to show this, but it is not the only format. #### What score needs action? **Answer:** There is no fixed number. Define a threshold in your procedure, and apply judgment to any item with high severity regardless of the product. #### Are opportunities scored the same way? **Answer:** You can use the same scale for benefit, likelihood and effort, or keep opportunities in a simpler list. What matters is that you decide and record the actions. #### How often should I update it? **Answer:** At least at each management review, and whenever the business changes, such as a new customer, process, supplier or audit finding. ## Search terms AS9100 risk register template, risk and opportunity register excel, clause 6.1 actions to address risks, AS9100 operational risk management, risk priority number worksheet, aerospace risk register --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json