Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View -ut interruption, please reactivate now. Reactivate Enable Editing MERIWELL COMPANY I Finished goods inventory, beginning Finished goods inventory, ending Depreciation, factory Administrative expenses Utilities, factory Maintenance, factory Supplies, factory Insurance, factory Purchases of raw materials Raw materials inventory, beginning Raw materials inventory, ending Direct labour Indirect labour Work in process inventory, beginning Work in process inventory, ending Sales Selling expenses $20,000 40,000 27,000 110,000 8,000 40,000 11,000 4,000 125,000 9,000 6,000 70,000 15,000 17,000 30,000 500,000 80,000 1) Complete a Cost of Goods Manufactured in Microsoft Excel in the template provided 2) Complete Cost of Goods Sold in Microsoft Excel in the template provided o AutoSave Off Assignment #1 Template.xlsx - Protec File Home Insert Draw Page Layout Formulas Data Review O PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless your SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. B3 > E F G H B C D 1 2 Cost of Goods Sold Manufactured 3 Raw Materials Beginhing Balance 4 Add:Purchases of Raw Materials 5 Raw Materials Available For Use 6 Less: Raw Materials Ending Balance 7 Raw Materials used in Production 8 9 Direct Materials 10 Direct Labour Cost 11 Manufacturing Overhead 12 13 14 75 16 17 18 19 Total Manufacturing Cost 20 21 WIP Beg iny 22 Add Total Manfacturing Cost 23 Total WIP Available 24 Less: WIP End Inv Assignment #1 Template i SUBSCRIPTION EXPIRED To keep using Excel without interruption, please - B3 X B C D E F 13 14 15 16 17 18 19 Total Manufacturing Cost 20 21 WIP Beg Inv 22 Add Total Manfacturing Cost 23 Total WIP Available 24 Less: WIP End Inv 25 Cost of Goods Manufactured 26 27 Cost of Goods Sold 28 29 Finished Goods Beg Inventory 30 Add: Cost of Goods Manufactured 31 Cost of Goods Available for Sale 32 Less: Finished Goods End Inventory 33 Cost of Goods Sold 34 35 36 Assignment #1 Tamnla
