Quantitative Math for Hlth Srv (MAT543002VA016-1226-001)
Getting Started
Course Info
My Professor
Announcements
XanEdu
Gradebook
zyBooks
Strayer Writing Standards
Your Course
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Help/Resources
Media Gallery
Course Tool Help
Email
ASSIGNMENT INFORMATION
Due Date
Monday, August 22, 2022
9:00 AM
Points Possible
30
Activity: Pareto Analysis and Business Process Flow Charting Practice
This activity consists of two problems.
Problem One
Gary Seitz is director of procurement for the Forest Medical Center in Oak Park, Illinois. His medical center recently purchased more than 300 new side tables for the patient rooms from Quick-and-Cheap Furniture. His team, however, is not happy with the paint quality of these tables. They feel the firm providing the tables was rushed to get the order out and did not do a great job.
They have examined each of the 312 tables that they have received so far and found the following defects, listed in alphabetical order:
Table Defects
Problem Number of Occurrences
Dirt in paint 65
Off-color 17
Orange peel 12
Other 1
Sad looking 43
Scratch 11
Sealer under 8
Thin paint 31
Instructions
Use Excel to:
Create a Pareto Chart for this situation.
Create and complete a table for this situation using the following headers:
Problem.
Frequency.
Cumulate Frequency.
Percentage.
Cumulate Percentage.
List the most frequently occurring problem first in the table, then the next more frequently occurring problem second in the table, and so forth.
In a Word document:
Draw two conclusions about the quality of the patient tables that Quick Furniture has shipped to the Forest Medical Center.
Submit both your Word and Excel files.
Problem Two
Ted Short, manager of procurement at the Lake Luna Medical Center (LLMC), is starting a process to examine at the general process that is followed at his center for procurement of medical supplies at his facility. His first step is to develop a flowchart for the current process that employees at his center follow. He has asked you to draw that flowchart for him and make any obvious changes to shorten the process.