Spread sheet decision making
Moh1
MGT425-Assignment-21.docxGeneral 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- 1 |
|
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- 2, 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: “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- 15)
Read the above case study and answer the following Questions :
1. Discuss the Analytic Hierarchy Process (AHP) that can assist decision-makers and continuous improvement managers. (250-300 words) 3 Marks
2. What is the importance of employee involvement in process of continuous improvement to be successful in manufacturing companies? (250-300 words) 3 Marks
3. Explain the purpose of this study and how it is helpful for automotive manufacturing Companies? (250-300 words) 3 Marks
4. Discuss four criteria that are the most important and needed to be considered when considering which material to use in the fabrication process. (250-300 words) 3 Marks
5. What is your opinion about this study and how it is related to the learning in course and beneficial for you? (250-300 words) 3 Marks
Answers:
1
2
3
4
5
