23) Cost of Goods Sold according to FIFO method for the month of October:
In FIFO method of inventory valuation, we record the cost of oldest goods purchased first at the time of selling.
That is why in the table below first 500 units sold are recorded at $1.00 and remaining units at $1.50.
Cost of goods sold on Oct 11 | 300 units *$1.00 | $300 |
Cost of goods sold on Oct 27 (500 units @$1.00 - 300 units @$1.00) | 200 units*$1.00 | $200 |
(650 units - 200 units @$1.00) | 450 units*$1.50 | $675 |
Cost of goods sold | $1,175 |
24) Cost of Inventory in Hand according to FIFO method at October 31:
Inventory at end (1,000 units - 450 units) | 550 units @$1.50 | $825 |
Goods Sold include 500 units @$1.00 purchased on Oct 1 and remaining 450 units@$1.50 purchased on Oct 22. The inventory left in hand is (1,000 units - 450 units) 550 units @$1.50.
25) Cost of Goods Sold according to LIFO method for the
month of October:
In LIFO method of inventory valuation, we record the cost of new goods purchased first at the time of selling.
Cost of goods sold on Oct 11 | 300 units *$1.00 | $300 |
Cost of goods sold on Oct 27 | 650 units*$1.50 | $975 |
Cost of goods sold | $1,275 |
In the table above, we sold the 300 units on Oct 11 from the Inventory of 500 units @$1.00 and the goods sold on Oct 27 are sold from Inventory purchased the most recently i.e. on Oct 22. That is why we recorded the units @$1.50.
26) Cost of Inventory in Hand according to LIFO method at October 31:
The inventory in hand according to LIFO method is 200 units from the Oct 1 purchase (500 units - 300 units). And 350 units from Oct 22 purchase (1,000 units - 650 units).
Inventory in hand on Oct 31 | |
200 units @$1.00 | $200 |
350 units @$1.50 | $525 |
Total Cost of Inventory in hand on Oct 31 | $725 |
27) Cost of Goods Sold according to Weighted Average Method:
In Weighted Average method of Inventory valuation we calculate the weighted average selling price. It is calculated by dividing the Total Cost of Inventory by Total Units.
Cost of Goods Sold on Oct 11 | 300 units @$1.00 | $300 |
Cost of Goods Sold on Oct 27 | 650 @$1.42 | $923 |
[Weighted Cost per unit :(200 units @ 1.00 +1,000 units @$1.50)/1,200 units] = $1.42 per unit | $1,223 |
The answer will be rounded off to $1,220.
i have the correct answers circled but have no idea how to get any of them...
You have the following information for Windsor, Inc. for the month ended October 31, 2022. Windsor uses a periodic method for inventory Date Description Units Unit Cost or Selling Price Oct.1 Beginning inventory 60 Oct. 9 Purchase Sale Oct. 11 Oct. 17 Oct. 22 Oct. 25 Purchase Sale Purchase Oct. 29 Sale Calculate the weighted average cost. (Round answer to 3 decimal places, eg. 5.125.) Weighted average cost per units Calculate ending inventory, cost of goods sold, gross profit under...
Use the following information for Vania Inc. for the following three questions. The company uses the perpetual inventory system, and recorded the following transactions in the month of October 2018. Oct 1 On hand, 50 units @ $15 each Oct 5 Purchased 75 units @ $18 each Oct 10 Sold 65 units @ $32 each Oct 14 Purchased 75 units @ $24 each Oct 29 Sold 85 units @ $38 each 1. What is Vania Inc’s Gross Profit for October...
You have the following information for Nash's Trading Post, LLC for the month ended October 31, 2022. Nash uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price 50 Oct. 1 Oct. 9 Beginning inventory Purchase Sale Oct. 11 Oct 17 Purchase Oct. 22 Oct. 25 Oct. 29 Sale Purchase Sale Calculate the weighted average cost. (Round answer to 3 decimal places, eg. 5.125.) Weighted-average cost per unit $ Calculate ending inventory, cost of goods sold,...
You have the following information for Skysong, Inc. for the month ended October 31, 2022. Skysong uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Oct. 9 Oct. 11 Oct. 17 Oct. 22 Beginning inventory Purchase Sale Purchase Sale Oct. 25 Purchase Oct. 29 Sale Calculate the weighted-average cost. (Round answer to 3 decimal places, eg. 5.125.) Weighted average cost per unit $ 35.833 eTextbook and Media List of Accounts Calculate ending inventory,...
View Policies Current Attempt in Progress You have the following information for Waterway Industries for the month ended October 31, 2022. Waterway uses a periodic method for inventory Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory $26 70 125 Oct. 9 Purchase Oct. 11 Sale Oct. 17 Purchase Oct. 22 Sale Oct. 25 Purchase Oct. 29 Sale Calculate the weighted average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted average cost per unit $...
You have the following information for Blue Spruce Corp. for the month ended October 31, 2022. Blue Spruce uses a periodic method for inventory Units Date Description Unit Cost or Selling Price Oct. 1 Beginning inventory 50 $22 Oct. 9 Purchase 125 24 Oct. 11 Sale 90 45 Oct. 17 Purchase 90 25 Oct. 22 Sale 50 50 Oct. 25 Purchase 60 27 Oct. 29 100 Sale 50 Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.)...
You have the following information for Vaughn Manufacturing for the month ended October 31, 2022. Vaughn uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 70 Oct. 9 Purchase Oct. 11 Sale Oct. 17 Purchase Oct. 22 Sale Oct. 25 Purchase Oct. 29 Sale - Your answer is incorrect. Calculate the weighted average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted average cost per unit $ 31.468 eTextbook and...
You have the following information for Waterway Industries for the month ended October 31, 2022. Waterway uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 70 $26 Oct. 9 Purchase Oct. 11 Sale Oct. 17 Purchase Oct. 22 Sale Oct. 25 Purchase Oct 29 Sale X Your answer is incorrect. Calculate the weighted average cost. (Round answer to 3 decimal places, eg. 5.125.) Weighted average cost per units 28.572 Your answer...
Question 2 View Policies Current Attempt in Progress You have the following information for Marigold Corp. for the month ended October 31, 2022. Marigold uses a periodic method for inventory Unit Cost or Selling Price Units 55 Date Description Oct 1 Beginning inventory Oct 9 Purchase Oct. 11 Sale Oct 17 Purchase Oct 22 Sale Oct. 25 Purchase Oct. 29 Sale Calculate the weighted average cost. (Round answer to 3 decimal places, e... 5.125.) Weighted average cost per units e...
Case Defence sells smartphone cases and uses the perpetual inventory system. The following is information on the purchases and sales of "Defender Box” cases. On October 1, Case Defence had 33 units with a unit cost of $27. Sales Units Unit Price Purchases Units Unit Cost 23 28 - 33 Date Oct. 3 Oct. 6 Oct. 12 Oct. 19 Oct. 23 Oct. 30 Oct. 31 28 33 $63 $63 43 38 $63 28 Required: 1. Calculate the dollar value of...