7.00 During October hadin beginning inventor 2.000 of Marilynn's CDs with a unit oor Doom's Day made the following purchases of Marilynn's CDs. 13- 113000 $800 19-Oct5.500 lluns 19.00 18-t 4 .000 units at 25- 2000 units at 11.00 10.00 During October 13,500 units were sold. Doom's Day uses a periodic inventory system. (a) Determine the cost of goods available for sale. Date: Quantity Unit Costxtended Cos Bil 2 000 units at $7.00 $14.000 3-Oct 3.000 units at $8.00 24000 9-Oct5.500 units at $9.00 49,500 18-Dot 4.000 units $10.00 40.000 125-Oci 2000 units at $11.00 22.000 Pentia 16500 Cost of goods wailable 149500 2016 (1) Determine the ending inventory and cost of goods sold under the First-in. First-out cost flow method Prove the accuracy of the cost of goods sold Ending Inventor Date Units Unit Referenceference Reference Reference Formula Reference Formula Total Formula Formula Formulal Cost of Goods Sold Cost of goods available for bference Less Tale Cost of Goods Sold Formula BENESS Proof of Cost of Goods Sold Date Units UnitTotalCost Reference Reference Reference Reference Reference Reference Form Reference Reference Reference Reference Foam Reference Formal 41 46 (2) Determine the ending inventory and cost of goods sold under the Last-in. First-out cost flow method Prove the accuracy of the cost of goods sold Ending Inventory Date Units Unit Referenceerence Reference Referenc Formula Reference Formula Total Force Form Form Cost of Good Sold Cort of goods available foreference B erence Tale Formular The SA 888 Proof of Cost of Goods Sold Date Units Unit To Cost Rolerende Peterence Reference Pelerence Reference Reference Formula Reference Reference Reference Formula Reference For Reference Form Formula (b)(3) Determine the ending inventory and cost of goods sold under the Average Cost cost flow method Lot un purchased cort Title Average unit on B eference Reference Set to the decimal places) Chapter 6 Excel Formula Proof of Cost of Goods Sold Date Units Unit Belereno Reference Reference Reference Reference Reference Reference for Reference Formula Bere nin Formula (b)(2) Determine the ending inventory and cost of goods sold under the Latin First-out cost how method. Prove the scouracy of the cost of goods sold Endine Inventory Date Units Unit Referenceference Reference Referend Formula Reference Formula Cost of Goods Sold Cost of goods available for eference leference Formula Total Formula Formula Formule Title Proof of Cost of Goods Sold Date Units UnitTotal Cost Reference Reference Reference Formula Reference Reference Reference Formula Reference Reference Reference Reference Dus Reference Formu Formula (b)(3) Determine the ending inventory and cost of goods sold under the Average Cost cost flow method Total units purchased cost: Refere Title 1 Average unit cost Formala (Set to three decimal places) Ending inventory quantity Ending inventory value Cost of goods sold Cost of goods available for sale Formula Formule Formula T o Which oost flow method results in the highest inventory amount for the balance sheet? Why Ester test ansver here. To which cost How method results in the highest cost of goods sold for the income statement? Why? Enter text answerhede