College of Administrative and Financial Sciences

Assignment-2

MGT425-Spreadsheet Decision Modeling

Deadline: End of Week 11 @ 23:59 (12/11/2022)

Course Name:

Spreadsheet Decision Modeling

Student’s Name:

Course Code: MGT425

Student’s ID Number:

Semester: 1

CRN: 14868

Academic Year: First Term- 2022-2023 (1444 H)

For Instructor’s Use only

Instructor’s Name: Dr. Salem Alanizan

Students’ Grade: Marks Obtained/Out of 15

Level 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 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, 3

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-5


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) (3-Marks).

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

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

Question 4: Why Supplier selection decisions are important for most of the manufacturing firms? (250-300 words) (3-Marks).

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

Answers:

1

2

3

4

5

image1.png