Skip to content
Shop | Excel system

Structured Decision Making System

Decision frame with roles, criteria and weights, alternatives, silent scoring with spread, cost and benefit, three cases, sensitivity, bias check, decision note with assumptions, decision register and audit.

Screenshot of the Structured Decision Making System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup and 03 Frame: the question, the trigger, the date, the class and the four roles with names and dates.
  2. 04 Criteria: musts, wants and the paired comparison. Fix the weights before any option is scored.
  3. 05 Alternatives: options with must check and the agreed scores. 06 Silent Scoring: every participant alone, then the spread.
  4. 07 Cost and Benefit, 08 Cases and 09 Sensitivity: the same period for every option, three cases, and what would change the ranking.
  5. 10 Bias Check before the decision. 11 Decision Note with assumptions as ranges. 12 Register with the review date.
  6. 13 Audit every three months on the five newest decisions. 14 Status when the decision is presented.

Definitions used in the workbook

  • Class: 1 reversible in three months for under EUR 10,000. 2 costly to reverse. 3 hard to reverse: large investment, long contract, positions.
  • Case: One future with one driver changed against the expected case. Three cases, never averaged.
  • Sensitivity: How far a weight, a price or a volume has to move before the ranking of the top two options changes.
  • Spread: Highest minus lowest score of the participants for one cell. Above three points the cell is discussed.

Sheets in the workbook

  1. Start
  2. Setup
  3. Frame
  4. Criteria
  5. Alternatives
  6. Silent Scoring
  7. Cost and Benefit
  8. Cases
  9. Sensitivity
  10. Bias Check
  11. Decision Note
  12. Register
  13. Audit
  14. Status

Who it is for

Plant managers and management teams who want one method and one register for all decisions of weight.

The method behind the numbers

This workbook is part of the Structured Decision Making 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.