FIFO Inventory

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.

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

The only relevant information you've discovered is as follows:

  • Your inventory of capes was purchased in different quantities and at different prices, as shown below:
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #1 44 $39 Capes
    Purchase #2 40 $30 Capes
    Purchase #3 44 $25 Capes
    Purchase #4 36 $32 Capes
  • Right after updating your inventory records, customers bought 89 capes.
Using the FIFO method, what is the value of the ending inventory?

Answer:

  • The ending inventory is worth $2,127.00.

Explanation:

  1. The first step should be to write out the current inventory.
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #1 44 $39 Capes
    Purchase #2 40 $30 Capes
    Purchase #3 44 $25 Capes
    Purchase #4 36 $32 Capes
  2. Now write down the number of customer sales we need to account for (89) and the quantity of items that the firm bought in the earliest inventory purchase in our table (44).
  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 (44).
    89 - 44 = 45
  4. Now our inventory table looks like this.
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #2 40 $30 Capes
    Purchase #3 44 $25 Capes
    Purchase #4 36 $32 Capes
  5. Now write down the number of customer sales we need to account for (45) and the quantity of items that the firm bought in the earliest inventory purchase in our table (40).
  6. 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 (40).
    45 - 40 = 5
  7. Now our inventory table looks like this.
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #3 44 $25 Capes
    Purchase #4 36 $32 Capes
  8. Now write down the number of customer sales we need to account for (5) and the quantity of items that the firm bought in the earliest inventory purchase in our table (44).
  9. Since the number of items we need to account for (5) is lower than the remaining items left in the most recent inventory purchase (44), we can just reduce the quantity of items in the earliest inventory purchase by (5).
  10. Here's the final state of our inventory table:
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #3 39 $25 Capes
    Purchase #4 36 $32 Capes
  11. Sum the dollar value of each row in our inventory table.
    ROW UNIT COUNT * ROW PRICE PER UNIT = ROW INVENTORY VALUE
  12. Now we just have to do the math to arrive at our ending inventory.
    ENDING INVENTORY = 39 * $25 + 36 * $32
Random FAR Random in Category Try Again