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 Units Unit Cost Beginning March 12 1,700 10.30 2,900 10.20 Total Cost $ 17,510 29,580 June 5 1,600 10.10 16,160 October 22 5,600 9.90 Totals 11,800 55,440 $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 Cost of Goods Sold Ending Inventory Gross Profit Weighted Average