In: Accounting
Sheldon Company had 2,000 units of inventory costing $10,000 in beginning inventory at July 1st. During July, Sheldon Co. engaged in the following transactions:
July 3rd - The company paid cash to purchase 1,000
units of inventory for $6,500.
July 10th - The company paid cash to purchase 1,200
units of inventory for $8,400.
July 24th – The company paid cash to purchase 250 units of inventory for $2,125.
Throughout July, the company sold inventory 3,700 units of inventory for $44,400 cash.
20. What is the total cost of goods available for sale?
| a. |
$ 27,025 |
|
| b. |
$ 17,375 |
|
| c. |
$ 44,400 |
|
| d. |
$ 17,025 |
21Under a FIFO valuation method, what is the dollar value of Sheldon Co.’s cost of goods sold in July?
| a. |
$44,400 |
|
| b. |
$8,750 |
|
| c. |
$21,400 |
|
| d. |
$23,275 |
22Under a FIFO valuation method, what is the dollar value of Sheldon Co.’s ending inventory balance at July 31st?
| a. |
$5,625 |
|
| b. |
$3,750 |
|
| c. |
$17,375 |
|
| d. |
$8,750 |
23Under a LIFO valuation method, what is the dollar value of Sheldon Co.’s cost of goods sold for July?
| a. |
$44,400 |
|
| b. |
$21,400 |
|
| c. |
$18,275 |
|
| d. |
$23,275 |
24Under a LIFO valuation method, what is the dollar value of Sheldon Co.’s ending inventory balance at July 31st?
| a. |
$17,375 |
|
| b. |
$23,275 |
|
| c. |
$3,750 |
|
| d. |
$5,625 |
| Ans. 20 | Option a $27,025 | ||||
| Date | Units (a) | Total cost (b) | |||
| 01-Jul | 2000 | $10,000 | |||
| 03-Jul | 1000 | $6,500 | |||
| 10-Jul | 1200 | $8,400 | |||
| 24-Jul | 250 | $2,125 | |||
| Cost of goods available for sale | 4450 | $27,025 | |||
| Ans. 21 | Option c $21,400 | ||||
| First of all, we will calculate the Cost per unit of each transaction. | |||||
| Cost per unit = Total cost / Units | |||||
| Date | Units (a) | Total (b) | Cost per unit (b/a) | ||
| 01-Jul | 2000 | $10,000 | $5.00 | ||
| 03-Jul | 1000 | $6,500 | $6.50 | ||
| 10-Jul | 1200 | $8,400 | $7.00 | ||
| 24-Jul | 250 | $2,125 | $8.50 | ||
| *Now we can calculate the cost of goods under FIFO method. | |||||
| Periodic FIFO: | |||||
| Date | Units | Rate | Total | ||
| 01-Jul | 2000 | $5.00 | $10,000 | ||
| 03-Jul | 1000 | $6.50 | $6,500 | ||
| 10-Jul | 700 | $7.00 | $4,900 | ||
| Cost of goods sold | 3700 | $21,400 | |||
| *In FIFO method the units that have purchased first, are released the first one and the ending inventory | |||||
| units remain from the last purchases. | |||||
| Ans. 22 | Option 1st $5,625 | ||||
| Periodic FIFO: | |||||
| Ending inventory = Total cost of goods available for sale - Cost of goods sold | |||||
| $27,025 - $21,400 | |||||
| $5,625 | |||||
| Ans. 23 | Option d $23,275 | ||||
| Periodic LIFO: | |||||
| Date | Units | Rate | Total | ||
| 24-Jul | 250 | $8.50 | $2,125 | ||
| 10-Jul | 1200 | $7.00 | $8,400 | ||
| 03-Jul | 1000 | $6.50 | $6,500 | ||
| 01-Jul | 1250 | $5.00 | $6,250 | ||
| Cost of goods sold | 3700 | $23,275 | |||
| *In LIFO method the units that have purchased last, are released the first one and ending inventory units | |||||
| remain from the first purchase. | |||||
| Ans. 24 | Option c $3,750 | ||||
| Ending inventory = Total cost of goods available for sale - Cost of goods sold | |||||
| $27,025 - $23,275 | |||||
| $3,750 | |||||