Question

In: Accounting

Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May:...

Alternative Inventory Methods

Garrett Company has the following transactions during the months of April and May:

Date Transaction Units Cost/Unit
April 1 Balance 500
      17 Purchase 200 $5.40
      25 Sale 150
      28 Purchase 100 5.80
May 5 Purchase 250 5.40
      18 Sale 300
      22 Sale 50

The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions.

Required:

Compute the costs of goods sold for each month and the inventories at the end of each month for the following alternatives:FIFO periodic

Cost of Goods Sold Ending Inventory
April $   $  
May $   $  

FIFO perpetual

Cost of Goods Sold Ending Inventory
April $   $  
May $   $  

LIFO periodic

Cost of Goods Sold Ending Inventory
April $   $  
May $   $  

LIFO perpetual (Round your intermediate calculations to the nearest cent.)

Cost of Goods Sold Ending Inventory
April $   $  
May $   $  

Weighted average (Round unit costs to 4 decimal places and final answer to the nearest dollar.)

Cost of Goods Sold Ending Inventory
April $   $  
May $   $  


Moving average (Round unit costs to 2 decimal places. Round your final answers to nearest dollar.)

Cost of Goods Sold Ending Inventory
April $   $  
May $   $  


Reconcile the difference between the LIFO periodic and the LIFO perpetual results. If an amount is zero, enter "0".

April Cost of Goods Sold Ending Inventory
Difference $   $  
May Cost of Goods Sold Ending Inventory
Difference $   $  

Solutions

Expert Solution

Periodic FIFO

Periodic Average

Periodic LIFO

Perpetual FIFO

Perpetual Average

Perpetual LIFO


Related Solutions

Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May:...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 400       17 Purchase 200 $5.50       25 Sale 150       28 Purchase 100 5.75 May 5 Purchase 250 5.50       18 Sale 300       22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Required: 1. Compute the inventories at the end of...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May:...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 300       17 Purchase 200 $5.10       25 Sale 150       28 Purchase 100 5.70 May 5 Purchase 250 5.10       18 Sale 300       22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Required: 1. Compute the inventories at the end of...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May:...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 500       17 Purchase 200 $5.10       25 Sale 150       28 Purchase 100 5.80 May 5 Purchase 250 5.10       18 Sale 300       22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Required: 1. Compute the inventories at the end of...
Garrett Company has the following transactions during the months of April and May: Date Transaction Units...
Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 300       17 Purchase 200 $5.10       25 Sale 150       28 Purchase 100 5.80 May 5 Purchase 250 5.10       18 Sale 300       22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Required: 1. Compute the inventories at the end of each month and...
Alternative Inventory Methods Nevens Company uses a periodic inventory system. During November, the following transactions occurred:...
Alternative Inventory Methods Nevens Company uses a periodic inventory system. During November, the following transactions occurred: Date Transaction Units Cost/Unit November 1 Balance 500 $3.50 8 Sale 350 13 Purchase 300 4.00 21 Purchase 200 5.00 28 Sale 150 Required: 1. Compute the cost of goods sold for November and the inventory at the end of November for each of the following cost flow assumptions. If required, round your answers to the nearest dollar. FIFO Cost of Goods Sold $...
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of...
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of June: Units Cost/Unit Inventory, June 1 200 $3.20 Purchases:       June 3 200 3.50       June 17 250 3.60       June 24 300 3.65 Sales:       June 6 300       June 21 200       June 27 150 Required: 1. Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: If required, round your answers to the...
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of...
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of June: Units Cost/Unit Inventory, June 1 200 $3.20 Purchases: June 3 200 3.50 June 17 250 3.60 June 24 300 3.65 Sales: June 6 300 June 21 200 June 27 150 Required: 1. Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: If required, round your answers to the...
REC Tire Company completed the following perpetual inventory transactions during the month of May: May 1...
REC Tire Company completed the following perpetual inventory transactions during the month of May: May 1 Beginning invetntory 16 tires @ $65 each May 11 purchased 10 tires @ $75 each May 23 sold 12 tires at $90 each May 26 purchased 14 tires at $80 each May 29 sold 15 tires at $80 each In the partially completed schedules provided below, show : 1. the cost of goods sold for each of the sales; and 2. the value of...
Inventory Kobe Inc. has purchased the following inventory items during the month of April. April 1           ...
Inventory Kobe Inc. has purchased the following inventory items during the month of April. April 1            5,000 units @ $5 each April 10          10,000 units @ $10 each April 16          10,000 units @ $20 each April 28          5,000 units @ 15 each Beginning inventory for Kobe Inc. @ March 31, 2018 as 10,000 @ $1 each. Kobe Inc. sold 10,000 units for $30 on April 8 and 20,000 units for $40 on April 30. What would be the Cost of...
Randal company has the following inventory transactions for the month of April: Purchases: Units Cost Sales:...
Randal company has the following inventory transactions for the month of April: Purchases: Units Cost Sales: Units April 1 (beg. balance) 600 $6.00 April 3 500 4 1,500 $6.08 9 1,400 8 800 $6.40 11 600 13 1,200 $6.50 23 1,200 21 700 $6.60 27 900 29 500 $6.79 Instructions: 1) Assume Randal Company uses periodic inventory records. Determine the value of ending inventory using: a) FIFO b) LIFO c) Average-cost 2) Assume Randa lComapny uses perpetual inventory records. Determine...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT