The 1 Euro coin has a silver-colored inner core and a yellow outer ring. The center core
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/666cf144cef5e_684666cf144cc00d.jpg)
The 1 Euro coin has a silver-colored inner core and a yellow outer ring. The center core is made from a copper-nickel alloy, while the outer ring is made of nicel brass. The coins are minted through a series of steps that combine two separate metal disks into the final coin that should weigh 7.5 grams. (You can watch a video of the process to make a 2 Euro coin at https://www.youtube.com/watch?v-rFDsSMDeV3w.) you are a quality control technician in the mint and are responsible for ensuring that the coins meet the official weight and size specifications. As part of this work, you have weighed 2,000 coins from eight different production runs to determine whether the machines producing the metal disks are operating to specifications.
Required
(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) Draw 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?
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?
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/666cf14504844_685666cf145014ea.jpg)