Assignment-2
MGT425-Spreadsheet Decision Modeling
Deadline: 30/03/2024 @ 23:59
Course Name: Spreadsheet Decision
Modeling
Course Code: MGT425
StudentÂ’s Name:
Semester: Second
CRN:
StudentÂ’s ID Number:
Academic Year: 2023-2024 (1445 H)
For InstructorÂ’s Use only
InstructorÂ’s Name:
StudentsÂ’ Grade: Marks Obtained / Out of 10 Level of Marks: High/Middle/Low
General 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)
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-1
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: “An Analytic Hierarchy Process Approach in Decision-Making for Material
Selection in an Automotive Company: A Case Study”
Author: Cheng Jack Kie, Ahmed Khalif, Norhana Mohd Aripin, Rafiuddin Mohd Yunus.
Date: August 18, 2019
Assignment Questions: (Marks- 10)
Read the above case study and answer the following Questions:
1. Discuss the Analytic Hierarchy Process that can assist decision-makers and
continuous improvement managers. (250-300 words) 2.5 Marks.
2. What is the importance of employee involvement in process of continuous
improvement to be successful in manufacturing companies? (250-300 words) 2.5
Marks
3. Discuss four criteria that are the most important and needed to be considered
when selecting the material to use in the fabrication process. (250-300 words) 2.5
Marks
4. What is your opinion about this study, how it is related to the course and
beneficial for you? (250-300 words) 2.5 Marks
Question-3
Question-4
Question-2
Answers:
1
2
3
4
