Management Question

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

Kingdom of Saudi Arabia
Ministry of Education
Saudi Electronic University

College of Administrative and Financial Sciences

Assignment-2
MGT425-Spreadsheet Decision Modeling
Due Date: 22/03/2025 @ 23:59 (End of Week 9)
Course Name: Spreadsheet Decision
Modeling
Course Code: MGT425

Student’s Name:

Semester: Second

CRN:

Student’s ID Number:

Academic Year: 2024-2025 (1446 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
•
•
•
•
•
•
•
•

Restricted – ‫مقيد‬

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
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

Aligned (PLOs)
MGT.K.1
(1.1)
MGT.K.3
(1.2)
MGT.S.1
(2.1)
MGT.V.1
(3.1)

Question-3

Question-4
Question-2

Assignment Instructions:
Assignment Questions: (Marks 10)
PART-A:
Business Analysis using Spreadsheets (Critical Thinking)
Question 1: In context of Business Analysis using Spreadsheets, Discuss the various
categories of Business Analysis that are required for detailed analysis by Business Analysts
(250-300 words) (2.5 Marks)..

PART-B: (Case Study)
• 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

Read the above case study and answer the following Questions:
2. Discuss the Analytic Hierarchy Process that can assist decision-makers and
continuous improvement managers. (250-300 words) 2.5 Marks.

Restricted – ‫مقيد‬

3. What is the importance of employee involvement in process of continuous
improvement to be successful in manufacturing companies? (250-300 words) 2.5
Marks

4. Discuss the 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

Answers:
1
2
3
4

Restricted – ‫مقيد‬

Purchase answer to see full
attachment