Applying Inventory Costing Methods: LIFO and Average Cost

TL;DR

LIFO and Average Cost are two ways to assign costs to inventory, impacting your cost of goods sold (COGS) and ending inventory values. LIFO assumes the latest inventory bought is sold first, while Average Cost uses a weighted average of all available inventory costs. Understanding these methods is key to accurately reporting profits and inventory on your financial statements.

1. The Mental Model

Think of inventory costing like a kitchen: when you grab ingredients, are you using the newest ones first (LIFO) or just mixing everything and taking a scoop (Average Cost)? How you decide this changes the "cost" of your finished dish and what's left in your pantry.

2. The Core Material

Inventory costing methods determine how you match the cost of goods purchased with the revenue they generate. Your choice impacts your financial statements, especially the income statement (COGS and net income) and balance sheet (ending inventory).

Last-In, First-Out (LIFO)

LIFO assumes that the last inventory items purchased are the first ones sold. This method is often chosen in periods of rising prices because it results in a higher COGS (matching higher recent costs with revenue) and thus lower taxable income. However, LIFO isn't permitted under International Financial Reporting Standards (IFRS) but is allowed under U.S. GAAP.

Key characteristics of LIFO:
* COGS: Higher during inflation, lower during deflation.
* Ending Inventory: Lower during inflation, higher during deflation (as older, lower costs remain).
* Net Income: Lower during inflation, higher during deflation.
* Tax: Lower tax liability during inflation due to lower net income.

Average Cost Method

Photo by Kindel Media on Pexels

The Average Cost method calculates a weighted-average cost for all inventory available for sale. This average cost is then applied to both the units sold (COGS) and the units remaining in inventory (ending inventory). This method smooths out price fluctuations, providing a middle-ground value for both COGS and ending inventory.

Key characteristics of Average Cost:
* COGS: A middle-ground value, less volatile than LIFO or FIFO.
* Ending Inventory: Also a middle-ground value, smoothing out fluctuations.
* Net Income: A middle-ground value, less volatile.
* Tax: A middle-ground tax liability, generally between LIFO and FIFO.

Both methods aim to match costs with revenues, but their assumptions about inventory flow lead to different financial outcomes.

Here's a look at the inventory cost flow for these methods:

graph TD
    A[Start Inventory Period] --> B{Purchase 1};
    B --> C{Purchase 2};
    C --> D{Purchase 3};
    D --> E{Units Available for Sale};

    E -- LIFO Assumption --> F[Sell Latest Units First];
    F --> G["COGS (Higher Costs)"];
    F --> H["Ending Inventory (Lower, Older Costs)"];

    E -- Average Cost Assumption --> I[Calculate Weighted Average Cost];
    I --> J["Apply Avg Cost to Units Sold"];
    I --> K["Apply Avg Cost to Ending Units"];
    J --> G;
    K --> H;

    G --> L[Impacts Income Statement (Higher COGS)];
    H --> M[Impacts Balance Sheet (Lower Inventory Value)];
    L & M --> N[End Inventory Period];

3. Worked Example

Let's use a simple example for a company selling widgets.

Inventory Activity for January:

• Jan 1: Beginning Inventory: 100 units @ \$10 each = \$1,000
• Jan 10: Purchase: 200 units @ \$12 each = \$2,400
• Jan 20: Purchase: 150 units @ \$13 each = \$1,950
• Jan 25: Sale: 300 units

Total Units Available for Sale: 100 + 200 + 150 = 450 units
Total Cost of Units Available for Sale: \$1,000 + \$2,400 + \$1,950 = \$5,350
Units Sold: 300 units
Ending Inventory Units: 450 - 300 = 150 units

Calculating with LIFO:

Photo by RDNE Stock project on Pexels

Cost of Goods Sold (COGS):
Under LIFO, we assume the last units purchased are sold first.
1. From Jan 20 purchase: 150 units @ \$13 = \$1,950
2. From Jan 10 purchase: 150 units @ \$12 = \$1,800 (remaining 300 - 150 = 150 units needed)
LIFO COGS = \$1,950 + \$1,800 = \$3,750

Ending Inventory:
The remaining 150 units come from the earliest purchases.
1. From Jan 1 beginning inventory: 100 units @ \$10 = \$1,000
2. From Jan 10 purchase: 50 units @ \$12 = \$600 (remaining 150 - 100 = 50 units needed)
LIFO Ending Inventory = \$1,000 + \$600 = \$1,600

Check: COGS + Ending Inventory = Total Cost Available for Sale (\$3,750 + \$1,600 = \$5,350. Correct!)

Calculating with Average Cost:

Photo by https://kaboompics.com/ on Pexels

Weighted-Average Cost per unit:
First, calculate the average cost of all units available for sale.
Total Cost of Units Available / Total Units Available = \$5,350 / 450 units = \$11.89 per unit (rounded)

Cost of Goods Sold (COGS):
Units Sold * Weighted-Average Cost per unit = 300 units * \$11.89 = **\$3,567**

Ending Inventory:
Ending Inventory Units * Weighted-Average Cost per unit = 150 units * \$11.89 = **\$1,783.50**

Check: COGS + Ending Inventory = Total Cost Available for Sale (\$3,567 + \$1,783.50 = \$5,350.50. Slight difference due to rounding, but essentially correct!)

4. Key Takeaways

• LIFO and Average Cost methods assign different costs to COGS and ending inventory, impacting financial statements.
• LIFO assumes the newest items are sold first, resulting in higher COGS during inflation.
• Average Cost uses a weighted average, smoothing out cost fluctuations.
• Your choice of method can significantly affect reported net income and tax liabilities.
• U.S. GAAP allows both LIFO and Average Cost, while IFRS does not permit LIFO.

Common Mistakes to Avoid:
* Mixing up assumptions: Don't apply LIFO's "last-in" rule to ending inventory; remember ending inventory under LIFO is made of the earliest costs.
* Calculation errors: Be precise when calculating the weighted average for the Average Cost method, especially with large numbers of units and purchases.
* Forgetting total costs: Always ensure that COGS plus ending inventory equals the total cost of goods available for sale as a check.
* Ignoring regulatory differences: Remember LIFO isn't allowed under IFRS; this is crucial if you're working with international companies.

5. Now Try It

Imagine a new scenario: Your company started February with 50 units @ \$20. On Feb 5, you bought 100 units @ \$22. On Feb 15, you bought another 70 units @ \