I Like Accounting

FIFO Inventory

Lesson
📖 Click Here for Lesson 📕 Click Here to Hide Lesson

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.

Question
You're managing an inventory system using the FIFO method.

You've been briefed with the following facts:

  • Your inventory of desks was purchased in different quantities and at different prices, as shown below:
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #1 49 $20 Desks
    Purchase #2 35 $16 Desks
    Purchase #3 48 $22 Desks
  • Right after updating your inventory records, customers bought 102 desks.

Using the FIFO method, what is the COGS of the items you just sold?
Answer
📖 Click Here for Answer & How to Solve 📕 Click Here to Hide Answer

👉 Answer:

  • The COGS is $1,936.00.

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

  1. The first step should be to write out the current inventory.
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct 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 PurchaseCountPrice per UnitProduct 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 PurchaseCountPrice per UnitProduct 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 PurchaseCountPrice per UnitProduct 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
Random FAR 🔀 Try Again 🔁