prepare simple inventory valuation statements
4.5 Valuation of Inventory 📦
Imagine you run a small snack shop. Every day you buy new snacks, sell some, and keep the rest in your shop. Inventory valuation is the way you decide how much those snacks are worth on your books at the end of the month. It matters because it affects your profit and the taxes you pay. We’ll look at three common ways to value inventory: FIFO, LIFO, and the Weighted Average method.
1️⃣ FIFO – First In, First Out
Think of a line of people waiting for a concert. The first person in line gets the ticket first. FIFO assumes the first items you bought are the first ones you sell. The remaining inventory is valued at the most recent purchase prices.
2️⃣ LIFO – Last In, First Out
Now imagine a stack of plates. You always take the top plate first. LIFO assumes the last items you bought are the first ones you sell. The remaining inventory is valued at the earliest purchase prices.
3️⃣ Weighted Average
Picture a smoothie made from a mix of fruits. The taste is an average of all the fruits you used. The weighted average method calculates an average cost per unit based on all purchases, then applies that average to the ending inventory.
📊 Example: A Snack Shop
Our shop bought snacks in two batches during the month:
| Batch | Units Bought | Cost per Unit ($) | Total Cost ($) |
|---|---|---|---|
| Batch 1 | 100 | 5.00 | 500.00 |
| Batch 2 | 50 | 6.00 | 300.00 |
| Total | 150 | 800.00 |
At month‑end, 60 units remain in inventory. Let’s calculate the ending inventory value using each method.
FIFO Calculation
Under FIFO, the first 60 units sold are from Batch 1 (the oldest). The remaining 60 units are the last 60 units bought, all from Batch 2 at $6 each.
| Batch | Units in Ending Inventory | Cost per Unit ($) | Total Cost ($) |
|---|---|---|---|
| Batch 1 | 0 | 5.00 | 0.00 |
| Batch 2 | 60 | 6.00 | 360.00 |
| Total | 60 | 360.00 |
LIFO Calculation
Under LIFO, the first 60 units sold are from Batch 2 (the newest). The remaining 60 units are the last 60 units bought, all from Batch 1 at $5 each.
| Batch | Units in Ending Inventory | Cost per Unit ($) | Total Cost ($) |
|---|---|---|---|
| Batch 1 | 60 | 5.00 | 300.00 |
| Batch 2 | 0 | 6.00 | 0.00 |
| Total | 60 | 300.00 |
Weighted Average Calculation
First, find the average cost per unit: $$\text{Weighted Average Cost} = \frac{\text{Total Cost}}{\text{Total Units}} = \frac{800}{150} = 5.\overline{33}\text{ dollars}$$ Then multiply by the 60 units left: $$\text{Ending Inventory Value} = 60 \times 5.\overline{33} = 320.\overline{00}\text{ dollars}$$
| Method | Ending Inventory Value ($) |
|---|---|
| FIFO | 360.00 |
| LIFO | 300.00 |
| Weighted Average | 320.00 |
📚 Quick Recap
- FIFO values ending inventory at the most recent purchase prices.
- LIFO values ending inventory at the earliest purchase prices.
- Weighted Average uses an average cost per unit across all purchases.
- Choose the method that best reflects your business and complies with accounting standards.
🎉 You’ve just mastered how to create simple inventory valuation statements! Practice with different numbers and see how the ending inventory value changes. Good luck, future accountants! 🚀
Revision
Log in to practice.