FIFO

  • 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:

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).

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:

NewCo Sporting Goods
Gross Profit Calculation
FIFO – perpetual
Description Amount
Gross sales $ 620.00
Costs of goods sold $352.00
Gross profit Single Line$268.00Double Line
Gross profit % 43.23%

Now that you have learned about FIFO, we’ll move on to cover LIFO next.