Master Multi-Criteria Decision Matrix - Beginner Level Problems Multi-Criteria Decision Matrix BEGINNER

Excel in competitive exams with this skill builder ⚡ worksheet on Multi-Criteria Decision Matrix. Worksheet 3 of 10 contains 20 beginner-level problems. Target your step-by-step problem solving skills while practicing multi-criteria decision matrix practice, multi-criteria decision matrix for competitive exams, and how to solve multi-criteria decision matrix.

📝 Worksheet 3 of 10 • 20 questions • ⏱️ Estimated time: 20 minutes • 🎯 Beginner level

What you'll learn in this worksheet:
Your progress through Multi-Criteria Decision Matrix
Worksheet 3 of 10 (22% complete)

Question 1

Scenario: Selecting a software vendor for company operations Criteria weights: Reliability (40%), Features (35%), Cost (25%) Scores: Vendor A: 9/8/7, Vendor B: 7/9/8, Vendor C: 8/7/9 Based on weighted multi-criteria evaluation, which option should be selected?
Weighted scores: A=9×0.4+8×0.35+7×0.25=3.6+2.8+1.75=8.15; B=2.8+3.15+2.0=7.95; C=3.2+2.45+2.25=7.9. Vendor A scores highest.

Question 2

Scenario: Selecting a software vendor for company operations Criteria weights: Reliability (40%), Features (35%), Cost (25%) Scores: Vendor A: 9/8/7, Vendor B: 7/9/8, Vendor C: 8/7/9 Based on weighted multi-criteria evaluation, which option should be selected?
Weighted scores: A=9×0.4+8×0.35+7×0.25=3.6+2.8+1.75=8.15; B=2.8+3.15+2.0=7.95; C=3.2+2.45+2.25=7.9. Vendor A scores highest.

Question 3

Scenario: Choosing a location for new factory Criteria weights: Labor costs (25%), Logistics (25%), Tax incentives (20%), Skilled workforce (20%), Energy costs (10%) Scores: Location X: 8/7/9/6/8, Location Y: 6/8/7/9/7, Location Z: 7/9/6/8/9 Based on weighted multi-criteria evaluation, which option should be selected?
X=2.0+1.75+1.8+1.2+0.8=7.55; Y=1.5+2.0+1.4+1.8+0.7=7.4; Z=1.75+2.25+1.2+1.6+0.9=7.7. Location Z scores highest.

Question 4

Scenario: Selecting a software vendor for company operations Criteria weights: Reliability (40%), Features (35%), Cost (25%) Scores: Vendor A: 9/8/7, Vendor B: 7/9/8, Vendor C: 8/7/9 Based on weighted multi-criteria evaluation, which option should be selected?
Weighted scores: A=9×0.4+8×0.35+7×0.25=3.6+2.8+1.75=8.15; B=2.8+3.15+2.0=7.95; C=3.2+2.45+2.25=7.9. Vendor A scores highest.

Question 5

Scenario: Selecting a software vendor for company operations Criteria weights: Reliability (40%), Features (35%), Cost (25%) Scores: Vendor A: 9/8/7, Vendor B: 7/9/8, Vendor C: 8/7/9 Based on weighted multi-criteria evaluation, which option should be selected?
Weighted scores: A=9×0.4+8×0.35+7×0.25=3.6+2.8+1.75=8.15; B=2.8+3.15+2.0=7.95; C=3.2+2.45+2.25=7.9. Vendor A scores highest.

Question 6

Scenario: Selecting a software vendor for company operations Criteria weights: Reliability (40%), Features (35%), Cost (25%) Scores: Vendor A: 9/8/7, Vendor B: 7/9/8, Vendor C: 8/7/9 Based on weighted multi-criteria evaluation, which option should be selected?
Weighted scores: A=9×0.4+8×0.35+7×0.25=3.6+2.8+1.75=8.15; B=2.8+3.15+2.0=7.95; C=3.2+2.45+2.25=7.9. Vendor A scores highest.

Question 7

Scenario: Choosing a marketing strategy for product launch Criteria weights: Reach (30%), Engagement (30%), Cost (25%), Speed (15%) Scores: Digital: 9/8/7/9, Traditional: 6/7/8/5, Hybrid: 8/9/6/8 Based on weighted multi-criteria evaluation, which option should be selected?
Digital weighted=2.7+2.4+1.75+1.35=8.2; Traditional=1.8+2.1+2.0+0.75=6.65; Hybrid=2.4+2.7+1.5+1.2=7.8. Digital scores highest, but Hybrid balances all factors.

Question 8

Scenario: Selecting a software vendor for company operations Criteria weights: Reliability (40%), Features (35%), Cost (25%) Scores: Vendor A: 9/8/7, Vendor B: 7/9/8, Vendor C: 8/7/9 Based on weighted multi-criteria evaluation, which option should be selected?
Weighted scores: A=9×0.4+8×0.35+7×0.25=3.6+2.8+1.75=8.15; B=2.8+3.15+2.0=7.95; C=3.2+2.45+2.25=7.9. Vendor A scores highest.

Question 9

Scenario: Choosing a location for new factory Criteria weights: Labor costs (25%), Logistics (25%), Tax incentives (20%), Skilled workforce (20%), Energy costs (10%) Scores: Location X: 8/7/9/6/8, Location Y: 6/8/7/9/7, Location Z: 7/9/6/8/9 Based on weighted multi-criteria evaluation, which option should be selected?
X=2.0+1.75+1.8+1.2+0.8=7.55; Y=1.5+2.0+1.4+1.8+0.7=7.4; Z=1.75+2.25+1.2+1.6+0.9=7.7. Location Z scores highest.

Question 10

Scenario: Selecting a software vendor for company operations Criteria weights: Reliability (40%), Features (35%), Cost (25%) Scores: Vendor A: 9/8/7, Vendor B: 7/9/8, Vendor C: 8/7/9 Based on weighted multi-criteria evaluation, which option should be selected?
Weighted scores: A=9×0.4+8×0.35+7×0.25=3.6+2.8+1.75=8.15; B=2.8+3.15+2.0=7.95; C=3.2+2.45+2.25=7.9. Vendor A scores highest.

Question 11

Scenario: Choosing a marketing strategy for product launch Criteria weights: Reach (30%), Engagement (30%), Cost (25%), Speed (15%) Scores: Digital: 9/8/7/9, Traditional: 6/7/8/5, Hybrid: 8/9/6/8 Based on weighted multi-criteria evaluation, which option should be selected?
Digital weighted=2.7+2.4+1.75+1.35=8.2; Traditional=1.8+2.1+2.0+0.75=6.65; Hybrid=2.4+2.7+1.5+1.2=7.8. Digital scores highest, but Hybrid balances all factors.

Question 12

Scenario: Selecting a candidate for promotion Criteria weights: Technical skills (30%), Leadership (30%), Experience (25%), Cultural fit (15%) Scores: Candidate P: 9/7/8/8, Candidate Q: 7/9/7/7, Candidate R: 8/8/9/9 Based on weighted multi-criteria evaluation, which option should be selected?
P=2.7+2.1+2.0+1.2=8.0; Q=2.1+2.7+1.75+1.05=7.6; R=2.4+2.4+2.25+1.35=8.4. Candidate R scores highest across all criteria.

Question 13

Scenario: Choosing a marketing strategy for product launch Criteria weights: Reach (30%), Engagement (30%), Cost (25%), Speed (15%) Scores: Digital: 9/8/7/9, Traditional: 6/7/8/5, Hybrid: 8/9/6/8 Based on weighted multi-criteria evaluation, which option should be selected?
Digital weighted=2.7+2.4+1.75+1.35=8.2; Traditional=1.8+2.1+2.0+0.75=6.65; Hybrid=2.4+2.7+1.5+1.2=7.8. Digital scores highest, but Hybrid balances all factors.

Question 14

Scenario: Choosing a location for new factory Criteria weights: Labor costs (25%), Logistics (25%), Tax incentives (20%), Skilled workforce (20%), Energy costs (10%) Scores: Location X: 8/7/9/6/8, Location Y: 6/8/7/9/7, Location Z: 7/9/6/8/9 Based on weighted multi-criteria evaluation, which option should be selected?
X=2.0+1.75+1.8+1.2+0.8=7.55; Y=1.5+2.0+1.4+1.8+0.7=7.4; Z=1.75+2.25+1.2+1.6+0.9=7.7. Location Z scores highest.

Question 15

Scenario: Choosing a marketing strategy for product launch Criteria weights: Reach (30%), Engagement (30%), Cost (25%), Speed (15%) Scores: Digital: 9/8/7/9, Traditional: 6/7/8/5, Hybrid: 8/9/6/8 Based on weighted multi-criteria evaluation, which option should be selected?
Digital weighted=2.7+2.4+1.75+1.35=8.2; Traditional=1.8+2.1+2.0+0.75=6.65; Hybrid=2.4+2.7+1.5+1.2=7.8. Digital scores highest, but Hybrid balances all factors.

Question 16

Scenario: Selecting a candidate for promotion Criteria weights: Technical skills (30%), Leadership (30%), Experience (25%), Cultural fit (15%) Scores: Candidate P: 9/7/8/8, Candidate Q: 7/9/7/7, Candidate R: 8/8/9/9 Based on weighted multi-criteria evaluation, which option should be selected?
P=2.7+2.1+2.0+1.2=8.0; Q=2.1+2.7+1.75+1.05=7.6; R=2.4+2.4+2.25+1.35=8.4. Candidate R scores highest across all criteria.

Question 17

Scenario: Selecting employee benefits package Criteria weights: Employee satisfaction (35%), Cost to company (30%), Retention impact (25%), Administrative ease (10%) Scores: Health focus: 9/5/8/7, Retirement focus: 6/8/7/8, Work-life balance: 8/7/9/6 Based on weighted multi-criteria evaluation, which option should be selected?
Health=3.15+1.5+2.0+0.7=7.35; Retirement=2.1+2.4+1.75+0.8=7.05; Work-life=2.8+2.1+2.25+0.6=7.75. Work-life package optimizes across criteria.

Question 18

Scenario: Selecting a candidate for promotion Criteria weights: Technical skills (30%), Leadership (30%), Experience (25%), Cultural fit (15%) Scores: Candidate P: 9/7/8/8, Candidate Q: 7/9/7/7, Candidate R: 8/8/9/9 Based on weighted multi-criteria evaluation, which option should be selected?
P=2.7+2.1+2.0+1.2=8.0; Q=2.1+2.7+1.75+1.05=7.6; R=2.4+2.4+2.25+1.35=8.4. Candidate R scores highest across all criteria.

Question 19

Scenario: Selecting a candidate for promotion Criteria weights: Technical skills (30%), Leadership (30%), Experience (25%), Cultural fit (15%) Scores: Candidate P: 9/7/8/8, Candidate Q: 7/9/7/7, Candidate R: 8/8/9/9 Based on weighted multi-criteria evaluation, which option should be selected?
P=2.7+2.1+2.0+1.2=8.0; Q=2.1+2.7+1.75+1.05=7.6; R=2.4+2.4+2.25+1.35=8.4. Candidate R scores highest across all criteria.

Question 20

Scenario: Selecting employee benefits package Criteria weights: Employee satisfaction (35%), Cost to company (30%), Retention impact (25%), Administrative ease (10%) Scores: Health focus: 9/5/8/7, Retirement focus: 6/8/7/8, Work-life balance: 8/7/9/6 Based on weighted multi-criteria evaluation, which option should be selected?
Health=3.15+1.5+2.0+0.7=7.35; Retirement=2.1+2.4+1.75+0.8=7.05; Work-life=2.8+2.1+2.25+0.6=7.75. Work-life package optimizes across criteria.
Previous Worksheet Next Worksheet