Question

GRA the previous controller left the company with little notice and left the accounting records in disarray. Ron needs the ending inventory balances to report first quarter numbers. For the previous month (March 2011) Ron was able to piece together the following information: Direct materials purchased Work-in-process inventory, 3/1/2011 Direct materials inventory, 3/1/2011 Finished goods inventory, 3/1/2011 Conversion Costs Total manufacturing costs added during the period $840,000 Cost of goods manufactured Gross margin as a percentage of revenues Revenues (Q3) Ron Williams recently took over as the controller of Johnson Brothers Manufacturing. Last month, $240,000 $ 70,000 $25,000 $320,000 $ 660,000 4 times direct materials used 20% $1,037,500 1. Compute the following Direct materials used Cost of goods manufactured 2. Complete the following table (schedule) and find A: Finished goods inventory, 3/3 1/2011 B: Work-in-process inventory, 3/31/2011 C: Direct materials inventory, 3/31/2011 Direct materials, 3/1/2011 Direct materials purchased Direct materials available for use Direct materials, 3/31/2011 С- Direct materials used Conversion costs Manufacturing costs added during the period Add work in process, 3/1/2011 Manufacturing costs to account for Deduct work in process, 3/31/2011 В - Cost of goods manufactured Add finished goods, 3/1/2011 Cost of goods available for sale Deduct finished goods, 3/31/2011 A= Cost of goods sold

Answer 1

Direct Material, 3/1/2011				$      25,000.00
Direct Material purchased				$    240,000.00
Direct Material available for use				$    265,000.00
Direct Material, 3/31/2011				$      85,000.00	($ 265000 - $ 180000)
Direct Material used				$    180,000.00	($ 840000 - $ 660000)
Conversion costs				$    660,000.00
Manu. Costs added during the period				$    840,000.00
Add: WIP, 3/1/2011				$      70,000.00
Manu. Costs to account for				$    910,000.00
Less: WIP, 3/31/2011				$    190,000.00	($ 910000 - $ 720000)
Cost of Goods manufactured				$    720,000.00	($ 180000 x 4)
Add: FG, 3/1/2011				$    320,000.00
Cost of goods available for sale				$ 1,040,000.00
Less: FG, 3/31/2011				$    210,000.00	($ 1040000 - $ 830000)
Cost of Goods sold				$    830,000.00	(W.N)

W.N
Gross Margin =		20% of Revenues
	=	$ 1037500 x 20%
	=	$ 207,500.00
Cost of Goods sold =		Revenues - Gross Margin
	=	$ 1037500 - $ 207500
	=	$ 830,000.00