Learning Outcomes
- Illustrate the use of FIFO cost flow assumption
FIFO stands for First-in, First-out cost flow assumption, which means the first (oldest) purchase prices are the ones we assign to COGS. In other words, the current inventory is assigned the most recent costs. A familiar physical cost flow example of this assumption would be milk. The stock clerk loads milk from inside the refrigeration unit, putting the newest milk in behind the older cartons or jugs. When you pull the frosty door open and grab the first jug off the shelf, you are buying the oldest milk. The newer stuff is in the back (that’s why parents often reach up behind the containers in front to get the fresher milk in the back).
However, the cost flow assumption doesn’t have to match the physical flow of goods. It’s just a method of assigning costs to items that we don’t track via specific identification.
Same data as before—the list of sales, by date:
All | Revenue | |
---|---|---|
29-Oct | 6 | $120 |
20-Nov | 6 | $120 |
24-Dec | 19 | $380 |
Total | 31Double line | $620Double line |
And the purchases:
NewCo Sporting Goods | ||||
Product ID | Description | Cost | Quantity | Purchases |
---|---|---|---|---|
Slugger | purchased 10/15/20XX | 10.00 | 10 | 100.00 |
Slugger | purchased 11/15/20XX | 12.00 | 25 | 300.00 |
Slugger | purchased 12/15/20XX | 15.00 | 8 | 120.00 |
Total Purchases | $ 520.00 |
We’ll use the same worksheet format as before and do our calculations step by step, tracking purchases, COGS, and inventory on hand for each date that something happens, this time using the FIFO method of assigning costs to inventory.
Purchases | Cost of Goods Sold | Inventory on Hand | |||||||
---|---|---|---|---|---|---|---|---|---|
Dates | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
Oct 1 | 0 | $0 | $0 | ||||||
Oct 15 | 10 | $10 | $100 | 10 | $10 | $100 | |||
Oct 29 | 6 | $10 | $60 | 4 | $10 | $40 | |||
Nov 15 | 4 | $10 | $40 | ||||||
Nov 15 | 25 | $12 | $300 | 25 | $12 | $300 |
This time we’ll use the color coding a bit differently. Light green represents 10 units of inventory we purchased in mid-October. In late October, we sold six of those units, so we had four left. In mid-November, we bought 25 more baseball bats at a higher price. At that point, we had four old bats at $10 each and 25 new, fresh bats at $12 each. Here’s where FIFO starts to look different from specific identification and weighted average.
On November 20, NewCo sold six more bats. Under FIFO, we’ll pull the oldest costs first, until that pool is depleted, and then we’ll go to the next oldest, and so on.
Purchases | Cost of Goods Sold | Inventory on Hand | |||||||
---|---|---|---|---|---|---|---|---|---|
Dates | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
Oct 1 | 0 | $0 | $0 | ||||||
Oct 15 | 10 | $10 | $100 | 10 | $10 | $100 | |||
Oct 29 | 6 | $10 | $60 | 4 | $10 | $40 | |||
Nov 15 | 4 | $10 | $40 | ||||||
Nov 15 | 25 | $12 | $300 | 25 | $12 | $300 | |||
Nov 20 | 4 | $10 | $40 | 0 | $10 | $0 | |||
Nov 20 | 2 | $12 | $24 | 23 | $12 | $276 |
At the start of business on the 20th, NewCo had 29 bats in stock. Four of them were old, and 25 were newer. During the day, the company sold six bats. We don’t care which batch or pot or box they come from because we are using a cost flow assumption here that allows us to use the oldest costs first, regardless of when the bats were purchased or how much those particular bats actually cost.
We take the cost of four bats from the oldest batch, and that amount is depleted. Then, we assign the other two bats we sold on that day a cost basis from the next oldest batch, the November 15 purchase at $12 each.
Purchases | Cost of Goods Sold | Inventory on Hand | |||||||
---|---|---|---|---|---|---|---|---|---|
Dates | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
Oct 1 | 0 | $0 | $0 | ||||||
Oct 15 | 10 | $10 | $100 | 10 | $10 | $100 | |||
Oct 29 | 6 | $10 | $60 | 4 | $10 | $40 | |||
Nov 15 | 4 | $10 | $40 | ||||||
Nov 15 | 25 | $12 | $300 | 25 | $12 | $300 | |||
Nov 20 | 4 | $10 | $40 | 0 | $10 | $0 | |||
Nov 20 | 2 | $12 | $24 | 23 | $12 | $276 | |||
Dec 15 | 0 | $10 | $0 | ||||||
Dec 15 | 23 | $12 | $276 | ||||||
Dec 15 | 8 | $15 | $120 | 8 | $15 | $120 |
On December 15, NewCo bought eight more bats at $15 each. The October 15 pool is gone. There are 23 bats left in the November 15 pool, and now eight in the newest pool. Again, these are all accounting pools, not physical bats. If you compare this list to the specific ID, where we actually tracked the cost of each bat, you’ll find them different.
On the 24th of December, then, the 19 bats all came out of the oldest pool of 23 bats from November 15 at $12, leaving four theoretical bats in that pool, and all eight theoretical bats in the newest (December 15) pool. The first bats we bought were the first ones we considered to be sold: FIFO or “last-in, still-here” (no accountant uses the acronym LISH though).
<tr”>Dec 24
0$10$0
Purchases | Cost of Goods Sold | Inventory on Hand | |||||||
---|---|---|---|---|---|---|---|---|---|
Dates | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
Oct 1 | 0 | $0 | $0 | ||||||
Oct 15 | 10 | $10 | $100 | 10 | $10 | $100 | |||
Oct 29 | 6 | $10 | $60 | 4 | $10 | $40 | |||
Nov 15 | 4 | $10 | $40 | ||||||
Nov 15 | 25 | $12 | $300 | 25 | $12 | $300 | |||
Nov 20 | 4 | $10 | $40 | 0 | $10 | $0 | |||
Nov 20 | 2 | $12 | $24 | 23 | $12 | $276 | |||
Dec 15 | 0 | $10 | $0 | ||||||
Dec 15 | 23 | $12 | $276 | ||||||
Dec 15 | 8 | $15 | $120 | 8 | $15 | $120 | |||
Dec 24 | 19 | $12 | $228 | 4 | $12 | $48 | |||
Dec 24 | 8 | $15 | $120 |
Here is the entire table, completed:
Purchases | Cost of Goods Sold | Inventory on Hand | |||||||
---|---|---|---|---|---|---|---|---|---|
Dates | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
Oct 1 | 0 | $0 | $0 | ||||||
Oct 15 | 10 | $10 | $100 | 10 | $10 | $100 | |||
Oct 29 | 6 | $10 | $60 | 4 | $10 | $40 | |||
Nov 15 | 4 | $10 | $40 | ||||||
Nov 15 | 25 | $12 | $300 | 25 | $12 | $300 | |||
Nov 20 | 4 | $10 | $40 | 0 | $10 | $0 | |||
Nov 20 | 2 | $12 | $24 | 23 | $12 | $276 | |||
Dec 15 | 0 | $10 | $0 | ||||||
Dec 15 | 23 | $12 | $276 | ||||||
Dec 15 | 8 | $15 | $120 | 8 | $15 | $120 | |||
Dec 24 | 0 | $10 | $0 | ||||||
Dec 24 | 19 | $12 | $228 | 4 | $12 | $48 | |||
Dec 24 | 8 | $15 | $120 | ||||||
Totals | 43 | $520 | 31 | $352 | |||||
Ending Inventory | 0 | $10 | $0 | ||||||
4 | $12 | $48 | |||||||
8 | $15 | $120 | |||||||
12 | $168 |
Here is the gross profit calculation for FIFO using a perpetual inventory system:
Description | Amount |
---|---|
Gross sales | $ 620.00 |
Costs of goods sold | $352.00 |
Gross profit | Single Line$268.00Double Line |
Gross profit % | 43.23% |
Practice Question
Now that you have learned about FIFO, we’ll move on to cover LIFO next.