Requirement $2$:

Change all numbers in the data area of your worksheet so it looks like this: If your formulas are correct, you should get the correct answers to the following questions.

$($a$)$ What is the equivalent units of production for materials?

$($b$)$ What is the equivalent units of production for conversion?

$($c$)$ What is the cost per equivalent unit for materials?

$($d$)$ What is the cost per equivalent unit for conversion?

$($e$)$ What is the cost of the units transferred out?