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..... Begining inventory..................................................5000@<hidden>= $20,000
1/10...3000@<hidden>= $15,000....................................................5000@<hidden>= $20,000
.......................................................................................3000@<hidden>= $15,000
2/13...8000@<hidden>= $36,000.................................................5000@<hidden>= $20,000
.......................................................................................3000@<hidden>= $15,000
.......................................................................................8000@<hidden>=$36,000
3/5...2000@<hidden>= $10,000.....................................................5000@<hidden>= $20,000
.......................................................................................3000@<hidden>= $15,000
.......................................................................................8000@<hidden>= $36,000
.......................................................................................2000@<hidden>= $10,000
Sales.........................................5000@<hidden>=$20,000.............4000@<hidden>=$18,000
.................................................3000@<hidden>=$15,000.............2000@<hidden>=$10,000
.............................................. 4000@<hidden>=$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..... Begining inventory..................................................5000@<hidden>= $20,000
1/10...3000@<hidden>= $15,000....................................................5000@<hidden>= $20,000
.......................................................................................3000@<hidden>= $15,000
2/13...8000@<hidden>= $36,000.................................................5000@<hidden>= $20,000
.......................................................................................3000@<hidden>= $15,000
.......................................................................................8000@<hidden>=$36,000
3/5...2000@<hidden>= $10,000.....................................................5000@<hidden>= $20,000
.......................................................................................3000@<hidden>= $15,000
.......................................................................................8000@<hidden>= $36,000
.......................................................................................2000@<hidden>= $10,000
Sales........................................2000@<hidden>=$10,000..............5000@<hidden>= $20,000
..............................................8000@<hidden>=$36,000.............1000@<hidden>= $5,000
..............................................2000@<hidden>= $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..... Begining inventory..................................................5000@<hidden>= $20,000
1/10...3000@<hidden>= $15,000....................................................5000@<hidden>= $20,000
.......................................................................................3000@<hidden>= $15,000
2/13...8000@<hidden>= $36,000.................................................5000@<hidden>= $20,000
.......................................................................................3000@<hidden>= $15,000
.......................................................................................8000@<hidden>=$36,000
3/5...2000@<hidden>= $10,000.....................................................5000@<hidden>= $20,000
.......................................................................................3000@<hidden>= $15,000
.......................................................................................8000@<hidden>= $36,000
.......................................................................................2000@<hidden>= $10,000
.......................................................................................avg. cost $4.5
Sale............................................12000@<hidden>=$54,000.......6000@<hidden>=$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