What is a weighted decision matrix?

A weighted decision matrix is a scoring tool where you assign percentage weights to your most important criteria, then score each option 1-5 per criterion. Multiply each score by its weight and sum the results. The option with the highest total best fits your stated priorities.

How many criteria should a decision matrix have?

Four to seven criteria is the practical range. Fewer than four and the matrix adds little over a simple pros and cons list. More than seven and criteria start overlapping, diluting scores and making results harder to interpret.

When should I use a decision matrix instead of a pros and cons list?

Use a decision matrix when you have three or more options, multiple stakeholders need to align, or the criteria are not equally important. A pros and cons list works fine for binary decisions with a single decision-maker and roughly equal-weight trade-offs.

Can a decision matrix give you the wrong answer?

Yes. The matrix is only as good as the weights and scores you put in. The most common failure is setting weights after you already know which option you want, which turns the exercise into rationalization rather than analysis. Always agree on weights before scoring.

What should I do if two options score nearly the same?

Run a sensitivity check by shifting your top two weights by 10 percentage points in either direction. If the same option keeps winning, choose it. If they keep swapping, the decision hinges on one criterion, which means you need to think harder about how much that criterion actually matters.

How to Use a Decision Matrix: Template and Examples

A decision matrix helps you score competing options against weighted criteria so you can make a defensible, bias-resistant choice in under an hour. You assign weights to what matters most, score each option 1 to 5 against those criteria, multiply and sum, then let the numbers surface the winner. This article gives you a copyable template and a worked example you can adapt today.

What a Decision Matrix Actually Does

When you have three or more options that all seem reasonable, gut instinct starts to fail. You keep cycling through the same pros and cons without resolution. A weighted decision matrix forces you to be explicit about what matters and how much before you look at the options. That sequencing is what prevents the choice from being driven by whoever argues loudest or whatever option gets presented last.

The matrix is a grid. Rows are your options. Columns are your criteria. Each cell gets a score, and each criterion gets a weight. The final scores tell you which option best satisfies your priorities given how you have weighted them.

When to Use One

A decision matrix is most useful when:

You have 3 to 7 options to evaluate
Multiple people need to align on the choice
The stakes are high enough that you need to document your reasoning
You are comparing options across more than two dimensions

It is less useful for genuinely novel decisions where you do not yet know what the criteria should be, or for decisions reversible enough that speed matters more than rigor.

If you are struggling to decide because you have not clarified your priorities yet, start with How to Set Strategic Priorities for Your Business before building a matrix. A matrix sharpens a decision; it cannot substitute for strategic clarity.

How to Build a Weighted Decision Matrix

Step 1: Define your options clearly

Write down each option as a specific, comparable action. "Expand into Europe" is a valid option. "Do something international" is not. You need enough specificity that you can score each one against the same criteria.

Step 2: Choose 4 to 7 criteria

Criteria are the dimensions that define what a good choice looks like for you right now. Common ones include:

Revenue potential
Time to first result
Resource requirement (cost, headcount, time)
Strategic fit
Risk or reversibility
Customer impact

Do not use more than seven. Beyond that, you start double-counting or adding criteria that feel important but do not actually differentiate the options.

Step 3: Assign weights

Distribute 100 percentage points across your criteria. The weights should reflect your current constraints and priorities. A team with six months of runway should weight "time to first revenue" much higher than a team that just closed a funding round.

The weights are where most of the strategic judgment lives. Changing a weight by 10 points can flip the winner. Be deliberate.

Step 4: Score each option per criterion

Use a 1 to 5 scale. Be consistent: 5 always means "best possible outcome on this criterion" and 1 means "worst." If the criterion is "resource requirement," a 5 means low resource requirement (favorable), not high.

Score each option independently. Try not to look at another option's score while you fill in the current row, because it biases the numbers.

Step 5: Calculate weighted scores

Multiply each raw score by the criterion weight, then sum across all criteria for each option.

Weighted score = Sum of (criterion weight x raw score) for each criterion

In a spreadsheet, use SUMPRODUCT. If weights are in column B (rows 2 to 6) and Option A scores are in column C, enter: =SUMPRODUCT(B2:B6, C2:C6)

Step 6: Pressure-test the result

If the winning option surprises you, that is useful information. Either the matrix has surfaced something your instincts were missing, or your weights are off. Run a sensitivity check: change your top two weights by 10 points in either direction and see if the winner changes. If the same option wins under several weight variations, it is a robust choice.

Template

Copy this structure into a spreadsheet or shared doc:

Criterion	Weight	Option A	Option B	Option C
[Criterion 1]	[%]	[1-5]	[1-5]	[1-5]
[Criterion 2]	[%]	[1-5]	[1-5]	[1-5]
[Criterion 3]	[%]	[1-5]	[1-5]	[1-5]
[Criterion 4]	[%]	[1-5]	[1-5]	[1-5]
[Criterion 5]	[%]	[1-5]	[1-5]	[1-5]
Weighted Total	100%

Fill in criteria and weights first. Lock them before anyone scores an option.

Worked Example: Choosing a Growth Strategy

The situation: A B2B SaaS company with $2M ARR and 8 employees needs to pick a growth strategy for the next 12 months. Three options are on the table:

Option A: Launch a second product line targeting a new buyer persona
Option B: Expand into the Canadian market with localized marketing and one sales hire
Option C: Invest in upsell and expansion revenue from the existing 140-customer base

The founders disagree. One wants the new product for its upside. The other wants to double down on current customers for speed and lower risk. They built a matrix to move past the argument.

Criteria and weights:

Given their constraints (tight headcount, no new funding planned, need to hit $3M ARR by month 12), the team weighted time-to-revenue and resource efficiency heavily.

Criterion	Weight	Rationale
Revenue potential (12-month)	30%	Primary goal is $3M ARR
Time to first revenue	25%	Need results within 6 months
Resource requirement	20%	No new hires budgeted except one
Strategic fit	15%	Must align with ICP and roadmap
Risk level	10%	Cannot absorb a failed bet right now

Scores and weighted totals:

Criterion	Weight	Option A: New Product	Option B: Canada	Option C: Upsell
Revenue potential	30%	5	4	3
Time to first revenue	25%	2	3	5
Resource requirement	20%	2	3	4
Strategic fit	15%	4	3	5
Risk level	10%	2	3	5
Weighted Total	100%	3.20	3.30	4.20

Scoring rationale:

Option A scores 5 on revenue potential because a successful second product could add $600K to $800K ARR. But it scores 2 on time to first revenue (estimated 9 to 12 months to first paying customers) and 2 on resource requirement (needs a product manager and roughly 3 months of engineering time).

Option B scores in the middle across the board. Canada is a natural adjacent market, but the company has no current Canadian customers, no legal entity there, and localization adds roughly $40K in upfront cost.

Option C scores high across all criteria. The existing 140 customers have an average contract of roughly $14K ARR, and internal analysis shows 40 accounts with upsell potential worth an estimated $350K to $500K in expansion ARR within 6 to 9 months. Resource requirement is low (one CSM hire, already budgeted) and it deepens relationships with the ICP they already understand.

The result: Option C wins with a weighted score of 4.20. The founders ran a sensitivity check by raising the weight on "revenue potential" to 45% and dropping "time to first revenue" to 10%. Even then, Option C scored 3.75 versus Option A's 3.80, essentially a tie. The matrix helped them agree that Option A only wins if you believe its 12-month revenue upside is dramatically higher than modeled.

They chose Option C, with a checkpoint at month 6 to revisit Option A.

The Most Common Mistake: Setting Weights After Scoring

The most common misuse of a decision matrix is deciding which option you want to win, then setting the weights to make it happen. This is especially common when one person has strong conviction and builds the matrix to validate their intuition rather than test it.

You can spot it when weights feel oddly specific (37%, 28%, 15%...) or when one criterion is weighted so heavily that it determines the outcome regardless of other scores.

The fix is to agree on weights before anyone scores the options. Run the weighting conversation as a separate exercise. Ask: "Given where we are as a business right now, how much should each of these criteria matter?" Lock the weights, then start scoring.

This is also why a decision matrix is more valuable as a team exercise than a solo one. When multiple people score independently and then compare, disagreements in raw scores reveal where assumptions differ. That conversation is often more valuable than the final number.

If you are using the matrix inside a broader planning process, feed the result into your one-page strategy plan as documented evidence for the choice you made and why.

When the Matrix Is Not Enough

A decision matrix compares known options on known criteria. It does not help you identify options you have not thought of, question whether the criteria themselves are right, or account for decisions that fundamentally reshape your competitive position.

For example, if you are evaluating whether to compete in a crowded market versus pursuing an uncontested space, you want to understand the distinction covered in Blue Ocean vs Red Ocean Strategy: Key Differences before you define your option set. The matrix executes the decision. Strategy frames the question.

Key Takeaways

A weighted decision matrix scores competing options against explicitly prioritized criteria, removing the advantage of whoever argues most forcefully in the room.
Always agree on weights before scoring options. Setting weights afterward turns analysis into rationalization.
Five criteria with thoughtful weights beats ten criteria that dilute each other and make the output harder to act on.
When the result surprises you, run a sensitivity check by shifting your top two weights by 10 points. A winner that holds across several weight variations is a robust choice.
Score disagreements within a team are the most valuable output of the exercise. They surface hidden assumptions faster than any meeting.
Document your weights and rationale, not just the winner. The reasoning degrades faster than you expect, and you will need it when you revisit the decision six months later.