Cost of goods available for sale | Cost of goods sold - Periodic FIFO | Ending Inventory - Periodic FIFO | |||||||
Perpetual FIFO | # of units (A) | Cost per unit | Cost of goods available for sale | # of units sold (B) | Cost per unit | Cost of goods sold | # of units in ending inventory (A) - (B) | Cost per unit | Ending Inventory |
Beginning Inventory | 3,900 | $ 8.00 | $ 31,200 | 3,900 | $ 8.00 | $ 31,200 | - | $ 8.00 | $ - |
Purchases: | |||||||||
Aug-08 | 19,500 | $ 7.40 | $ 1,44,300 | 19,500 | $ 7.40 | $ 1,44,300 | - | $ 7.40 | $ - |
Aug-18 | 11,700 | $ 6.60 | $ 77,220 | 6,800 | $ 6.60 | $ 44,880 | 4,900 | $ 6.60 | $ 32,340 |
Aug-28 | 5,900 | $ 5.80 | $ 34,220 | - | $ 5.80 | $ - | 5,900 | $ 5.80 | $ 34,220 |
41,000 | $ 2,86,940 | 30,200 | $ 2,20,380 | 10,800 | $ 66,560 | ||||
Purchases | Cost of goods sold | Inventory on hand | |||||||
Perpetual Average | Quantity | Cost per unit | Total cost | Quantity | Cost per unit | Total cost | Quantity | Cost per unit | Total cost |
Beginning Inventory | 3,900 | $ 8.00 | $ 31,200 | 3,900 | $ 8.00 | $ 31,200 | |||
Aug-08 | 19,500 | $ 7.40 | $ 1,44,300 | 19,500 | $ 7.40 | $ 1,44,300 | |||
23,400 | $ 7.50 | $ 1,75,500 | |||||||
Aug-14 | 15,600 | $ 7.50 | $ 1,17,000 | 7,800 | $ 7.50 | $ 58,500 | |||
Aug-18 | 11,700 | $ 6.60 | $ 77,220 | 11,700 | $ 6.60 | $ 77,220 | |||
19,500 | $ 6.96 | $ 1,35,720 | |||||||
Aug-25 | 14,600 | $ 6.96 | $ 1,01,616 | 4,900 | $ 6.96 | $ 34,104 | |||
Aug-28 | 5,900 | $ 5.80 | $ 34,220 | 5,900 | $ 5.80 | $ 34,220 | |||
Totals | 41,000 | $ 2,86,940 | 30,200 | $ 2,18,616 | 10,800 | $ 68,324 | |||
Cost of goods available for sale | Cost of goods sold | Ending Inventory | |||||||
LIFO | # of units (A) | Cost per unit | Cost of goods available for sale | # of units sold (B) | Cost per unit | Cost of goods sold | # of units in ending inventory (A) - (B) | Cost per unit | Ending Inventory |
Beginning Inventory | 3,900 | $ 8.00 | $ 31,200 | - | $ 8.00 | $ - | 3,900 | $ 8.00 | $ 31,200 |
Purchases: | |||||||||
Aug-08 | 19,500 | $ 7.40 | $ 1,44,300 | 12,600 | $ 7.40 | $ 93,240 | 6,900 | $ 7.40 | $ 51,060 |
Aug-18 | 11,700 | $ 6.60 | $ 77,220 | 11,700 | $ 6.60 | $ 77,220 | - | $ 6.60 | $ - |
Aug-28 | 5,900 | $ 5.80 | $ 34,220 | 5,900 | $ 5.80 | $ 34,220 | - | $ 5.80 | $ - |
41,000 | $ 2,86,940 | 30,200 | $ 2,04,680 | 10,800 | $ 82,260 |
If it is helpful, please rate the answer and if any doubt arises let me know
Required information [The following information applies to the questions displayed below.] Altira Corporation provides the following...
Required information {The following information applies to the questions displayed below.) Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: 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. 28 Purchased 5,900 units for $5.80 each. 31 Inventory on hand-10,800 units. Required: 1. Using...
Required information [The following information applies to the questions displayed below.] Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand-2,300 units; cost $6.40 each. 8 Purchased 11,500 units for $5.80 each. 14 Sold 9, 200 units for $12.30 each. 18 Purchased 6,900 units for $5.00 each. 25 Sold 8, 200 units for $11.30 each. 28 Purchased 4,300 units for $5.80 each. 31 Inventory on hand-7, 600 units. Required:...
Required information (The following information applies to the questions displayed below.] Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand-3,600 units; cost $7.70 each 8 Purchased 18,000 units for $7.10 each 14 Sold 14,400 units for $13.60 each 18 Purchased 10,800 units for $6.60 each 25 Sold 13,400 units for $12.60 each 28 Purchased 5,600 units for $5.80 each 31 Inventory on hand-10,200 units. 2. Using calculations based...
Required information [The following information applies to the questions displayed below Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand-3,400 units; cost $7.50 each 8 Purchased 17,000 units for $6.90 each 14 Sold 13,600 units for $13.40 each 18 Purchased 10,200 units for $6.40 each 25 Sold 12,600 units for $12.40 each 28 Purchased 5,400 units for $5.80 each 31 Inventory on hand--9,800 units Required: 1. Using calculations...
Required information (The following information applies to the questions displayed below.) Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand-3,600 units; cost $7.70 each. 8 Purchased 18,000 units for $7.10 each. 14 Sold 14,400 units for $13.60 each. 18 Purchased 10,800 units for $6.60 each. 25 Sold 13, 400 units for $12.60 each. 28 Purchased 5,600 units for $5.80 each. 31 Inventory on hand-10, 200 units. 2. Using...
Required information (The following information applies to the questions displayed below.) Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021 Aug.1 Inventory on hand-2,900 units; cost $7.00 each. 8 Purchased 14,500 units for $6.40 each. 14 Sold 11,600 units for $12.90 each. 18 Purchased 8,700 units for $6.00 each. 25 Sold 10,600 units for $11.90 each. 28 Purchased 4,900 units for $5.80 each. 31 Inventory on hand-8, 800 units. Required: 1. Using...
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand-3,300 units; cost $6.60 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.90 each. 25 Sold 12, 200 units for $12.30 each. 28 Purchased 5,300 units for $5.80 each. 31 Inventory on hand-9,600 units. Required: Using calculations based on a periodic inventory system, determine the inventory balance Altira...
Required information (The following information applies to the questions displayed below.) Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand 4,000 units cost $0.10 cach. 8 Parehased 20,000 units for $7.50 each. 14 Sold 16,000 units for $14.00 each. 18 Parehased 12,000 units for $7.00 each. 25 Bold 15,000 units for $13.00 each. 28 Prohased 6,000 units for $5.80 each. 31 Inventory on hand-11,000 units. Required: 1. Using...
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand-2,800 units; cost $6.10 each. 8 Purchased 14,000 units for $6.30 each. 14 Sold 11,200 units for $12.80 each. 18 Purchased 8,400 units for $6.40 each. 25 Sold 10, 200 units for $11.80 each. 28 Purchased 4.800 units for $5.80 each. 31 Inventory on hand-8,600 units. Required: Using calculations based on a periodic inventory system, determine the inventory balance Altira...
Please help explain. Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand—3,100 units; cost $6.40 each. 8 Purchased 15,500 units for $6.60 each. 14 Sold 12,400 units for $13.10 each. 18 Purchased 9,300 units for $6.70 each. 25 Sold 11,400 units for $12.10 each. 28 Purchased 5,100 units for $5.80 each. 31 Inventory on hand—9,200 units. Required: Using calculations based on a periodic inventory system, determine the inventory...