A company provides the following inventory records.

Number of units sold =	8,5000
Selling price per unit =	$ 30.00

Date	Transaction	Number of Units	Unit Cost	Total Cost
January 1	Beginning inventory	1,200	$ 10.25	$ 12,300
March 12	Purchase	2,200	10.30	22,660
June 5	Purchase	2,700	10.40	28,080
October 22	Purchase	3,900	10.60	41,340
	Totals	10,000		$ 104,380

Required:

1. Based on the information given above, calculate cost of goods sold and ending inventory using the FIFO method.
2. Calculate cost of goods sold and ending inventory using the LIFO method.
3. Calculate cost of goods sold and ending inventory using the Weighted Average Method.
4. Calculate gross profit under all three methods.

Use the Open Excel in New Tab button to launch this question.

1. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.