ces FILE Paste A1 L Clipboard 5 HOME Calibri BI U- READY INSERT V I Description 8 Less: January Sales 9 Ending Inventory 10 3 4 Beginning Inventory 5 Jan. 15 Purchase 6 Jan. 20 Purchase 7 Goods Available for Sale 16 17 Jan. 20 Purchase 18 Jan. 15 Purchase 19 20 21 22 23 Beginning Inventory 24 Jan 15 Duroboro > Description F Font Description Sheet1 11 PAGE LAYOUT A A A Y fx A 8 B 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: 2 G Inventory costing methods - Excel FORMULAS DATA % Alignment Number # of Units 20 $ 27 33 80 36 44 Better Bottles, Inc., uses a periodic inventory system and has the following 11 12 Required: 13 1) Calculate both the Ending Inventory and Cost of Goods Soni using Periodic FIFO. 14 15 FIFO Ending Inventory # of Units 44 Cost per Unit 20.00 22.00 30.00 FIFO Cost of Goods # of Units Cost REVIEW Conditional Format as Cell Cells Editing Table Styles Formatting Styles Sold per Unit Cost per Unit $ $ VIEW D Total Cost 400.00 594.00 990.00 1,984.00 Total Cost Total Cost 0 ? H E Sign In A 100% F X