complete the attached Spreadsheet and determine: i) Ending Inventory ii) Gross Profit Margin For both FIFO and MWA inventory costing methods (under perpetual). Rubric: 5 marks for each method including ending inventory and gross profit margin. 1 PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. P13 fx Enable B 1 A B D E F G H J K M 2 3 4 Date Received Sold 5 Quantity Cost Cost Amount Quantity Amount Quantity Balance Cost Amount 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Practice Problem (FIFO) | MWA Template Ready IU 11 A B C D E F G H K 12 13 14 15 16 17 18 Sales 19 20 21 22 23 24 Cost of Goods Sold: Cost of Goods Available Less Ending Inventory Cost of Goods Sold Gross Margin 25 26 27 28 29 30 21 > Practice Problem (FIFO) MWA Template + Ready 8C Sunny O Search fx the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A B C D E F G H eady 8C Sunny K M Date Received Sold Balance Quantity Cost Amount Quantity Cost Amount Quantity Cost Amount Sales Cost of Goods Sold: Cost of Goods Available Practice Problem (FIFO) MWA Template Search 22 23 1 PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. L35 fx Enable Ed A B C D E G Cost of Goods Sold: Cost of Goods Available Less Ending Inventory Cost of Goods Sold Gross Margin 24 25 26 Sales 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 13 Ready 8C Sunny Practice Problem (FIFO) MWA | Template | + Search K L35 PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. fx Enable Editing B D E F G H 3 4 Date Received Sold 5 Quantity Cost Amount Quantity Cost Amount Quantity Balance Cost Amount 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23