An analysis of the accounts of Roberts Company reveals t June 30, 2017 reveals the following manufacturing cost data for the month ended he f cost Beginnin$13,100 7,000 8,000 $9,000 5,000 9,000 incurred raw materials purchases s54,000 direct labor $47,000 Woihed goodsteals purchass s00, fyycost$1.500. Assume that all raw materials used were manufacturing overhead $19.900. The specific machinery depreciation $4,000, machinery direct labor $47,000, Costs incurred: raw materi overhead costs were: head costs were: indirect labor $5,500, factory insurance, $4,000.m repairs $1,800, factory utlities $3,100, miscellaneous factory costs $1,500 nerded 1.0 direct materials. ed June 30, 2017 2017 balance sheet. Instructions (a) Prepare the cost of goods manufactured schedule for the month end (b) Show the presentation of the ending inventories on the June 30. 2017 ha number or a formula in cells with a"?" NOTE: Enter a number in cells requesting a value; enter either a n factured schedule for the month ended June 30, 2017 I(a) Prepare the cost of goods manuf ROBERTS COMPANY Cost of Goods Manufactured Schedule For the Month Ended June 30, 2017 Work in process inventory, June 1 Value Valuea, Raw materials inventory, June 1 Raw materials purchases Total raw materials available for use Less: Raw materials inventory, June 30 Direct materials used 0o Value000 Value 12I Direct labor Manufacturing overhead ? Value u Indirect labor Value Value Factory insurance Machinery depreciation Factory utilities Machinery repairs Miscellaneous factory costs Value Value Value Total manufacturing overhead Total manufacturing costs Total cost of work in process Less: Work in process, June 30 alue Cost of goods manufactured (b) Show the presentation of the onding inventories on the June 30, 2017 balance sh ROBERTS COMPANY (Partial) Balance Sheet June 30, 2017 Current assets Inventories Finished goods Work in process Raw materials Value Value Value7 After you have completed E1-16, consider the additional question 1. Assume that the inventory balances changed as follows: beginning raw material s $12.000, ending work in process $6,750 and ending finished goods $10,000. changes on the cost of goods manufactured schedule and balance sheet. Show the impact of these