A Cut Calibn 11 - A A Merge & Center - $ - % it Copy BI U - B- &- A- Numb Format Painter Alignment CaboAnd Beactrate 1) SUBSCRIPTION EXPIRED To keep wing Excelwithout interruption, please reactivate now. X Gore Company makes products for sporting events. The following 28 point data are for the year ended December 31: Materials inventory. January 1 $ 45,000 Materlab Inventory, December 31 65,000 Materials purchases 175,000 Direct labor 235,000 Work in process laventory, January 1 30,000 Work in process Inventory, December 31 40,000 Manufacturing overhead 130,000 11 Indirect Materials Used 2.000 Finished goods inventory, January 1 80,000 13 Finished goods Inventory, December 31 140,000 14 15 Prepare a Coat of Goods Manufactured Statement and compute the Cost of Goods 14 17 19 Gore Company 20 Cost of Goods Manufactured Statement 21 Direct Materials Used: For Year Ended December 11 22 23 27 26 Direct Materials Used 20 31 Tot Manufacturing Cost 12 14 COST OF GOODS MANUFACTURED Cost Identification Problem #1 Cod Identification Problem 87 Type here to search COGM problem Manut, and Inc. StatAlignment Parte Formal Painter Font Beactivate SUBSCRIPTION EXPIRED To keep insing Excel without interruption, please reactivate now. X Y L A 19 Gore Company Cost of Goods Manufactured Statement 19 For Year Ended December 31 21 Direct Material Used: 22 23 24 25 26 27 28 Direct Materials Used 29 31 Total Manufacturing Cost 32 33 34 COST OF GOODS MANUFACTURED 37 Gore Company 30 Cost of Goods Sold For Year Ended December 31 42 43 COST OF GOODS SOLD 44 45 This Excel Worksheet was created by Amy Bohrer, CPA and is License. licensed under a Creative Commons Attribution 4.0 International Com identification Problem .2 Type here to search COGM problem Manuf, and inc. St OCalibri A E Of Wrap Text It Copy BIU - - &-A- Merge & Center - 5 - 6 56 Format Painter Font Alignment Number SUBSCRIPTION EXPIRED To keep using Excel without interruption, please most vale now. Beactivate A3 X administrative expenses were $75,000. Requirements: a. Prepare a statement of cost of goods manufactured for Good Vibrations, Inc. for the year ended December 31. (Items that are subtracted should be entered as a negative number) Not thes b. Prepare an Income statement for Good Vibrations, Inc., for the year ended If the December 31. (Mems that are subtracted should be entered as a negative number.] Good Vibrations, Inc. 31 Manufacturing statement 32 For Year Ended December 11 33 Beginning Raw Materials Inventory 34 35 35 Raw Materials Used 37 35 Direct Materials Used [DM) 40 Direct Labor (01) 41 42 Manufacturing Overhead: Hint: The Onthead 45 amount If they an Expel will m 50 Toul Overhead (OHDJ 52 Total Manufacturing Cost (DM + DC . OHD) 53 35 Cost of Goods Manufactured Cont Identification Problem Fi COOM problem Manuf, and inc Statement P Type here to searchNote from the Professor: Please use the drop down lists to choose the conect wording to go in these yellow cels in order to complete the statements. If the cell turns GREEN you are correct. If the cell turns RED you are incorrect, try again. Note from the Professor: All yelow cels must be completed. If the cell turns GREEN you are correct. If the cell turns RED you are incorrect, by apan. Make sure if the item is subtracted that it is entered as a negative number or Excel will mark it incorrect. DGM problem Manut. and Inc. Statement W m11 Finished goods inventory, January 1 140,000 12 Finished goods inventory, December 31 Prepare a Cost of Goods Manufactured Statement and compute 14 15 16 17 Gore Company 18 Cost of Goods Manufactured Statem 19 20 For Year Ended December 31 21 Direct Materials Used: 22 23 Beginning Raw Materials Inventory Plus: Raw Materials Purchases 24 Less: Raw Materials Purchases 25 Plus: Ending Raw Materials Inventory Less: Ending Raw Materials Inventory 26 Raw Materials Used Plus: Indirect Materials Used 27 Less: Indirect Materials Used 28 Direct Materials Used 29 30 31 Total Manufacturing Cost 32 33 34 COST OF GOODS MANUFACTURED 35 37 39 Gore Company 40 Cost of Goods Sold 41 For Year Ended December 31 42 Ready Cost Identification Problem Type here to search Cost Identification Problem #17 Gore Company Cost of Goods Manufactured Statement 19 For Year Ended December 31 20 21 Direct Materials Used: 22 23 24 25 26 27 28 Direct Materials Used 29 30 31 Total Manufacturing Cost 33 34 COST OF GOODS MANUFACTURED 35 137 38 Gore Company 39 Cost of Goods Sold 40 For Year Ended December 31 41 42 43 COST OF GOODS SOLD 44 45 This Excel Worksheet was created by Amy Bohrer, CPA and License. licensed under a Creative Commons Attribution 4.0 Internation Cost Identification Problem i Cost Identification Problem #2 Type here to search COGM problem OClipboard Font Alignment SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. 122 X IV Gore Company makes products for sporting events. The following data are for the year ended December 31: Materials inventory, January 1 $ 45,000 Materials inventory, December 31 65,000 Materials purchases 175,000 Direct labor 225,000 Work in process inventory, January 1 30,000 Work in process inventory, December 31 40,000 Manufacturing overhead 130,000 Indirect Materials Used 2,000 Finished goods inventory, January 1 80,000 Finished goods inventory, December 31 140,000 Prepare a Cost of Goods Manufactured Statement and compute the Cost of Goods Gore Company Cost of Goods Manufactured Statement irect Materials Used: For Year Ended December 31 irect Materials Used al Manufacturing