Question

In: Accounting

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—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.)

FIFO Cost of Goods Available for Sale Cost of Goods Sold - Periodic FIFO Ending Inventory - Periodic FIFO
# of units Cost per unit Cost of Goods Available for Sale # of units sold Cost per unit Cost of Goods Sold # of units in ending inventory Cost per unit Ending Inventory
Beginning Inventory 10,500 $8.40 $88,200 10,500 $8.40 $88,200 $8.40 $0
Purchases:
August 8 29,000 $7.40 214,600 29,000 $7.40 214,600 $7.40 0
August 18 15,500 $6.90 106,950 500 $6.90 3,450 15,000 $6.90 103,500
Total 55,000 $409,750 40,000 $306,250 15,000 $103,500


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.)

LIFO Cost of Goods Available for Sale Cost of Goods Sold - Periodic LIFO Ending Inventory - Periodic LIFO
# of units Cost per unit Cost of Goods Available for Sale # of units sold Cost per unit Cost of Goods Sold # of units in ending inventory Cost per unit Ending Inventory
Beginning Inventory 10,500 $8.40 $88,200 $8.40 $0 $8.40
Purchases:
August 8 29,000 $7.40 214,600 24,500 $7.40 181,300 4,500 $7.40 33,300
August 18 15,500 $6.90 106,950 15,500 $6.90 106,950 $6.90 0
Total 55,000 $409,750 40,000 $288,250 4,500 $33,300

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.)

Average Cost Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Ending Inventory - Average Cost
# of units Unit Cost 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 10,500 $8.40 $88,200
Purchases:
August 8 29,000 $7.40 214,600
August 18 15,500 $6.90 106,950
Total 55,000 $409,750 40,000 $7.45 $298,000 15,000 $7.45 $111,750

Solutions

Expert Solution

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.


Related Solutions

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,000 units; cost $6.50 each. 8 Purchased 12,000 units for $5.70 each. 14 Sold 9,000 units for $12.20 each. 18 Purchased 7,000 units for $5.20 each. 25 Sold 8,000 units for $11.20 each. 31 Inventory on hand—5,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...
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—5,000 units; cost $7.90 each. 8 Purchased 22,000 units for $6.70 each. 14 Sold 16,000 units for $13.20 each. 18 Purchased 12,000 units for $6.20 each. 25 Sold 15,000 units for $12.20 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...
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—7,000 units; cost $8.10 each. 8 Purchased 20,000 units for $6.50 each. 14 Sold 15,000 units for $13.00 each. 18 Purchased 11,000 units for $6.00 each. 25 Sold 14,000 units for $12.00 each. 31 Inventory on hand—9,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...
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,000 units; cost $8.00 each. 8 Purchased 26,000 units for $7.10 each. 14 Sold 19,000 units for $13.60 each. 18 Purchased 14,000 units for $6.60 each. 25 Sold 18,000 units for $12.60 each. 31 Inventory on hand—13,000 units. Determine the inventory balance Altira would report in its August 31, 2018, balance sheet and the...
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—6,500 units; cost $7.90 each. 8 Purchased 24,000 units for $6.90 each. 14 Sold 18,000 units for $13.40 each. 18 Purchased 13,000 units for $6.40 each. 25 Sold 17,000 units for $12.40 each. 31 Inventory on hand—8,500 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 2017 is available:
Inventory cost flow methods; periodic systemAltira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2017 is available:  Aug.1    Inventory on hand—6,500 units; cost $7.90 each.8    Purchased 24,000 units for $6.9 each.14    Sold 18,000 units for $13.4 each.18    Purchased 13,000 units for $6.4 each.25    Sold 17,000 units for $12.4 each.31    Inventory on hand—8,500 units.Required:Determine the inventory balance Altira would report in its August 31, 2017, balance sheet and the cost of goods sold it would report in...
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2018 is available:
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.80 each8 Purchased 30,000 units for $7.50 each14 Sold 21,000 units for $14.00 each18 Purchased 16,000 units for $7.00 each25 Sold 20,000 units for $13.00 each31 Inventory on hand - 15,500 unitsRequired: Determine the inventory balance Altira would report in it's August 31, 2018, balance sheet and the cost...
Altira Corporation uses a perpetual inventory system. The following transactions affected its merchandise inventory during the...
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,300 units; cost $7.40 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.20 each. 25 Sold 12,200 units for $12.30 each. 31 Inventory on hand—4,300 units. Exercise 8-14 Part 2 2. Determine the inventory balance Altira would report in its August 31, 2018, balance sheet...
Altira Corporation provides the following information related to its merchandise inventory during the month of August...
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand—2,000 units; cost $5.30 each. 8 Purchased 8,000 units for $5.50 each. 14 Sold 6,000 units for $12.00 each. 18 Purchased 6,000 units for $5.60 each. 25 Sold 7,000 units for $11.00 each. 28 Purchased 4,000 units for $5.80 each. 31 Inventory on hand—7,000 units. Required: Using calculations based on a periodic inventory system, determine the inventory balance Altira would...
Altira Corporation provides the following information related to its merchandise inventory during the month of August...
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 $6.90 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 $7.20 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: Using calculations based on a periodic inventory system, determine the inventory balance Altira would...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT