Question
having a little trouble with this problem, can someone figure it out?

chronological order, calculating new inventory on hand balances after each transaction. Once allo em 0 Requirements Х ind nou
SE T, calculating new inventory on hand culate the quantity and total cost of merchandise inventory pure 1 More Info C Jul. 2
Requirement 2. Determine the amount that would be reported in ending merchandise inventory on July 15 using the LIFO inventor
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1) Inventory valuation under FIFO method :

Date Purchases Purchases Purchases COGS COGS COGS Inventory on hand Inventory on hand Inventory on hand
Quantity unit cost Total cost Quantity Unit cost Total Cost Quantity Unit cost Total cost
July 2 10 1.60 16.0 10 1.60 16.00
July 6 2 1.90 3.80

10

2

1.60

1.90

16.00

3.80

July 8 4 1.60 6.40

6

2

1.60

1.90

9.60

3.80

July 13 2 2.35 4.70

6

2

2

1.60

1.90

2.35

9.60

3.80

4.70

July 14 4 1.60 6.40

2

2

2

1.60

1.90

2.35

3.20

3.80

4.70

Total 14 24.50 8 12.80 6 $ 11.70

2) Inventory valuation under LIFO method :

Date Purchases Purchases Purchases COGS COGS COGS Invenyory on hand inventory on hand   Inventory on hand
Quantity Unit cost Total cost Quantity Unit cost Total cost Quantity Unit cost Total cost
July 2 10 1.60 16.00 10 1.60 16.00
July 6 2 1.90 3.80

10

2

1.60

1.90

16.00

3.80

July 8

2

2

1.90

1.60

3.80

3.20

8 1.60 12.80
July 13 2 2.35 4.70

8

2

1.60

2.35

12.80

4.70

July 14

2

2

2.35

1.60

4.70

3.20

6 1.60 9.60
Total 14 24.50 8 14.90 6 $ 9.60

3) Inventory valuation under Weighted average Method:

Weighted Average cost per unit of inventory = Total purchase cost / Total purchased units

Weighted average cost per unit of inventory = $ 24.50 / 14 = $ 1.75

Total units sold = 8

Cost of goods sold = $ 1.75 X 8 = $ 14

Ending inventory ( Units) = Total units purchased - Total units sold = 14 - 8 = 6 units

Ending inventory ( in dollars ) = 6 X $ 1.75 = $ 10.50

If you understand the above solution please give me a like ( Upward rating) . Please .

Add a comment
Know the answer?
Add Answer to:
having a little trouble with this problem, can someone figure it out? chronological order, calculating new...
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
  • I am having a hard time with Fifo/Lifo and am confused how to finish this. Inside...

    I am having a hard time with Fifo/Lifo and am confused how to finish this. Inside Track, a regional convenience store chain, maintains milk inventory by the gallon. The first month's milk purchases and sales at its Denver, Colorado, location follow: (Click the icon to view the purchases and sales.) Read the requirements.? Ele-15 Requirement 1. Determine the amount that would be reported in ending merchandise inventory on May 15 using the FIFO inventory costing method. Enter the transactions in...

  • Requirement 3. Determine the amount that would be reported in ending merchandise inventory on May 15...

    Requirement 3. Determine the amount that would be reported in ending merchandise inventory on May 15 using the weighted average inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter all amounts to the nearest cent, $X.XX.) Fast Mart,...

  • 1. 2. Requirement 2. Determine the amount that would be reported in ending merchandise inventory on...

    1. 2. Requirement 2. Determine the amount that would be reported in ending merchandise inventory on May 15 using the LIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter all amounts to the nearest cent, $X.XX. Enter...

  • please clean graph preferred to be typed, please Fast Mart, a regional convenience store chain, maintains...

    please clean graph preferred to be typed, please Fast Mart, a regional convenience store chain, maintains milk inventory by the gallon. The first month's milk purchases and sales at its Old Saybrook, Connecticut, location follow: i (Click the icon to view the purchases and sales.) Read the requirements. Requirement 1. Determine the amount that would be reported in ending merchandise inventory on May 15 using the FIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on...

  • Please show answers clearly. Fit Gym began July with merchandise inventory of 76 crates of vitamins...

    Please show answers clearly. Fit Gym began July with merchandise inventory of 76 crates of vitamins that cost a total of $4,560. During the month, Fit Gym purchased and sold merchandise on account as follows: (Click the icon to view the transactions.) Read the requirements Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and delermine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold...

  • Requirement 1. Compute cost of goods sold and gross profit using the FIFO inventory costing method...

    Requirement 1. Compute cost of goods sold and gross profit using the FIFO inventory costing method Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. Enter the transacions in chronalogical order, calculating news inventory an hand balances ater each transaction Once all of the transacions have been entered into the perpetal record, caloulate the quantly and total oost of merchandise inventory purchased, sold, and on hand at the end...

  • Requirement 1. Compute cost of goods sold and gross profit using the FIFO inventory costing method....

    Requirement 1. Compute cost of goods sold and gross profit using the FIFO inventory costing method. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. Enter the transactions in chronological​ order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual​ record, calculate the quantity and total cost of merchandise inventory​ purchased, sold, and on hand at the end...

  • Dec. 1 Beginning merchandise inventory 12 units @ $8 each 8 Sale 8 units @ $21...

    Dec. 1 Beginning merchandise inventory 12 units @ $8 each 8 Sale 8 units @ $21 each 14 Purchase 16 units @ $14 each 21 Sale 15 units @ $21 each 1. Compute the cost of goods​ sold, cost of ending merchandise​ inventory, and gross profit using the FIFO inventory costing method. 2. Compute the cost of goods​ sold, cost of ending merchandise​ inventory, and gross profit using the LIFO inventory costing method. 3. Which method results in a higher...

  • Dec. 1 Beginning merchandise inventory 20 tires @ $66 each 11 Purchase 8 tires @ $73...

    Dec. 1 Beginning merchandise inventory 20 tires @ $66 each 11 Purchase 8 tires @ $73 each 23 Sale 15 tires @ $87 each 26 Purchase 13 tires @ $84 each 29 Sale 15 tires @ $87 each Requirement 2. Compute cost of goods sold and gross profit using the LIFO inventory costing method. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the LIFO inventory costing method. Enter the transactions in chronological​ order,...

  • Dec. 1 Beginning merchandise inventory 13 units @ $11 each 8 Sale 9 units @ $24...

    Dec. 1 Beginning merchandise inventory 13 units @ $11 each 8 Sale 9 units @ $24 each 14 Purchase 17 units @ $15 each 21 Sale 14 units @ $24 each Assume that Upper J Upper L ToysJ L Toys store bought and sold a line of dolls during DecemberDecember as​ follows: LOADING... ​(Click the icon to view the​ transactions.) Upper J Upper L ToysJ L Toys uses the perpetual inventory system.Read the requirements. LOADING... Requirement 1. Compute the cost...

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