FIFO Inventory

FIFO stands for first in, first out. This means that older inventory is sold first.

Imagine people lining up at store. The people at the front of the line have been there the longest. When a clerk is available, he'll go to the person at the front of the line, he'll speak to the person in the front of the line. In other words, the person that was there the longest is the first one who will get to complete his business and leave the line.

In other words, the first person that was waiting gets to be the first person to leave the line.

👉 Answer:

👩‍🎓 Here are the steps to figure it out:

1. The first step should be to write out the current inventory.

   Inventory Holdings

   Inventory Purchase	Count	Price per Unit	Product Name
   Purchase #1	49	$20	Desks
   Purchase #2	35	$16	Desks
   Purchase #3	48	$22	Desks

2. Now write down the number of customer sales we need to account for (102) and the quantity of items that the firm bought in the earliest inventory purchase in our table (49).
3. We need to account for more sales than can be covered by our most recent inventory purchase. Let's remove the entire earliest inventory purchase from our inventory table and reduce the number of sales we have to account for by the quantity of inventory we just removed (49).
   102 - 49 = 53
4. Don't forget that we're trying to solve for COGS though, so as we sell items, we have to record their costs.
   COGS FOR THIS ROW = 49 * $20
5. Now our inventory table looks like this.

   Inventory Holdings

   Inventory Purchase	Count	Price per Unit	Product Name
   Purchase #2	35	$16	Desks
   Purchase #3	48	$22	Desks

6. Now write down the number of customer sales we need to account for (53) and the quantity of items that the firm bought in the earliest inventory purchase in our table (35).
7. We need to account for more sales than can be covered by our most recent inventory purchase. Let's remove the entire earliest inventory purchase from our inventory table and reduce the number of sales we have to account for by the quantity of inventory we just removed (35).
   53 - 35 = 18
8. Don't forget that we're trying to solve for COGS though, so as we sell items, we have to record their costs.
   COGS FOR THIS ROW = 35 * $16
9. Now our inventory table looks like this.

   Inventory Holdings

   Inventory Purchase	Count	Price per Unit	Product Name
   Purchase #3	48	$22	Desks

10. Now write down the number of customer sales we need to account for (18) and the quantity of items that the firm bought in the earliest inventory purchase in our table (48).
11. Since the number of items we need to account for (18) is lower than the remaining items left in the most recent inventory purchase (48), we can just reduce the quantity of items in the earliest inventory purchase by (18).
12. Don't forget that we're trying to solve for COGS though, so as we sell items, we have to record their costs.
    COGS FOR THIS ROW = 18 * $22
13. Here's the final state of our inventory table:

    Inventory Holdings

    Inventory Purchase	Count	Price per Unit	Product Name
    Purchase #3	30	$22	Desks

14. And now we just have to take all of those statements where we figured out the COGS for each row, and add them up.
    TOTAL COGS = 49 * $20 + 35 * $16 + 18 * $22