AaBbccudi AaBbccudi Aabb Paste BIU abe x x 1 Normal Aay.A Heading 2 1 No Spac... Heading 1 Title Subtitle Intense Subtle Em... Emphasis 2 Copy Calibri A A A A HABUCCO AdBOCC Adb 1 No Spac... Heading 1 Heading 2 - 12 Habo CD AdboC AdboCCL 1 No Spac... Heading 1 Heading 2 AaBb CCD Subtitle abc x, X aly 1 No Spac... Heading 1 Heading 2 Title - Copy *Format Painter Paste 1 Normal Title Aaly. A Subtitle Intense E Paste 1 Normal Subtle Em... Emphasis ,,, abc X X Title Subtitle Subtle Em... Paste Emphasis 1 Normal Subtitle Title Intense E Paste Emphasis Aaly. A Subtle Em... Copy Paste Format Painter Clipboard abc X, X? A - aly. A IU - abe Xx x = 1 Normal 1 No Spac... Heading 1 Heading 2 Emphasis Intens Format Painter Clipboard Subtle Em... Emphasis Intense E... Eg Copy *Format Painter Clipboard I U TT 21 T ,, X, X AaBbCcDd AaBbCcDd AaBbci AaBbcc AaB AaBbCcDAoBb CcDd AaBbccddi AaBbccddi AaBb 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em... Emphasis Intense E... Stru Paste Subtitle A - aly. A Subtle Em... , St Emphasis Intense E... Format Painter Clipboard Font Styles Paragraph e Copy Format Painter Clipboard 5 Copy Format Painter Clipboard BI U abs x x Aaly. A Font Paragraph Styles Clipboard Font Paragraph Styles Font Paragraph Font Styles Font Styles WELCO LIGHTLI115 HIIL. COLCU LITTLI115 HIIL. Font Paragraph Styles 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. Your Actions: 1 Normal 1 No Spac... Heading 1 Heading 2 Title Paragraph Bestco Lighting Division - Monthly Reject Records Date Dept sharp paint plug hose dented glass label edge defect length Cover chip position Paragraph 1 Styles 1 18 3 2 chain 18 2 1 The charts and graphs must generated using Excel. Please remember to identify your charts/graphs-Main Titles, X-Axis and Y-Axis labels other names of data. This assignment is NOT to be written in the first person. Format your charts and table. 1 Scratch defect 19 1 1 2 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. 19 2 1 1 1 2 1 1 4 1 1 22 1 2 1 Bestco 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 60% 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. Bestco 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 60% 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 2 2 2 1 1 2 1 1 22 2 3 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 1 Your next stop was at the Quality Control Department, where you obtained the records for the Assembly Department rejects, for the last month. 2 1 3 1 1 2 23 1 1 3 3 3 2 2 1 1 1 1 23 2 2 1 1 1 3 1 2 4 4 2 3 1 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. 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. 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. 5 1 2 1 1 5 2 1 4 8 1 2 1 1 2 8 Please view the rubric for this assignment before handing in. 2 2 1 1 1 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. 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 marks) 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. 9 1 3 2 2 3 9 2 1 1 Bestco Lighting Division - Monthly Reject Records Date Dept sharp paint plug hose dented glass label edge scratch defect length Cover chip position 1 1 3 1 chain 1 2 2 10 10 11 1 1 defect As a new graduate of Seneca 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. As a new graduate of Seneca 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 1 2 24 3 2. Draw a Run Chart (Line Chart) for each of the top 2 defects indicated on your Pareto Chart, 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) 2 1 11 1 2 1 1 1 1 4 1 2 1 24 1 2 1 3 1 2 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 2 2 1 1 2 2 1 1 1 25 1 12 12 1 2 1 Process Overview: Process Overview: 3 1 1 1 2 25 2 1 2 1 1 15 2 1 1 1 3 2 2 1 1 1 1 26 1 3 2 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) 1 1 1 1 4 1 1 2 3 15 26 1 2 1 1 1 1 2 1 2 1 16 4 1 2 1 1 1 2 3 1 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. 1 29 2 16 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. 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. 1 5 1 2 1 29 1 2 17 1 5 1 30 1 4 1 1 1 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 Bestco Lighting. (one paragraph each, please number recommendations #1,2,371 6 marks) 2 1 2 8 2 1 4 1 1 2 2 1 30 2 1 17 18 Your Actions: 1 8 2 3 2 2 31 1 1 1 1 1 1 1 2 1 1 1 1 18 2 1 2 31 2 1 2 2 2 The charts and graphs must generated using Excel. Please remember to identify your After the products are assembled, they are checked by an inspector. Each product is then After the products are assembled, they are checked by an inspector. Each product is then Your discussions with supervisors in the facility did not yield any definite clues as to the reasons 1145 words Page 2 of 4 1145 words replichiad rotor Page 3 of 4 E English (United States) Page 3 of 4 1145 words E English (United States) ED * English (United States) ES AaBbccudi AaBbccudi Aabb Paste BIU abe x x 1 Normal Aay.A Heading 2 1 No Spac... Heading 1 Title Subtitle Intense Subtle Em... Emphasis 2 Copy Calibri A A A A HABUCCO AdBOCC Adb 1 No Spac... Heading 1 Heading 2 - 12 Habo CD AdboC AdboCCL 1 No Spac... Heading 1 Heading 2 AaBb CCD Subtitle abc x, X aly 1 No Spac... Heading 1 Heading 2 Title - Copy *Format Painter Paste 1 Normal Title Aaly. A Subtitle Intense E Paste 1 Normal Subtle Em... Emphasis ,,, abc X X Title Subtitle Subtle Em... Paste Emphasis 1 Normal Subtitle Title Intense E Paste Emphasis Aaly. A Subtle Em... Copy Paste Format Painter Clipboard abc X, X? A - aly. A IU - abe Xx x = 1 Normal 1 No Spac... Heading 1 Heading 2 Emphasis Intens Format Painter Clipboard Subtle Em... Emphasis Intense E... Eg Copy *Format Painter Clipboard I U TT 21 T ,, X, X AaBbCcDd AaBbCcDd AaBbci AaBbcc AaB AaBbCcDAoBb CcDd AaBbccddi AaBbccddi AaBb 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em... Emphasis Intense E... Stru Paste Subtitle A - aly. A Subtle Em... , St Emphasis Intense E... Format Painter Clipboard Font Styles Paragraph e Copy Format Painter Clipboard 5 Copy Format Painter Clipboard BI U abs x x Aaly. A Font Paragraph Styles Clipboard Font Paragraph Styles Font Paragraph Font Styles Font Styles WELCO LIGHTLI115 HIIL. COLCU LITTLI115 HIIL. Font Paragraph Styles 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. Your Actions: 1 Normal 1 No Spac... Heading 1 Heading 2 Title Paragraph Bestco Lighting Division - Monthly Reject Records Date Dept sharp paint plug hose dented glass label edge defect length Cover chip position Paragraph 1 Styles 1 18 3 2 chain 18 2 1 The charts and graphs must generated using Excel. Please remember to identify your charts/graphs-Main Titles, X-Axis and Y-Axis labels other names of data. This assignment is NOT to be written in the first person. Format your charts and table. 1 Scratch defect 19 1 1 2 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. 19 2 1 1 1 2 1 1 4 1 1 22 1 2 1 Bestco 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 60% 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. Bestco 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 60% 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 2 2 2 1 1 2 1 1 22 2 3 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 1 Your next stop was at the Quality Control Department, where you obtained the records for the Assembly Department rejects, for the last month. 2 1 3 1 1 2 23 1 1 3 3 3 2 2 1 1 1 1 23 2 2 1 1 1 3 1 2 4 4 2 3 1 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. 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. 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. 5 1 2 1 1 5 2 1 4 8 1 2 1 1 2 8 Please view the rubric for this assignment before handing in. 2 2 1 1 1 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. 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 marks) 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. 9 1 3 2 2 3 9 2 1 1 Bestco Lighting Division - Monthly Reject Records Date Dept sharp paint plug hose dented glass label edge scratch defect length Cover chip position 1 1 3 1 chain 1 2 2 10 10 11 1 1 defect As a new graduate of Seneca 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. As a new graduate of Seneca 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 1 2 24 3 2. Draw a Run Chart (Line Chart) for each of the top 2 defects indicated on your Pareto Chart, 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) 2 1 11 1 2 1 1 1 1 4 1 2 1 24 1 2 1 3 1 2 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 2 2 1 1 2 2 1 1 1 25 1 12 12 1 2 1 Process Overview: Process Overview: 3 1 1 1 2 25 2 1 2 1 1 15 2 1 1 1 3 2 2 1 1 1 1 26 1 3 2 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) 1 1 1 1 4 1 1 2 3 15 26 1 2 1 1 1 1 2 1 2 1 16 4 1 2 1 1 1 2 3 1 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. 1 29 2 16 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. 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. 1 5 1 2 1 29 1 2 17 1 5 1 30 1 4 1 1 1 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 Bestco Lighting. (one paragraph each, please number recommendations #1,2,371 6 marks) 2 1 2 8 2 1 4 1 1 2 2 1 30 2 1 17 18 Your Actions: 1 8 2 3 2 2 31 1 1 1 1 1 1 1 2 1 1 1 1 18 2 1 2 31 2 1 2 2 2 The charts and graphs must generated using Excel. Please remember to identify your After the products are assembled, they are checked by an inspector. Each product is then After the products are assembled, they are checked by an inspector. Each product is then Your discussions with supervisors in the facility did not yield any definite clues as to the reasons 1145 words Page 2 of 4 1145 words replichiad rotor Page 3 of 4 E English (United States) Page 3 of 4 1145 words E English (United States) ED * English (United States) ES