Skip to content
Shop | Excel system

Operational Risk Management System

Register, matrix, measures with residual risk, top risks, supplier risk raster, continuity plans with target restart times, exercise log, loss events against the register, project risk, seven key figures and the audit.

Screenshot of the Operational Risk Management System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup holds the site data and the three scales. Agree them in writing with plant management before the first rating.
  2. 03 Register holds every risk with cause, event, effect, owner, rating, measure, residual risk and review dates. 04 Matrix shows where they sit.
  3. 05 Measures compares cost against the expected loss removed. 06 Top Risks is the picture for the management report.
  4. 07 Supplier Risk scores every supplier on five criteria and marks the critical ones. 08 Continuity Plans holds one row per scenario with a target restart time.
  5. 09 Exercises records every table top and live exercise with the time achieved. 10 Events checks whether the events of the year were in the register.
  6. 11 Project Risk takes the risks of projects and changes at the decision. 12 Key Figures tracks seven numbers per month, 13 Audit the 25 statements, 14 Status is the one-page summary.

Definitions used in the workbook

  • Risk: A cause, an event and an effect, with one named owner. Without all three it is a concern, not a risk.
  • Score: Probability class times impact class, from 1 to 25. The score decides what has to happen.
  • Expected value: Probability per year times impact in EUR. The only field that can be summed, so it gives the order of work.
  • Target restart time: When deliveries to the customer run again after a scenario, agreed with sales and proven in an exercise.

Sheets in the workbook

  1. Start
  2. Setup
  3. Register
  4. Matrix
  5. Measures
  6. Top Risks
  7. Supplier Risk
  8. Continuity Plans
  9. Exercises
  10. Events
  11. Project Risk
  12. Key Figures
  13. Audit
  14. Status

Who it is for

Risk owners, plant managers and operations leads who run risk work for a whole site and report it twice a year.

The method behind the numbers

This workbook is part of the Operational Risk Management toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every two weeks.