Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. K Sales Sale Price 15,000 units 27 ces Number of Date Units Unit Cost Total Cost Beginning 3,100 10.30 $31,930 March 12 4,300 10.201 43,860 June 5 3,000 10.10 30,300 October 22 7,700 9.90 Totals 18,100 76,230 $182,320 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 $ 108,970 $ 108,210 $ 108,663 Ending Inventory 18,810 19,570 15.092 Gross Profit 182,630 183,390 182,937