please, I need the excel formula for this assignment and all the answers plz and thank you

siaa Noori Company uses the weighted average method of process costing. It had 30,000 units in boginning inventory, which were 80% complete as to materials and 65% complete as to conversion. During the month, it started 90,000 units. At the end of the month, 20,000 units were in inventory, which were 60% complete as to materials and 25% complete as to Conversion. Cost information is as follows: \begin{tabular}{|c|} \hline 1 \\ \hline 27 \\ 28 \\ 29 \\ 30 \\ 31 \\ 32 \\ 33 \\ 34 \\ 35 \\ \hline 36 \\ 37 \\ 38 \\ 39 \\ \hline 40 \\ \hline 41 \\ 42 \\ \hline 43 \\ \hline 44 \\ \hline 45 \\ \hline 46 \\ \hline 47 \\ \hline 48 \\ \hline 49 \end{tabular} Equivalont Units of Production Direct materials Conversion Equivalent units completed and transferred out Equivalent units for ending work in process Total equivalent units of production Cost per Equivalent Unit of Production Costs of beginning work in process inventory Costs added during month Total costs 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 cost of units completed this period \begin{tabular}{c} 1 \\ \hline 38 \\ 39 \\ 40 \\ 41 \\ 42 \\ 43 \\ 44 \\ 45 \\ 46 \\ 47 \\ 48 \\ 49 \\ 50 \\ 51 \end{tabular} Assign and reconcile costs Cost of units completed and transforred out Direct materials Conversion Total cost of units comploted this period Cost of units in ending inventory Direct materials Conversion Total cost of units comploted this period Total costs accounted for