1. WHAT PRODUCTION PROBLEMS DO YOU HAVE? For this assignment use XLMD_ Production.xls. Its list…

 

1. WHAT PRODUCTION PROBLEMS DO YOU HAVE? For this assignment use XLMD_ Production.xls. Its list definition table is as follows:

 

A. BATCH —A unique number that identifies each batch or group of products produced

 

B. PRODUCT —A unique number that identifies each product

 

C. MACHINE —A unique number that identifies each machine on which products are produced

 

D. EMPLOYEE —A unique number that identifies each employee producing products

 

E. BATCH SIZE —The number of products produced in a given batch

 

F. NUM DEFECTIVE —The number of defective products produced in a given batch

 

It seems you have some real problems. There are an unacceptable number of defective products being produced. Your task is to use some combination of Filter, conditional formatting, and pivot tables to illustrate where the problems seem to be concentrated, perhaps by product, by employee, by machine, or even by batch size. Based on your analysis, recommend how to correct the problems.