Home Page Layout Formulas Data Review View Liberation Sans 12 - A A 25 Wrap Text General Paste BIU A Marge & Centar $ % ) M27 x fx 1 A D F 0 1 E14.10. Prepara.cost of goods manufactured schedule and present the ending more on the balance sheet 2 An analysis of the counts of Roberts Company reveals the flowing manufacturing cost data for the month anded 3 June 30, 2000 Inventories Beginning Ending 5 Raw materials $9,000 $13,100 6 Work in proces 5.000 7.000 7 Fished goods 0.000 8.000 Costs incurred water purchases $5,000, direct labor $47,000, manufacturing overhead $10,000. The specie overhead costs were director $5.500, factory insurance, 84,000, machinery depresion $4.000 chey 10 repairs 1,000, actory is $3,100, miscellaneous factory costs $1,500. Asunt al raw materials used were 11 direct materials 1. Instructions 14 a Prepare the cost of goods aractured schedule for the month ended June 30, 2020 u Show the presentation of the ending inventories on the June 30, 2020 balance sheet 16 NOTE: Enter a number in calia requesting a value anterther a number or a formula in cells with a "". 18 19 Prepare ecolof goods manufactured schedule for the mothanded June 30, 2020 ROBERTS COMPANY 22 Cost of Good Manufactured chedule 24 24 Work in proces vertory, June 1 Value 25 Direct Row more invertory, June 1 V Raw purchase Towable for use Less: Raw materwortory, June 30 V Direct materials used 30 Director Vai Manufacturing overhead 30 det Factory Trance Machinery deprecation Valve Factory Vau Machinery Vau Miscellaneous factory out Valle Total manufacturing over Tomaturing Totalconetwork in process Los: Work in process, VEL Cost of goods matured Show the presentation of meer verors on the June 30, 2000 Balce sheet E14-12 E14-18 PA P14-SA + MacBook Air DOO esc F2 30 F3 COF FS FG A # 3 $ 4 % 5 & 7. 1 2 6 TAN C D T Home Insert Draw Page Layout Formulas Data Review View Liberation Sans 12 Wrap Tout Pasta General uv a.A. ill Merge & Centar $ % ) M27 Xfic A F 6 H 5 37 38 19 Vale Wake 8 0 Factory utiles Machinery repairs Miscellaneous factory cost Total manufacturing overhead Total manufacturing co Total cost of work in process Loss: Work in process, June 30 Cost of goods manufactured 49 41 7 Vabop 41 5 46 Show the presentation of the ending Inventories on the June 30, 2020 balance sheet 47 ROBERTS COMPANY (Part Balance Sheet June 30, 2020 SO 51 50 Current assets Inventories Finished goods Work in proces Raw materiale Value VALD 90 52 50 50 6 Aher you have completed 14-16, consider the additional question Asume that the inventory balances changed as follows: beginning raw materials $12,000, ending work in process 56.750 and ending finished goods $10,000 Show the impact of these changes on the cost of goods manufactured schedule and balance sheet GS 71 E14 E14.12 14-10 P14.4 P14.5A + MacBook Air esc 0 20 F3 @ # 3 $ 4 % 5 2 6 7
