During 2021, a company sells 490 units of inventory for $90
each. The company has the following inventory purchase transactions
for 2021:
Date | Transaction | Number of Units |
Unit Cost |
Total Cost | |||||||||
Jan. | 1 | Beginning inventory | 79 | $ | 70 | $ | 5,530 | ||||||
May | 5 | Purchase | 264 | 71 | 18,744 | ||||||||
Nov. | 3 | Purchase | 188 | 73 | 13,724 | ||||||||
531 | $ | 37,998 | |||||||||||
Calculate cost of goods sold and ending inventory for 2021 assuming
the company uses the weighted-average cost method. (Round
weighted-average unit cost to 4 decimal places. Round your final
answers to the nearest dollar amount.)
Cost of goods sold:
Ending inventory:
Cost of Goods sold | = | $ 35,064 |
Ending inventory | = | $ 2,934 |
Explanation:
Calculation of cost of goods sold and ending inventory under Weighted Average Cost - Periodic system:- | ||||||||||
Average Cost per unit | = | Total Cost of Goods available for sale | ||||||||
Total quantity | ||||||||||
Periodic -Weighted Average Cost | Cost of Goods Available for Sale | Cost of Goods Sold - Average Cost | Ending inventory - Average Cost | |||||||
# of Units | Cost per Unit | Cost of Goods Available for Sale | # of Units sold | Average Cost per Unit | Cost of Goods Sold | # of Units in Ending inventory | Average Cost per Unit | Ending inventory | ||
Beginning Inventory (Jan 1) | 79 | $ 70 | $ 5,530 | |||||||
Purchases: | ||||||||||
May 5 | 264 | $ 71 | $ 18,744 | |||||||
Nov 3 | 188 | $ 73 | $ 13,724 | |||||||
Total | 531 | $ 71.5593 | $ 37,998 | 490 | $ 71.5593 | $ 35,064 | 41 | $ 71.5593 | 2,934 | |
Average Cost per unit | = | $37,998 | ||||||||
531 | ||||||||||
= | $71.5593 | |||||||||
Total No. of units sold | = | 490 | ||||||||
Amount assigned to Cost of Goods sold | = | 490 * $71.5593 | = | $ 35,064 | ||||||
Units in ending inventory | = | 531-490 | = | 41 | ||||||
Amount assigned to ending inventory | = | 41 * $71.5593 | = | $ 2,934 | ||||||
Cost of Goods sold | = | $ 35,064 | ||||||||
Ending inventory | = | $ 2,934 |
Feel free to ask any clarification, if required. Kindly
provide feedback by thumbs up, if satisfied. It will be highly
appreciated.
Thank you.
During 2021, a company sells 490 units of inventory for $90 each. The company has the...
During 2021, a company sells 460 units of inventory for $90 each. The company has the following Inventory purchase transactions for 2021: Date Transaction Jan. 1 Beginning inventory May 5 Purchase Nov. 3 Purchase Number of Units 78 262 187 Unit Cost Total Cost 78 $ 6,084 20,698 15,147 $41,929 81 $27 Calculate cost of goods sold and ending inventory for 2021 assuming the company uses the weighted average cost method. (Round weighted average unit cost to 4 decimal places....
23 During 2021, a company sells 470 units of inventory for $93 each. The company has the following inventory purchase transactions for 2021 Number of Units 80 267 Unit Cost $ Date Transaction Jan. 1 Beginning inventory May 5 Purchase Nov.) Purchase 8 points 30 82 Total Cost $ 6,320 21,360 15,334 $43,014 Calculate cost of goods sold and ending inventory for 2021 assuming the company uses the weighted average cost method. (Round weighted average unit cost to 4 decimal...
22 During 2021, a company sells 356 units of inventory for $88 each. The company has the following inventory purchase transactions for 2021 Number Unit Date Transaction of Units Cost Total Cost Jan. 1 Beginning inventory 63 566 May 5 Purchase 161 es 10,948 Nov.) Purchase 180 71 12,700 M 8 DO 2224 Calculate ending Inventory and cost of goods sold for 2021 assuming the company uses UFO Ending inventory Cost of goods sold
During 2021, a company sells 20 units of inventory. The company has the following inventory purchase transactions for 2021 Date Transaction Jan. 1 Beginning inventory Sep.8 Purchase Number of Units 15 10 25 Unit Cost Total Cost $50 $ 750 94 $1,690 940 Calculate ending inventory and cost of goods sold for 2021 assuming the company uses the weighted average cost method. (Round weighted-average unit cost to 4 decimal places. Round your final answers to the nearest dollar amount.) Ending...
During 2021, a company sells 25 units of inventory. The company has the following inventory purchase transactions for 2021 Date Transaction Jan.1 Beginning inventory Sep.8 Purchase Number Unit of Units Cost 20 $50 Total Cost $1,000 700 $1,700 70 Calculate ending inventory and cost of goods sold for 2021 assuming the company uses the weighted average cost method. (Round weighted average unit cost to 4 decimal places. Round your final answers to the nearest dollar amount.) Ending inventory Cost of...
6) During 2021, a company sells 400 units of inventory for $85 each. The company has the following inventory purchase transactions for 2021: Date Transaction Jan. 1 Beginning inventory May 5 Purchase Nov. 3 Purchase Number of Units Unit Cost Total Cost 60 S70 S4.200 1801 721 12.960 1901 7 51 14.250 430 $31.410 Calculate ending inventory and cost of goods sold for 2021 assuming the company uses FIFO Calculate ending inventory and cost of goods sold for 2021 assuming...
During 2018, a company sells 350 units of inventory for $90 each. The company has the following inventory purchase transactions for 2018 Number of Units Date Transaction Beginning Unit Cost $ 61 62 Jan. 1 inventory 70 Total Cost $ 4270 10,230 12,032 May 5 Purchase Nov. 3 Purchase 165 188 64 423 $26,532 Calculate ending inventory and cost of goods sold for 2018 assuming the company uses FIFO with a periodic inventory system. Ending inventory Cost of goods sold
During 2021, a company sells 364 units of inventory for $94 each. The company has the following inventory purchase transactions for 2021: Number of Units Date Transaction Jan.1 Beginning inventory May 5 Purchase Nov. 3 Purchase 166 Unit Cost Total Cost $67 $ 4,087 11, 454 13,536 $29,077 69 Calculate ending inventory and cost of goods sold for 2021 assuming the company uses LIFO. Ending inventory Cost of goods sold < Prev 16 of 40 Next > MacBook Air
24 During 2021, a company sells 340 units of inventory for $85 each. The company has the following inventory purchase transactions for 2021 Unit Cost $66 Date Transaction Jan. 1 Beginning inventory May 5 Purchase Nov. 3 Purchase Number of Units 66 170 186 422 8 points Total cost $ 4,356 11,390 12,834 $28,580 69 02:13:19 Calculate ending inventory and cost of goods sold for 2021 assuming the company uses FIFO. Ending inventory Cost of goods sold
During 2021, a company sells 160 units of inventory for $55 each. The company has the following inventory purchase transactions for 2021: Date Transaction Number of Units Unit Cost Total Cost Jan. 1 Beginning inventory 58 $ 40 $ 2,320 May 5 Purchase 107 39 4,173 Nov. 3 Purchase 75 38 2,850 240 $ 9,343 Actual sales by the company include its entire beginning inventory, 87 units of inventory from the May 5 purchase, and 15 units from the November...