1.prepare a check sheet 2. Perform Preto analysis 3. requirement of ISO certificate? why ? why not?

data collected

Pemn Lighting Inc, located in Mississauga, is a manufacturer of lighting products including table and desktop lamps, track lighting, and decorative wall lighting. There has been an alarming increase with rejected products found during the manufacturing operation. The Quality Manager has collected the data below to conduct a Pareto Analysis. Assignment: 10 marks 1) Make a check sheet (must be computer generated) - 2 mark 2) Perform a Pareto Analysis on ALL six sets of data collected including the Pareto chart and graph using Microsoft Excel (import/embed excel worksheet to show all Excel formulas used). Round each answer up - no decimals and free of spelling and grammatical errors - 1 mark. Analysis - 2 marks, Graph - 2 mark & import/embed of excel worksheet - 2 marks 3) From the information you have discovered, would you recommend Pemn Lighting Inc. should consider ISO Certification in order to make improvements on customer complaints. Why or why not? ONE paragraph, maximum 50 words. (1 marks) w...IL Alan - choose Microsoft Excel Worksheet Object (the first option) and click OK. Done You can double click on any cell and it should open up as a Microsoft EXCEL document and your formulas are visible. Lighting Division - Monthly Reject Records - October 2020 Label Twisted Missing Cracked Wire wrong Pieces Plug Length Part Date Error X Wire X 1 X 2 X X X X X 3 4 X 5 X 6 X X X 7 8 X 9 X X X 10 11 X 12 X X X 13 14 15 16 17 X 18 19 20 X X 21 22 X X 23 24 X X 25 26 27 28 29 X X 30 31 X