Countermeasures Matrix

Evaluates the feasibility and effectiveness of countermeasures to reduce or eliminate root causes

counter-measures matrix excelLike ecological weed prevention, a countermeasure prevents problems from ever taking root in a process. A good countermeasure not only eliminates the root cause but also prevents other weeds from growing.


Countermeasures Matrix Template in the QI Macros

Countermeasures matrix in Excel

QI Macros Countermeasures Matrix includes a Feasibility - Effectivess Plot

This chart plots the ranking values in columns C and E:

feasibility effectiveness chart in the QI Macros for Excel

Process to Complete the Counter Measures Matrix

  1. Transfer the problem statement and the root causes from your root cause analysis (Fishbone diagram or Ishikawa diagram).
  2. For each root cause, identify one to three broad countermeasures (what to do).
  3. Rank the effectiveness of each countermeasure (Low, Medium, or High).
  4. Identify the specific actions (how to do it) for implementing each countermeasure.
  5. Rank the feasibility (time, cost) of each specific action (Low, Medium, or High).
  6. Decide which specific actions to implement.

*Note: A Countermeasures Matrix/Prioritization Matrix can be used in place of an Effort-Impact Quadrant.

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!