View Full Version : Perpetual inventory, LIFO
Daisy2
Mar 7, 2007, 06:03 PM
1/1... Beginning Inventory... 1,000... $12
2/4... Purchase... 2,000... $18
2/20... Sale... 2,500... $30
4/2... Purchase... 3,000... $23
11/4... Sale... 2,000... $33
How do I compute cost of goods sold using LIFO under the perpetual inventory system?
bhet
Mar 7, 2007, 06:58 PM
under lifo inventory, it assumed the first purchases should be sold first.
... unit... unit cost... cost balance
beginning inventory 1000 $12 $12000 12000
purchase 2000 $18 36000 48000
sale (2500) - (39000) 9000
purchase 3000 23 69000 78000
sale 2000 - (43500) 34500
ending inventory: 34500
shotcut approach:
beginning inv: 1000
total purchases 5000
units available: 6000
less: sales 4500
unsold units 1500
cost of unsold units: (1500*23) = 34500
cost of goods sold:
beg inv. (1000*12) 12000
2/4 (2000*18) 36000
4/2 (1500*23) 34500
cost of goods sold: 82500
bhet
Mar 7, 2007, 07:04 PM
under lifo inventory, it assumed the first purchases should be sold first.
... unit.. . unit cost... cost... balance
beginning inventory... 1000... $12... $12000... 12000
purchase... 2000... $18... 36000... 48000
sale... (2500)... -... (39000)... 9000
purchase... 3000... 23... 69000... 78000
sale... (2000)... -... (43500)... 34500
ending inventory: 34500
shotcut approach:
beginning inv:... 1000
total purchases... 5000
units available:... 6000
less: sales... 4500
unsold units... 1500
cost of unsold units: (1500*23) = 34500
cost of goods sold:
beg inv (1000*12)... 12000
2/4 (2000*18)... 36000
4/2 (1500*23)... 34500
cost of goods sold:... 82500
CaptainForest
Mar 7, 2007, 08:27 PM
Hi there Daisy,
I will try to make this short and sweat.
LIFO means that you SELL the goods you received LAST, first.
On 2/20, you sold 2,500 units. Therefore, you sold them at 2/4 price of 2,000 x 18 and 500 units from 1/1 at 12.
COGS from the 2/20 sale = 2,000 x 18 + 500 x 12 = 36,000 + 6,000 = $42,000
11/4 Sale of 2,000 units.
We assume you sold 2,000 of the 3,000 of items purchased on 4/2 at 23
COGS from the 11/4 sale = 2,000 x 23 = $46,000
Total COGS for the year = 42,000 + 46,000 = $88,000
Also note that Perpetual Inventory means that you calculate COGS after EVERY sale. If it was Periodic Inventory, you would only calculate the COGS at the end of the year/accounting period.