Question

Some of the information found on a detail inventory card for Metlock Inc. for the first month of operations is as follows. Da
From these data compute the ending inventory on each of the following bases. Assume that perpetual inventory records are kept
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Received
Date Unit Cost per unit Total cost
a b a*b
Jan 2. 1700 3.84 6528
Jan 10. 1100 4.1 4510
Jan 18. 1500 4.22 6330
Jan 23. 1800 4.35 7830
Jan 28. 2100 4.48 9408
8200 34606
Average cost per unit=34606/8200=$ 4.22
Ending inventory in units=1000 units
FIFO:
Goods purchased first are sold first
Hence,ending inventory of 1000 units consist of last purchase (Jan 28.)
Ending inventory=1000*4.48=$ 4480
LIFO:
Goods purchased last are sold first
Hence,ending inventory of 1000 units consist of first purchase (Jan 2)
Ending inventory=1000*3.84=$ 3840
Average-cost:
Ending inventory=Units in inventory*Average cost per unit=1900*4.22=$ 8018
FIFO:
Would amount be same ? Yes
Under FIFO method,Goods purchased first are sold first.
Purchases Cost of goods sold Ending inventory
# of units Cost per unit Total cost # of units sold Cost per unit Cost of merchandise sold Ending inventory
Jan 2. 1700 3.84 6528 1700 3.84 6528
Jan 7. 1200 units issued as follows: 500 3.84 1920
1200 3.84 4608
Jan 10. 1100 4.1 4510 500 3.84 1920
1100 4.1 4510
Jan 13. 1000 units issued as follows:
500 3.84 1920 600 4.1 2460
500 4.1 2050 (1100-500)
(1000-500)
Jan 18. 1500 4.22 6330 800 units issued as follows: 1300 4.22 5486
600 4.1 2460 (1500-200)
200 4.22 844
(800-600)
Jan 20. 1100 units issued as follows: 200 4.22 844
1100 4.2 4620 (1300-1100)
Jan 23. 1800 4.35 7830 200 4.22 844
1800 4.35 7830
Jan 26. 1300 units issued as follows: 700 4.35 3045
200 4.22 844 (1800-1100)
1100 4.35 4785
(1300-200)
Jan 28. 2100 4.48 9408 700 4.35 3045
2100 4.48 9408
Jan 31. 1800 units issued as follows: 1000 4.48 4480
700 4.35 3045 (2100-1000)
1100 4.48 4928
(1800-700)
Total

Add a comment
Know the answer?
Add Answer to:
Some of the information found on a detail inventory card for Metlock Inc. for the first month of operations is as...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Some of the information found on a detail inventory card for Oriole Inc. for the first...

    Some of the information found on a detail inventory card for Oriole Inc. for the first month of operations is as follows. Date January 2 5.06 Received Issued, Balance, No. of Units Unit Cost No. of Units No. of Units 1,700 $4.74 1,700 1.200 500 1,100 1,600 1,000 600 1,500 5.21 800 1,300 1,100 1,800 5.37 2.000 1,300 700 2,100 5.53 2.800 1,800 1,000 200 Calculate average cost per unit. (Round answer to 2 decimal places, e.g. 2.76.) Average-cost per...

  • Some of the information found on a detail inventory card for Oriole Inc. for the first...

    Some of the information found on a detail inventory card for Oriole Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Units January     2 1,700 $4.74 1,700 7 1,200 500 10 1,100 5.06 1,600 13 1,000 600 18 1,500 5.21 800 1,300 20 1,100 200 23 1,800 5.37 2,000 26 1,300 700 28 2,100 5.53 2,800 31 1,800 1,000 Calculate average-cost per unit. (Round answer to...

  • Some of the information found on a detail inventory card for Novak Inc. for the first...

    Some of the information found on a detail inventory card for Novak Inc. for the first month of operations is as follows. If the perpetual inventory record is kept in dollars, and costs are computed at the time of each withdrawal, would the amounts shown as ending inventory in (1)FIFO, (2)LIFO, and (3)Average Cost above be the same? What amount would be shown as ending inventory? (Round average cost per unit to 4 decimal places, e.g. 2.7621 and final answers...

  • Some of the information found on a detail inventory card for Shamrock Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Un...

    Some of the information found on a detail inventory card for Shamrock Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Units January 2 1,300 $4.38 1,300 7 800 500 10 700 4.67 1,200 13 600 600 18 1,100 4.82 400 1,300 20 1,100 200 23 1,400 4.96 1,600 26 900 700 28 1,700 5.11 2,400 31 1,400 1,000 Calculate average-cost per unit. (Round answer...

  • Some of the information found on a detail inventory card for Ayayai Inc. for the first...

    Some of the information found on a detail inventory card for Ayayai Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Units January 2 1,600 $3.75 1,600 7 1,100 500 10 1,000 4.00 1,500 13 900 600 18 1,400 4.13 700 1,300 20 1,100 200 23 1,700 4.25 1,900 26 1,200 700 28 2,000 4.38 2,700 31 1,700 1,000 If the perpetual inventory record is...

  • Some of the information found on a detail inventory card for Tamarisk Inc. for the first month of operations is as follo...

    Some of the information found on a detail inventory card for Tamarisk Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Units January     2 1,300 $4.38 1,300 7 800 500 10 700 4.67 1,200 13 600 600 18 1,100 4.82 400 1,300 20 1,100 200 23 1,400 4.96 1,600 26 900 700 28 1,700 5.11 2,400 31 1,400 1,000 1a) Calculate average-cost per unit. 1b) From...

  • Problem 8-05 (Part Level Submission) Some of the information found on a detail inventory card for...

    Problem 8-05 (Part Level Submission) Some of the information found on a detail inventory card for Coronado Inc. for the first month of operations is as follows. Received No. of Units 1,400 Date Issued, No. of Units Unit Cost $4.02 January 2 900 800 4.29 Balance, No. of Units 1,400 500 1,300 600 1,300 200 1,700 700 2,500 1,000 1,200 700 500 1,100 4.42 1,500 4.56 1,000 1,800 4.69 1,500 (b) Your answer is partially correct. Try again. If the...

  • Some of the information found on a detail inventory card for Buffalo Inc. for the first...

    Some of the information found on a detail inventory card for Buffalo Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Units January 2 1,600 $5.10 1,600 7 1,100 500 10 1,000 5.44 1,500 13 900 600 18 1,400 5.61 700 1,300 20 1,100 200 23 1,700 5.78 1,900 26 1,200 700 28 2,000 5.95 2,700 31 1,700 1,000 Calculate average-cost per unit. (Round answer...

  • Some of the information found on a detail inventory card for Tamarisk Inc. for the first...

    Some of the information found on a detail inventory card for Tamarisk Inc. for the first month of operations is as follows. Received Date No. of Units Unit Cost Issued, No. of Units Balance, No. of Units January     2 1,300 $4.38 1,300 7 800 500 10 700 4.67 1,200 13 600 600 18 1,100 4.82 400 1,300 20 1,100 200 23 1,400 4.96 1,600 26 900 700 28 1,700 5.11 2,400 31 1,400 1,000 Calculate average-cost per unit. (Round answer...

  • I just need to figure out what the moving average cost is for the ending inventory....

    I just need to figure out what the moving average cost is for the ending inventory. And if you could include an explanation in how you found the average cost on the 18th that would be great because so far I have this. Just so I can understand how to determine the avg cost for a date that has both a purchase and selling of goods. Date Buy COGS UNITS AVG Cost Inventory Cost 2 1700*3.39 0 1700 3.39 5763...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT