Prism Decision Systems

  • Email
  • RSS
  • HOME
  • SCHOOLUTIONS
    • Vision, mission and core beliefs
    • Targets, priorities and strategies
    • School improvement planning
  • TOOLS
    • Dynamic Group Process
    • Group Decision Support Systemâ„¢
    • Shared Decision-Making
  • DECISION SUPPORT
    • Strategic Planning
    • Decision Support
  • THE EIGHT KEYS
    • Buy Now
    • Reader Praise for the Eight Keys
  • BLOG
  • TESTIMONIALS
  • ABOUT
    • Client List
    • Papers
    • Readings
You are here: Home / Decision-making / How to: Multi-criteria Analysis – Part 3

05/19/2011 by Sean Brady

How to: Multi-criteria Analysis – Part 3

A multi-criteria analysis is a formal decision process you might use when making a weighty decision. This is the final of a three-part post that walks you through the process, step-by-step.

Part 1:

Like this post? You'll love the book. Make better decisions now! Read about the Eight Keys today!
Like this post? You’ll love the book. Make better decisions now! Read about the Eight Keys today!
  • Step 1: Complete your research
  • Step 2: Generate and weight criteria (i.e., define your desired outcome)

Part 2:

  • Step 3: Identify and/or create options, alternatives or solutions
  • Step 4: Complete a side-by-side comparison

Part 3:

  • Step 5: Objectively assess each option against each weighted criterion
  • Step 6: Make your decision

Step 5: Assess each option against each weighted criterion
Having completed your research, articulated a set of weighted criteria, converged on a rich set of options, and completed your side-by-side comparison, you now need to objectively assess each option against each weighted criterion. Let’s continue with the example of the Elmsford facilities task force.

First, task force members reviewed their completed side-by-side comparison and used a 1 to 9 scale to score the three facilities options against the 11 criteria on a worksheet. Then, in subgroups, they shared their worksheets and began to converge on reasonable, evidence-based scoring for each cell. Finally, the whole group used Prism’s Group Decision Support Systemâ„¢ to vote all the cells in the decision matrix. After all 33 cells were complete, the system automatically calculated the weighted scores in each cell and the total benefit (i.e., the sum of the weighted scores) for each option. See chart below.

Elmsford Decision Matrix

Returning to the example of college selection: if you do not have access to sophisticated decision support technology, you can complete your decision matrix using a chart and calculator or a spreadsheet. For your convenience, you can download a working spreadsheet.

Simply follow the directions on the spreadsheet to enter your

  • Decision criteria across the top row of the matrix (completed in Step 2)
  • Criteria weights (completed in Step 2)
  • Options down the first column (completed in Step 3)

While referring closely to your side-by-side comparison, score each option against each criterion in the appropriate cell. You can use a 1-9 scale or you can limit your scale to the total number of options (e.g., if you had four options, the scale would be 1-4). By the way, the download does all the matrix calculations automatically. See sample completed matrix below.

Decision matrix completed

Step 6: Make your decision
With your decision matrix complete, you should now be prepared to make a confident, sound decision. You can

  • Compare the total benefit of each option against the set of weighted criteria
  • Examine the specific trade-offs
  • Create scenarios by changing the decision criteria weights

Regarding trade-offs: a trade-off is the giving up of one thing in return for another. Just about every complex decision requires that you accept having less of one thing in order to get more of something else. The beauty of a decision matrix is that you can easily manage the tradeoff analysis because you can see where the trade-offs are.

In the college selection example, a family might decide to select Syracuse because it has the highest Total Benefit score and scores highest on three criteria: Distance, Clubs and Food. However, the trade-offs are also clear. Delaware is superior on two criteria: Social Life and Facilities. Temple, on one: Major. The decision framework creates clarity: by selecting Syracuse, the family achieves the greatest Total Benefit but gives up on superior Facilities, Social Life and Major. (See annotated chart below, highlighting the trades.)

Decision matrix completed tradeoffs

Of course, the matrix above begs a powerful question: Is Syracuse University, a private institution, worth the more than 40% premium it charges in tuition, room and board and fees over public institutions such as Temple and Delaware? Put in quantitative terms, is it worth spending a 40% premium to attend Syracuse instead of Delaware if Syracuse only provides an 18% additional Total Benefit (236 points versus 200 points)?

Returning to our other example, the Elmsford facilities task force could not make a decision based solely on their multiple criteria matrix. They needed to take one more step and complete a cost-benefit analysis. A family looking to maximize its return on their college investment may want to do the same.

See this post for a detailed discussion of how to complete a cost-benefit analysis.

Share this post:

  • Twitter
  • Facebook
  • LinkedIn
  • Reddit
  • Pocket
  • Pinterest
  • Print

Related

Filed Under: Decision-making Tagged With: decision criteria, decision-making, group decision system, matrix, multiple criteria, tradeoff

Like What You’re Reading? Subscribe Today!

Contact

[email protected]
607.727.1088

Buy Now!

You Are What You Decide is now available in paperback and for all e-Readers.

BLOG: SUBSCRIBE TODAY!

Blog: recent posts

Resilience in three steps: endure, adapt & thrive

How to run successful virtual decision-making meetings

The power of Amazon’s press release and FAQ protocol

Leadership during a pandemic: Joseph McShane, S.J.

Prism deploys virtual decision-making service

Blog: all posts

Recent tweets

BLOG: SUBSCRIBE TODAY!

Some home page icons courtesy,
The Noun Project

Contact

Sean Brady
President
Prism Decision Systems, LLC
[email protected]
607.727.1088
Skype: PrismDecision
Twitter: @prismdecision

 

Search this website

Connect

  • Email
  • RSS

Copyright © 2021 · Prism Decision Systems, LLC · [email protected]