Please put in excel spreadsheet and please show formula and answers. Thank you.

unit cost to the nearess cent) and (b) cost of goods From the following, calculate the (a) cost of sold using the weighted-average method, FIFO, and LIFO (ending inventory shows 61 units). LU 18-1(2) m the following, calculate the (a) cost of ending inventory (round the average Cost per Number purchased Total unit $160 420 400 495 January 1 inventory40 April l June 1 50 November 1 18-2. Weighted average: 18-3. FIFO 18-4. LIFO rrom the following, (18-5 to 18-12) calculate the cost of ending inventory and cost of goods sold for the LIFO (18-13), FL (18-14, and weighted-average (18-15) methods (make sure to first find total cost to complete the table); ending inventory is 9 units: LU 18-1(2) Beginning inventory and purchases 18-. Beginning inventory, January 1 18- April 10 18-1. May 15 18. July 22 18. August 19 8-10. September 30 8-1. November 10 812. December 15 Units Unit cost $2.00 2.50 3.00 3.25 4.00 4.20 4.40 4.80 Total dollar cost 10 12 15 18 20 32 16 Cost of goods sold Cost of ending inventory