Production Errors

Since it was established in 2002, Custom T-shirts has rapidly become the place to order customized T-shirts. One huge selling factor is that the company manufactures T-shirts based on customers' own designs. However, the quality manager for the production plant, Nancy Rusher, has noticed an unacceptable number of defective T-shirts being produced (see Figure 1).

You have been hired to assist Nancy in understanding where the problems are concentrated. She suggests using Excel's PivotTable feature to perform an analysis and has provided you with a data file, TshirtProduction.xlsx. The following is a brief definition of the information within the data file:

• Batch: A unique number that identifies each batch or group of products produced.
• Product: A unique number that identifies each product.
• Machine: A unique number that identifies each machine on which products are produced.
• Employee: A unique number that identifies each employee producing products.
• Batch Size: The number of products produced in a given batch.
• Num Defect: The number of defective products produced in a given batch.

The PivotTable feature enables you to analyze, summarize, and manipulate data in large lists, databases, worksheets, or other collections.

In this assignment, you need to create multiple PivotTables to analyze how the major four factors -Product, Machine, Employee, and Batch Size impact Num defect. You need to create PivotTables to analyze how one (e.g., Product or Machine or Employee...), two (e.g. Product & Machine, or Machine & Employee...), three (e.g., Product & Machine & Employee, or Machine & Employee & Batch Size...), and all four factors influence the number of defects in T-shirts production.

Write a brief conclusion under each PivotTable to summarize what you learned from the PivotTable regarding defects and possible reasons. You are expected to make at least 10 PivotTables to finish the analysis.

Please see the attached document for details. C D E F B BATCH PRODUCT MACHINE EMPLOYEE BATCH SIZE NUM DEFECTIVE 500 16 10 3333 20 5555 10000 10 HAWN 30 2222 5000 13 30 4444 1000 12 20 3333 1000 5 20 1111 5000 9 2222 10000 20 9 3333 10000 14 1111 5000 17 5555 500 19 3333 500 444 100 i count 2222 5000 3333 10000 1111 10000 21 1111 5000 15 1111 500 6 4444 500 3333 500 0 2222 1000 15 5555 10000 12 3333 10000 10 4444 10000 8 2222 5000 12 6555 1000 6 1111 1000 8 2222 500 5 3333 10000 18 4444 500 15 5555 500 4 4444 1000 13 5555 500 5 3333 5000 18 2222 1000 11 4444 100 23 1111 500 14 3333 500 2222 1000 4444 5000 2222 1000 2222 1000 2222 500 Annan Figure 1. T-shirts Production Data