THE ONES CIRCLED IN PINK ARE WRONG PLEASE HELP GET ONLY THOSE RIGHT

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