HELLO PLEASE INCLUDE THE FORMULAS THAT WILL BE USED FOR EXCEL! Thanks

2. Compute costs. \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Mixing Department } \\ Costs per Equivalent Unit \\ \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 \end{tabular} 3. Assign costs. Costs of Ending Work in Process Inventory and the Units Transferred Out \begin{tabular}{|l|l|l|} \hline Ending work in process inventory: & Materials \\ \hline Equivalent units of production \\ \hline Cost per equivalent unit \\ \hline Cost of ending work in process inventory \\ \hline Units completed and transferred out: \\ \hline Units transferred to the next department \\ \hline Cost per equivalent unit \\ \hline Cost of units transferred out \\ \hline \end{tabular} 4. Prepare report. Mixing Department Cost Reconciliation Costs to be accounted for: Cost of beginning work in process inventory Costs added to production during the period Total cost to be accounted for Costs accounted for as follows: Cost of ending work in process inventory Cost of units transferred out Total cost accounted for 2 Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging. \begin{tabular}{|r|r|r|} \hline 3 & The following information relates to work in the mixing department \\ \hline 4 & & \\ \hline 5 & Work in process, beginning: & 300 \\ \hline 6 & Units in process & 60% \\ \hline 7 & Completion with respect to materials & 40% \\ \hline 8 & Completion with respect to conversion & \\ \hline 9 & Costs in the beginning inventory: & $10,500 \\ \hline 10 & Materials cost & $6,750 \\ \hline 11 & Conversion cost & 6,200 \\ \hline 12 & Units started into production during the period & \\ \hline 13 & Costs added to production during the period: & \\ \hline 14 & Materials cost & $332,150 \\ \hline 15 & Conversion cost & $407,645 \\ \hline 16 & Work in process, ending: & \\ \hline 17 & Units in process & 450 \\ \hline 18 & Completion with respect to materials & 40% \\ \hline 19 & Completion with respect to conversion & \\ \hline 20 & & \\ \hline 21 & Required: & \\ \hline \end{tabular} 22 Use the data to fill in the following information. (Use cells A5 to B19 from the given information to complete this question.) 1. Compute equivalent units. \begin{tabular}{|l|l|} \hline 27 & \multicolumn{1}{c|}{ Mixing Department } \\ 28 & \multicolumn{1}{|c|}{ Costs per Equivalent Unit } \\ \hline 29 & \\ \hline 30 & Units transferred to the next department \\ \hline 31 & Ending work in process: \\ \hline 32 & Materials \\ \hline 33 & Conversion \\ \hline 34 & Equivalent units of production \\ \hline \end{tabular} 2. Compute costs. \begin{tabular}{|l|l|} \hline 37 & \multicolumn{1}{c|}{ Mixing Department } \\ \hline 38 & \multicolumn{1}{|c|}{ Costs per Equivalent Unit } \\ \hline 39 & \\ \hline 40 & Cost of beginning work in process inventory \\ \hline 41 & Costs added during the period \\ \hline 17 & TL1 \\ \hline \end{tabular}