Finance Brain
Sign in
← Back to decks
Sign in to save your progress.Sign in

Inventory Cost Flow Methods

Identical goods bought at different prices raise a question: which cost goes to cost of goods sold and which stays in inventory? This lesson compares specific identification, FIFO, average cost and LIFO, under periodic and perpetual records, with one data set worked every way.

12 cards
Study this deck

Inventory Cost Flow Methods

In this lesson · 5 sections
Step 3 of 5

One data set, five answers

A distributor of commercial ceiling fans has this activity during a year:

DateEventUnitsUnit cost
January 1On hand1,00040
March 10Purchase3,00044
May 22Sale3,500
August 4Purchase3,00050
November 15Sale2,500

Goods available cost 322,000 for 7,000 units (40,000 + 132,000 + 150,000), and 1,000 units remain at year end.

MethodEnding inventoryCost of goods sold
FIFO, either system1,000 x 50 = 50,000272,000
Moving average, perpetual1,000 x 49 = 49,000273,000
Weighted average, periodic1,000 x 46 = 46,000276,000
LIFO, perpetual500 x 40 + 500 x 50 = 45,000277,000
LIFO, periodic1,000 x 40 = 40,000282,000

Workings:

  • Weighted average: 322,000 / 7,000 = 46 a unit.
  • Moving average: after March, 4,000 units cost 172,000, or 43 each. The May sale leaves 500 units costing 21,500. August adds 3,000 units, giving 3,500 units costing 171,500, or 49 each.
  • Perpetual LIFO: the May sale takes all 3,000 March units and 500 January units, leaving 500 at 40. The November sale takes 2,500 August units, leaving 500 at 50.
  • Periodic LIFO: the 1,000 units left are costed from the oldest layer, the January units at 40.