spreadsheet decision modleing

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. What is the importance of material selection in manufacturing companies (150- 200 Words)

3. What is the Analytic Hierarchy Process (AHP) that can be used in decision making process in manufacturing companies (150-200 Words)

4. What are the important steps you suggest for the decision-maker in order to make a good decision (150-200 Words)

5. How this study is helpful for you in understanding the decision making process about material selection in manufacturing companies? (150-200 words)

Answers: