Needed to be solve in Excel please add explanation

Rohit Marwaha Company uses the weighted average method of process costing It had 40,000 units in beginning inventory, which were 70% complete as to materials and 80% complete as to conversion. During the month, it started 115,000 units. At the end of the month, 32,000 units were in inventory, which were 65% complete as to materials and 30% complete as to conversion Cost information is as follows: 0 1 22 3 4 5 $141,400 155,200 Beginning work in process inventory Direct materials costs Conversion costs Total beginning inventory cost Costs added during the month Direct materials costs Conversion costs Total costs added during the month Total production costs $296,600 591,980 481 280 1,073,260 $1,369,860 7 8 9 20 21 222 Units 40.000 115,000 32,000 Materials % 70% Conversion% 80% Beginning Inventory Units Started Ending Inventory 65% 30% 24 5 26 27 Equivalent Units of Production Direct materials Ganuar Direct materials Conversion Equivalent Units of Production 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 Direct materials Conversion Equivalent Units of Production Cost per equivalent unit of production 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 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 IT Total costs accounted for