Question

Marigold Corp. had 1,700 units of part M.O. on hand May 1, 2020, costing $25 each....

Marigold Corp. had 1,700 units of part M.O. on hand May 1, 2020, costing $25 each. Purchases of part M.O. during May were as follows.

Units

Units Cost

May 9

2,200 $26

17

3,700 28

26

1,200 29


A physical count on May 31, 2020, shows 2,200 units of part M.O. on hand. Using the FIFO method, what is the cost of part M.O. inventory at May 31, 2020? Using the LIFO method, what is the inventory cost? Using the average-cost method, what is the inventory cost? (Round average cost per unit to 2 decimal places, e.g. 15.25 and final answers to 0 decimal places, e.g. 1,620.)

FIFO

LIFO

Average Cost

Inventory Cost

$enter a dollar amount rounded to 0 decimal places

$enter a dollar amount rounded to 0 decimal places

$enter a dollar amount rounded to 0 decimal places

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

Answer 1)

Calculation of value of inventory at May 31, 2020 under FIFO Method

Date

Units

Unit Cost

Total Cost

May'17

1,000

$ 28

$ 28,000

May'26

1,200

$ 29

$ 34,800

Total

2,200

$ 62,800

The value of 2,200 units of inventory under FIFO method is $ 62,800

FIFO Method: Under FIFO method inventory is valued on the assumption that the units which are first bought are first sold and so on. Thus the ending inventory will comprise of the goods which are latest bought and moving backwards.

In given question, the company had 2,200 units of inventory in hand on May’31. Under FIFO method, out of the 2,200 units, 1,000 units will be from the units purchased on May’17 at $ 28.00 per unit and balance 1,200 units will be the inventory purchased on May’26 at $ 29.00 per unit.

Answer 2)

Calculation of value of inventory at May 31, 2020 under LIFO method

Date

Units

Unit Cost

Total Cost

May'1

1,700

$ 25

$ 42,500

May'9

500

$ 26

$ 13,000

Total

2,200

$ 55,500

The value of 2,200 units of inventory under LIFO method is $ 55,500

LIFO Method: Under LIFO method inventory is valued on the assumption that the units which are latest bought are first sold and moving backwards. Thus the ending inventory will comprise of the goods which are bought at the earliest and so on.

In given question, the company had 2,200 units of inventory in hand on May’31. Under LIFO method, out of the 2,200 units, 1,700 units will be from the inventory balance on May’1 at $ 25.00 per unit and balance 400 units will be the inventory purchased on May’9 at $ 26.00 per unit.

Answer 3)

Calculation of value of inventory at May 31, 2020 under average cost method

Date

Units

Unit Cost

Total Cost

May'1

1,700

$ 25

$ 42,500

May'9

2,200

$ 26

$ 57,200

May'17

3,700

$ 28

$ 103,600

May'26

1,200

$ 29

$ 34,800

Total

8,800

$ 238,100

average cost = (Total cost of opening inventory and inventory bought during the period/ Total number of units in opening inventory and inventory bought during the period)

                                         = $ 238,100/ 8,800 units

                                        = $ 27.0568 or 27.06 (Approximately)

Value of Inventory = Number of units in inventory X average cost

                                   = 2,200 units X $ 27.0568

                                   = $ 59,525

The value of 2,200 units of inventory under average cost method is $ 59,525

Average cost method: Under average cost method, an average cost is calculated by dividing the aggregate value of inventory at the beginning of the period and inventory bought during the period by the total number of units at the beginning of the period and units bought during the period. The average cost so calculated is then multiplied with the number of units at the end of period to arrive at the value of inventory.

Add a comment
Know the answer?
Add Answer to:
Marigold Corp. had 1,700 units of part M.O. on hand May 1, 2020, costing $25 each....
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
  • Waterway Corp. had 2,000 units of part M.O. on hand May 1, 2020, costing $32 each....

    Waterway Corp. had 2,000 units of part M.O. on hand May 1, 2020, costing $32 each. Purchases of part M.O. during May were as follows. Units Units Cost May 9 2,500 $33 17 4,000 35 26 1,500 36 A physical count on May 31, 2020, shows 2,500 units of part M.O. on hand. Using the FIFO method, what is the cost of part M.O. inventory at May 31, 2020? Using the LIFO method, what is the inventory cost? Using the...

  • Sandhill Corp. had 1,700 units of part M.O. on hand May 1, 2017, costing $25 each....

    Sandhill Corp. had 1,700 units of part M.O. on hand May 1, 2017, costing $25 each. Purchases of part Μ.Ο. during May were as follows: Units Units Cost $26 28 29 May 9 2,200 17 3,700 26 1,200 A phys cal count on May 31, 2017, shows 2,200 units of part M.0. on hand. Using the FIFO method, what is the cost of part M.O.Inventory at May 31, 2017? Using the LtFO method, what is the inventory cost? Using the...

  • Sweet Corp. had 1,840 units of part M.O. on hand May 1, 2017, costing $28 each....

    Sweet Corp. had 1,840 units of part M.O. on hand May 1, 2017, costing $28 each. Purchases of part M.O. during May were as follows. Units Units Cost May 9 2,340 $29 17 3,840 31 26 1,340 32 A physical count on May 31, 2017, shows 2,340 units of part M.O. on hand. Using the FIFO method, what is the cost of part M.O. inventory at May 31, 2017? Using the LIFO method, what is the inventory cost? Using the...

  • Concord Company’s inventory of $1,058,900 at December 31, 2020, was based on a physical count of...

    Concord Company’s inventory of $1,058,900 at December 31, 2020, was based on a physical count of goods priced at cost and before any year-end adjustments relating to the following items. (a) Goods shipped from a vendor f.o.b. shipping point on December 24, 2020, at an invoice cost of $69,520 to Concord Company were received on January 4, 2021. (b) The physical count included $31,120 of goods billed to Sakic Corp. f.o.b. shipping point on December 31, 2020. The carrier picked...

  • Skysong Co. purchased goods with a list price of $185,700, subject to trade discounts of 20%...

    Skysong Co. purchased goods with a list price of $185,700, subject to trade discounts of 20% and 10%, with no cash discounts allowable. How much should Skysong Co. record as the cost of these goods? Cost of goods purchased $enter the Cost of goods purchased in dollars LINK TO TEXT LINK TO TEXT LINK TO TEXT Concord Company’s inventory of $1,058,900 at December 31, 2020, was based on a physical count of goods priced at cost and before any year-end...

  • Your answer is incorrect. Concord Corp. had 1,900 units of part T on hand April 1,...

    Your answer is incorrect. Concord Corp. had 1,900 units of part T on hand April 1, 2017, costing $8 each. During April, Concord made the following purchases of part T. Units Unit Cost April 4 2,700 $8.25 10 4,800 8.40 19 1,200 9 29 3,000 9.90 A physical count at April 30, 2017 showed 4,300 units of Part T on hand. Using the FIFO method, what is the cost of part T inventory at April 30, 2017? Using the LIFO...

  • Problem 8-01 The following independent situations relate to inventory accounting. Answer the following questions about inventories....

    Problem 8-01 The following independent situations relate to inventory accounting. Answer the following questions about inventories. Kingbird Co. purchased goods with a list price of $177,300, subject to trade discounts of 20% and 10%, with no cash discounts allowable. How much should Kingbird Co. record as the cost of these goods? Cost of goods purchased $enter the Cost of goods purchased in dollars LINK TO TEXT LINK TO TEXT LINK TO TEXT Oriole Company’s inventory of $1,113,100 at December 31,...

  • Problem 8-1 The following independent situations relate to inventory accounting. Answer the following questions about inventories....

    Problem 8-1 The following independent situations relate to inventory accounting. Answer the following questions about inventories. Metlock Co. purchased goods with a list price of $168,300, subject to trade discounts of 20% and 10%, with no cash discounts allowable. How much should Metlock Co. record as the cost of these goods? Cost of goods purchased $ Windsor Corp. had 1,880 units of part M.O. on hand May 1, 2017, costing $29 each. Purchases of part M.O. during May were as...

  • Bramble Corp. began the year with 10 units of marine floats at a cost of $12...

    Bramble Corp. began the year with 10 units of marine floats at a cost of $12 each. During the year, it made the following purchases: May 5, 32 unit at $16; July 16, 19 units at $20; and December 7, 24 units at $23. Assume there are 35 units on hand at the end of the period. Bramble uses the periodic approach. A. Determine cost of goods sold under FIFO B. Determine cost of goods sold under LIFO C. Calculate...

  • You have the following information for Novak Corp. for the month ended October 31, 2017. Novak Corp. uses a periodic method for inventory.

    You have the following information for Novak Corp. for the month ended October 31, 2017. Novak Corp. uses a periodic method for inventory.DateDescriptionUnitsUnit Cost or Selling PriceOct. 1Beginning inventory59$24Oct. 9Purchase11026Oct. 11Sale10035Oct. 17Purchase11027Oct. 22Sale6440Oct. 25Purchase6329Oct. 29Sale10440Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.)Weighted-average cost per unit$enter the Weighted-average cost per unit in dollars rounded to 3 decimal placesCalculate ending inventory, cost of goods sold, gross profit under each of the following methods.(1) LIFO.(2) FIFO.(3) Average-cost. (Round answers...

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