Excel accounting practice.

1 Better Bottles, Inc., uses a dic tory system and has the following information ava ila ble: Description # of Units Cost per Unit Total Cost 4 Beginning Inven 5 Jan. 15 Purchase 6 Jan. 20 Purchase 7 Goods Available for Sale 8 Less: January Sales 9 Ending Inv 10 400.00 594.00 990.00 1984.00 20.00 S 22.00 30.00 36 12 Required: 131] Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. 15 FIFO Ending Invento # of Units Cost per Unit Total Cost 17 Jan. 20 Purchase 18 Jan. 15 Purchase 19 20 21 FIFO Cost of Goods Sold # of Units Cost per Unit Total Cost 23 24 Jan. 15 Purchase 25 26 27 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO. 28 29 30 31 Beginning Inventor 32 Jan. 15 Purchase inning Inventor 36 LIFO Ending Invento Description # of Units Cost per Unit Total Cost Weighted Average Ending Inven 48 49 # of Units Cost Unit Total Cost 51 Weighted Average Cost of Goods Sold Cost per Unit # of Units Total Cost 54 56 4) Use the given information and your calculated numbers to complete the Cost of Goods Sold 57Equation below for all three inventory methods. (All numbers should be positive 58 59 Beginning Inventor 60 Add: Purcha ses 61 Goods Available for Sale 62 Less: Ending Invento 63 Cost of Goods Sold FIFO LIFO Wtd