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.