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 the cost of goods
sold it would report in its August 2018 income statement using the
FIFO method. (Round "Cost per Unit" to 2 decimal
places.)
b. 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 the LIFO method. (Round "Cost per Unit" to 2 decimal places.)
c. 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 the Average cost method. (Round "Average Cost per Unit" to 2 decimal places.)
Answer:
Perpetual FIFO |
Cost of Goods Available for Sale | Cost of Goods Sold- August 14 | Cost of Goods Sold-August 25 | Inventory Balance | ||||||||
# of Units | Cost per Unit | Cost of Goods Available for Sale | # of Units Sold | Cost per Unit | Cost of Goods Sold | # of Units Sold | Cost per Unit | Cost of Goods Sold | # of Units in Ending Inventory | Cost per Unit | Ending Inventory | |
Beg. Inventory | ||||||||||||
Purchases: | ||||||||||||
August 8 | ||||||||||||
August 18 | ||||||||||||
Total |
Perpetual LIFO |
Cost of Goods Available for Sale | Cost of Goods Sold- August 14 | Cost of Goods Sold-August 25 | Inventory Balance | ||||||||
# of Units | Cost per Unit | Cost of Goods Available for Sale | # of Units Sold | Cost per Unit | Cost of Goods Sold | # of Units Sold | Cost per Unit | Cost of Goods Sold | # of Units in Ending Inventory | Cost per Unit | Ending Inventory | |
Beg. Inventory | ||||||||||||
Purchases: | ||||||||||||
August 8 | ||||||||||||
August 18 | ||||||||||||
Total |
Perpetual Average | Inventory on Hand | Cost of Goods Sold | Inventory Balance | ||||||
# of Units | Cost per Unit | Inventory Value | # of Units | Average Cost per Unit | Cost Of Goods Sold | # of Units in Ending Inventory | Cost Per Unit | Ending Inventory | |
Beginning Inventory | |||||||||
Purchase- August 8 | |||||||||
Sale- August 14 | |||||||||
Purchase- August 18 | |||||||||
Sale- August 25 | |||||||||
Total |
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | ||||||||||||
FIFO | ||||||||||||
Purchases | Cost of Goods Sold 14 | Cost of Goods Sold 25 | Ending Inventory | |||||||||
Date | Unit | Unit Cost | Total Cost | Unit | Unit Cost | Total Cost | Unit | Unit Cost | Total Cost | Unit | Unit Cost | Total Cost |
Aug 1 | 2,900 | $ 7.00 | $ 20,300 | |||||||||
Purchases: | ||||||||||||
Aug 8 | 14,500 | $ 6.40 | $ 92,800 | 2,900 | $ 7.00 | $ 20,300 | 5,800 | $ 6.40 | $ 37,120 | 3,900 | $ 6.00 | $ 23,400 |
Aug 18 | 8,700 | $ 6.00 | $ 52,200 | 8,700 | $ 6.40 | $ 55,680 | 4,800 | $ 6.00 | $ 28,800 | |||
Cost of Godos Sold | 11,600 | $ 75,980 | $ 65,920 | |||||||||
Ending Inventory | 3,900 | $ 23,400 | ||||||||||
LIFO | ||||||||||||
Purchases | Cost of Goods Sold | Ending Inventory | ||||||||||
Date | Unit | Unit Cost | Total Cost | Unit | Unit Cost | Total Cost | Unit | Unit Cost | Total Cost | |||
Aug 1 | 2,900 | $ 7.00 | $ 20,300 | |||||||||
Purchases: | ||||||||||||
Aug 8 | 14,500 | $ 6.40 | $ 92,800 | 8,700 | $ 6.00 | $ 52,200 | 10,600 | $ 6.40 | $ 67,840 | 2,900 | $ 7.00 | $ 20,300 |
Aug 18 | 8,700 | $ 6.00 | $ 52,200 | 2,900 | $ 6.40 | $ 18,560 | 1,000 | $ 6.40 | $ 6,400 | |||
Cost of Godos Sold | 11,600 | $ 70,760 | 10,600 | $ 67,840 | ||||||||
Ending Inventory | 3,900 | $ 26,700 | ||||||||||
Weighted Average | ||||||||||||
Purchases | Cost of Goods Sold | Ending Inventory | ||||||||||
Date | Unit | Unit Cost | Total Cost | Unit | Unit Cost | Total Cost | Unit | Unit Cost | Total Cost | |||
Aug 1 | 2,900 | $ 7.000 | $ 20,300 | |||||||||
Aug 8 | 14,500 | $ 6.40 | $ 92,800 | 17,400 | $ 6.500 | $ 113,100 | ||||||
Aug 14 | 11,600 | $ 6.500 | $ 75,400 | 5,800 | $ 6.500 | $ 37,700 | ||||||
Aug 18 | 8,700 | $ 6.00 | $ 52,200 | 14,500 | $ 6.200 | $ 89,900 | ||||||
Aug 18 | 10,600 | $ 6.200 | $ 65,720 | 3,900 | $ 6.200 | $ 24,180 | ||||||
Cost of Godos Sold | 22,200 | $ 141,120 | ||||||||||
Ending Inventory | 3,900 | $ 24,180 |
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,700 units cost $7.80 each. 8 Purchased 18,500 units for $7.20 each. 14 Sold 14, 800 units for $13.70 each. 18 Purchased 11, 100 units for $6.40 each. 25 Sold 13, 800 units for $12.70 each. 31 Inventory on hand 1.700 units. Required: 1. Determine the inventory balance Altira would report in its August 31,...
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 provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand—2,400 units; cost $6.50 each. 8 Purchased 12,000 units for $5.90 each. 14 Sold 9,600 units for $12.40 each. 18 Purchased 7,200 units for $5.40 each. 25 Sold 8,600 units for $11.40 each. 28 Purchased 4,400 units for $5.80 each. 31 Inventory on hand—7,800 units. 1. Using calculations based on a perpetual inventory system, determine the inventory balance Altira would...
Required information Nora Corporationes perpetual vertory The Bor rachomated merchandise during 14. to di for Lee the story becera w reports August 20 c het and the cost of goods wouport Good Cow Goode - Cod 2. Determine the invertory balance Aura would report in August 2013 balance sheet and the cost of goods sold it would report in August 20 income statement sang the LIFO method Round "Contorno 2 imelles) Required information At Corporation uses a perpetual the month...
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...
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,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. Required: 1. Using calculations based on a perpetual inventory system, determine the inventory balance Altira...
What are the average costs per unit? Required information Altira Corporation uses a perpetual inventory system. The following transactions affected its merchandise inventory during the month of August 2018 Inventory on hand-2.100 units: cost $6.20 each. 8 Purchased 10,500 units for $5.60 each. 14 Sold 8,400 units for $12.10 each. 18 Purchased 6,300 units for $5.40 each. 25 Sold 7,400 units for $11.10 each 31 Inventory on hand-3,100 units. Aug. 1 3. Determine the inventory balance Altira would report in...
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand—2,700 units; cost $6.00 each. 8 Purchased 13,500 units for $6.20 each. 14 Sold 10,800 units for $12.70 each. 18 Purchased 8,100 units for $6.30 each. 25 Sold 9,800 units for $11.70 each. 28 Purchased 4,700 units for $5.80 each. 31 Inventory on hand—8,400 units. Required: Using calculations based on a periodic inventory system, determine the inventory balance Altira would...