Altira Corporation uses a periodic inventory system. The
following information related to its merchandise inventory during
the month of August 2018 is available:
Aug.1 | Inventory on hand—3,000 units; cost $7.50 each. |
8 | Purchased 19,000 units for $6.40 each. |
14 | Sold 12,500 units for $12.90 each. |
18 | Purchased 10,500 units for $5.90 each. |
25 | Sold 11,500 units for $11.90 each. |
31 | Inventory on hand—8,500 units. |
Required:
Determine the inventory balance Altira would report in its August
31, 2018, balance sheet and the cost of goods sold it would report
in its August 2018 income statement using each of the following
cost flow methods:
FIFO : | |||||||||
Cost of goods available for sale | Cost of goods sold | Ending inventory | |||||||
# of units | Unit cost | Total cost | # of units sold | Unit cost | Cost of goods sold | # of units | unit cost | Ending inventory | |
Beginning inventory | 3000 | 7.5 | $22,500 | 3000 | 7.5 | $22,500 | |||
Purchase | |||||||||
Aug-08 | 19000 | 6.4 | $1,21,600 | 9500 | 6.4 | $60,800 | |||
Aug-18 | 10500 | 5.9 | $61,950 | 9500 | 6.4 | $60,800 | |||
2000 | 5.9 | $11,800 | 8500 | 5.9 | $50,150 | ||||
Total | 32500 | $2,06,050 | 24000 | $1,55,900 | 8500 | $50,150 | |||
LIFO : | |||||||||
Cost of goods available for sale | Cost of goods sold | Ending inventory | |||||||
# of units | Unit cost | Total cost | # of units sold | Unit cost | Cost of goods sold | # of units | unit cost | Ending inventory | |
Beginning inventory | 3000 | 7.5 | $22,500 | 0 | 0 | $0 | 3000 | 7.5 | $22,500 |
Purchase | |||||||||
Aug-08 | 19000 | 6.4 | $1,21,600 | 12500 | 6.4 | $80,000 | 6500 | 6.4 | $41,600 |
Aug-18 | 10500 | 5.9 | $61,950 | 10500 | 5.9 | $61,950 | |||
1000 | 6.4 | $6,400 | -1000 | 6.4 | -$6,400 | ||||
Total | 32500 | $2,06,050 | 24000 | $1,48,350 | 8500 | $57,700 | |||
Average cost | |||||||||
Cost of goods available for sale | Cost of goods sold | Ending inventory | |||||||
# of units | Unit cost | Total cost | # of units sold | Average Unit cost | Cost of goods sold | # of units | Average unit cost | Ending inventory | |
Beginning inventory | 3000 | 7.5 | $22,500 | ||||||
Purchase | |||||||||
Aug-08 | 19000 | 6.4 | $1,21,600 | ||||||
Aug-18 | 10500 | 5.9 | $61,950 | ||||||
Total | 32500 | $2,06,050 | 33000 | 6.34 | $2,09,220 | 8500 | 6.34 | $53,890 | |
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during...
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2018 is available: Aug.1 Inventory on hand—3,500 units; cost $6.70 each. 8 Purchased 17,000 units for $6.20 each. 14 Sold 11,500 units for $12.70 each. 18 Purchased 9,500 units for $5.70 each. 25 Sold 10,500 units for $11.70 each. 31 Inventory on hand—8,000 units. Required: Determine the inventory balance Altira would report in its August 31, 2018, balance sheet and...
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2018 is available: Aug.1 Inventory on hand-10,500 units: cost $8.40 each 8 Purchased 29,000 units for $7.40 each. 14 Sold 20, 500 units for $13.90 each. 18 Purchased 15, 500 units for $6.90 each 25 Sold 19, 500 units for $12.90 each. 31 Inventory on hand-15,000 units. Required: Determine the inventory balance Altira would report in its August 31, 2018,...
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2018 is available: Aug.1 Inventory on hand-3,500 units; cost $7.60 each. 8 Purchased 15,000 units for $6.00 each. 14 Sold 10,500 units for $12.50 each. 18 Purchased 8,500 units for $5.50 each. 25 Sold 9,500 units for $11.50 each. 31 Inventory on hand-7,000 units. Required: Determine the inventory balance Altira would report in its August 31, 2018, balance sheet and...
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2016 is available: Aug.1 Inventory on hand—10,500 units; cost $8.80 each. 8 Purchased 30,000 units for $7.50 each. 14 Sold 21,000 units for $14.00 each. 18 Purchased 16,000 units for $7.00 each. 25 Sold 20,000 units for $13.00 each. 31 Inventory on hand—15,500 units. Required: Determine the inventory balance Altira would report in its August 31, 2016, balance sheet and...
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Using calculations based on a periodic inventory system, determine the inventory balance Altira would report in its August 31, 2021, balance sheet and the cost of goods sold it would report in its August 2021 income statement using the FIFO method. Aug.1 Inventory on hand-2,300 units; cost $5.60 each. 8 Purchased 11,500 units for $5.80 each. 14 Sold 9,200 units for $12.30 each....
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—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. 31 Inventory on hand—3,900 units. Required: a. Determine the inventory balance Altira would report in its August 31, 2018, balance sheet and...
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1Inventory on hand—2,400 units; cost $6.50 each.8Purchased 12,000 units for $5.90 each.14Sold 9,600 units for $12.40 each.18Purchased 7,200 units for $5.40 each.25Sold 8,600 units for $11.40 each.28Purchased 4,400 units for $5.80 each.31Inventory on hand—7,800 units. Using calculations based on a perpetual inventory system, determine the inventory balance Altira would report in its August 31, 2021, balance sheet and the cost of goods sold it would...
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1Inventory on hand—3,800 units; cost $7.10 each.8Purchased 19,000 units for $7.30 each.14Sold 15,200 units for $13.80 each.18Purchased 11,400 units for $7.40 each.25Sold 14,200 units for $12.80 each.28Purchased 5,800 units for $5.80 each.31Inventory on hand—10,600 units. Required:Using calculations based on a periodic inventory system, determine the inventory balance Altira would report in its August 31, 2021, balance sheet and the cost of goods sold it would...
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...
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...