ClickSnap Containers manufacture food-grade plastic containers. Its R&D Department has recently been working on a new formulation, which will produce plastic that is much more tolerant of changes in temperature. Marketing believes that this new plastic will let ClickSnap obtain much higher market share in the food container industry.

At an executive meeting, the Director of R&D argued for further testing and fine-tuning on the new material before it was put into production. Marketing argued that it was very important to be first-to-market in order to gain a competitive advantage in the market. The CEO asked if the product was safe and the R&D Director said that there was no doubt about the materials safety. ClickSnap has two identical production lines Line A and Line B. The CEO made the decision to start production using the new material on line B.

One month later, the Operations Manager was looking at defect reports from the two lines. This data is shown in the excel file. Use this data to create the requested quality management tools and answer the following questions.

Use MS Excelcolumn chartsto create two Pareto Charts to analyse the defects, one for the Standard material (Line A) and one for the New material (Line B). In each chart, the columns should be ordered from largest to smallest. The x-axis should show the type of defect and the y-axis should show the total number of defects over the 4 weeks. The y axes should be adjusted so that they show the same maximum number of defects on both charts. (This makes it easier to visually compare the two charts.)