Question

In: Accounting

Ayayai Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month...

Ayayai Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month of June:

Date Explanation Units Unit Cost Total Cost
June 1 Beginning inventory 1,390 $4 $5,560.00
12 Purchases 2,230 5 11,150
15 Sale (2,640 )
16 Purchases 4,580 6 27,480
23 Purchases 1,640 7 11,480
27 Sales (5,460 )

Part 1

Determine the cost of goods sold and the cost of the ending inventory using (1) FIFO and (2) Average cost. (Round average
final answers to 2 decimal places, e.g. 1.25. Do not round intermediate calculations.)

FIFO Average
Cost of goods sold $enter a dollar amount $enter a dollar amount
Cost of ending inventory $enter a dollar amount $enter a dollar amount

Which cost formula results in the higher cost of goods sold? Why?

The select an option                                                                      averageFIFO cost formula results in a select an option                                                                      higherlower cost of goods sold because the cost of inventory is select an option                                                                      risingfalling.

Which cost formula results in the higher net income? Why?

The select an option                                                                      averageFIFO cost method formula in a select an option                                                                      higherlower profit because it produces the select an option                                                                      lowerhigher cost of goods sold when prices are select an option

Which cost formula results in the higher ending inventory? Why?

The select an option                                                                      averageFIFO cost formula results in a select an option                                                                      higherlower ending inventory because the cost of inventory is select an option                                                                      risingfalling.

Which cost formula results in the higher cash flow? Why?

select an option                                                                      AverageFIFOBoth cost formula result in the same pre-tax cash flow. The cost methods select an option                                                                      increasedecreasedo not change the pre-tax cash flows of a company.

Solutions

Expert Solution

1) FIFO

Purchase Cost of goods sold Balance
Date Units Price Total Units Price Total Units Price Total
June 1 1390 4 5560
June 12 2230 5 11150 1390 4 5560
2230 5 11150
June 15 1390 4 5560
1250 5 6250 980 5 4900
June 16 4580 6 27480 980 5 4900
4580 6 27480
June 23 1640 7 11480 980 5 4900
4580 6 27480
1640 7 11480
June 27 980 5 4900
4480 6 26880 100 6 600
1640 7 11480
Total 8450 550110 8100 43590 1740 12080

COGS : 43590

Ending inventory 12080

2)

Purchase Cost of Goods Sold Balance
Date Units Amont Total Units Amount Total Units Amount Total
June1 1390 4 5560
June 12 2230 5 11150 1390 4 5560
2230 5 11150
3620 16710/3620 =4.62 16710
June 15 2640 4.62 12196.8 980 4.62 4527.6
June 16 4580 6 27480 980 4.62 4527.6
4580 6 27480
5560 5.76 32007.6
June 23 1640 7 11480 5560 32007.6
1640 11480
7200 6.04 43487.6
June 27 5460 6.04 32978.4 1740 6.04 10509.6
Total 8100 45175.2 1740 6.04 10509.6

COGS 45175.2

Ending Inventory 10509.6

1) Which cost formula results in the higher cost of goods sold : AVERAGE COST because cost of invemtory is RISING

2) Which cost formula results in the higher net income : LIFO

Higher profit because lower cost of goods sold

3) Which cost formula results in the higher ending inventory LIFO Cost formula results in HIGHER ending inventory because RISING COST OF INVENTORY

4) Which cost formula results in the higher cash flow? FIFO This cost method increases the cash flow *


Related Solutions

Ayayai Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month...
Ayayai Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month of June: Date Explanation Units Unit Cost/Price Total Cost June 1 Beginning inventory 1,480 $5 $7,400 12 Purchases 2,340 6 14,040 15 Sale (2,420 ) 12 16 Purchases 4,280 7 29,960 23 Purchases 1,580 8 12,640 27 Sales (5,580 ) 15 alculate the gross profit for the month of June using (1) FIFO and (2) average cost. (Round average final answers to 2 decimal...
Riverside Inc. uses a perpetual iventory system and reports the following transactions for the month of...
Riverside Inc. uses a perpetual iventory system and reports the following transactions for the month of July. Show the inventory records using the FIFO,LIFO, and weighted Average methods. Under each method compute sales, cost of goods sold, and gross profit. July 1 Beginning inventory 12 units cost/price $100.00 July 4 Purchase 8 units Cost//Price 103.00 July 9 Purchase 5 units Cost/Price 104.00 July 17 Sale 21 units Cost/Price 249.99 July 21 Purchase 4 units Cost/Price 106.00 July 31 Sale 6...
Klump Co. uses a perpetual inventory system and had the following inventory transactions for the month...
Klump Co. uses a perpetual inventory system and had the following inventory transactions for the month of March. Beginning Inventory - 150 units at $81 March 7 Sold 70 units March 11 Purchase 200 units at $85 March 12 Sold 220 units If the company uses the FIFO inventory costing method, the amount of ending inventory reported on the balance sheet is:
Pina Colada Corp. uses a perpetual inventory system reports the following for the month of June....
Pina Colada Corp. uses a perpetual inventory system reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 130 $4 $520 12 Purchases 390 5 1,950 23 Purchases 230 6 1,380 30 Inventory 265 New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is incorrect. Calculate the average cost per unit, using a perpetual inventory system. Assume a sale of 430 units occurred on...
Culver Corporation uses a perpetual inventory system reports the following for the month of June. Date...
Culver Corporation uses a perpetual inventory system reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 140 $6 $840 12 Purchases 360 7 2,520 23 Purchases 230 8 1,840 30 Inventory 245 Calculate the average cost per unit, using a perpetual inventory system. Assume a sale of 430 units occurred on June 15 for a selling price of $9 and a sale of 55 units on June 27 for $10. (Round...
Flounder Corp. uses a perpetual inventory system reports the following for the month of June. Date...
Flounder Corp. uses a perpetual inventory system reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 130 $4 $520 12 Purchases 390 5 1,950 23 Purchases 220 6 1,320 30 Inventory 240 Partially correct answer iconYour answer is partially correct. Calculate the average cost per unit, using a perpetual inventory system. Assume a sale of 450 units occurred on June 15 for a selling price of $7 and a sale of...
Mead Company uses a perpetual inventory system and engaged in the following transactions during the month...
Mead Company uses a perpetual inventory system and engaged in the following transactions during the month of May: Date Transaction May 1 Made cash sales of $8,100; the cost of the inventory was $3,100. 5 Purchased $2,400 of inventory on credit. 9 Made credit sales of $3,500; the cost of the inventory sold was $2,100. 13 Paid sales salaries of $800 and office salaries of $500. 14 Paid for the May 5 purchases. 18 Purchased sales equipment costing $5,100; made...
ABC Corporation uses a perpetual inventory system. The following transactions affected itsmerchandise inventory during the month...
ABC Corporation uses a perpetual inventory system. The following transactions affected itsmerchandise inventory during the month of June 2018:June 2 Inventory on hand-1,500 units; cost$4.50 each. 6 Purchased 5,000 units for $5.00 each. 13 .Sold 5,500 units for $10.00 each. 21 Purchased 8,000 units for $5.50 each. 26 Sold 5,000 units for $9.00 each. 30 Inventory on hand-4,000 units. Determine the inventory balance ABC would report in its June 30, 2018, balance sheet and the cost of goods sold it...
Listed below are some transactions for Resistant Products Ltd., which uses a perpetual inventory system and...
Listed below are some transactions for Resistant Products Ltd., which uses a perpetual inventory system and reports under ASPE. May 2 Sold inventory on account to Jameson Inc., terms 2/10, n/30. Selling price $24,000; cost $9,600. 3 Received a portion of the inventory sold on the previous day because it was damaged inventory that could never be sold in the future. Selling price $1,800; cost $720. 5 Received a portion of the inventory sold on May 2 that was in...
Walstrom Company uses a perpetual inventory system and had the following inventory transactions for June 2019....
Walstrom Company uses a perpetual inventory system and had the following inventory transactions for June 2019. June 1 Beg. Inventory 50 units @ $14 for $700, on June 4 Purchased 115 units @ $15 for $1,725, on June 5 Sold 100 units, on June 10 Purchased 75 units @ $16 for $1,200, and on June 24 Sold 50 units. Total Cost of Goods Sold Available equals $3,625. The June 30th Ending Inventory is 90 units. The June 30th ending inventory...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT