Question

In: Accounting

Inventory Costing Methods-Perpetual Method Fortune Stores uses the perpetual inventory system for its merchandise inventory. The...

Inventory Costing Methods-Perpetual Method Fortune Stores uses the perpetual inventory system for its merchandise inventory. The April 1 inventory for one of the items in the merchandise inventory consisted of 130 units with a unit cost of $335. Transactions for this item during April were as follows:

April 9 Purchased 40 units @ $355 per unit
14 Sold 80 units @ 560 per unit
23 Purchased 20 units @ 360 per unit
29 Sold 40 units


Required
a. Calculate the cost of goods sold and the ending inventory cost for the month of April using the weighted-average cost method. Do not round until your final answers. Round your final answers to the nearest dollar.

b. Calculate the cost of goods sold and the ending inventory cost for the month of April using the first-in, first-out method.

c. Calculate the cost of goods sold and the ending inventory cost for the month of April using the last-in, first-out method.

a. Weighted Average
Ending Inventory Answer
Cost of goods Sold Answer
b. First-in, First-out:
Ending Inventory Answer
Cost of Goods Sold: Answer
c. Last-in, first-out:
Ending Inventory Answer
Cost of Goods Sold: Answer

Solutions

Expert Solution

Answers

a. Weighted Average
Ending Inventory $ 24,038
Cost of Goods Sold $ 40,912
b. First-in, First-out:
Ending Inventory $ 24,750
Cost of Goods Sold: $ 40,200
c. Last-in, first-out:
Ending Inventory $ 23,450
Cost of Goods Sold: $ 41,500

Calculations:

Weighted average Method
Fortune Stores
Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Merchandise Sold Unit Cost Cost of Merchandise Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost
1-Apr             130 $   335.00 $   43,550
9-Apr                40 $    355.00 $    14,200             170 $   339.71        57,750
14-Apr             80 $          339.71 $            27,176               90 $   339.71        30,574
$            -  
23-Apr                20 $    360.00 $      7,200             110 $   343.40        37,774
29-Apr 40 $          343.40 $            13,736               70 $   343.40        24,038
Totals                60        21,400           120                40,912               70        24,038
First-in, First-out Method
Fortune Stores
Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Merchandise Sold Unit Cost Cost of Merchandise Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost
1-Apr             130 $   335.00 $   43,550
9-Apr                40 $    355.00 $    14,200             130 $   335.00 $   43,550
              40 $   355.00 $   14,200
14-Apr             80 $          335.00 $            26,800               50 $   335.00 $   16,750
              40 $   355.00 $   14,200
23-Apr                20 $    360.00 $      7,200               50 $   335.00 $   16,750
              40 $   355.00 $   14,200
              20 $   360.00 $      7,200
29-Apr 40 335 $            13,400               10 $   335.00 $      3,350
              40 $   355.00 $   14,200
              20 $   360.00 $      7,200
Totals                60        21,400           120                40,200               70        24,750
Last-in, First-out Method
Fortune Stores
Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Merchandise Sold Unit Cost Cost of Merchandise Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost
1-Apr             130 $   335.00 $   43,550
9-Apr                40 $    355.00 $    14,200             130 $   335.00 $   43,550
              40 $   355.00 $   14,200
14-Apr             40 $          355.00 $            14,200               90 $   335.00 $   30,150
            40 $          335.00 $            13,400
23-Apr                20 $    360.00 $      7,200               90 $   335.00 $   30,150
              20 $   360.00 $      7,200
29-Apr 20 360 $              7,200               70 $   335.00 $   23,450
20 335 $              6,700
Totals                60        21,400           120                41,500               70        23,450

In case of any doubt, please comment.


Related Solutions

Inventory Costing Methods - Periodic Method Fortune Stores uses the periodic inventory system for its merchandise...
Inventory Costing Methods - Periodic Method Fortune Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for one of the items in the merchandise inventory consisted of 120 units with a unit cost of $355. Transactions for this item during April were as follows: Required a. Calculate the cost of goods sold and the ending inventory cost for the month of April using the weighted-average cost method. Do not round until your final answers. Round...
Inventory Costing Methods-Perpetual Method Kali Company uses the perpetual inventory system for its merchandise inventory. The...
Inventory Costing Methods-Perpetual Method Kali Company uses the perpetual inventory system for its merchandise inventory. The June 1 inventory for one of the items in the merchandise inventory consisted of 60 units with a unit cost of $45. Transactions for this item during June were as follows: June 5 Purchased 40 units @ $50 per unit 13 Sold 50 units @ $95 per unit 25 Purchased 40 units @ $53 per unit 29 Sold 20 units@ $110 per unit Required...
Fortune Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for...
Fortune Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for one of the items in the merchandise inventory consisted of 120 units with a unit cost of $375. Transactions for this item during April were as follows: April 9 Purchased 40 units @ $395 per unit 14 Sold 80 units @ $600 per unit 23 Purchased 20 units @ $400 per unit 29 Sold 40 units Required a. Calculate the cost of goods sold...
Inventory Costing Methods—Perpetual Method Arrow Company is a retailer that uses the perpetual inventory system. August...
Inventory Costing Methods—Perpetual Method Arrow Company is a retailer that uses the perpetual inventory system. August 1 Beginning inventory 80 units of Product A @ $1,600 total cost 5 Purchased 100 units of Product A @ $2,116 total cost 8 Purchased 200 units of Product A @ $4,416 total cost 11 Sold 170 units of Product A @ $4,800 total sale Calculate the inventory cost of item A on August 11 (after the sale) using (a) first-in, first-out, (b) last-in,...
Question text Inventory Costing Methods—Perpetual Method Chou Sales Corporation uses the perpetual inventory system. On January...
Question text Inventory Costing Methods—Perpetual Method Chou Sales Corporation uses the perpetual inventory system. On January 1, 2018, Chen had 1,000 units of product A with a unit cost of $20 per unit. A summary of purchases and sales during 2018 follows: Unit Cost Units Purchased Units Sold Feb.2 400 Apr.6 $22 1,800 July 10 1,600 Aug.9 25 800 Oct.23 800 Dec.30 28 1,400 Required a. Assume that Chou uses the first-in, first-out method. Compute the cost of goods sold...
At the end of last year, Helen's, Inc. (uses a perpetual inventory system) had merchandise costing...
At the end of last year, Helen's, Inc. (uses a perpetual inventory system) had merchandise costing $115,000 in inventory. During January of the current year, the company purchased merchandise costing $35,000, and sold merchandise which it had purchased at a total cost of $55,000. Based on the foregoing information, the amount of costs transferred from the Inventory account to the Cost of Goods Sold account during January was:
Altira Corporation uses a perpetual inventory system. The following transactions affected its merchandise inventory during the...
Altira Corporation uses a perpetual inventory system. The following transactions affected its merchandise inventory during the month of August 2018: Aug.1 Inventory on hand—3,300 units; cost $7.40 each. 8 Purchased 16,500 units for $6.80 each. 14 Sold 13,200 units for $13.30 each. 18 Purchased 9,900 units for $6.20 each. 25 Sold 12,200 units for $12.30 each. 31 Inventory on hand—4,300 units. Exercise 8-14 Part 2 2. Determine the inventory balance Altira would report in its August 31, 2018, balance sheet...
Required information Altira Corporation uses a perpetual inventory system. The following transactions affected its merchandise inventory...
Required information Altira Corporation uses a perpetual inventory system. The following transactions affected its merchandise inventory during the month of August 2018: Aug.1 Inventory on hand—3,900 units; cost $8.00 each. 8 Purchased 19,500 units for $7.40 each. 14 Sold 15,600 units for $13.90 each. 18 Purchased 11,700 units for $6.60 each. 25 Sold 14,600 units for $12.90 each. 31 Inventory on hand—4,900 units. 3. Determine the inventory balance Altira would report in its August 31, 2018, balance sheet and the...
Inventory Costing Methods-Periodic Method Spangler Company is a retailer that uses the periodic inventory system. March...
Inventory Costing Methods-Periodic Method Spangler Company is a retailer that uses the periodic inventory system. March 1 Beginning inventory 110 units of Product M @ $1,590 total cost 6 Purchased 210 units of Product M @ $3,600 total cost 10 Purchased 160 units of Product M @ $3,000 total cost 15 Sold 190 units of Product M Calculate the March cost of goods sold and the ending inventory at March 31 using (a) first-in, first-out, (b) last-in, first-out, and (c)...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system August...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system August 1 Beginning Inventory 150 Units of product A @ $1700 total cost 5 Purchased 170 Units of product A @ $2716 total cost purchased 270 Units of product A @ $5716 total cost Sold 230 Units of product A @ Calculate the August cost of goods sold and the ending inventory at August 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT