MGT425-Spreadsheet Decision Modeling

Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University

المملكة العربية السعودية وزارة التعليم الجامعة السعودية الإلكترونية

College of Administrative and Financial Sciences

Assignment-2

MGT425-Spreadsheet Decision Modeling

Instructions – PLEASE READ THEM CAREFULLY

• The Assignment must be submitted on Blackboard (WORD format only) via allocated folder.
• Assignments submitted through email will not be accepted.
• Students are advised to make their work clear and well presented; marks may be reduced for poor presentation. This includes filling your information on the cover page.
• Students must mention question number clearly in their answer.
• Late submission will NOT be accepted.
• Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
• All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).
• Submissions without this cover page will NOT be accepted.

Course Learning Outcomes-Covered

Aligned (PLOs)	Course Learning Outcomes (CLOs)	Question
MGT.K.1 (1.1)	Find some structured ways of dealing with complex managerial decision problems.	Question- 2.
MGT.K.3 (1.2)	Explain simple decision models and management science ideas that provide powerful and (often surprising) qualitative insight about large spectrum of managerial problems.	Question- 1
MGT.S.1 (2.1)	Demonstrate the tools for deciding when and which decision models to use for specific problems.	Question-4
MGT.V.1 (3.1)	Build an understanding of the kind of problems that is tackled using Spreadsheet Modeling and decision analysis.	Question-3

Assignment Instructions:

• Log in to Saudi Digital Library (SDL) via University’s website
• On first page of SDL, choose “English Databases”
• From the list find and click on EBSCO database.
• In the Search Bar of EBSCO find the following article:

Title: A Rough Multi-Criteria Decision-Making Approach for Sustainable Supplier Selection under Vague Environment: A Case Study.

Author: Huiyun Lu , Shaojun Jiang , Wenyan Song, Xinguo Ming

Date: 26 July 2018

Assignment Questions: (Marks 15)

Read the above case study and answer the following Questions:

Question 1: Explain the decision-making approach discussed in this case study (250-300 words) (2.5-Marks).

Question 2: Why supplier selection is a typical multi-criteria decision-making process involving subjectivity and vagueness? (250-300 words) (2.5-Marks).

Question 3: Discuss the Sustainable supplier selection that is required for manufacturing companies. (250-300 words) (2.5-Marks).

Question 4: What is your opinion about this study and how it is connected to course and beneficial for you? (250-300 words) (2.5-Marks).

Answers:

1

2

3

4