You have a decision to make. Multiple options, multiple factors, and no clear winner. So you do what any reasonable person does: you open a spreadsheet and build a decision matrix.
Good instinct. A decision matrix is one of the most practical tools for structured decision-making. But most templates you will find online have a critical flaw that can lead you to the wrong answer.
This guide covers everything: what a decision matrix is, how to build one, a ready-to-use template, and -- importantly -- where basic matrices break down and what to use instead.
What Is a Decision Matrix?
A decision matrix (also called a Pugh matrix, weighted scoring model, or criteria matrix) is a table that helps you evaluate multiple options against multiple criteria. Instead of holding all the factors in your head and hoping your brain sorts them correctly, you externalize the analysis into a structured format.
At its core, a decision matrix has:
- Rows for each option you are considering
- Columns for each criterion that matters to you
- Scores in each cell rating how well an option meets a criterion
- Weights indicating how important each criterion is
- A total score for each option, calculated by multiplying scores by weights and summing
The option with the highest total score is your recommended choice.
Step-by-Step: Building a Basic Decision Matrix
Let us walk through a concrete example. Say you are choosing a project management tool for your team. Your options are Asana, Monday.com, and Notion. Your criteria are ease of use, features, pricing, and integrations.
Step 1: List Your Options and Criteria
Write your options as rows and criteria as columns.
Step 2: Assign Weights to Criteria
Rate each criterion's importance on a scale (typically 1-5 or 1-10). Be honest about what actually matters versus what sounds like it should matter.
Step 3: Score Each Option
Rate how well each option performs on each criterion, using the same scale.
Step 4: Calculate Weighted Scores
Multiply each score by its criterion weight.
Step 5: Sum the Totals
Add up the weighted scores for each option.
Here is the completed matrix:
DECISION: Best Project Management Tool for Our Team
Ease of Use Features Pricing Integrations TOTAL
Weight: 4 3 5 2
-----------------------------------------------------------------------
Asana 4(16) 4(12) 3(15) 5(10) 53
Monday.com 3(12) 5(15) 2(10) 4(8) 45
Notion 5(20) 3(9) 4(20) 3(6) 55
-----------------------------------------------------------------------
Format: raw score (weighted score)
Winner: Notion (55 points)
Notion wins because it scores highest on the two most heavily weighted criteria: pricing and ease of use. Even though Monday.com has the best features, that criterion carries less weight.
A Blank Template You Can Copy
DECISION: [Your decision]
[Criterion 1] [Criterion 2] [Criterion 3] [Criterion 4] TOTAL
Weight: ? ? ? ?
--------------------------------------------------------------------------
[Option A] ?(?) ?(?) ?(?) ?(?) ?
[Option B] ?(?) ?(?) ?(?) ?(?) ?
[Option C] ?(?) ?(?) ?(?) ?(?) ?
--------------------------------------------------------------------------
Scale: 1 (worst) to 5 (best)
Weight scale: 1 (least important) to 5 (most important)
Weighted score = raw score x weight
How to use it:
- Replace the bracketed text with your specific decision, options, and criteria
- Assign a weight (1-5) to each criterion based on importance
- Score each option (1-5) on each criterion
- Multiply score by weight for the weighted score (shown in parentheses)
- Sum each row for the total
This works. It is better than a pros and cons list. It is better than gut feeling. For simple decisions with 2-3 options and clear criteria, a basic decision matrix is often sufficient.
But there is a problem.
Where Basic Decision Matrices Break Down
If you have used decision matrices before, you may have noticed something uncomfortable: the results are highly sensitive to how you assign weights and scores. Change a single weight by one point and the winner can flip entirely.
This is not a minor issue. It points to three fundamental flaws in the basic weighted scoring approach:
Flaw 1: Arbitrary Weight Assignment
When you assign a weight of 4 to ease of use and 3 to features, what does that actually mean? Is ease of use 33% more important than features? Is it twice as important when the decision is close? The basic matrix does not define this relationship precisely.
Different people will assign different numbers to the same relative preference. One person's "4 out of 5" for importance is another person's "3 out of 5." There is no calibration.
Flaw 2: Unanchored Scoring
Rating Notion a 5 for ease of use and Asana a 4 tells you Notion is better. But how much better? Is it slightly better or dramatically better? A one-point difference on a 5-point scale could mean anything.
Even worse, there is no guarantee your scores are consistent. You might rate Option A a 4 and Option B a 3 on one criterion, but if asked to compare them directly, you might say they are nearly identical. The matrix does not catch this.
Flaw 3: No Consistency Checking
A basic decision matrix accepts whatever numbers you put in. If your weights are internally contradictory (you say pricing matters most but then give high scores to the most expensive option because of its features), the matrix will not flag this. It just calculates the wrong answer with confidence.
Flaw 4: Scale Sensitivity
The result depends heavily on the scale you choose. A 1-5 scale compresses differences. A 1-10 scale amplifies them. A 1-100 scale introduces false precision. There is no mathematically optimal scale for the basic approach because the basic approach is not mathematically grounded.
The Fix: How AHP Improves the Decision Matrix
The Analytic Hierarchy Process, developed by mathematician Thomas Saaty in the 1970s, solves all four of these problems. It is essentially a decision matrix that has been rebuilt on a mathematical foundation.
Here is how AHP differs from a basic weighted matrix:
Pairwise Comparisons Instead of Arbitrary Weights
Instead of assigning a weight of 1-5 to each criterion independently, AHP asks you to compare every pair of criteria. "Is ease of use more important than pricing? How much more?" This produces weights that are mathematically derived from your actual preferences, not guessed at.
This might seem like more work, but it is actually easier cognitively. Comparing two things directly ("Do I care more about salary or location?") is a natural human judgment. Assigning abstract numerical weights to seven criteria simultaneously is not.
Relative Scoring Instead of Absolute Scoring
Similarly, instead of rating each option on an absolute scale, AHP compares options in pairs for each criterion. "Is Notion easier to use than Asana? How much easier?" This eliminates the problem of unanchored scales because every judgment is relative.
Built-in Consistency Ratio
AHP calculates a consistency ratio for your comparisons. If you say A is better than B, B is better than C, but C is better than A, the algorithm catches this logical contradiction and asks you to reconsider. This is like having a fact-checker review your reasoning before you commit to a decision.
Mathematically Grounded Scale
The Saaty scale (1-9) is not arbitrary. It was specifically designed and validated through research to map to human perception of relative importance. A score of 3 means "moderately more important." A score of 9 means "extremely more important." The scale is bounded and anchored with clear definitions at each point.
AHP vs. Basic Decision Matrix: A Comparison
Feature Basic Matrix AHP Matrix ----------------------------------------------------------- Weight assignment Arbitrary (1-5) Derived from pairwise comparisons Scoring method Absolute scale Relative pairwise comparisons Consistency check None Built-in consistency ratio Mathematical basis Simple arithmetic Linear algebra (eigenvectors) Result reliability Depends on user Mathematically validated Cognitive difficulty High (abstract) Low (natural comparisons)
When to Use Which
Use a basic decision matrix when:
- You have a simple decision with 2-3 options and 2-3 criteria
- The criteria are clearly prioritized and you have high confidence in your weights
- Speed matters more than precision
- The stakes are low
Use AHP when:
- You have 3 or more options with 3 or more criteria
- Criteria are difficult to weight (they all feel important)
- Multiple stakeholders need to agree on a decision
- The stakes are high (career moves, major purchases, business strategy)
- You want a defensible, documented rationale for your choice
How to Run an AHP Analysis in Minutes
The challenge with AHP has historically been the math. Calculating eigenvectors and consistency ratios by hand is tedious. Spreadsheet implementations exist but are fragile and hard to modify.
Decisio is an iOS app that automates the entire AHP process. You define your decision, add criteria and options, and answer simple comparison questions: "Which matters more, and by how much?" The app handles the linear algebra, checks your consistency, and presents a clear result with percentage scores.
It also uses AI to help you think through your criteria. Describe your decision and the app can suggest factors you might not have considered.
The free tier gives you three complete decisions -- enough to test it on a real choice you are facing right now.
Try Decisio Free
Run an AHP analysis in 2 minutes instead of 2 hours. No spreadsheet required.
Download on the App StoreDecisio uses the Analytic Hierarchy Process (AHP) to help you make better decisions. Available on iOS.