This is one question.

1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods. ? 6 * XE H 5 FILE , 15 HOME INSERT Inventory costing methods - Excel FORMULAS DATA REVIEW - 8 Sign In PAGE LAYOUT VIEW B I U - - aste Clipboard - A - Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Font H15 1 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 Cost per Unit 20$ 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 Jan. 15 Purchase FIFO Cost of Goods Sold # of Units Cost per Unit Total Cost Description 23 Beginning Inventory 24 Jan. 15 Purchase 54) Use the given information and your calculated numbers to complete the Cost of Goods Sold 7 Equation below for all three inventory methods. All numbers should be positive.) FIFO LIFO Wtd. Avg. Beginning Inventory Add: Purchases Goods Available for Sale 2 Less: Ending Inventory 3 Cost of Goods Sold