DescriptionMinistry of Education Saudi Electronic University College of Science & Theoretical

Description

Ministry of Education
Saudi Electronic University
College of Science & Theoretical Studies
___________________________________________________________________
Quantitative Methods (STAT-201)
Assignment 3: Excel QM (Social-Responsible)
2nd Semester, 1444-1445 (2023-2024)
Due date: 06 May 2024 (Time: 11:00 PM)
Student’s Name
Student’s ID
Section/CRN
Location
Marking Scheme
Question
Score
Q-1
2
Q-2
2
Q-3
2
Q-4
2
Obtained Score
Note: You are required to fill your full name, ID, and CRN.
Message: Social responsibility is a framework of ethics in which an individual collaborates and
works with other organizations and individuals for the betterment of the community. There are
numerous ways in which an organization can exhibit social responsibility; for instance, by
promoting volunteerism, facilitating donations, employing ethical employment practices, and
implementing environmental improvements. It introduces the subjective obligation that entails
maintaining a delicate equilibrium between one’s ecosystem and the economy, as well as the
potential compromises that may be made between economic progress and societal and
environmental wellbeing. This transcends business organizations and affects all individuals
whose actions influence the environment.
Restricted – ‫مقيد‬
Ministry of Education
Saudi Electronic University
College of Science & Theoretical Studies
Solve the following questions using Excel QM.
(2×4 = 8 marks)
1. Helping others through blood donation is a form of social solidarity or social responsibility. The
blood donors cite a sense of social responsibility as their reason for donating blood, and as a result,
the communities value and reward this activity. The following table shows the number of blood
donors in a university from 2011–2023. Develop a 3-year moving average forecast and obtain the
related statistical measures using excel QM.
Solution:
Restricted – ‫مقيد‬
year
Blood Donors
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
116
105
146
159
108
194
227
219
234
224
248
253
265
311
Ministry of Education
Saudi Electronic University
College of Science & Theoretical Studies
2. University X has a unique on-campus dispensary that provides medical care. On a typical
working day, patients arrive at the dispensary at an average rate of 2 patients per hour. There
is one single nurse at the dispensary, and the average time required to give a consultation is 12
minutes.
It is assumed that the service times can be described by the exponential distribution, and the
arrival process by a Poisson distribution. You are requested to find:
a. The average time in line,
b. The average number of patients in line,
c. The average time in the system,
d. The average number of patients in the system,
e. The probability that the dispensary is empty,
f. The utilization factor of the system.
Solution:
Restricted – ‫مقيد‬
Ministry of Education
Saudi Electronic University
College of Science & Theoretical Studies
3. Assume that you are a statistical consultant and want to provide a volunteer consultation to a
start-up company as a social responsibility consultation. The company is planning to
purchase a uniform outfit for their employees, and they obtained the following quantity
discount table with three discount options:
DISCOUNT NUMBER
DISCOUNT QUANTITY
DISCOUNT COST (SAR)
1
0 to 49
100
2
50 to 99
90
3
100 and over
85
Annual demand is 400 outfits, ordering cost is 50, and holding cost is 25% of the cost of the
outfit. Use Excel QM to find the discount option with the minimum total cost.
Solution:
Restricted – ‫مقيد‬
Ministry of Education
Saudi Electronic University
College of Science & Theoretical Studies
4. To help needy people through charity is a form of social responsibility. The act of doing charity to help
others is recognized and rewarded by all communities of the society. The following table shows the
amount collected through charity and the amount spent on social development (in million dollars) in
the last 8 years. Find the correlation and coefficient of determination for the given data and obtain the
related statistical measures using excel QM.
Year
1
2
3
4
5
6
7
8
Solution:
Restricted – ‫مقيد‬
Amount collected(y)
18
14
12
15
10
8
9
6
Amount spent(x)
15
10
9
12
5
4
6
3

Purchase answer to see full
attachment

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

DescriptionCollege of Administration and Finance Sciences Assignment (1) Deadline: Saturday 12/10/2024 @ 23:59 Course Name: Cost

Description College of Administration and Finance Sciences Assignment (1) Deadline: Saturday 12/10/2024 @ 23:59 Course Name: Cost Accounting Student’s Name: Course Code: ACCT 301 Student’s ID Number: Semester: First CRN: Academic Year: 1446 H (2024-25) For Instructor’s Use only Instructor’s Name: Students’ Grade: /15 Level of Marks: High/Middle/Low Instructions –

Description‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫ر‬ ‫اإللكتونية‬ ‫الجامعة السعودية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫ر‬ ‫اإللكتونية‬ ‫الجامعة السعودية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Quality Management (MGT 424) Due Date: 05/10/2024 @ 23:59 Course Name: Quality Management Student’s Name: Course Code: MGT 424 Student’s ID Number:

Description‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Organization Design and Development (MGT 404) Due Date: 05/10/2024 @ 23:59 Course Name: Student’s Name: Course Code: MGT404 Student’s ID Number: Semester: First

Description‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫ر‬ ‫اإللكتونية‬ ‫الجامعة السعودية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫ر‬ ‫اإللكتونية‬ ‫الجامعة السعودية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Communications Management (MGT 421) Due Date: 5/10/2024 @ 23:59 Course Name: Communication Management Student’s Name: Course Code: MGT421 Student’s ID Number: Semester:

Description‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment – 1st Marketing Management (MGT 201) Due Date: 05/10/2024 @ 23:59 Course Name: Marketing Management Student’s Name: Course Code: MGT201 Student’s ID Number: Semester:

Description‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫ر‬ ‫اإللكتونية‬ ‫الجامعة السعودية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫ر‬ ‫اإللكتونية‬ ‫الجامعة السعودية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Organization Design and Development (MGT 404) Due Date: 05/10/2024 @ 23:59 Course Name: Student’s Name: Course Code: MGT404 Student’s ID Number: Semester:

Description‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Entrepreneurship and small business (MGT 402) Due Date: 05/10/2024 @ 23:59 Course Name: Entrepreneurship and small business Course Code: MGT402 Student’s Name: Semester:

Description‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Quality Management (MGT 424) Due Date: 05/10/2024 @ 23:59 Course Name: Quality Management Student’s Name: Course Code: MGT 424 Student’s ID Number: Semester:

DescriptionCollege of Administration and Finance Sciences Assignment (1) Deadline: Saturday 12/10/2024 @ 23:59 Course Name: Introduction to

Description College of Administration and Finance Sciences Assignment (1) Deadline: Saturday 12/10/2024 @ 23:59 Course Name: Introduction to AIS Student’s Name: Course Code: ACCT402 Student’s ID Number: Semester: First semester CRN: 50201 Academic Year: 1446 H For Instructor’s Use only Instructor’s Name: Habiba Moabber Students’ Grade: /15 Level of Marks:

Description‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University Department of Business Administration College of Administrative and Financial Sciences Assignment 1 MGT324 (1st Term 2024-2025) Public Management (MGT 324) Due Date: 5/10/2024 Course Name: Public Management Student’s Name: Course Code: