2 An analysis of the accounts of Roberts Company reveals the following manufacturing cost data for the month ended June 30, 2020. Inventories Raw materials Work in process Finished goods Beginning $9,000 5,000 9,000 Ending $13,100 7,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, miscellaneous factory costs $1,500. Assume that all raw materials used were direct materials. Instructions (a) Prepare the cost of goods manufactured schedule for the month ended June 30, 2020. (b) Show the presentation of the ending inventories on the June 30, 2020 balance sheet. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". Work in process inventory, June 1 Direct materials Value Raw materials inventory, June 1 Value Raw materials purchases Value Total raw materials available for use 2 Less Raw materials inventory, June 30 Value Direct materials used Direct labor 2 Value Manufacturing overhead Indirect labor Factory insurance Machinery depreciation Factory utilities Machinery repairs Miscellaneous factory costs Total manufacturing overhead Total manufacturing costs Total cost of work in process Less: Work in process, June 30 Cost of goods manufacturad Value Value Value Value Value Value 2 ? Value (b) Show the presentation of the ending inventories on the June 30, 2020 balance sheet. Current assets Inventories Finished goods Value Work in process Raw materials Value Value