An analysis of the accounts of Roberts Company reveals the following manufacturing cost data for the month ended June 30, 2017.

An analysis of the accounts of Roberts Company reveals the following manufacturing cost data for the month ended June 30, 2017.

Inventory		Beginning		Ending
Raw materials		$9,000		$13,100
Work in process		5,000		7,000
Finished goods		9,000		8,000

Costs incurred: raw materials purchases $54,000, direct labor $47,000, manufacturing overhead $19,900. The specific overhead costs were: indirect labor $5,500, factory insurance $4,000, machinery depreciation $4,000, machinery repairs $1,800, factory utilities $3,100, and miscellaneous factory costs $1,500. Assume that all raw materials used were direct materials.

(a) Prepare the cost of goods manufactured schedule for the month ended June 30, 2017.

ROBERTS COMPANY Cost of Goods Manufactured Schedule For the Month Ended June 30, 2017 June 30, 2017 For the Year Ended June 30, 2017
Cost of Goods Manufactured Direct Labor Direct Materials Direct Materials Used Factory Insurance Factory Utilities Indirect Labor Machinery Depreciation Machinery Repairs Manufacturing Overhead Miscellaneous Factory Costs Raw Materials Inventory, June 1 Raw Materials Inventory, June 30 Raw Materials Purchases Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Total Raw Materials Available for Use Work in Process Inventory, June 1 Work in Process Inventory, June 30 Finished Goods Inventory, June 1 Finished Goods Inventory, June 30						$
Cost of Goods Manufactured Direct Labor Direct Materials Direct Materials Used Factory Insurance Factory Utilities Indirect Labor Machinery Depreciation Machinery Repairs Manufacturing Overhead Miscellaneous Factory Costs Raw Materials Inventory, June 1 Raw Materials Inventory, June 30 Raw Materials Purchases Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Total Raw Materials Available for Use Work in Process Inventory, June 1 Work in Process Inventory, June 30 Finished Goods Inventory, June 1 Finished Goods Inventory, June 30
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30		$
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30
Add     Less :  Cost of Goods Manufactured Direct Labor Direct Materials Direct Materials Used Factory Insurance Factory Utilities Indirect Labor Machinery Depreciation Machinery Repairs Manufacturing Overhead Miscellaneous Factory Costs Raw Materials Inventory, June 1 Raw Materials Inventory, June 30 Raw Materials Purchases Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Total Raw Materials Available for Use Work in Process Inventory, June 1 Work in Process Inventory, June 30 Finished Goods Inventory, June 1 Finished Goods Inventory, June 30
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30				$
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30
Cost of Goods Manufactured Direct Labor Direct Materials Direct Materials Used Factory Insurance Factory Utilities Indirect Labor Machinery Depreciation Machinery Repairs Manufacturing Overhead Miscellaneous Factory Costs Raw Materials Inventory, June 1 Raw Materials Inventory, June 30 Raw Materials Purchases Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Total Raw Materials Available for Use Work in Process Inventory, June 1 Work in Process Inventory, June 30 Finished Goods Inventory, June 1 Finished Goods Inventory, June 30
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30		$
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30
Cost of Goods Manufactured     Direct Labor     Direct Materials     Direct Materials Used     Factory Insurance     Factory Utilities     Indirect Labor     Machinery Depreciation     Machinery Repairs     Manufacturing Overhead     Miscellaneous Factory Costs     Raw Materials Inventory, June 1     Raw Materials Inventory, June 30     Raw Materials Purchases     Total Cost of Work in Process     Total Manufacturing Costs     Total Manufacturing Overhead     Total Raw Materials Available for Use     Work in Process Inventory, June 1     Work in Process Inventory, June 30     Finished Goods Inventory, June 1     Finished Goods Inventory, June 30
Cost of Goods Manufactured Direct Labor Direct Materials Direct Materials Used Factory Insurance Factory Utilities Indirect Labor Machinery Depreciation Machinery Repairs Manufacturing Overhead Miscellaneous Factory Costs Raw Materials Inventory, June 1 Raw Materials Inventory, June 30 Raw Materials Purchases Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Total Raw Materials Available for Use Work in Process Inventory, June 1 Work in Process Inventory, June 30 Finished Goods Inventory, June 1 Finished Goods Inventory, June 30
Cost of Goods Manufactured Direct Labor Direct Materials Direct Materials Used Factory Insurance Factory Utilities Indirect Labor Machinery Depreciation Machinery Repairs Manufacturing Overhead Miscellaneous Factory Costs Raw Materials Inventory, June 1 Raw Materials Inventory, June 30 Raw Materials Purchases Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Total Raw Materials Available for Use Work in Process Inventory, June 1 Work in Process Inventory, June 30 Finished Goods Inventory, June 1 Finished Goods Inventory, June 30
Add Less :  Cost of Goods Manufactured Direct Labor Direct Materials Direct Materials Used Factory Insurance Factory Utilities Indirect Labor Machinery Depreciation Machinery Repairs Manufacturing Overhead Miscellaneous Factory Costs Raw Materials Inventory, June 1 Raw Materials Inventory, June 30 Raw Materials Purchases Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Total Raw Materials Available for Use Work in Process Inventory, June 1 Work in Process Inventory, June 30 Finished Goods Inventory, June 1 Finished Goods Inventory, June 30
Cost of Goods Manufactured Direct Labor Direct Materials Direct Materials Used Factory Insurance Factory Utilities Indirect Labor Machinery Depreciation Machinery Repairs Manufacturing Overhead Miscellaneous Factory Costs Raw Materials Inventory, June 1 Raw Materials Inventory, June 30 Raw Materials Purchases Total Cost of Work in Process Total Manufacturing Costs Total Manufacturing Overhead Total Raw Materials Available for Use Work in Process Inventory, June 1 Work in Process Inventory, June 30 Finished Goods Inventory, June 1 Finished Goods Inventory, June 30						$

(b) Show the presentation of the ending inventories on the June 30, 2017, balance sheet.

ROBERTS COMPANY (Partial) Balance Sheet For the Month Ended June 30, 2017 For the Year Ended June 30, 2017 June 30, 2017
Current Assets Current Liabilities Intangible Assets Long-term Investments Long-term Liabilities Property, Plant and Equipment Stockholders' Equity Total Assets Total Current Assets Total Current Liabilities Total Intangible Assets Total Liabilities Total Liabilities and Stockholders' Equity Total Long-term Investments Total Long-term Liabilities Total Property, Plant and Equipment Total Stockholders' Equity
Accounts Receivable Cash Finished Goods Inventories Prepaid Expenses Raw Materials Work in Process
Accounts Receivable     Cash     Finished Goods     Inventories     Prepaid Expenses     Raw Materials     Work in Process			$
Accounts Receivable     Cash     Finished Goods     Inventories     Prepaid Expenses     Raw Materials     Work in Process
Accounts Receivable     Cash     Finished Goods     Inventories     Prepaid Expenses     Raw Materials     Work in Process
					$