Assuming that you only sold the 12,000 cases and that that was the only selling and happen the same day
FIFO
Date... Purchases... Cost of goods sold... Inventroy
1/1... Beginning inventory... 5000@4= $20,000
1/10... 3000@5= $15,000... 5000@4= $20,000
... 3000@5= $15,000
2/13...
[email protected]= $36,000... 5000@4= $20,000
... 3000@5= $15,000
...
[email protected]=$36,000
3/5... 2000@5= $10,000... 5000@4= $20,000
... 3000@5= $15,000
...
[email protected]= $36,000
... 2000@5= $10,000
Sales... 5000@4=$20,000...
[email protected]=$18,000
... 3000@5=$15,000... 2000@5=$10,000
...
[email protected]=$18,000...
The cost of goods sold under FIFO is $53,000, the ending inventory is $28,000, the gross profit is $67,000
LIFO
Date... Purchases... Cost of goods sold... Inventroy
1/1... Beginning inventory... 5000@4= $20,000
1/10... 3000@5= $15,000... 5000@4= $20,000
... 3000@5= $15,000
2/13...
[email protected]= $36,000... 5000@4= $20,000
... 3000@5= $15,000
...
[email protected]=$36,000
3/5... 2000@5= $10,000... 5000@4= $20,000
... 3000@5= $15,000
...
[email protected]= $36,000
... 2000@5= $10,000
Sales... 2000@5=$10,000... 5000@4= $20,000
...
[email protected]=$36,000... 1000@5= $5,000
... 2000@5= $10,000...
The cost of goods sold under FIFO is $56,000, the ending inventory is $25,000, the gross profit is $64,000
Weight Average
Date... Purchases... Cost of goods sold... Inventroy
1/1... Beginning inventory... 5000@4= $20,000
1/10... 3000@5= $15,000... 5000@4= $20,000
... 3000@5= $15,000
2/13...
[email protected]= $36,000... 5000@4= $20,000
... 3000@5= $15,000
...
[email protected]=$36,000
3/5... 2000@5= $10,000... 5000@4= $20,000
... 3000@5= $15,000
...
[email protected]= $36,000
... 2000@5= $10,000
... avg. cost $4.5
Sale...
[email protected]=$54,000...
[email protected]=$27,000
The cost of goods sold under the weight average is $54,000, the ending inventory is $27,000, the gross profit is $66,000
Hope this could help you