Laptop for University Decison Matrix.xlsx - Decision Matrix Example A Decision Matrix template is provided on the other worksheet Decision Model

Laptop for University Decison Matrix.xlsx - Decision Matrix...

This preview shows page 1 - 5 out of 5 pages.

Decision Matrix Example A Decision Matrix template is provided on the other worksheet ALTERNATIVES Decision Model Option A Option B Option C DeifnationCriterion Weight Rating Score Rating Score Rating Score Cost Criterion 1 2 4 8 2 4 4 8 School Criterion 2 4 2 8 3 12 2 8 Mortgage Criterion 3 4 2 4 5 4 3 3 Sq Ft Criterion 4 5 0 0 4 20 3 15 G/B Criterion 5 15 Year Criterion 6 Total 30 8 20 14 40 12 34 Score = Rating * Weight Option A Option B Option C 0 2 4 6 8 10 Rating Score Decision Matrix: Comparing Option Scores Rating Score Alternatives Scores Decision Model
Image of page 1
How to rate an option? Rating Description 0 No fit 1 Low fit 2 Fit 3 Good fit 4 Excellent fit
Image of page 2
Cost School Area Neighborhood Mortgage Year Size (Sq Ft) Maintenance Kitchen Livingroom Master Bedroom Bedrooms Closet Size Backyard No. of Rooms Bathroom Garage Flooring Appliances HOA
Image of page 3
Decision Matrix Template ALTERNATIVES How to Decision Model Dell
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 5 pages?

  • Spring '11
  • F
  • Harshad number, Bedroom, Decision Matrix Example, Decision MatrixITM 5200 Week 9

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture