Lost of ending inventory and cost of goods sold using period functione ne poeeible B C D 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 331 $ 30.00 2. 3 4 5 6 7 January Sales Ending Inventory 36 8 9 10 11 N