Seh The Home Page Layout Formula Data Re Vie Help DOCH VIEWS 3.000 E14.16 Prepare a cost of goods manufactured schedule and get the engines on the balance An analysis of the accounts of Roberts Company reveals the following manufacturing cost data for the month anded June 30, 2020 Inventories Beginning Erong Raw materials 39,000 $13.100 Work in process 5.000 7.000 Finished goods 9.000 Costs curred raw material purchases $54.000 direct labor $47.000, manufacturing overhead 519,900 The specie overhead costa were Indirect labor 55.500 factory nuance. 54.000 machinery depreciation 54000, chinery 10 repairs $1,800, factory stities 53 100 miscellaneous factory costs $1.500. Assume that at materials used were 1 direct materials 12 11 Instructions 4) Prepare the cost of goods manufactured schedule for the month ended June 30, 2020 () Show the presentation of the ending investories on the June 30, 2020 balance sheet 16 NOTE: Enter a number in cells requesting a value enter either a number or a formula in cels with "y 17 1 19a) Prepare the cost of goods manufactured schedule for the momented June 30 2020 21 ROBERTS COMPANY Cost of Goods Manastured Schedule 23 For the Month Ended une 30, 2000 VW Work in process mentory 1 Direct material 26 Raw materiais wventory 1 27 Raw material purchases Totaan materials available for Less Raw materiais entry June 30 Va Det material used Etats 25 V 221 E SADA Ariedas such Fle Home OCH W Page Layout Form View 21 32 11 Valve 25 D Direct materals used Direct labor Manufacturing overhead Indirect labor Factory insurance Machinery depreciation Factory utiles Machinery repairs Miscelaneous factory out Total manufacturing overhead Total manufacturing costs Total cost of work in process Less Work in process, June 30 Cost of goods manufactured Value Value Value Value 27 2 2 Value ch) Show the presentation of the ending inventores on the June 30, 2020 ne sheet ROBERTS COMPANY (Partia Balance Sheet 2020 Current assets Inventories 53 Fished goods Vale Work in process Vale Raw materials 5 Pietro hop