Question

In: Accounting

Aug.1 Inventory on hand—2,800 units; cost $6.10 each. 8 Purchased 14,000 units for $6.30 each. 14...

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 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 each of the following cost flow methods.

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. (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 2,800 $6.10 $17,080 2,800 $6.10 $17,080 0 $6.10 $0
Purchases:
August 8 14,000 $6.30 88,200 14,000 $6.30 88,200 0 $6.30 0
August 18 8,400 $6.40 53,760 x $6.40 x $6.40
August 28 4,800 $5.80 27,840 0 x $5.80
Total 30,000 $186,880 16,800 $105,280 0 $0

*IMPORTANT: The x's I placed in the boxes are the answers I need*

Solutions

Expert Solution

--Requirement asked

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 2,800 $                                                 6.10 $17,080 2,800 $             6.10 $17,080 0 $                               6.10 $               -  
Purchases:
Aug-08 14,000 $                                                 6.30 $88,200 14,000 $             6.30 $88,200 0 $                               6.30 $               -  
Aug-18 8,400 $                                                 6.40 $53,760 4600 $             6.40 $29,440 3,800 $                               6.40 $    24,320.00
Aug-28 4,800 $                                                 5.80 $27,840 0 $             5.80 $0 4,800 $                               5.80 $    27,840.00
Total 30,000 $186,880                               21,400 $134,720                                 8,600 $52,160

Related Solutions

Aug.1 Inventory on hand—2,800 units; cost $6.10 each. 8 Purchased 14,000 units for $6.30 each. 14...
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 would report in its August 31, 2021, balance sheet and the cost of goods sold it would report...
Aug.1 Inventory on hand—3,900 units; cost $8.00 each. 8 Purchased 19,500 units for $7.40 each. 14...
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. 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 report in...
Causwell Company began 2018 with 22,000 units of inventory on hand. The cost of each unit...
Causwell Company began 2018 with 22,000 units of inventory on hand. The cost of each unit was $6.00. During 2018 an additional 42,000 units were purchased at a single unit cost, and 32,000 units remained on hand at the end of 2018 (32,000 units therefore were sold during 2018). Causwell uses a periodic inventory system. Cost of goods sold for 2018, applying the average cost method, is $225,600. The company is interested in determining what cost of goods sold would...
Causwell Company began 2021 with 25,000 units of inventory on hand. The cost of each unit...
Causwell Company began 2021 with 25,000 units of inventory on hand. The cost of each unit was $6.00. During 2021 an additional 45,000 units were purchased at a single unit cost, and 35,000 units remained on hand at the end of 2021 (35,000 units therefore were sold during 2021). Causwell uses a periodic inventory system. Cost of goods sold for 2021, applying the average cost method, is $241,500. The company is interested in determining what cost of goods sold would...
Causwell Company began 2021 with 29,000 units of inventory on hand. The cost of each unit...
Causwell Company began 2021 with 29,000 units of inventory on hand. The cost of each unit was $4.00. During 2021 an additional 45,000 units were purchased at a single unit cost, and 39,000 units remained on hand at the end of 2021 (35,000 units therefore were sold during 2021). Causwell uses a periodic inventory system. Cost of goods sold for 2021, applying the average cost method, is $171,500. The company is interested in determining what cost of goods sold would...
A company has beginning inventory of 14 units at a cost of $12.00 each on October...
A company has beginning inventory of 14 units at a cost of $12.00 each on October 1. On October 5, it purchases 13 units at $13.00 per unit. On October 12 it purchases 23 units at $14.00 per unit. On October 15, it sells 39 units. Using the FIFO periodic inventory method, what is the value of the inventory at October 15 after the sale?
date activities units cost total units sold retail price total aug 1 beginning inventory 150 $8.00...
date activities units cost total units sold retail price total aug 1 beginning inventory 150 $8.00 $1,200.00 aug 10 sales 70 $80.00 $5,600.00 aug 20 purchases 50 $9.00 $450.00 aug 25 sales 100 $80.00 $8,000.00 aug 31 purchases 50 $9.25 $475.00 totals 250 $2125.00 170 Corey Church is a seller of designer sunglasses. Following is a summary of Corey Church’s purchases and sales for the month of August, 2020. Calculate the cost of the ending inventory under the A) FIFO...
On May 1, Black Bear Company had 400 units of inventory on hand, at a cost...
On May 1, Black Bear Company had 400 units of inventory on hand, at a cost of $4.00 each. The company uses a perpetual inventory system. All purchases and sales are on account. A record of inventory transactions for the month of May for the company is as follows: Purchases Sales 300@ $7.00 1,000 @ $7.00 400 @ $7.50 May 4 May 3 1,300@ $4.10 700 @ $4.40 14 16 29 500@ $4.75 18 Instructions a. Calculate the cost of...
A client is using and tracking inventory on hand. They purchased 10 widgets at $10 each...
A client is using and tracking inventory on hand. They purchased 10 widgets at $10 each and 10 widgets at $15 each. All of the widgets are sold in one transaction. Considering QuickBooks Online uses the FIFO method for tracking inventory, what is the best way to see line items affected in the sales transaction? Run a Balance Sheet, and select Inventory on hand to see the transaction history Open the customer invoice, and select the transaction journal Run an...
A company has inventory of 10 units at a cost of $10 each on June 1....
A company has inventory of 10 units at a cost of $10 each on June 1. On June 3, it purchased 20 units at $12 each. 12 units are sold on June 5. Using the average-cost periodic inventory method, what is the cost of the 12 units that were sold? Select one: a.  $136. b.  $130. c.  $204. d.  $340.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT