I Like Accounting

LIFO Inventory

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

LIFO stands for last in, first out. This means that newer inventory is sold first, and older inventory is kept longer.

Imagine a stack of cups. The ones closer to the top were stacked the most recently. When someone decides to take a cup, he'll take it from the top, right? That means he's going to get the cup that was placed in the stack more recently than the others. In other words, the last cup that was added in is the first cup that is taken out.

Coincidentally, many accountants reference the term LIFO when explaining that they are, in fact, the LIFO the party, which only further highlights the fact that accountants tend to have a terrible sense of humor.

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

This is what you've been told:

  • Right after updating your inventory records, customers bought 105 dishwashers.

  • Your inventory of dishwashers was purchased in different quantities and at different prices, as shown below:

    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #1 44 $26 Dishwashers
    Purchase #2 23 $22 Dishwashers
    Purchase #3 38 $40 Dishwashers

Using the LIFO method, what is the value of the ending inventory?
Answer
📖 Click Here for Answer & How to Solve 📕 Click Here to Hide Answer

👉 Answer:

  • The ending inventory is worth $1,144.00.

👨‍🎓 Here's how we arrived at the answer:

  1. The first step should be to write out the current inventory.
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #1 44 $26 Dishwashers
    Purchase #2 23 $22 Dishwashers
    Purchase #3 38 $40 Dishwashers
  2. Now write down the number of customer sales we need to account for (105) and the quantity of items that the firm bought in the most recent inventory purchase in our table (38).
  3. We need to account for more sales than can be covered by our most recent inventory purchase. Let's remove the entire most recent 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 (38).
    105 - 38 = 67
  4. Now our inventory table looks like this.
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #1 44 $26 Dishwashers
    Purchase #2 23 $22 Dishwashers
  5. Now write down the number of customer sales we need to account for (67) and the quantity of items that the firm bought in the most recent inventory purchase in our table (23).
  6. We need to account for more sales than can be covered by our most recent inventory purchase. Let's remove the entire most recent 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 (23).
    67 - 23 = 44
  7. Now our inventory table looks like this.
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #1 44 $26 Dishwashers
  8. Now write down the number of customer sales we need to account for (44) and the quantity of items that the firm bought in the most recent inventory purchase in our table (44).
  9. It looks like we have to sell all of the items from the most recent remaining purchase. We can just remove the most recent inventory purchase, and we'll have an accurate inventory count. Here's the final state of our inventory table:
  10. Here's the final state of our inventory table:
    Inventory Holdings
    Inventory PurchaseCountPrice per UnitProduct Name
    Purchase #1 44 $26 Dishwashers
  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 = 44 * $26
Random FAR 🔀 Try Again 🔁