How many batches were run?

How many unique products are there?

List the identifying numbers for the products $($ascending numbers separated by commas$)$

What is the definition of "Batch"?

What is the definition of "Batch Size"?

What is the average batch size?

What is the maximum number of defects for a batch?

What is the total number of defects?

Add a data column "Price" to the Working Data worksheet. Use VLOOKUP to add the Prices to the correct product from the Price$\_$Costs worksheet. When finished, type "Done" in cell C$10$ in this worksheet.

Add a data column "Costs" to the Working Data worksheet. Use VLOOKUP to add the Costs to the correct product from the Price$\_$Costs worksheet. When finished, type "Done" in cell C$11$ in this worksheet.

Add a data column "Profits" to the Working Data worksheet. Use a formula with cell references to determine the profits from each batch. Note that you cannot sell defective products so you must take that into account in your formula. When finished, type "Done" in cell C$12$ in this worksheet.

Which product was the most profitable?

How much total profit did that product generate?

Which product generated the most costs?

What were the total costs associated with that product?