Homework answers / question archive / Established in 2002, t-shirts

Established in 2002, t-shirts

Business

Share With

Established in 2002, t-shirts.com rapidly became the place to find, order, and save on T-shirts. The company manufactures its own T-shirts, a huge selling point. However, the quality manager for the production plant, Kasey Harnish, noticed an unacceptable number of defective T-shirts during production. You must assist Kasey in understanding the problems. He suggests using formatting, pivot tables and other Excel Decision Support Tools to perform an analysis and provided you with a data file, TshirtProduction_Data.xlsx.

The following is a brief definition of the information within the data file:

Definitions

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.

• Use conditional formatting to highlight all batches where the number of defective products is greater than 10. Call this worksheet “Conditional”.
• Create a pivot table that shows the number of defective products produced by machine by product and call the worksheet “Machine”.
• Create a pivot table that shows the number of defective products produced by employee by product and call the worksheet “Defective”.
• Create a pivot table that shows the total number of products produced by each employee and call the worksheet “Total”.
• Create a pivot table that shows the total number of products produced by each employee as well as the total number of defective products produced by each employee and call the worksheet “Employee”.
• There are an unacceptable number of defective products being produced.Your task is to use some combination of any Excel formula or function to illustrate the problems, perhaps product, employee, machine, or even batch size. Call this worksheet “Unacceptable”. Based on your analysis, recommend how to correct the problems in a paragraph or two in the Unacceptable worksheet.