Help 1. Calculate cost of ending Inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average cost methods. ? - X H B5. 7: Inventory costing methods - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 AN De- Paste B T U . 3- A. Alignment Number Conditional Format as. Cell. Formatting" Table Styles Clipboard Font 6 Sign in Cells Editing Styles X Better Bottles, Inc., uses a periodic inventory system and has the following Better Bottles, Inc., uses a periodic inventory system and has the following information available: # of Units Description 4 Beginning Inventory 5 Jan. 15 Purchase 6 Jan. 20 Purchase 7 Goods Available for Sale 8 Less: January Sales 9 Ending Inventory 10 Cost per Unit 20 S 20.00 $ 22.00 30.00 $ Total Cost 400.00 594.00 990.00 1,984.00 12 Required: 13 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. FIFO Ending Inventory # of Units Cost per Unit T otal Cost Description 17 Jan. 20 Purchase 18 Ian 15 Purchase