Question

Paste В І ov Merge & Center $ % 98 -28 Conditional Format Cell Formatting as Table Styles Insert Delete Format C1 . B C 1 Chapter 4: Applying Excel Name: 2 3 Data 4 Beginning work in process inventory: 5 Units in process 200 6 Completion with respect to materials 55% 7 Completion with respect to conversion 30% 8 Costs in the beginning work in process inventory: 9 Materials cost $9,600 10 Conversion cost $5,575 11 Units started into production during the period 5,000 12 Costs added to production during the period: 13 Materials cost $368,600 14 Conversion cost $350,900 15 Ending work in process inventory: 16 Units in process 17 Completion with respect to materials 40% 18 Completion with respect to conversion 25% 19 20 Enter a formula into each of the green cells marked with a ? below. Once complete use the "Copy Formula" button. 21 22 Weighted Average method: Formulas Req 1 Ch4 Req 2 Ch4 Reg 3 Ch4 400 +

Answer 1

	Units completed and transferred out=Beginning Work in Process Inventory+Units started -Ending Work in Process Inventory=(200+5000-400)
	Ccost Worksheet
	Flow of Production	Physical Units	Direct Material	Conversion
	Work in Process Beginning	200
	Started during Period	5000
	To account for	5200
	Units Completed	4800	4800	4800
	Work in Process Ending(400*40%),(400*25%)	400	160	100
	Equivalent Units	5200	4960	4900
	Costs	Direct Material	Conversion	Total
	Work in Process beginning	$                        9,600.00	$                      5,575.00	$                  15,175.00
	Costs added during the period	$                  3,68,600.00	$                3,50,900.00	$              7,19,500.00
	Total cost to account for	$                  3,78,200.00	$                3,56,475.00	$              7,34,675.00
	Cost per Equivalent unit=($378200/4960),($356475/4900)	$                              76.25	$                            72.75	$                        149.00
	Cost of ending Work in Process and the Units transferred out
		Direct Material	Conversion	Total
	Ending Work in Process Inventory
	Equivalent Units	160	100
	Cost per Equivalent unit	$                              76.25	$                            72.75
	Cost of Ending Work in Process Inventory	$                      12,200.00	$                      7,275.00	$                  19,475.00
	Units completed and transferred out
	Equivalent Units	4800	4800
	Cost per Equivalent Units	$                              76.25	$                            72.75
	Cost of units completed and transferred out	$                  3,66,000.00	$                3,49,200.00	$              7,15,200.00
	Cost Reconciliation
	Assignment of costs
	Beginning Work in Process Inventory	$                      15,175.00
	Costs added o the production during the period	$                  7,19,500.00
	Total cost to account for	$                  7,34,675.00
	Cost accounted for as follows
	Ending Work in Process Inventory	$                      19,475.00
	Cost of units transferred out	$                  7,15,200.00
	Total cost accounted for	$                  7,34,675.00