Weighted Decision Matrix –Selection of Supplier


Donna H. Rhodes, Principal Research Scientist, MIT

Weighted Decision Matrix-Selection of Supplier

Step-by-Step Process for Creating a Weighted Matrix:

  1. List all your options as the row labels on the table and list the factors (eg quality, location, reliability, and credit options)  that you need to consider as the column headings.
  2. Next, work out the relative importance of the factors in your decision.Show these as numbers from, for example, 0 to 5, where 0 means that the factor is unimportant in the final decision, and 5 means that it is very important.
  3. Next, work your way down the columns of your table, scoring each option for each of the factors in your decision. Score each option from 0 (poor) to 5 (very good).
  4. Now multiply each of your scores from Step 2 by the values for relative importance of the factor that you calculated in Step 3. This will give you weighted scores for each option/factor combination.
  5. Finally, add up these weighted scores for each of your options. The option that scores the highest wins!

Assuming quality is most important, and if you do the weighted analysis now, Supplier C will win.

Another Example :

Weighted Decision Matrix-Selection of Supplier-Example_17Jul2017

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s