please fill out the excel template based on the information from the question. the values I've already entered onto the template may be wrong fyi. thanks :)

Bagger, Incorporated uses a process costing system. The following operating and cost data occurred during October: Direct Materials Conversion Percent Percent Complete Beginning work in process inventory Units started this period Completed and transferred out Ending work in process inventory Beginning work in process inventory Direct materials Conversion Coats added this period Direct materials Conversion Units 30,000 40,000 50,000 20,000 $ 60,000 100% $ 110, 100 100% 22,500 $ 82,500 86,700 $196,800 Complete 508 Prepare the October production costs report assuming the weighted-average method of inventory costing. 30% Units to account for: Beginning work in process Units started this period Total units to account for Equivalent Units of Production (EUP) Completed and transferred out Ending work in process Equivalent units of production 30,000 40,000 70,000 Cost per EUP Cost of beginning work in process Costs added this period Total costs + Equivalent units of production Cost per EUP Cost Assignment Completed and transferred out Direct materials Conversion Ending work in process Direct materials Conversion Total costs accounted for Percent Complete Direct Materials 100% 100% EUP Units accounted for: Completed and transferred out Ending Work in Process Total units accounted for 50000 Equivalent Units of Production 50000 20000 70000 Direct Materials 60000 110,100 170,100 70,000 2.43 Cost per EUP Conversion Costs Percent Complete 100 30% 50,000 20,000 70,000 Equivalent Units of Production Total Cost 50,000 6,000 56,000 Conversion 22,500 86,700 109,200 56,000 1.95