Bay Path Hardware provides the following information relating to its June inventory activity. Hahn 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.