you will practice using absolute cell referencing, the MIN function, and formulas to calculate and compare the effects of the LIFO, FIFO, and the Weighted Average inventory costing methods.

(pls help me i cant do this anymore)

Chapter 6 Homework Seved Help Say 13 Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. 10 points Sales Sale Price 19,900 units 27 eBook Date Beginning March 12 June 5 October 22 Totals Number of Units 4,500 5,700 4.400 9,800 24,480 Unit Cost 10.30 10.20 10.10 9.90 Total Cost $ 46,350 58,140 44,440 97,020 $245,950 References 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