spreadsheet decision 425

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

Kingdom of Saudi Arabia
Ministry of Education
Saudi Electronic University

College of Administrative and Financial Sciences

Assignment-3
MGT425-Spreadsheet Decision Modeling
Due Date: 30/11/2024 (End of Week-13) @ 23:59
Course Name: Spreadsheet Decision
Modeling
Course Code: MGT425

Student’s Name:

Semester: First

CRN:

Student’s ID Number:

Academic Year: 2024-2025 (1446 H) – 1st Term

For Instructor’s Use only
Instructor’s Name:
Students’ Grade: Marks Obtained/Out of 10 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, doublespaced) 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)
MGT.K.1
(1.1)
MGT.K.3
(1.2)
MGT.S.1
(2.1)
MGT.V.1
(3.1)

Course Learning Outcomes (CLOs)

Question

Find some structured ways of dealing with complex managerial
decision problems.
Explain simple decision models and management science ideas
that provide powerful and (often surprising) qualitative insight
about large spectrum of managerial problems.
Demonstrate the tools for deciding when and which decision
models to use for specific problems.
Build an understanding of the kind of problems that is tackled
using Spreadsheet Modeling and decision analysis.

Question- 2.
Question- 1, 5

Question-4
Question-3

Assignment Instructions:
Assignment Questions: (Marks 10)
PART-A:
Decision Analysis (Critical Thinking)
Question 1: “A decision tree is a specialized model for recognizing the role of uncertainties
in a decision-making situation” In context of this statement explain the Principles for
Building and Analysing the Decision Trees (250-300 Words) (3-Marks)

PART-B:
• 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

Read the above case study and answer the following Questions:
Question 2: Explain the decision-making approach discussed in this case study (250-300
words) (2-Marks).
Question 3: Why supplier selection is a typical multi-criteria decision-making process
involving subjectivity and vagueness? (250-300 words) (2-Marks).
Question 4: Discuss the Sustainable supplier selection that is required for manufacturing
companies. (250-300 words) (2-Marks).
Question 5: Write minimum four references in APA style in support of your answers (1Mark).

Answers:
1
2
3
4
5

Restricted – ‫مقيد‬

Purchase answer to see full
attachment