Can you answer this on excel

END-OF-CHAPTER PROBLEMS connect Check figures for odd-numbered problems in Appendix B. Name Date DRILL PROBLEMS 18-1. Using the specific identification method, calculate (a) the cost of ending inventory and (b) the cost of goods sold given the following: LU 18-1(2) Date Units purchased Cost per unit Ending inventory June 1 15 Echo Show's 360 $275 2 Echo Show's from June July 1 45 Echo Show's 360 250 15 Echo Show's from July August 1 60 Echo Show's 360 240 12 Echo Show's from August From the following, calculate the (a) cost of ending inventory (round the average unit cost to the nearest cent) and (b) cost of goods sold using the weighted-average method, FIFO, and LIFO (ending inventory shows 61 units). LU 18-1(2) Number Cost per purchased unit Total January 1 inventory 40 $4 $160 April 1 60 420 June 1 50 400 November 1 55 495 18-2. Use weighted average: 18-3. Use FIFO: 18 4. Use LIFO: From the following (18-5 10 18-12), calculate the cost of ending inventory and cost of goods sold for the LIFO (18-13), FIFO (18-14), and weighted-average (18-15) methods (make sure to first find total cost to complete the table); ending inventory is 49 units: LU 18-1(2) 483