Question

Several items are omitted from the income statement and cost of goods manufactured statement data for two different companies for the month of December:

	On Company		Off Company
Materials inventory, December 1	$88,800		$119,880
Materials inventory, December 31	(a)		135,460
Materials purchased	225,550		(a)
Cost of direct materials used in production	237,980		(b)
Direct labor	334,780		269,730
Factory overhead	103,900		134,270
Total manufacturing costs incurred in December	(b)		775,620
Total manufacturing costs	847,160		1,064,530
Work in process inventory, December 1	170,500		288,910
Work in process inventory, December 31	143,860		(c)
Cost of goods manufactured	(c)		768,430
Finished goods inventory, December 1	150,070		134,270
Finished goods inventory, December 31	157,180		(d)
Sales	1,308,910		1,198,800
Cost of goods sold	(d)		775,620
Gross profit	(e)		(e)
Operating expenses	170,500		(f)
Net income	(f)		266,130

Required:

1. Determine the amounts of the missing items, identifying them by letter. Enter all amounts as positive numbers.

Letter	On Company	Off Company
a.	$	$
b.	$	$
c.	$	$
d.	$	$
e.	$	$
f.	$	$

2. Prepare On Company's statement of cost of goods manufactured for December.

On Company
Statement of Cost of Goods Manufactured
For the Month Ended December 31
Work in process inventory, December 1			$
Direct materials:
Materials inventory, December 1	$
Purchases $
Cost of materials available for use	$
Less materials inventory, December 31 $
Cost of direct materials used in production		$
Direct labor    $
Factory overhead $
Total manufacturing costs incurred during December    $
Total manufacturing costs			$
Less work in process inventory, December 31 $
Cost of goods manufactured			$

3. Prepare On Company's income statement for December.

On Company
Income Statement
For the Month Ended December 31
Sales		$
Cost of goods sold:
Finished goods inventory, December 1	$
Cost of goods manufactured    $
Cost of finished goods available for sale	$
Less finished goods inventory, December 31    $
Cost of goods sold $
Gross profit		$
Operating expenses    $
Net income		$

Answer 1

Answer a.

On Company:

Cost of direct materials used in production = Materials inventory, December 1 + Materials purchased - Materials inventory, December 31
$237,980 = $88,800 + $225,550 - Materials inventory, December 31
Materials inventory, December 31 = $76,370

Total manufacturing costs incurred in December = Cost of direct materials used in production + Direct labor + Factory overhead
Total manufacturing costs incurred in December = $237,980 + $334,780 + $103,900
Total manufacturing costs incurred in December = $676,660

Cost of goods manufactured = Total manufacturing costs - Work in process inventory, December 31
Cost of goods manufactured = $847,160 - $143,860
Cost of goods manufactured = $703,300

Cost of goods sold = Cost of goods manufactured + Finished goods inventory, December 1 - Finished goods inventory, December 31
Cost of goods sold = $703,300 + $150,070 - $157,180
Cost of goods sold = $696,190

Gross profit = Sales - Cost of goods sold
Gross profit = $1,308,910 - $696,190
Gross profit = $612,720

Net income = Gross profit - Operating expenses
Net income = $612,720 - $170,500
Net income = $442,220

Off Company:

Total manufacturing costs incurred in December = Cost of direct materials used in production + Direct labor + Factory overhead
$775,620 = Cost of direct materials used in production + $269,730 + $134,270
Cost of direct materials used in production = $371,620

Cost of direct materials used in production = Materials inventory, December 1 + Materials purchased - Materials inventory, December 31
$371,620 = $119,880 + Materials purchased - $135,460
Materials purchased = $387,200

Cost of goods manufactured = Total manufacturing costs - Work in process inventory, December 31
$768,430 = $1,064,530 - Work in process inventory, December 31
Work in process inventory, December 31 = $296,100

Cost of goods sold = Cost of goods manufactured + Finished goods inventory, December 1 - Finished goods inventory, December 31
$775,620 = $768,430 + $134,270 - Finished goods inventory, December 31
Finished goods inventory, December 31 = $127,080

Gross profit = Sales - Cost of goods sold
Gross profit = $1,198,800 - $775,620
Gross profit = $423,180

Net income = Gross profit - Operating expenses
$266,130 = $423,180 - Operating expenses
Operating expenses = $157,050

Answer b.