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	?