LIFO

  • Illustrate the use of LIFO cost flow assumption

 

LIFO stands for Last-in, First-out cost flow assumption. This means the newest purchase prices are the ones we assign to COGS. In other words, the current inventory is assigned the oldest costs. A physical cost flow example of this assumption could be gravel at the landscaping yard. A truck comes in and dumps a load of gravel in an enclosure. Later, another truck comes and dumps more gravel on top of the first load.

A dump truck filled with a load of dirt.

A customer backs in and takes a quarter ton, but hardly scrapes the surface of the newest dumped rock. Another supply truck adds to the pile, and the next customer takes gravel from the front of the pile. The oldest gravel may sit there for years and years unless the company liquidates all the LIFO layers, clear back to the first one.

Again, the cost flow assumption doesn’t have to match the physical flow of goods. A grocery store could use LIFO to account for milk inventories, even though it would never sell the newest milk first, leaving the old stuff to sit and sour in the back. LIFO is just another 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 something happens. This time we’ll use the LIFO 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

Again, 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 two LIFO layers: four old October bats at $10 each and 25 new November bats at $12 each. Here’s where LIFO starts to look different from FIFO and the other assumptions.

On Nov 20, NewCo sold six more bats. Under LIFO, we’ll pull the newest costs first: all six bats we sold come from the November 15 purchase.

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 0 $10 $0 4 $10 $40
Nov 20 6 $12 $72 19 $12 $228

That leaves us with those four old bats and 19 of the 25 we just bought—on paper only. Remember this is just a theoretical cost flow assumption, not a reflection of the physical flow.

We add another LIFO layer on December 15 when we buy another eight bats at $15 each. Under LIFO, these will be the first costs out the door when the holiday rush hits.

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 0 $10 $0 4 $10 $40
Nov 20 6 $12 $72 19 $12 $228
Dec 15 4 $10 $40
Dec 15 19 $12 $228
Dec 15 8 $15 $120 8 $15 $120

On the 24th, we sell 19 bats:

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 0 $10 $0 4 $10 $40
Nov 20 6 $12 $72 19 $12 $228
Dec 15 4 $10 $40
Dec 15 19 $12 $228
Dec 15 8 $15 $120 8 $15 $120
Dec 24 4 $10 $40
Dec 24 11 $12 $132 8 $12 $96
Dec 24 8 $15 $120 0 $15 $0

The assumption is that the most recent purchases are the first to go out, like the gravel pit, regardless of which bats actually sold. We don’t bother color coding them because we don’t get significantly better information using that system.

For the 19 bats we sold, we assume they were the eight we just bought plus 11 out of the ones we bought right before that. At the end of the day, we still have those first four left in inventory and eight of the second batch of bats. A hundred years from now, if NewCo is still in business and because of inflation bats now cost us $130 each, we may have four bats in inventory that have a cost assigned to them of $10. That’s a strange thing about LIFO, and one of the reasons International Financial Reporting Standards (IFRS) doesn’t allow it, even though Generally Accepted Accounting Principles (GAAP) does.

Here’s the completed worksheet for LIFO (which could be called “first-in, still-here, or FISH, but it isn’t).

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 0 $10 $0 4 $10 $40
Nov 20 6 $12 $72 19 $12 $228
Dec 15 4 $10 $40
Dec 15 19 $12 $228
Dec 15 8 $15 $120 8 $15 $120
Dec 24 4 $10 $40
Dec 24 11 $12 $132 8 $12 $96
Dec 24 8 $15 $120 0 $15 $0
Totals 43 $520 31 $384
Ending Inventory 4 $10 $40
8 $12 $96
0 $15 $0
12 $136

And the gross profit calculation:

NewCo Sporting Goods
Gross Profit Calculation
LIFO – perpetual
Description Amount
Gross sales $ 620.00
Costs of goods sold $384.00
Gross profit Single Line$236.00Double Line
Gross profit % 38.06%

Next, we’ll compare all these different methods to see what kind of impact each one has on the business bottom line.