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.

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.

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.

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.

The recorded data is in the on the "Question 1" tab.

Process Overview: 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 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.

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. 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.

Your Actions: Compile a report for Jen Davis summarizing the results that were received.

Using this excel document, complete the following:

Step 1. Complete the table to include the item category and the total number of complaints for each respective item category.

Step 2. Complete the table to include the item category, the total number of complaints for each item category, the cumulative complaint total, and the cumulative percent total. Make sure to sort in descending order

Step 3. Show me the Pareto Chart containing the number of each complaint, the percentage and cumulative percentage. Use formulas for calculations. Please add a chart title and include the cumulative percentage labels within the charts.

Use "Question 1" tab.

Question 1

		Danco Lighting Monthly Reject Log
Date		Cord Length	Glass Clarity	Paint Discoloring	Dented Cover	Plug Defect	Label Position
2022-01-01				4	1
2022-01-02		1	1		2	2
2022-01-03				3			2
2022-01-04				4	4
2022-01-05			1	3			1
2022-01-06		1		3	3	1
2022-01-07			2		4		1
2022-01-08				4		1
2022-01-09				4	3		1
2022-01-10		1
2022-01-11			1	3	4
2022-01-12		2		3	3	2
2022-01-13							1
2022-01-14			1	3		1
2022-01-15		1			1		2
2022-01-16			2	1
2022-01-17		1		4	1
2022-01-18					4	2
2022-01-19		1					1
2022-01-20			1	4
2022-01-21				2	2		1
2022-01-22			1		4
2022-01-23		1		3
2022-01-24					2	1
2022-01-25			2		3		1
2022-01-26				2		3
2022-01-27			2	3	1	1
2022-01-28		1			4
2022-01-29				4		2
2022-01-30							1
2022-01-31		1	1	4	4
STEP 1		Item Category	Complaints
STEP 2		Item Category	Complaints	Cumulative total	Cumulative Percent
STEP 3 PARETOCHART