DATA for the pounding department: Beginning work-in-process Degree of Completion of Beginning Work in process Started During March Completed and transferred out during March Ending Work In process Inventory Degree of Completed of ending work in process Total costs Added during March Physical Direct Conversion Total Units Materials Costs Costs 2,000 units $3,920 $3,850 $7,770 100% 80% 12,000 units 10,000 units ???? units 100% 45% $20,160 $5,000 $25,160 You may find it helpful to compute the following units and percentage so you can reference this information as data to complete my production reports. You are more than welcome to set up your own Data information on this DATA worksheet to reference on your production reports. I set this up when I developed the 2 production reports, so I know you need this information, too. Calculate the Units started and completed and the ending work-in-process for the pounding department. Determine the percentage of materials and conversion costs used(added) in the current period (March) for the pounding department's beginning, units started and completed, and ending work-in-process. Units started and completed Ending Work in process Units Units Beginning work in process Units started and completed Ending work-in-process Materials Conversion costs Part 1 Weighted average Production Report-Pounding Department Quantity Schedule and Equivalent units Step 1 Units to account for: Work in process, Bl Started in production Total Units Step 2 Units to be assigned costs: Transferred to next department Work in process, El Total units to be assigned cost Costs Unit cost: Step 3 Beginning Inventory Current cost this period Cost to account for: (a) Total equivalent units (taken from above)(b) Cost per equivalent unit (a/b) Step 4 Quantity Schedule Guidance: Don't forget to use cell references Guidance: Your total units in cell E9 must equal your total in cell e15 for total units to be assigned costs. Materials Equivalent Units 10,000 0 10,000 Conversion Total Costs cost Materials Conversion Whole Unit Cost Reconciliation: Step 5 Transferred to next department Work in process, El balance Total cost to be accounted for: 4. Prepare the journal entry Guidance: This is a good check figure. Cell e30should equal e25. Guidance: This is an optional computation, but I like to do this, since it makes my calculation for cost reconciliation easier.