Periodic vs. Perpetual LIFO

Same Inventory. Same LIFO Rule. Different COGS.

LIFO always means that the newest costs are assigned to Cost of Goods Sold first. But when we apply LIFO matters. Under a periodic system, we wait until the end of the period. Under a perpetual system, we apply LIFO every time inventory is sold.

The Big Picture: Periodic LIFO and perpetual LIFO use the same basic rule - newest costs go to Cost of Goods Sold first. But they do not necessarily use the same newest costs.

Periodic LIFO: Look at all of the inventory available for the entire period.
Perpetual LIFO: Look only at the inventory available at the moment each sale occurs.

Start With the Inventory Activity

Assume Trailside Outfitters has the following inventory activity during the month:

Activity Units Cost Per Unit Total Cost
Beginning Inventory 10 $10 $100
Purchase #1 10 $12 $120
Sale #1 12 sold - -
Purchase #2 10 $14 $140
Sale #2 8 sold - -

Before doing anything with dollars, start with the units.

Work it first: How many units were available during the month? How many units were sold? How many units should remain in ending inventory?
Reveal the unit calculation

Units available:

10 beginning + 10 purchased + 10 purchased = 30 units available

Units sold:

12 + 8 = 20 units sold

Ending inventory:

30 available − 20 sold = 10 units remaining

Periodic LIFO

Under a periodic inventory system, we do not assign costs to Cost of Goods Sold every time a sale occurs.

Instead, we wait until the end of the period and look at all inventory costs available during the period.

Cost layers available for the entire month:

10 units @ $10 = $100
10 units @ $12 = $120
10 units @ $14 = $140

Total cost of goods available = $360
Work it first: We sold 20 units. Under periodic LIFO, which 20 units of cost should be assigned to Cost of Goods Sold?
Reveal Periodic LIFO

Periodic LIFO uses the newest costs from the entire period.

The 20 units assigned to Cost of Goods Sold are:

10 units @ $14 = $140
10 units @ $12 = $120

Periodic LIFO COGS = $260

That leaves the oldest layer in ending inventory:

10 units @ $10 = $100 ending inventory

Check:

$260 COGS + $100 Ending Inventory = $360 total cost available

Now Do the Same Problem Using Perpetual LIFO

Under a perpetual inventory system, we cannot wait until the end of the month.

Every time a sale happens, we must determine Cost of Goods Sold using the inventory layers that exist at that moment.

Sale #1

Before the first sale, the company has:

10 units @ $10
10 units @ $12

The company sells 12 units.
Work it first: Under perpetual LIFO, which costs go to Cost of Goods Sold for this first sale?
Reveal Sale #1

LIFO uses the newest inventory available when the sale occurs.

10 units @ $12 = $120
2 units @ $10 = $20

COGS for Sale #1 = $140

Inventory remaining after the sale:

8 units @ $10

Purchase #2 Arrives

The company then purchases another 10 units at $14 each.

Inventory immediately before Sale #2:

8 units @ $10
10 units @ $14

Sale #2

The company now sells another 8 units.

Work it first: Which inventory layer supplies the 8 units under perpetual LIFO?
Reveal Sale #2

The newest inventory available is the $14 layer.

8 units @ $14 = $112

COGS for Sale #2 = $112

Inventory remaining:

8 units @ $10 = $80
2 units @ $14 = $28

Ending Inventory = $108

Perpetual LIFO COGS

Work it first: Combine the Cost of Goods Sold from the two sales. What is total COGS under perpetual LIFO?
Reveal Perpetual LIFO COGS

Sale #1 COGS = $140

Sale #2 COGS = $112

$140 + $112 = $252 total Cost of Goods Sold

Ending Inventory = $108

Check:

$252 COGS + $108 Ending Inventory = $360 total cost available

Put Them Side by Side

Reveal the comparison
Periodic LIFO Perpetual LIFO
Cost of Goods Sold $260 $252
Ending Inventory $100 $108
Total Cost Available $360 $360
Why are the answers different?

Under periodic LIFO, we wait until the end of the period. That allows the $14 inventory purchased later in the month to be treated as part of the newest costs assigned to all units sold during the month.

Under perpetual LIFO, the first sale happened before the $14 inventory was purchased. We cannot use a cost layer that did not exist yet. The first sale therefore used the $12 and $10 layers.

That timing difference is what creates different Cost of Goods Sold and ending inventory amounts.

The Four Things to Remember

1
Units first.
Determine units available, units sold, and units remaining before assigning costs.
2
Periodic waits.
Periodic LIFO applies the LIFO assumption to all inventory available during the entire period.
3
Perpetual updates after every sale.
Each sale uses only the inventory layers available at that moment.
4
Always reconcile.
Cost of Goods Sold + Ending Inventory must equal total cost of goods available for sale.