Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO and Weighted Average Cost methods. Make use of Excel/Sheets 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 Reference or given data section. MASTER RECORD - This should be calculated FIRST. Total Inventory January Sales Ending Inventory 80 36 These are the two cells you are solving for with each method of costing 0 E F D B Calculate the Ending Inventory and Cost of Goods Sold using Periodic FIFO FIFO Ending Inventory Description # of Units Cost per unit Total cost FIFO Cost of Goods Sold # of Units Cost per unit Description Total cost 7 B 30 30 31 Calculate the Ending Inventory and cost of Goods Sold using Periodic LIFO 32 33 34 35 36 37 38 ho 45 46 47 48 Calculate the Ending Inventory and Cost of Goods Sold using Periodic Weighted Average 50 51 52 53 54 55 56 57 58 59 60 62 69 66 58 70