In: Accounting
Using a perpetual system, what is the cost of the goods sold for November if the company uses LIFO?
| Nov. 01 | Inventory | 22 units at $21.00 |
| Nov. 04 | Sold | 9 units |
| Nov. 10 | Purchased | 33 units at $23.00 |
| Nov. 17 | Sold | 25 units |
| Nov. 30 | Purchased | 23 units at $24.00 |
Using the perpetual LIFO system, what is the cost of the merchandise sold for November?
Answer)
Calculation of Cost of goods sold for November using LIFO method, perpetual inventory system
|
Date |
Goods Purchased |
Cost of goods sold |
Balance Inventory |
||||||
|
Number of Units |
Cost per Unit (In $) |
Goods Purchased(In $) |
Number of Units sold |
Cost per Unit (In $) |
Cost of Goods Sold (In $) |
Number of Units |
Cost per Unit (In $) |
Inventory Balance (In $) |
|
|
Nov'1 |
22 |
$ 21.00 |
$ 462.00 |
||||||
|
Nov'4 |
9 |
$ 21.00 |
$ 189.00 |
13 |
$ 21.00 |
$ 273.00 |
|||
|
Nov'10 |
33 |
$ 23.00 |
$ 759.00 |
13 |
$ 21.00 |
$ 273.00 |
|||
|
33 |
$ 23.00 |
$ 759.00 |
|||||||
|
Nov'17 |
25 |
$ 23.00 |
$ 575.00 |
13 |
$ 21.00 |
$ 273.00 |
|||
|
8 |
$ 23.00 |
$ 184.00 |
|||||||
|
Nov'30 |
23 |
$ 24.00 |
$ 552.00 |
13 |
$ 21.00 |
$ 273.00 |
|||
|
8 |
$ 23.00 |
$ 184.00 |
|||||||
|
23 |
$ 24.00 |
$ 552.00 |
|||||||
|
Total |
56 |
$ 1,311.00 |
34 |
$ 764.00 |
44 |
$ 1,009.00 |
Therefore cost of goods sold using LIFO method, perpetual inventory system is $ 764.