Beginning inventory Purchases: Sales #1 #2 #3 E F Units Unit cost 1,000 $4.00 1,200 $5.00 1,600 $6.00 800 $8.

so this is already an excel sheet I had already filled earlier.

can I get help with the following calculation of the ending inventory and cost of goods sold using each of the following inventory methods:

a. FIFO

b. LIFO

c. Average cost

this is how I started it but now I'm stuck and don't know what to do