I also need the ending inventory and costs of goods sold for periodic LIFO and periodic weighted average - Thank you!

D E F G H I J K L M N O P 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 1 available: 2 Description # of Units Cost per unit | Total cost 3 Beginning inventory 20 $ 20.00 4 Jan 15 purchase 27 $ 22.00 5 Jan 20 purchase 33 $ 30.00 6 Goods available for sale 7 January Sales 8 Ending Inventory 9 Reference or given data section. 13 Calculate the Ending Inventory and Cost of Goods Sold using Periodic FIFO 14 15 FIFO Ending Inventory Description #of Units Cost per unit Sample header for schedule in answer section. Total cost FIFO Cost of Goods Sold # of Units Cost per unit Description Total cost