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 each month and the cost of goods sold for each month for the following alternatives:
Cost of Goods Sold | Ending Inventory | |
April | $ | $ |
May | $ | $ |
Cost of Goods Sold | Ending Inventory | |
April | $ | $ |
May | $ | $ |
Cost of Goods Sold | Ending Inventory | |
April | $ | $ |
May | $ | $ |
Cost of Goods Sold | Ending Inventory | |
April | $ | $ |
May | $ | $ |
Cost of Goods Sold | Ending Inventory | |
April | $ | $ |
May | $ | $ |
Cost of Goods Sold | Ending Inventory | |
April | $ | $ |
May | $ | $ |
2. 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 | $ | $ |
3. If Garrett uses IFRS, which of the previous alternatives would be acceptable, and why?
If Garrett Company uses IFRS, it may report its inventory under ___________________________ . It may not use __________________ under IFRS because it is not consistent with any presumed physical flow of inventory. Also,_____________________________ is not allowed for tax purposes in most other countries, so there is no tax incentive for a company to use ___________________________ . Note that companies that use IFRS and have rising inventory costs will report a higher income because they include holding gains in income.
WORKINGS:
Units | Apr | May |
Gds.Av.for Sale | 600 | 700 |
Gds.Sold | 150 | 350 |
End./Inv. | 450 | 350 |
a. FIFO periodic | ||
April | ||
COGAS | ((300*5)+(200*5.10)+(100*5.7))= | 3090 |
COGS | 150*5= | 750 |
Ending Inv. | ((150*5)+(200*5.10)+(100*5.7))= | 2340 |
May | ||
COGAS | ((150*5)+(200*5.10)+(100*5.7))+(250*5.1)= | 3615 |
COGS | ((150*5)+(200*5.10)= | 1770 |
Ending Inv. | (100*5.7)+(250*5.1)= | 1845 |
b. FIFO perpetual | ||
April | ||
COGAS | ((300*5)+(200*5.10)+(100*5.7))= | 3090 |
COGS | 150*5= | 750 |
Ending Inv. | ((150*5)+(200*5.10)+100*5.7)= | 2340 |
May | ||
COGAS | ((150*5)+(200*5.10)+(100*5.7))+(250*5.1)= | 3615 |
COGS | (150*5)+(150*5.10)+(50*5.10)= | 1770 |
Ending Inv. | (100*5.7)+(250*5.1)= | 1845 |
c. LIFO periodic | ||
April | ||
COGAS | ((300*2)+(200*5.10)+(100*5.7))= | 2190 |
COGS | (100*5.7)+(50*5.1)= | 825 |
Ending Inv. | (300*2)+(150*5.10)= | 1365 |
May | ||
COGAS | (300*2)+(150*5.10)+(250*5.1)= | 2640 |
COGS | (250*5.1)+(50*5.1)+(50*5.1)= | 1785 |
Ending Inv. | (300*2)+(50*5.10)= | 855 |
d. LIFO perpetual | ||
April | ||
COGAS | ((300*2)+(200*5.10)+(100*5.7))= | 2190 |
COGS | 150*5.10= | 765 |
Ending Inv. | ((300*2)+(50*5.10)+(100*5.7))= | 1425 |
May | ||
COGAS | ((300*2)+(50*5.10)+(100*5.7)+(250*5.1))= | 2700 |
COGS | (250*5.1)+(50*5.7)+(50*5.7)= | 1845 |
Ending Inv. | ((300*2)+(50*5.10)= | 855 |
e. Weighted av. | ||
April | ||
COGAS | (300*4)+(200*5.1)+(100*5.7)= | 2790 |
COGS | 150*4.65= | 697.5 |
Ending Inv. | 450*4.65= | 2092.5 |
2790/600= 4.65 | ||
May | ||
COGAS | (450*4.65)+(250*5.1)= | 3367.5 |
COGS | 350*4.8107= | 1683.75 |
Ending Inv. | 350*4.8107= | 1683.75 |
3367.5/700=4.8107 | ||
f. Moving average | ||
April | ||
COGAS | (300*4)+(200*5.1)+(100*5.7)= | 2790 |
COGS | 150*4.44= | 666 |
Ending Inv. | (350*4.44)+(100*5.7) | 2124 |
((300*4)+(200*5.1))/500=4.44 | ||
May | ||
COGAS | (350*4.44)+(100*5.7)+(250*5.1)= | 3399 |
COGS | 350*4.8557= | 1699.50 |
Ending Inv. | 350*4.8557= | 1699.50 |
3399/700=4.8557 | ||
ANSWERS: | ||
a. FIFO periodic | ||
COGS | End.Inv. | |
April | 750 | 2340 |
May | 1770 | 1845 |
b. FIFO perpetual | ||
COGS | End.Inv. | |
April | 750 | 2340 |
May | 1770 | 1845 |
c. LIFO periodic | ||
COGS | End.Inv. | |
April | 825 | 1365 |
May | 1785 | 855 |
d.LIFO perpetual | ||
COGS | End.Inv. | |
April | 765 | 1425 |
May | 1845 | 855 |
e. Weighted av. | ||
COGS | End.Inv. | |
April | 697.5 | 2092.5 |
May | 1683.75 | 1683.75 |
f.Moving average | ||
COGS | End.Inv. | |
April | 666 | 2124 |
May | 1699.5 | 1699.5 |
2.. | ||||
LIFO | Periodic-Perpetual | |||
April | COGS | Ending Inventory | ||
Difference | 825-765= | 60 | 1365-1425= | -60 |
May | COGS | Ending Inventory | ||
Difference | 1785-1845= | -60 | 855-855= | 0 |
3. If Garrett uses IFRS, which of the previous alternatives would be acceptable, and why? |
If Garrett Company uses IFRS, it may report its inventory under FIFO or weighted average method. It may not use LIFO under IFRS because it is not consistent with any presumed physical flow of inventory. Also,LIFO method of valuation is not allowed for tax purposes in most other countries, so there is no tax incentive for a company to use LIFO. Note that companies that use IFRS and have rising inventory costs will report a higher income because they include holding gains in income. |
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 Cost/Unit April 1 Balance 17 Purchase 25 Sale Units 500 200 $5.40 28 May 5 18 22 5.70 5.40 Purchase Purchase Sale Sale 300 The cost of the inventory on April 1 Is 55, 54, and 52 per unit, respectively, under the FIFO, average and fine m ELLE he cost of the inventory on April 1 is $5, $4, and $2 per...
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.90 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: Compute the costs of goods sold for each...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 17 Purchase $5.10 25 Sale 500 200 150 100 250 300 28 Purchase 5.90 5.10 May 5 Purchase 18 Sale 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 costs of goods sold for...
PLEASE explain how to get the answer ? 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.90 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:...
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 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 each...
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.30 25 Sale 150 28 Purchase 100 5.70 May 5 Purchase 250 5.30 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 Totman Company has the following transactions during the months of January and February: Date Transaction Units Cost/Unit January 1 Balance 200 10 Purchase 50 $25 22 Sale 40 28 Purchase 60 27 February 4 Purchase 40 28 14 Sale 50 23 Sale 20 The cost of the inventory at January 1 is $24, $23, and $15 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Required: Compute the cost of goods sold for each...
4.Inventory Costing Methods Morrison Inc. reported the following information for the month of May: Inventory, May 1 57 units @ $26 Purchase: May 7 46 units @ $28 May 18 71 units @ $30 May 27 38 units @ $32 During May, Morrison sold 137 units. The company uses a periodic inventory system. Required: What is the value of ending inventory and cost of goods sold for May under the following assumptions. Assumption Cost of Goods Sold Ending Inventory 1....
2. During May, the following changes in inventory took place: SHOW ALL CALCULATIONS 1,100 units @ S25 S2 7,500 800 units@$3628,800 24 Purchases 700 units@$30 21,000 May 1 Balance 14 Purchases May 8 Sold 19 Sold 29 Sold 500 units@$50 300 units @ $49 600 units@ $54 A physical count indicates that 1,200 units are on hand on May 31. The company uses the PERPETUAL method. umin a. (1). LIFO (2). FIFO b. What is the moving average cost per...
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...