This method requires that the cost of goods sold be determined by using the cost of units from the latest (newest) inventory layers. Therefore, when figuring out the cost of the 120 units sold on March 3, we need to take into calculation the cost of the 100 items from the second, latest layer (purchased on February 25, $12 per unit) and add the cost of 20 units from the first layer (beginning inventory, $10 per unit). The second layer is used first because it is newer than the first layer (beginning inventory).
As for the sale on May 17, the cost of goods sold is the cost of the 60 items from the third layer (purchased on April 6, $14 per item) plus the cost of 10 units from the first layer (beginning inventory, $10 per unit). Pay attention that for goods sold on May 17, we could not use the units from the second layer (purchased on February 25) because they were already used for the sale on March 3. The table below gives you a brief summary of LIFO application:
Illustration 10: Example of LIFO cost flow method under perpetual system
| Date |
Purchase |
Cost of Goods Sold |
Inventory |
||||||||||||
| Units |
x |
Cost |
= |
Total |
Units |
x |
Cost |
= |
Total |
Units |
x |
Cost |
= |
Total |
|
| Jan. 1 |
|
|
|
|
|
|
|
|
|
|
50 |
x |
$10 |
= |
$500 |
| Feb. 25 |
100 |
x |
$12 |
= |
$120 |
|
|
|
|
|
50 |
x |
$10 |
= |
$500 |
|
|
|
|
|
|
|
|
|
|
|
|
100 |
x |
$12 |
= |
$1,200 |
| Mar. 3 |
|
|
|
|
|
100 |
x |
$12 |
= |
$1,200 |
|
|
|
|
|
|
|
|
|
|
|
|
20 |
x |
$10 |
= |
$200 |
30 |
x |
$10 |
= |
$300 |
| Apr. 6 |
60 |
x |
$14 |
= |
$840 |
|
|
|
|
|
30 |
x |
$10 |
= |
$300 |
|
|
|
|
|
|
|
|
|
|
|
|
60 |
x |
$14 |
= |
$840 |
| May 17 |
|
|
|
|
|
60 |
x |
$14 |
= |
$840 |
|
|
|
|
|
|
|
|
|
|
|
|
10 |
x |
$10 |
= |
$100 |
20 |
x |
$10 |
= |
$200 |
|
|
|
|
|
|
|
Total COGS |
= |
$2,340 |
End. Inventory |
= |
$200 |
||||
The two preceding examples above show the computations of the cost of goods sold and ending inventory assuming the perpetual inventory system.


