1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods X FILE 5.a. HOME % Calibri INSERT PAGE LAYOUT Inventory costing methods - Excel FORMULAS DATA REVIEW ? x VIEW - 6 Sign In Paste B IU - -A- Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard D66 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: of Units 20 S $ Description 4 Beginning Inventory 5 Jan. 15 Purchase 6 Jan. 20 Purchase 7 Goods Available for Sale 8 Less: January Sales 9 Ending Inventory Cost per Unit 20.00 22.00 30,00 Total Cost 400.00 594,00 331 990.00 1.94.00 Bol 12 Required: 13 1) Calculate both the Ending Inventory and cost of Goods Sold using Periodic Firo. FIFO Ending Inventory of Units Cost per Unit 30.00 22.00 Description 17 Jan. 20 Purchase 18 Jan. 15 Purchase S Total Cost 990.00 242.00 1.232.00 $ FIFO Cost of Goods Sold of Units Cost per Unit 20 $ 20.00 Total Cost 400.00 $ Description 23 Beginning inventory Sheeti ... READY Attempt(s) Prev 1 of 7 Next >