Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 18,500 units 27 Date Beginning March 12 June 5 October 22 Totals Number of Units 4,100 5,300 4,000 9.200 22,600 Unit Cost 10.30 10.20 10.10 9.90 Total Cost $ 42, 230 54,060 40,400 91,080 $227,770 Required: 1. Use your spreadsheet to recalculate the cost of Goods Sold, Inventory balances, and Gross Profit under each method and enter your results below: (Round your answers to the nearest whole dollar amount.) FIFO LIFO Weighted Average Cost of Goods Sold Ending Inventory Gross Profit