Click on the "Process Costing" tab and enter your name in Cell C$1.$ If Cell C$1$ is left blank, you will not be able to see your score. Each yellow cell requires a formula. The formula must only contain cell addresses. Each correct formula will begin with $\backslash (=,+\backslash ),$ or $-.$ The basic mathematical operators are,$+-,*$ and $/$ Addition: To add the values in cells A$1$ and B$4,$ the formula is $=$A$1+$B$4$ Subtraction: To subtract the value in cell B$4$ from the value in cell A $1,$ the formula is $=$A$1-$B$4$ Multiplication: To multiply the values in cells A$1$ and B$4,$ the formula is $=$A$1*$B$4$ Division: To divide the value in cell $\backslash ($ A $1\backslash )$ by the value in cell $\backslash ($ B $4\backslash ),$ the formula is $=$A$1/$B$4$ Using absolute addresses Once a formula is created, you will often want to copy the formula to other columns and rows. It's important to understand that excel always uses "relative addresses" unless you indicate otherwise by creating an "absolute address". For example, if you are calculating the cost of purchasing $2$ boxes of cereal at a cost of $\backslash (\backslash$$ $3\mathrm{.}95\backslash )$ per box, the formula in cell B$20$ is $\backslash (=\backslash )$ B$18*$B$19.$ Although we read cell B$20$ as "Multiply $2$ boxes by $\backslash (\backslash$$ $3\mathrm{.}95^\{\backslash$prime $\backslash$prime$\}\backslash ),$ Excel is actually calculating the value in cell B$20$ as "Multiply the value in the cell in the same column $($column B$)2$ rows above $($row $19)$ by the value in the cell in the same column $1$ row above $($row $19).$ This works just fine to calculate the cost of $2$ boxes, but if we copy the formula in cell B$20$ to C$20,$ Excel will assume relative references. The formula in cell C$20$ will become $\backslash (=\backslash )$ C$18*$ C $19.$ Since Cell C$19$ is blank, the formula will return a value of $\backslash (\backslash$$ $0\backslash )($which is an excellent deal for $6$ boxes of cereal, but it isn't accurate!$)$ Adding a $\backslash (\backslash$$ $\backslash )$ sign before the column or row reference locks the formula to a specific location. Sophie Sanders Company uses the weighted average method of process costing. It had $50,000$ units in beginning inventory, which were $\backslash (65\backslash \%\backslash )$ complete as to materials and $\backslash (70\backslash \%\backslash )$ complete as to conversion. During the month, it started $120,000$ units. At the end of the month, $40,000$ units were in inventory, which were $\backslash (70\backslash \%\backslash )$ complete as to materials and $\backslash (35\backslash \%\backslash )$ complete as to conversion. Cost information is as follows:

Equivalent Units of Production Cost per equivalent unit of production

Assign and reconcile costs

Cost of units completed and transferred out

Direct materials

Conversion

Total cost of units completed this period

Cost of units in ending inventory

Direct materials

Conversion

Total costs accounted for