Question

Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing m3. Calculate the cost of ending inventory and cost of goods sold using the (a) FIFO, (b) LIFO, and (c) weighted average cost

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The table will be populated in the following manner:

Cost of Ending Inventory Cost of Goods Sold
FIFO $47,300 $23,100
LIFO $40,100 $30,300
Weighted Average $44,000 $26,400

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.

Workings

Under FIFO, goods entering the inventory first are sold first. Hence, closing inventory will comprise of goods purchased later.

FIFO
Units Cost per unit Total Cost
Beginning Inventory 240 75 18000
Purchase Jan 15 320 85 27200
Purchase Jan 24 240 105 25200
Cost of Sales 800 70400
300 Units Sold -240 75 -18000
-60 85 -5100
500 units Ending Inventory 260 85 22100
240 105 25200
Cost of Goods Sold 23100
Ending Inventory 47300

Under LIFO, goods entering the inventory LAST are sold first. Hence, closing inventory will comprise of goods purchased earlier and the beginning inventory.

LIFO
Units Cost per unit Total Cost
Beginning Inventory 240 75 18000
Purchase Jan 15 320 85 27200
Purchase Jan 24 240 105 25200
Cost of Sales 800 70400
300 Units Sold -240 105 -25200
-60 85 -5100
500 units Ending Inventory 260 85 22100
240 75 18000
Cost of Goods Sold 30300
Ending Inventory 40100

Under Weighted Average method, weighted average price should be calculated after every transaction and that price is applied to units sold and units remaining in ending inventory.

Weighted Average
Units Weighted Average Price Total Cost
Beginning Inventory 240 75 18000
Purchase Jan 15 320 85 27200
Total 560                80.71 45200
Purchase Jan 24 240 105 25200
Total 800                88.00 70400
300 Units Sold -300                88.00    -26,400.00
Ending Inventory 500                88.00 44000

75 Ovo AwN Beginning Inventory Purchase Jan 15 Purchase Jan 24 Cost of Sales 300 Units Sold Units 240 320 240 =SUM(B3:B5) -24

Add a comment
Know the answer?
Add Answer to:
Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...
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
  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January Sales totaled 320 units Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses...

  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January Sales totaled units Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a...

  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January. Sales totaled 320 units. Beginning Inventory Purchase Purchase Date January 1 January 15 January 24 Units Unit Cost Total Cost 180 $ 70 $12,600 490 8 0 3 9,200 280 100 28,000 Required: 1....

  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January. Sales totaled 310 units. Beginning Inventory Purchase Purchase Date January 1 January 15 January 24 Units 240 360 200 Unit Cost $ 80 90 118 Total cost $19,200 32.400 22.000 Required: 1. Calculate the...

  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if It uses a periodic Inventory system. Assume Oahu Kiki's records show the following for the month of January, Sales totaled 270 units. Beginning Inventory Purchase Purchase Date January 1 January 15 January 24 Units Unit Cost Total Cost 228 $ 85 $18,700 489 95 45,686 288 115 23,800 Required: 1. Calculate the...

  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory cos...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January. Sales totaled 240 units. Units Unit Cost 120 380 Total Cost 9,600 34,200 22,000 Date Beginning Inventory Purchase Purchase 80 90 January 1 January 15 January 24 200 110 Required: 1. Calculate the number...

  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method perpetually at the time of each sale, as if it uses perpetual inventory system. Assume Oahu Kiki's records show the following for the month of January. The company sold 290 units between January 16 and 23. Units Unit Cost Total Cost $16,8e0 36,000 21,000 Date Beginning Inventory Purchase Purchase January 1 January 15 January 24 240 450 210 100 Required:...

  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January. Sales totalled 240 units. Unit Cost $ 8 Beginning Inventory Purchase Purchase Date January 1 January 15 January 24 Units 120 380 200 Total Cost $ 960 3,420 2,200 11 Required: 1. Calculate the...

  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method perpetually at the time of each sale, as if it uses perpetual inventory system. Assume Oahu Kiki's records show the following for the month of January. The company sold 270 units between January 16 and 23. Beginning Inventory Purchase Purchase 6.25 points Units Unit Cost Total Cost 140 $ 75 $10,500 300 85 25,500 240 105 25, 200 January 1...

  • Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies...

    Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January, Sales totaled 270 units. Beginning Inventory Purchase Purchase Date January 1 January 15 January 24 Units Unit Cost 140 $ 75 300 85 240 105 Total Cost $19,5ee 25,500 25, 200 Required: 1. Calculate...

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