Word Problem 18-30 (Static) [LU 18-1 (1,2)] Increased and volatile demand combined with constrained supply challenged the supply chain during the pandemic. A spokesperson for Clorox stated demand for Clorox wipes increased 500% during the pandemic, as reported by CNN Business. If your local grocery store had the following Clorox wipes stock, calculate cost of ending inventory and cost of goods sold using the weighted-average method, FIFO, and LIFO. Ending inventory is 5 units. Note: Round your intermediate calculations and final answers to the nearest cent. Inventory Beginning inventory Purchase March 1 Purchase April 1 Purchase June 1 Purchase November 1 Number of units Cost per unit Total cost 60 $ 4.50 $ 270.00 25 4.75 118.75 5 6.25 2 10.25 31.25 20.50 12 8.90 106.80 104 $ 547.30 Ending Cost of inventory goods sold Weighted-average FIFO LIFO