Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Sales Sale Price 10,100 units 27 Number of Date Beginning March 12 June 5 Units Unit Cost 1,700 10.30 Total Cost $ 17,510 2,900 10.20 29,580 1,600 10.10 16,160 October 22 5,600 9.90 55,440 Totals 11,800. $118,690 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