Chapter 4 Form \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|l|}{ Chapter 4: Applying Excel } \\ \hline & & & 4 & \\ \hline \multicolumn{5}{|l|}{ Data } \\ \hline \multicolumn{5}{|l|}{ Beginning work in procoss inventory: } \\ \hline Units in process & 200 & & & \\ \hline Completion with respect to materials & 55% & & & \\ \hline Completion with respect to conversion & 30% & & & \\ \hline \multicolumn{5}{|l|}{ Costs in the beginning work in process inventory. } \\ \hline Materials cost & $9,600 & & & \\ \hline Conversion cost & $5,575 & & & \\ \hline Units started into production during the period & 5,000 & & & \\ \hline \multicolumn{5}{|l|}{ Costs added to production during the period: } \\ \hline Materials cost & $368,600 & & & \\ \hline Conversion cost - & $350,900 & + & & \\ \hline \multicolumn{5}{|l|}{ Ending work in process inventory: } \\ \hline Units in process & 400 & & & \\ \hline Completion with respect to materials & 40% & & & \\ \hline Completion with respect to conversion & 25% & & & \\ \hline \multicolumn{5}{|c|}{ Enter a formula into each of the colls markod with a ? bolow } \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Woighted Average method: } \\ \hline \multicolumn{5}{|c|}{ Equivalent Units of Production } \\ \hline & Materials & Conversion & & \\ \hline Units transferred to the next department & ? & ? & & \\ \hline \multicolumn{5}{|l|}{ Equivalent units in ending work in process inventory: } \\ \hline Materials & ? & & & \\ \hline Conversion & & ? & & \\ \hline \multirow{2}{*}{ Equivalent units of production } & ? & ? & & \\ \hline & & & & \\ \hline \multicolumn{5}{|c|}{ Costs per Equivalent Unit } \\ \hline & Materials & Conversion & & \\ \hline Cost of beginning work in process invontory & ? & ? & & \\ \hline Costs added during the period & ? & ? & & \\ \hline Total cost & ? & ? & & \\ \hline Equivalent units of production & ? & ? & & \\ \hline Cost per equivalent unit & ? & ? & & - \\ \hline & & ran & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Costs per Equivalent Unit } & & \\ \hline & Materials & Cnversion & & \\ \hline Cost of beginning work in process inventory & ? & ? & & \\ \hline Costs added during the period & ? & ? & & \\ \hline Total cost & ? & ? & & \\ \hline Equivalent units of production & ? & ? & & \\ \hline Cost per equivalent unit & ? & ? & & \\ \hline \multicolumn{5}{|c|}{ Costs of Ending Work in Process Inventory and the Units Transferred Out } \\ \hline & Materials & Conversion & Total & \\ \hline \multicolumn{5}{|l|}{ Ending work in process inventory: } \\ \hline Equivalent units & ? & ? & & \\ \hline Cost per equivalent unit & ? & ? & & \\ \hline Cost of onding work in process inventory & ? & ? & ? & \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Units completed and transferred out: } \\ \hline Units transferred to the next department & ? & ? & & \\ \hline Cost per equivalent unit & ? & ? & & \\ \hline Cost of units transferted out & ? & ? & ? & \\ \hline & & & & \\ \hline \multicolumn{5}{|l|}{ Cost Reconcillation } \\ \hline Costs to be accounted for: & & & & \\ \hline Cost of beginning wotk in process inventory & ? & & & \\ \hline Costs added to production during the period & ? & & & \\ \hline Total cost to be accounted for & ? & & & \\ \hline Costs accounted for as follows: & & & & \\ \hline Cost of ending work in process inventory & ? & & & \\ \hline Cost of units transforred out & ? & & & \\ \hline Total cost accounted for & ? & & & \\ \hline \end{tabular}