PROBLEM More \& More Limited uses a periodic inventory system. The following additional information is available

c D E G F K L o p s Using Excel to Determine Periodic Inventory Costs PROBLEM More & More Limited uses a periodic inventory system. The following Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or to the work area asa licable. additional information is available: Units June 1 inventory June 15 purchase June 23 purchase Units sold 200 400 400 1 ,ooo 600 Unit Cost 12 14 15 Total Cost 2,400 5,600 6,000 14,000 a. b. C. Calculate the June 30 inventory and the June cost of goods sold, using the weighted average cost formula. Weighted average cost per unit Endin inventory Cost of goods sold Calculate the June 30 inventory and the June cost of goods sold, using the FIFO formula. Endin inventory Cost of goods sold Calculate the June 30 inventory and the June cost of goods sold, using the specific identification method assuming the following units were sold on June 24. Units Sold Unit Cost 200 $ 300 100 Ending inventory 12.00 14.00 15.00 Units from June 1 inventory Units from June 15 inventory Units from June 23 inventory Cost of goods sold Units from June 1 inventory Units from June 15 inventory Units from June 23 inventory