How to calculate LIFO and FIFO Perpetual

The basic concept underlying perpetual LIFO is the last in, first out (LIFO) cost layering system. Under LIFO, you assume that the last item entering inventory is the first one to be used. For example, consider stocking the shelves in a food store, where a customer purchases the item in front, which was likely to be the last item added to the shelf by a clerk. These LIFO transactions are recorded under the perpetual inventory system, where inventory records are constantly updated as inventory-related transactions occur.

What is Periodic LIFO?

In a periodic LIFO system, inventory records are only updated at the end of a reporting period.

Comparing Perpetual LIFO and Periodic LIFO

The only difference between the two cost flow concepts is how rapidly a cost layer is stripped away or replenished in the costing database. Under perpetual LIFO, there can be a great deal of this activity throughout a reporting period, with inventory layers being added and eliminated potentially as frequently as every day. This means that the costs at which items are sold could vary throughout the period, since costs are being drawn from the most recent of a constantly varying set of cost layers.

Under a periodic LIFO system, however, layers are only stripped away at the end of the period, so that only the very last layers are depleted.

In a period of continually increasing prices, a periodic LIFO system will result in the highest cost of goods sold and therefore the lowest net income, since it will always use up the most recently purchased inventory first. Conversely, in a period of decreasing prices, the reverse would be true.

The costing results of a perpetual LIFO system are more common than a periodic LIFO system, since most inventory is now tracked using computerized systems that maintain inventory records on a real-time basis.

Example of the Perpetual LIFO and Periodic LIFO Systems

ABC International acquires 10 green widgets on January 15 for $5, and acquires another 10 green widgets at the end of the month for $7. ABC sells five green widgets on January 16. Under a perpetual LIFO system, you would charge the cost of the five widgets sold on January 16 to the cost of goods sold as soon as the sale occurs, which means that the cost of goods sold is $25 (5 units x $5 each). Under a periodic LIFO system, you would wait until the end of the month and then record the sale, which means that you remove five units from the last layer recorded at the end of the month, which results in a charge to the cost of goods sold of $35 (5 units x $7 each).

   FIFO vs. LIFO

   Example 1 shows that per unit purchase cost increases continuously throughout the period ($10 --> $12 --> $14 --> $15).

   FIFO assumes that items purchased FIRST are sold FIRST.
      --> Cost of old purchase is recorded as cost of goods sold.
      --> Cost of recent purchases is recorded as cost of ending inventory.

      --> When price goes up, old price is lower than recent price.
      --> Cost of goods sold is lower for FIFO. ($11,000 < $12,400)
      --> Cost of ending inventory is higher for FIFO. ($8,600 > $7,200)

   LIFO assumes that items purchased LAST are sold FIRST.
      --> Cost of recent purchase is recorded as cost of goods sold.
      --> Cost of old purchases is recorded as cost of ending inventory.

      --> When price goes up, recent price is higher than old price.
      --> Cost of goods sold is higher for LIFO. ($12,400 > $11,000)
      --> Cost of ending inventory is lower for LIFO. ($7,200 < $8,600)

    FIFO, Perpetual Cost of Goods Sold = FIFO, Periodic Cost of Goods Sold
            ($11,000 = $11,000)

    FIFO, Perpetual Inventory Cost = FIFO, Periodic Inventory Cost
            ($8,600 = $8,600)

    LIFO, Perpetual Cost of Goods Sold < LIFO, Periodic Cost of Goods Sold
            ($12,400 < $13,600)

    Moving average, Perpetual Cost of Goods Sold 
         < Weighted average, Periodic Cost of Goods Sold
            ($11,750 < $12,250)

    Moving average, Perpetual Inventory Cost 
          > Weighted average, Periodic Inventory Cost
            ($7,895 > $7,350)

Is perpetual LIFO or FIFO?

Can LIFO be used on perpetual inventory system?

How is perpetual inventory calculated?

Is LIFO perpetual or periodic?