Ask Experts Questions for FREE Help!
 

Free Answers in 3 Easy Steps

Register Now
3 Steps
 


Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.
  Answer this Question    Ask about Accounting    Ask about another Subject  
 

laila25
Nov 27, 2007, 06:41 AM
During the first quarter of 20xx, Taube Company sold 12,000 cases of Product T for $120,000. Facts related to its beginning inventory and purchases are as follows:
For the quarter ended March 31, 20xx, compute the ending inventory, cost of goods sold, and gross profit under three methods: (a) average-cost, (b) FIFO, and (c) LIFO. (Show your work.)

qcmar24
Nov 27, 2007, 12:32 PM
During the first quarter of 20xx, Taube Company sold 12,000 cases of Product T for $120,000. Facts related to its beginning inventory and purchases are as follows:
For the quarter ended March 31, 20xx, compute the ending inventory, cost of goods sold, and gross profit under three methods: (a) average-cost, (b) FIFO, and (c) LIFO. (Show your work.)
ok in order for me to help you need to include in your post the beginning invnetory balance and its value, also you need to inclued any purchased or selling of any merchandise inventory.

laila25
Nov 27, 2007, 01:00 PM
jan 1 beginning inventory 5000 cases@<hidden>
10 purchases 3000 cases@<hidden>
feb 13 purchases 8000 cases@<hidden>
mar 5 purchases 2000 cases@<hidden>

qcmar24
Nov 27, 2007, 02:03 PM
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