please show steps and formulas BSAM SAM - LoginC Ashcroft 72"...M Question 2 -...M Integrated Ex...b My Questions...how to avoid..BbExcelMcGraw Hill Excel Question - SavedSearch (Option + Q)FileHomeDrawFormulasDataReviewViewHelpO EditingInsertw/11 v B.00→.0CalibriabGeneral.00A1fx Accessibility tab summary: Financial information for Better Bottles, Incorporated, is presented in cells A4 to D10. A statement for requirenAВCEFH.I12Better Bottles, Inc., uses a periodic inventory system and has the following information available:3# of UnitsCost per UnitTotal CostDescriptionBeginning Inventory420$20.00$400.006.Jan. 15 Purchase2722.00594.007Jan. 20 Purchase3330.00990.008Goods Available for Sale80$1,984.009.Less: January Sales3610 Ending Inventory441112 Required:13 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO.1415 (Use cells A4 to D10 from the given information to complete this question.)16FIFO Ending Inventory# of Units1718DescriptionCost per UnitTotal Cost19 Jan. 20 Purchase20 Jan. 15 Purchase21442223FIFO Cost of Goods Sold24# of UnitsTotal CostDescription25 Beginning InventoryCost per Unit26 Jan. 15 Purchase273628A Graded WorksheetCalculation Mode: AutomaticWorkbook Statistics

First In, First Out: First In, First Out (FIFO) is a bookkeeping strategy wherein resources bought…

Better Bottles, Inc., uses a periodic inventory system and has the following information availa Description Beginning Inventory Cost per Unit Total Cost 20 27 # of Units $20.00 $400.00 Jan. 15 Purchase 22.00 594.00 Jan. 20 Purchase 33 30.00 990.00 80 36 44 Goods Available for Sale $1,984.00 Less: January Sales 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.) FIFO Ending Inventory Description # of Units Cost per Unit Total Cost Jan. 20 Purchase Jan. 15 Purchase 44