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 B C D E F G H J K L M N P Q R Part 1 FIFO Method Production Report-Pounding Department Quantity Schedule and Equivalent units Step 1 Units to account for: Work in process, BI Started in production Total Units Step 2 Units to be assigned costs: Work in process, BI Started and completed this period Total units transferred out Work in process, El Total units to be assigned cost Costs Unit cost: Step 3 Work in Process, Beginning Current cost this period (a) Quantity Schedule Total cost Guidance: Your total units in cell E9 must equal your total in cell e17 for total units to be assigned costs. Equivalent Units Materials Conversion Materials Costs Conversion Whole Unit Costs of work done before current period, therefore do not show amount for materials and conversion costs under FIFO Total equivalent units (taken from above)(b) Cost per equivalent unit (a/b) Total Costs to account for Step 4 Cost Reconciliation(Assignment of Costs): Step 5 Work in process, Bl balance Costs to complete BI Total cost of BI Started and Completed Units Transferred out cost Work in process, El balance Total cost to be accounted for: Guidance: This is a good check finure. Cell Guidance: This is an optional computation, but I like to do this, since it makes my calculation for cost reconciliation easier.