Better Bottles, Inc., uses a periodic inventory system and has the following information available: Description Beginning...

Transcribed Image Text:

Better Bottles, Inc., uses a periodic inventory system and has the following information available: Description Beginning Inventory Jan. 15 Purchase Jan. 20 Purchase Goods Available for Sale Less: January Sales # of Units Cost per Unit Total Cost 20 $20.00 $400.00 27 22.00 594.00 33 30.00 990.00 80 $1,984.00 36 44 Ending Inventory Required: 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. (Use cells A4 to D10 from the given information to complete this question.) Description Jan. 20 Purchase Jan. 15 Purchase FIFO Ending Inventory # of Units Cost per Unit Total Cost 44 Description Beginning Inventory Jan. 15 Purchase FIFO Cost of Goods Sold # of Units 36 Cost per Unit Total Cost 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO. (Use cells A4 to D10 from the given information to complete this question.) Description Beginning Inventory Jan. 15 Purchase LIFO Ending Inventory # of Units Cost per Unit Total Cost 44 LIFO Cost of Goods Sold Description # of Units Jan. 20 Purchase Jan. 15 Purchase 36 Cost per Unit Total Cost 3) Using Periodic Weighted Average, first calculate the cost per unit using the formula below. Next, apply that same cost per unit to calculate both the Ending Inventory and Cost of Goods Sold. (Use cells A4 to D10 from the given information to complete this question.) Weighted Average Cost = Cost of Goods Available for Sale Number of Units Available for Sale Weighted Average Ending Inventory # of Units Cost per Unit Total Cost # of Units Weighted Average Cost of Goods Sold Cost per Unit Total Cost per unit 4) Use the given information and your calculated numbers to complete the Cost of Goods Sold Equation below for all three inventory methods. (All numbers should be positive.) (Use cells A4 to D10 from the given information to complete this question.) Beginning Inventory Add: Purchases Goods Available for Sale Less: Ending Inventory Cost of Goods Sold FIFO LIFO Wtd. Avg. Better Bottles, Inc., uses a periodic inventory system and has the following information available: Description Beginning Inventory Jan. 15 Purchase Jan. 20 Purchase Goods Available for Sale Less: January Sales # of Units Cost per Unit Total Cost 20 $20.00 $400.00 27 22.00 594.00 33 30.00 990.00 80 $1,984.00 36 44 Ending Inventory Required: 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. (Use cells A4 to D10 from the given information to complete this question.) Description Jan. 20 Purchase Jan. 15 Purchase FIFO Ending Inventory # of Units Cost per Unit Total Cost 44 Description Beginning Inventory Jan. 15 Purchase FIFO Cost of Goods Sold # of Units 36 Cost per Unit Total Cost 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO. (Use cells A4 to D10 from the given information to complete this question.) Description Beginning Inventory Jan. 15 Purchase LIFO Ending Inventory # of Units Cost per Unit Total Cost 44 LIFO Cost of Goods Sold Description # of Units Jan. 20 Purchase Jan. 15 Purchase 36 Cost per Unit Total Cost 3) Using Periodic Weighted Average, first calculate the cost per unit using the formula below. Next, apply that same cost per unit to calculate both the Ending Inventory and Cost of Goods Sold. (Use cells A4 to D10 from the given information to complete this question.) Weighted Average Cost = Cost of Goods Available for Sale Number of Units Available for Sale Weighted Average Ending Inventory # of Units Cost per Unit Total Cost # of Units Weighted Average Cost of Goods Sold Cost per Unit Total Cost per unit 4) Use the given information and your calculated numbers to complete the Cost of Goods Sold Equation below for all three inventory methods. (All numbers should be positive.) (Use cells A4 to D10 from the given information to complete this question.) Beginning Inventory Add: Purchases Goods Available for Sale Less: Ending Inventory Cost of Goods Sold FIFO LIFO Wtd. Avg.