MGT425
|
Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University |
|
المملكة العربية السعودية وزارة التعليم الجامعة السعودية الإلكترونية
|
College of Administrative and Financial Sciences
Assignment 2
Spreadsheet Decision Modeling (MGT 425)
Due Date: 09/04/2022 @ 23:59 (End of Week 11)
|
Course Name: Spreadsheet Decision Modeling |
Student’s Name: |
|
Course Code: MGT 425 |
Student’s ID Number: |
|
Semester: 2 |
CRN: |
|
Academic Year: 2021-22-2nd |
|
|
|
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.
Learning Outcomes:
|
No. |
Course Learning Outcomes (CLOs) |
Question Number
|
|
CLO1 |
Find some structured ways of dealing with complex managerial decision problems. |
Question 2 |
|
CLO2 |
Explain simple decision models and management science ideas that provide powerful and (often surprising) qualitative insight about large spectrum of managerial problems. |
Question 1 |
|
CLO3 |
Demonstrate the tools for deciding when and which decision models to use for specific problems. |
Question 3, 4 |
|
CLO4 |
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: “An Analytic Hierarchy Process Approach in Decision-Making for Material Selection in an Automotive Company: A Case Study”
· Author: Cheng Jack Kie, Ahmed Khalif Hassan, Norhana Mohd Aripin, Rafiuddin Mohd Yunus.
· Date: August 18, 2019
Assignment Questions: (10-Marks)
Read the above article and answer the following Questions:
1. Describe the objective of this case study according to your understanding (150-200 Words) 2 Marks
2. What is the importance of material selection in manufacturing companies (150- 200 Words) 2 Marks
3. What is the Analytic Hierarchy Process (AHP) that can be used in decision making process in manufacturing companies (150-200 Words) 2 Marks
4. What are the important steps you suggest for the decision-maker in order to make a good decision (150-200 Words) 2 Marks
5. How this study is helpful for you in understanding the decision making process about material selection in manufacturing companies? (150-200 words) 2 Marks
Answers: