B D E F Refere data s Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO and Weighted Average Cost methods. Make use of Excel capabilities by using as many formulas and functions as possible. Better Bottles, Inc. uses a periodic inventory system and has the following information available: Description # of Units Cost per unit Total cost Beginning inventory 20 $ 20.00 Jan 15 purchase 27 $ 22.00 Jan 20 purchase 33 $ 30.00 MASTE 2 3 4 5 6 7 36 January Sales Ending Inventory 8 9 10 11 12 13 14 Calculate the Ending Inventory and Cost of Goods Sold using Periodic Sample hea in answer se FIFO Ending Inventory Description # of Units Cost per unit Total cost 15 16 17 18 19 n.com/d21/common/dialogs/quickLink/quickLink.d2l?ou=1... REQUIRED FOR POINTS: Complete the master inventory record as the data or information section. Reference that for each method. Complete the inventory calculation tables documenting details of ending inventory and cost of goods sold for each of the 3 costing methods. Numerous examples have been provided throughout chapter 7 as a reference. One reference can be found in the e-text through the demonstration case starting on page 323. Link or reference back to the description, units and cost. Be sure you download or make a copy before making any changes. Include your name in file title. (Excel or Sheets) Basic project directions contain videos or additional help. Reach out if questions. schedule 10 11 12 13 14 Calculate the Ending Inventory and Cost of Goods Sold using Periodic Sample header for sc in answer section. FIFO Ending Inventory Description # of Units Cost per unit Total cost 15 16 17 18 19 20 21 FIFO Cost of Goods Sold # of Units Cost per unit 22 Description Total cost 23 24 25 26 27 Calculate the Ending Inventory and Cost of Goods Sold using Periodic LIFO 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Calculate the Ending Inventory and Cost of Goods Sold using Periodic Weighted Average 42 43 44 45 46 47