A- Assume that the standard cost of metal in the coin is €.09.

Calculate the direct materials quantity variance for each batch of the coin sample. Do the coins appear to be too heavy or too light? (You may find COUNTIF and SUMIF functions helpful.)

b- Prepare an XY scatterplot of the data using Excel's charting tool. The horizontal axis should be coin weight and the vertical axis should be batch number. What do you notice about the coin weight?

c- Calculate the average weight of the coins.

d- Calculate the average coin weight for each batch. (You may find the AVERAGEIF function helpful.)

e- Recognizing that there may be some variation in the weight of the disks being used to make the Euro coins? What if the tolerance is +/- .03 grams?

f- Given that the coins are a combination of two separate disks of different metals, how would you determine which of the two disks is outside of specification? Explain briefly.