solve the problem by looking at the given information and show formulas and calculations ...... AВDF2829 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO.3031 (Use cells A4 to D10 from the given information to complete this question.)32LIFO Ending Inventory# of Units3334Total CostDescription35 Beginning InventoryCost per Unit36Jan. 15 Purchase37443839LIFO Cost of Goods Sold40Description# of UnitsCost per UnitTotal Cost41 Jan. 20 Purchase42 Jan. 15 Purchase43364445 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.4748 (Use cells A4 to D10 from the given information to complete this question.)4950Cost of Goods Available for SaleWeighted Average Cost =%3D51Number of Units Available for Saleper unit52 FileHomeInsertDrawFormulasDataReviewViewHelpO EditingCalibriV 11GenВ35fxABCEF1Better Bottles, Inc., uses a periodic inventory system and has the following information available:34# of UnitsTotal CostDescriptionBeginning InventoryCost per Unit20$20.00$400.006.Jan. 15 Purchase2722.00594.007Jan. 20 Purchase3330.00990.008Goods Available for Sale80$1,984.00Less: January Sales10 Ending Inventory9.36441112 Required:

Name: solve the problem by looking at the given information and show formula
Uploaded: 2022-11-21T18:53:23.000Z
Channel: Bartleby
Description: solve the problem by looking at the given information and show formulas and calculations ...... AВDF2829 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO.3031 (Use cells A4 to D10 from the given information to complet