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 nearest dollar. |
Cost of Goods Sold | $ |
Ending Inventory | $ |
Cost of Goods Sold | $ |
Ending Inventory | $ |
Cost of Goods Sold | $ |
Ending Inventory | $ |
Cost of Goods Sold | $1095 |
Ending Inventory | $2240 |
Cost of Goods Sold | $1047.50 |
Ending Inventory | $2287.50 |
Cost of Goods Sold | $1083 |
Ending Inventory | $2252 |
Explanations :-
FIFO :-
Total units available for sale = Beginning inventory + Purchase
= 200 + 200 + 250 + 300 = 950 units
Cost of Goods available for sale = (200 * $3.20) + (200 * $3.5) + (250 * $3.6) + (300 * 3.65) = $3335
Ending Inventory consists 300 units purchased as on June 24
= 300 units * $3.65 = $1095
Cost of goods sold = Cost of Goods available for sale - Ending Inventory
= $3335 - $1095 = $2240
LIFO :-
Ending Inventory consists 100 units from Beginning Inventory, 50 units from June 17 & 150 units from June 24
= (100 * $3.20) + (50 * $3.60) + (150 * $3.65) = $1047.50
Cost of goods sold = Cost of Goods available for sale - Ending Inventory
= $3335 - $1047.50 = $2287.50
Average :-
(200 * $3.20) + (200 * $3.50)/400 = $3.35
Units sold = 300 units
Remaining = 100 units @ $3.35
Purchase June 17 = (250 * $3.60) + (100 * $3.35)/350 = $3.53
Sale June 21 = 200 units
Remaining units = 150 units @ $3.53
Purchase June 24 = (300 * $3.65) + (150 * $3.53)/450 = $3.61
Sale June 27 = 150 units
Ending Inventory = 300 units * $3.61 = $1083
Cost of goods sold = $3335 - $1083 = $2252
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month 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 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 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...
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...
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 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...
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...
Inventory Costing Methods-Perpetual Method Shiloh Company uses the perpetual inventory system for its merchandise inventory. The June 1 inventory for one of the items in the merchandise inventory consisted of 60 units with a unit cost of $60. Transactions for this item during June were as follows: June 5 Purchased 40 units @ $70 per unit 13 Sold 50 units @ 110 per unit 25 Purchased 30 units @ 72 per unit 29 Sold 20 units Required a. Calculate the...
Inventory Costing Methods Morrison Inc. reported the following information for the month of August: Inventory, August 1 61 units @ $26 Purchase: August 7 56 units @ $27 August 18 65 units @ $29 August 27 43 units @ $30 During August, Morrison sold 143 units. The company uses a periodic inventory system. Required: What is the value of ending inventory and cost of goods sold for August under the following assumptions. Assumption Cost of Goods Sold Ending Inventory 1....