# Business decision matrix template

Compare alternatives using explicit criteria, weighted scores, uncertainty and a sensitivity check. Download a decision matrix you can edit.

A decision matrix makes your priorities visible. It does not turn subjective judgments into objective facts. Use one when several options meet a basic requirement but involve different tradeoffs. Eliminate options that fail a non-negotiable constraint before assigning scores.

Choose a small set of criteria that do not count the same benefit twice. Define the scale before rating the alternatives. Add an evidence or uncertainty note to every score and test whether a modest change in your assumptions changes the ranking. The exercise is useful even when it shows that you need more information.

## How to use it

### 1. Separate constraints from preferences

List requirements an option must meet, such as a budget ceiling or required export format. A weighted total should not let an attractive but ineligible option overcome a mandatory requirement. Mark eligibility before comparing preferences.

### 2. Define criteria and weights

Write four or five distinct criteria and distribute 100 weight points. Have the decision owner explain the weights. Cost and affordability may measure the same thing; remove overlap so one preference does not receive extra influence.

### 3. Anchor the scoring scale

Use a scale such as 1 to 5 and define what the endpoints mean for each criterion. Record a source, test result or explicit judgment beside each rating. Leave an unknown unscored rather than silently assigning it the middle value.

### 4. Calculate a weighted result

For each scored criterion, multiply its weight by its score divided by the maximum score. Sum the contributions only when the same criteria have evidence for all eligible options. Preserve both the original ratings and the calculation.

### 5. Test the recommendation

Change the most uncertain score or an important weight and recompute. If the leading option changes easily, call the ranking fragile. Identify the single missing observation most likely to improve the decision, then make that your next step.

## Copyable prompt

```text
Build a business decision matrix.
Decision: [choice].
Alternatives: [options].
Mandatory constraints: [pass/fail requirements].
Criteria and weights totaling 100: [list].
Scale anchors: [what 1 and 5 mean for each criterion].
Evidence: [source-backed ratings or observations].
Separate constraints from preferences. Do not invent ratings for missing evidence. Show weight × score / 5 for each contribution. Flag double-counted criteria. Run a sensitivity check using the most uncertain input and explain whether the recommendation changes. End with the next evidence-gathering step; I make the final decision.
```

## Worked calculation: choosing an internal documentation tool

Fictional options and subjective example ratings. Scores show arithmetic, not tested product quality.

| Criterion / weight | Option A contribution | Option B contribution |
| --- | --- | --- |
| Editing fit / 40 | 40 × 4 / 5 = 32 | 40 × 3 / 5 = 24 |
| Export fit / 35 | 35 × 3 / 5 = 21 | 35 × 4 / 5 = 28 |
| Setup effort / 25 | 25 × 3 / 5 = 15 | 25 × 4 / 5 = 20 |
| Total / 100 | 68 out of 100 | 72 out of 100 |

If Option A's editing rating changes from 4 to 5, its total becomes 76. That reversal means the editing assumption deserves a real test before treating Option B's original lead as a decision.

## Review checklist

- [ ] All options pass mandatory constraints

- [ ] Criteria are distinct and weights total 100

- [ ] Scale anchors are defined

- [ ] Ratings include evidence or uncertainty notes

- [ ] The recommendation survives a sensitivity check

Source: https://growit.lol/templates/business-decision-matrix
Updated: 2026-10-01
Growit / o1