College of Administrative and Financial Sciences

/in /by
Kingdom of Saudi Arabia Ministry of Education Saudi Electronic Universityالمملكة العربية السعودية وزارة التعليم الجامعة السعودية الإلكترونية  

College of Administrative and Financial Sciences

Assignment-2

MGT425-Spreadsheet Decision Modeling

Due Date: 11/11/2023 (End of Week-11) @ 23:59

Course Name:Spreadsheet Decision ModelingStudent’s Name:
Course Code:MGT425Student’s ID Number:
Semester: FirstCRN:
Academic Year: 2023-2024 (1445 H)
 

For Instructor’s Use only

Instructor’s Name:
Students’ Grade: Marks Obtained/Out of 15Level of Marks: High/Middle/Low

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 usingTimes 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).