In: Accounting
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, 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
statement using the FIFO method. (Round "Cost per Unit" to 2 decimal places.)
|
LIFO
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.)
|
Average Cost
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.)
|
Cost of goods available for sale
Date |
Explanation |
Units |
Unit cost |
Total cost |
Aug. 1 |
Beginning inventory |
10,500 |
$8.40 |
88,200 |
Aug. 8 |
Purchase |
29,000 |
$7.40 |
214,600 |
Aug. 18 |
Purchase |
15,500 |
$6.90 |
106,950 |
Total |
55,000 |
$409,750 |
FIFO Method
Step 1. Ending inventory
Date |
Units |
Unit cost |
Total cost |
Aug. 25 |
15,000 |
$6.90 |
$103,500 |
Step 2. Cost of goods sold
Cost of goods available for sale $409,750
Less: Ending inventory - $103,500
Cost of goods sold $306,250
LIFO Method
Step 1. Ending inventory
Date |
Units |
Unit cost |
Total cost |
Aug. 1 |
10,500 |
$8.40 |
$88,200 |
Aug. 8 |
4,500 |
$7.40 |
$33,300 |
|
$121,500 |
Step 2. Cost of goods sold
Cost of goods available for sale $409,750
Less: Ending inventory - $121,500
Cost of goods sold $288,250
Average cost method
Step 1. Ending inventory
Weighted average unit cost = Cost of goods available for sale/Total units available for sale
= 409,750/55,000
= $7.45
Ending inventory = 15,000 x 7.45
= $111,750
Step 2. Cost of goods sold
Cost of goods available for sale $409,750
Less: Ending inventory - $111,750
Cost of goods sold $298,000
Kindly give a positive rating if you are satisfied with the answer. Feel free to ask if you have any doubts. Thanks.