I have seen this problem posted numerous times with the same incorrect answers. Please do not copy and paste the same wrong info. Please show the work and what formulas are used as the answers must be entered in excel formulas.

1 Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing department for the month of July: \begin{tabular}{|l|l|} \hline B28 \\ 22 & 1. Compute equivalent units. \end{tabular} Mixing Department Equivalent Units of Production 2. Compute cost per equivalent unit. Mixing Department Cost per Equivalent Unit Cost of beginning work in process 37 Cost added during the period 38 Total cost 39 Equivalent units of production 40 Cost per equivalent unit 42 3. Assign costs. \begin{tabular}{|l|l|} \hline 59 & Costs to be accounted for: \\ 60 & Cost of beginning work in process inventory \\ 61 & Costs added to production during the period \\ 62 & Total cost to be accounted for \\ 63 & Costs accounted for as follows: \\ 64 & Cost of ending work in process inventory \\ 65 & Cost of units transferred out \\ 66 & Total cost accounted for \\ 67 & \\ 68 & \\ 69 & \\ 7n & \end{tabular}