In: Accounting
Joy Co.'s recorded inventory information for the month of August is as follows:
| Beginning Inventory | 22 units at $15 each |
| First Purchase | 25 units at $18 each |
| Second Purchase | 21 units at $20 each |
| Sales | 48 units |
a. Determine the total cost of ending inventory
according to FIFO method.
$
b. Determine the total cost of ending inventory according to LIFO method.
$
Answer-a)- The total cost of ending inventory according to FIFO method =$400.
Explanation-
| FIFO Method | ||||||||
| Goods purchased | Cost of goods sold | Inventory balance | ||||||
| S.no. | # of units | Cost per unit | # of units sold | Cost per unit | Cost of goods sold | # of units | Cost per unit | Inventory balance |
| 1 | 22 | 15.00 | 330 | |||||
| 2 | 25 | 18.00 | 22 | 15.00 | 330 | |||
| 25 | 18.00 | 450 | ||||||
| 3 | 21 | 20.00 | 22 | 15.00 | 330 | |||
| 25 | 18.00 | 450 | ||||||
| 21 | 20.00 | 420 | ||||||
| 4 | 22 | 15 | 330 | 20 | 20.00 | 400 | ||
| 25 | 18 | 450 | ||||||
| 1 | 20 | 20 | ||||||
| Totals | 48 | 800 | 20 | 20 | 400 | |||
b)- The total cost of ending inventory according to LIFO method =$300.
Explanation-
| LIFO Method | ||||||||
| Goods purchased | Cost of goods sold | Inventory balance | ||||||
| S.no. | # of units | Cost per unit | # of units sold | Cost per unit | Cost of goods sold | # of units | Cost per unit | Inventory balance |
| 1 | 22 | 15.00 | 330 | |||||
| 2 | 25 | 18.00 | 22 | 15.00 | 330 | |||
| 25 | 18.00 | 450 | ||||||
| 3 | 21 | 20.00 | 22 | 15.00 | 330 | |||
| 25 | 18.00 | 450 | ||||||
| 21 | 20.00 | 420 | ||||||
| 4 | 21 | 20 | 420 | 20 | 15.00 | 300 | ||
| 25 | 18 | 450 | ||||||
| 2 | 15 | 30 | ||||||
| Totals | 48 | 900 | 20 | 15 | 300 | |||