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 DefectsProblemNumber of OccurrencesDirt in paint65Off-color17Orange peel12Other1Sad looking43Scratch11Sealer under8Thin paint31
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.
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.