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 |
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.
Marigold Corp. had 1,700 units of part M.O. on hand May 1, 2020, costing $25 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. 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. 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 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% 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, 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. 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. 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 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.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...