Pumpkin Hardware provides the following information relating to its June inventory activity. It uses a perpetual inventory system.

Date	Transaction	Units	Unit Cost	Total Cost
1-Jun	Inventory	13	$8.00	$104
7-Jun	Purchase	22	$9.50	$209
12-Jun	Sale	20
18-Jun	Purchase	10	$10.25	$102.50
20-Jun	Sale	14
26-Jun	Purchase	16	$11.00	$176
30-Jun	Sale	15

Compute the ending inventory and cost of goods sold using the FIFO, LIFO, AND, Weighted Average Cost costing method. Submit in excel with each method on a separate tab.