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 ?