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:
Cost of Goods Sold | Ending Inventory | |
January | $ | $ |
February | $ | $ |
Cost of Goods Sold | Ending Inventory | |
January | $ | $ |
February | $ | $ |
Cost of Goods Sold | Ending Inventory | |
January | $ | $ |
February | $ | $ |
Cost of Goods Sold | Ending Inventory | |
January | $ | $ |
February | $ | $ |
Cost of Goods Sold | Ending Inventory | |
January | $ | $ |
February | $ | $ |
Cost of Goods Sold | Ending Inventory | |
January | $ | $ |
February | $ | $ |
January | Cost of Goods Sold | Ending Inventory |
Difference | $ | $ |
February | Cost of Goods Sold | Ending Inventory |
Difference | $ | $ |
February | FIFO periodic: | LIFO periodic: |
Cost of Goods Sold: | $ | $ |
FIFO periodic
for January COST OF GOODS SOLD Opening stock+ purchases-closing stock
=4800+2870-6710
=960
for February COST OF GOODS SOLD Opening stock+ purchases-closing stock
=6710+1120-6150
=1680
Cost of Goods Sold | Ending Inventory | |
January | $ 960 | $ 6710 |
February | $ 1680 | $ 6150 |
FIFO perpetual
sales on 22 jan. 40*24=960
sale in the month of feb.
sale on 14 feb. 50*24= 1200
sale on 23 feb. 20*24=480
Cost of Goods Sold | Ending Inventory | |
January | $ 960 | $ 6710 |
February | $ 1680 | $ 6150 |
LIFO
LIFO Cost of goods sold = opening stock+purchses-closing stock
=3000+2870-4870
=1000
for the month of feb.
4870+1120-4060
=1930
LIFO periodic
Cost of Goods Sold | Ending Inventory | |
January | $ 1000 | $ 4870 |
February | $ 1930 | $ 4060 |
LIFO perpetual
cost of goods sold (jan)=40*25=1000
cost of goods sold (feb.) = 40*28=1120
= 10*27=270
= 20*27=540
Cost of Goods Sold | Ending Inventory | |
January | $ 1000 | $ 4870 |
February | $ 1930 | $ 4060 |
Weighted average (Round unit costs to 4 decimal places and round final answers to nearest dollar.)
cost of goods sold for the month of Jan.
4600+1250+1620-6534
=936
for the month of feb.
=6534+1120-5925.6
=1728.4
Cost of Goods Sold | Ending Inventory | |
January | $ 936 | $ 6534 |
February | $ 1728.4 | $ 5925.6 |
Alternative Inventory Methods Totman Company has the following transactions during the months of January and February:...
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 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: 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...
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 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...
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:...
Inventory Costing Methods VanderMeer Inc. reported the following information for the month of February: Inventory, February 1 57 units @ $18 Purchase: February 7 51 units @ $20 February 18 67 units @ $21 February 27 40 units @ $23 During February, VanderMeer sold 138 units. The company uses a periodic inventory system. Required: What is the value of ending inventory and cost of goods sold for February under the following assumptions. Assumption Cost of Goods Sold Ending Inventory 1....
Inventory Costing Methods Carrington Inc. reported the following information for the month of February: Inventory, February 1 63 units @ $26 Purchase: February 7 55 units @ $27 February 18 60 units @ $29 February 27 45 units @ $31 During February, Carrington sold 142 units. The company uses a periodic inventory system. Required: What is the value of ending inventory and cost of goods sold for February under the following assumptions. Assumption Cost of Goods Sold Ending Inventory 1....
Use the following data for #5-12: Inventory information is presented below. Please calculate the ending inventory, cost of goods sold, and gross profit for each of the six inventory methods below and answer the questions. Round answers to the nearest dollar. 4/1 - Beginning inventory - 12 units at $22 cost 4/10 - Purchase - 22 units at $23 cost 4/15 - Sale - 26 units ($30 sales price) 4/20 - Purchase - 27 units at $24 cost 4/25 -...