1. Business
  2. Accounting
  3. chapter 4 applying excel data beginning work in process inventory...

Question: chapter 4 applying excel data beginning work in process inventory...

Question details
Chapter 4: Applying Excel
Data
Beginning work in process inventory:
Units in process 200
Completion with respect to materials 100%
Completion with respect to conversion 40%
Costs in the beginning work in process inventory:
Materials cost $2,000
Conversion cost $800
Units started into production during the period 1,800
Costs added to production during the period:
Materials cost $18,400
Conversion cost $38,765
Ending work in process inventory:
Units in process 100
Completion with respect to materials 100%
Completion with respect to conversion 30%
Enter a formula into each of the cells marked with a ? below
Weighted Average method:
Equivalent Units of Production
Materials Conversion
Units transferred to the next department ? ?
Ending work in process inventory:
Materials ?
Conversion ?
Equivalent units of production ? ?
Costs per Equivalent Unit
Materials Conversion
Cost of beginning work in process inventory ? ?
Costs added during the period ? ?
Total cost ? ?
Equivalent units of production ? ?
Cost per equivalent unit ? ?
Costs of Ending Work in Process Inventory and the Units Transferred Out
Materials Conversion Total
Ending work in process inventory:
Equivalent units of production ? ?
Cost per equivalent unit ? ?
Cost of ending work in process inventory ? ? ?
Units completed and transferred out:
Units transferred to the next department ? ?
Cost per equivalent unit ? ?
Cost of units transferred out ? ? ?
Cost Reconciliation
Costs to be accounted for:
Cost of beginning work in process inventory ?
Costs added to production during the period ?
Total cost to be accounted for ?
Costs accounted for as follows:
Cost of ending work in process inventory ?
Cost of units transferred out ?
Total cost accounted for ?
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution