1 1 1 2 1 2 1 3 1 1 2 1 1 1 2 Components to assemble the lighting are received in large quantities from Canadian, American and offshore suppliers. After inspection and storage, quantities for one day's production are sent directly to the different workstations of each department, every night for the next day's production. Goods that do not pass receiving inspection are held, and sent back to suppliers as soon as possible. 2 1 1 1 2 1 1 1 1 1 1 2 1 2 1 4 3 2 2 4 1 2 Danco Lighting Inc is a GTA based manufacturer of lighting products including table and desktop lamps, track lighting, and decorative wall lighting. The company employs 80 employees, and exports 40% of its product to the USA. Approximately 50% of the employees are full-time, and the remainder are part-time and temporary. These workers are called upon to work when demand is high, and for vacation relief and to fill in for sick days. Some of their product is sold through the smaller retail lighting locations as well as to home builders for the new home market. 2 1 1 Your Actions 2 1 1 2 3 1 1 1 Your discussions with supervisors in the facility did not yield any definite clues as to the reasons for all the defects. There seemed to be many different types of rejects piled in various locations throughout the facility. 1 1 2 2 2 1 2 1 2 1 1 2 2 2 Jen Davis, is the new VP of Operations and she has been very concerned about the increasing problem with rejected products found during the manufacturing operation. 3 2 4 1 3 1 2 1 1 1 Your next stop was at the Quality Control Department, where you obtained the records for the Assembly Department rejects, for the last month. 1 2 1 2 1 1 2 1 1 2 1 2 1 2 1 2 1 2 1 2 2 1 Several new designs were introduced in January, and since that time rejects have been high "Rejects have been a large source of waste since we resumed production in January", said Davis in the weekly management meeting. She feels strongly that data must be collected and analyzed in order to begin fixing the problems. 2 1 1 1 2 1 Assignment: Submit one EXCEL document with the filename your firstname.lastnameAss2. Ensure that you use EXCEL formulas for any calculations. Round all numbers to whole numbers. 2 3 1 2 2 1 1 2 1 1 1 1 1 1 3 1 2 1 1 1 2 As a new graduate of Colombia College, you have been brought in to help review and analyze the quality data for Quality Lighting. Although you will not make technical recommendations, you should be able to help them figure out what the problems are and to point them in the right direction. 1 1 2 2 2 3 3 4 4 5 5 8 8 9 9 10 10 11 11 12 12 15 15 16 16 17 17 18 18 19 19 22 22 23 23 24 24 25 25 26 26 29 29 30 30 31 31 1. Perform a Pareto Analysis for the monthly Reject Log of the Assembly Process based on the total number of rejects from each category. Include a text box that explains the course of action that should be taken by Jen Davis. Ensure that you provide the Pareto Table and Chart. 4 ) (4 marks) 1 1 1 1 1 1 3 1 Process Overview: : 2 1 2 1 2 3 2 1 2 1 2 1 1 2 3 1 2. Draw a Run Chart (Line Chart) for each of the top 2 defects indicated on your Pareto Chart, 2 using the monthly reject data. These charts should plot each day's rejects by department. In summary, one chart for the highest defect, and one chart for the second highest defect. Plot each department's daily rejects. (2 charts required) (2 lines on each chart) Include a text box with comments on the run charts. (4 marks) 1 1 1 A tour of the assembly operation indicated that there are two departments, with different equipment and employees. These two departments assemble large production runs of the various lighting products. The production planner, Amir Patel (also a Seneca grad) translates the customer orders into production requirements, then sends each order to one of the departments for assembly. Currently each department is capable of producing all of the lighting products 3 3 1 2 1 2 1 1 4 3 1 1 1 2 1 2 2 1 3. Draw a Fish-Bone (Cause and Effect) diagram, which indicates some possible reasons for the defects listed in the case. Aim for at least 4-5 points on each line. (3 marks) 2 1 1 1 After the products are assembled, they are checked by an inspector. Each product is then packed into its carton box, and then packed onto a skid for delivery to the warehouse. 1 4 2 2 1 1 1 2 1 1 1 1 1 2 2 1 2 2 1 4. Include a text box and from the information you have discovered, give your top THREE recommendations to Jen Davis on how to reduce the defects at Dance Lighting-lane paragraph each, please number recommendations #1,2,3) L6 marks) 1 1 2 1 2 1 1 2 1 2 1 2. 2 1 2 2 1 1 Currently, products that are found faulty at the final inspection are to be sent to a special team of 2 employees, in the repair department. These employees are responsible to evaluate, repair (if possible) and document their work. Some product is scrapped and discarded if it cannot be fixed. The remainder is repaired. There is a constant supply of products waiting to be evaluated by the repair team. After being repaired, products are returned to the final inspection area at the end of each department where they originated. Here they are evaluated to ensure that they are ready to ship. At the inspection area, inspectors are often needed to work overtime to inspect the products that arrive from the repair department. 1 2 2 4 3 1 1 4 1 Danco Lighting Monthly Reject Log Date Dept chain cord glass paint dented plug label sharp defect length clarity scratch Cover defect position edge 1 2 1 2 1 1 1 1 2 1 2 1 3 1 1 2 1 1 1 2 Components to assemble the lighting are received in large quantities from Canadian, American and offshore suppliers. After inspection and storage, quantities for one day's production are sent directly to the different workstations of each department, every night for the next day's production. Goods that do not pass receiving inspection are held, and sent back to suppliers as soon as possible. 2 1 1 1 2 1 1 1 1 1 1 2 1 2 1 4 3 2 2 4 1 2 Danco Lighting Inc is a GTA based manufacturer of lighting products including table and desktop lamps, track lighting, and decorative wall lighting. The company employs 80 employees, and exports 40% of its product to the USA. Approximately 50% of the employees are full-time, and the remainder are part-time and temporary. These workers are called upon to work when demand is high, and for vacation relief and to fill in for sick days. Some of their product is sold through the smaller retail lighting locations as well as to home builders for the new home market. 2 1 1 Your Actions 2 1 1 2 3 1 1 1 Your discussions with supervisors in the facility did not yield any definite clues as to the reasons for all the defects. There seemed to be many different types of rejects piled in various locations throughout the facility. 1 1 2 2 2 1 2 1 2 1 1 2 2 2 Jen Davis, is the new VP of Operations and she has been very concerned about the increasing problem with rejected products found during the manufacturing operation. 3 2 4 1 3 1 2 1 1 1 Your next stop was at the Quality Control Department, where you obtained the records for the Assembly Department rejects, for the last month. 1 2 1 2 1 1 2 1 1 2 1 2 1 2 1 2 1 2 1 2 2 1 Several new designs were introduced in January, and since that time rejects have been high "Rejects have been a large source of waste since we resumed production in January", said Davis in the weekly management meeting. She feels strongly that data must be collected and analyzed in order to begin fixing the problems. 2 1 1 1 2 1 Assignment: Submit one EXCEL document with the filename your firstname.lastnameAss2. Ensure that you use EXCEL formulas for any calculations. Round all numbers to whole numbers. 2 3 1 2 2 1 1 2 1 1 1 1 1 1 3 1 2 1 1 1 2 As a new graduate of Colombia College, you have been brought in to help review and analyze the quality data for Quality Lighting. Although you will not make technical recommendations, you should be able to help them figure out what the problems are and to point them in the right direction. 1 1 2 2 2 3 3 4 4 5 5 8 8 9 9 10 10 11 11 12 12 15 15 16 16 17 17 18 18 19 19 22 22 23 23 24 24 25 25 26 26 29 29 30 30 31 31 1. Perform a Pareto Analysis for the monthly Reject Log of the Assembly Process based on the total number of rejects from each category. Include a text box that explains the course of action that should be taken by Jen Davis. Ensure that you provide the Pareto Table and Chart. 4 ) (4 marks) 1 1 1 1 1 1 3 1 Process Overview: : 2 1 2 1 2 3 2 1 2 1 2 1 1 2 3 1 2. Draw a Run Chart (Line Chart) for each of the top 2 defects indicated on your Pareto Chart, 2 using the monthly reject data. These charts should plot each day's rejects by department. In summary, one chart for the highest defect, and one chart for the second highest defect. Plot each department's daily rejects. (2 charts required) (2 lines on each chart) Include a text box with comments on the run charts. (4 marks) 1 1 1 A tour of the assembly operation indicated that there are two departments, with different equipment and employees. These two departments assemble large production runs of the various lighting products. The production planner, Amir Patel (also a Seneca grad) translates the customer orders into production requirements, then sends each order to one of the departments for assembly. Currently each department is capable of producing all of the lighting products 3 3 1 2 1 2 1 1 4 3 1 1 1 2 1 2 2 1 3. Draw a Fish-Bone (Cause and Effect) diagram, which indicates some possible reasons for the defects listed in the case. Aim for at least 4-5 points on each line. (3 marks) 2 1 1 1 After the products are assembled, they are checked by an inspector. Each product is then packed into its carton box, and then packed onto a skid for delivery to the warehouse. 1 4 2 2 1 1 1 2 1 1 1 1 1 2 2 1 2 2 1 4. Include a text box and from the information you have discovered, give your top THREE recommendations to Jen Davis on how to reduce the defects at Dance Lighting-lane paragraph each, please number recommendations #1,2,3) L6 marks) 1 1 2 1 2 1 1 2 1 2 1 2. 2 1 2 2 1 1 Currently, products that are found faulty at the final inspection are to be sent to a special team of 2 employees, in the repair department. These employees are responsible to evaluate, repair (if possible) and document their work. Some product is scrapped and discarded if it cannot be fixed. The remainder is repaired. There is a constant supply of products waiting to be evaluated by the repair team. After being repaired, products are returned to the final inspection area at the end of each department where they originated. Here they are evaluated to ensure that they are ready to ship. At the inspection area, inspectors are often needed to work overtime to inspect the products that arrive from the repair department. 1 2 2 4 3 1 1 4 1 Danco Lighting Monthly Reject Log Date Dept chain cord glass paint dented plug label sharp defect length clarity scratch Cover defect position edge 1 2 1 2 1