# of Units 2 3 4 Better Bottles, Inc., uses a periodic inventory system and has the following information available: Description 5 Beginning Inventory Cost per Unit Total Cost 20 $20.00 $400.00 6 Jan. 15 Purchase 27 22.00 594.00 7 Jan. 20 Purchase 33 30.00 990.00 8 Goods Available for Sale 80 $1,984.00 9 Less: January Sales 36 10 Ending Inventory 44 11 12 Required: 13 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. 14 15 (Use cells A4 to D10 from the given information to complete this question.) 16 17 FIFO Ending Inventory 18 Description 19 Jan. 20 Purchase 20 Jan. 15 Purchase 21 22 23 24 Description 25 Beginning Inventory 26 Jan. 15 Purchase 27 28 # of Units Cost per Unit Total Cost 33 $30.00 $990.00 110 22.00 242.00 44 $1,232.00 FIFO Cost of Goods Sold # of Units Cost per Unit Total Cost 200 $20.00 $400.00 16- 22.00 352.00 36 $752.00 29 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO. 30 31 (Use cells A4 to D10 from the given information to complete this question.) 32 33 34 LIFO Ending Inventory Description # of Units 35 Beginning Inventory 36 Jan. 15 Purchase 200 24 Cost per Unit $20.00 22.00 Total Cost $400.00 37 44 528.00 $928.00 38 39 LIFO Cost of Goods Sold 40 Description # of Units 41 Jan. 20 Purchase 42 Jan. 15 Purchase 33- 30 Cost per Unit 30.00 22.00 Total Cost $990.00 66.00 43 36 44 $1,056.00 45 3) Using Periodic Weighted Average, first calculate the cost per unit using the formula below. 46 Next, apply that same cost per unit to calculate both the Ending Inventory and Cost of Goods Sold. 47 48 (Use cells A4 to D10 from the given information to complete this question.) 49 50 51 Weighted Average Cost Cost of Goods Available for Sale Number of Units Available for Sale 52 + per unit G