How to make a decision matrix, with a worked example

A decision matrix helps make tradeoffs visible. It does not turn preferences into objective truth. Separate must-have constraints from weighted preferences, define what each score means, and change the weights once to see how stable the comparison is.

Apply gates before weights

If an option fails a non-negotiable requirement, do not let a high score elsewhere average that failure away. For a fictional workspace choice, accessible entry may be a gate; quietness and travel time may be preferences. The user must decide which requirements are truly non-negotiable.

A small worked matrix

Use a scale where 1 is poor fit and 5 is strong fit, with definitions agreed before scoring.

A scores 0.6 × 5 + 0.4 × 2 = 3.8. B scores 0.6 × 3 + 0.4 × 5 = 3.8. The tie is informative: the options suit different priorities. Changing the commute weight to 0.6 gives A 3.2 and B 4.2.

Ask for structure without fake precision

Help compare these options using criteria I supply.
Separate must-have gates from preferences.
Define the scoring scale before scoring.
Use my evidence for scores and mark missing information.
Show the weighted arithmetic and test one alternative weighting.
Do not recommend a winner solely from the score.
Options: [facts]
Criteria and constraints: [list]

Inspect the sensitive criteria

If a small weight change flips the ranking, discuss the tradeoff rather than adding decimal places. If a score is based on a guess, gather evidence before treating the total as meaningful.

Record why you chose the final option and which assumptions mattered. Later, compare the actual experience with those assumptions. The matrix is most useful as a record of your reasoning, especially when several people need to understand a decision. It should make disagreement easier to discuss, not hide it inside a polished number.

Decide what a score means before assigning it

In the workspace example, “easy commute” can mean door-to-door travel time at the hours you expect to travel. Write down the ranges for a 1, 3, or 5 before seeing the total. Otherwise, it is easy to give your favorite option a generous score and then treat the result as independent confirmation.

Quietness needs different evidence. A tour at noon may not tell you whether you can take calls at nine in the morning. Keep that uncertainty next to the score. If you have not tested a space, leave the cell blank or label the score provisional rather than presenting it as an observation.

Use the tie to plan the next question

The two spaces both score 3.8 in the first calculation. That does not mean they are interchangeable. A is stronger for calls; B is stronger for commuting. Ask which constraint will matter on a normal week and which is harder to change. Could you visit A less often? Is there a quiet room at B, and can you actually book it?

A fictional next-step record might read: “We have not chosen yet. We will test a morning call at B and check the door-to-door commute to A. Those two observations could change the scores.” The matrix has produced a useful investigation rather than a forced winner.

Keep a short decision record

Choice made: [option, or no decision yet]
Must-haves checked: [evidence]
Most important tradeoff: [what I gain and give up]
Uncertain score: [which one and why]
What would change my choice: [new evidence or changed priority]
Review date: [when this decision needs another look]

A weighted table is optional. If only one tradeoff matters, a direct comparison may be clearer. Use the matrix when several preferences need to be discussed, especially when different people value them differently.