In: Accounting
The following units of an item were available for sale during the year:
Beginning inventory | 7,200 units at $160 |
Sale | 4,800 units at $300 |
First purchase | 16,000 units at $168 |
Sale | 12,000 units at $300 |
Second purchase | 15,000 units at $176 |
Sale | 11,000 units at $300 |
The firm uses the perpetual inventory system, and there are 10,400 units of the item on hand at the end of the year. What is the total cost of the ending inventory according to (A) FIFO, and (B) LIFO? I need step by step solution to understand how to work it properly
Solution:
A. Computation of ending inventory under FIFO | ||||||||||||
Event | Beginning inventory | Purchases | Cost of Goods sold | Ending Inventory | ||||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
Beginning | 7200 | $160.00 | $11,52,000.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 7200 | $160.00 | $11,52,000.00 |
Sale | 7200 | $160.00 | $11,52,000.00 | 0 | $0.00 | $0.00 | 4800 | $160.00 | $7,68,000.00 | 2400 | $160.00 | $3,84,000.00 |
First purchase | 2400 | $160.00 | $3,84,000.00 | 16000 | $168.00 | $26,88,000.00 | 0 | $0.00 | $0.00 | 2400 | $160.00 | $3,84,000.00 |
16000 | $168.00 | $26,88,000.00 | ||||||||||
Sale | 2400 | $160.00 | $3,84,000.00 | 0 | $0.00 | $0.00 | 2400 | $160.00 | $3,84,000.00 | 6400 | $168.00 | $10,75,200.00 |
16000 | $168.00 | $26,88,000.00 | 9600 | $168.00 | $16,12,800.00 | |||||||
Second purchase | 6400 | $168.00 | $10,75,200.00 | 15000 | $176.00 | $26,40,000.00 | 0 | $0.00 | $0.00 | 6400 | $168.00 | $10,75,200.00 |
15000 | $176.00 | $26,40,000.00 | ||||||||||
Sale | 6400 | $168.00 | $10,75,200.00 | 0 | $0.00 | $0.00 | 6400 | $168.00 | $10,75,200.00 | 10400 | $176.00 | $18,30,400.00 |
15000 | $176.00 | $26,40,000.00 | 4600 | $176.00 | $8,09,600.00 | |||||||
Ending Inventory | 10400 | $18,30,400.00 |
B. Computation of ending inventory under LIFO | ||||||||||||
Event | Beginning inventory | Purchases | Cost of Goods sold | Ending Inventory | ||||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
Beginning | 7200 | $160.00 | $11,52,000.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 7200 | $160.00 | $11,52,000.00 |
Sale | 7200 | $160.00 | $11,52,000.00 | 0 | $0.00 | $0.00 | 4800 | $160.00 | $7,68,000.00 | 2400 | $160.00 | $3,84,000.00 |
First purchase | 2400 | $160.00 | $3,84,000.00 | 16000 | $168.00 | $26,88,000.00 | 0 | $0.00 | $0.00 | 2400 | $160.00 | $3,84,000.00 |
16000 | $168.00 | $26,88,000.00 | ||||||||||
Sale | 2400 | $160.00 | $3,84,000.00 | 0 | $0.00 | $0.00 | 12000 | $168.00 | $20,16,000.00 | 2400 | $160.00 | $3,84,000.00 |
16000 | $168.00 | $26,88,000.00 | 4000 | $168.00 | $6,72,000.00 | |||||||
Second purchase | 2400 | $160.00 | $3,84,000.00 | 15000 | $176.00 | $26,40,000.00 | 0 | $0.00 | $0.00 | 2400 | $160.00 | $3,84,000.00 |
4000 | $168.00 | $6,72,000.00 | 4000 | $168.00 | $6,72,000.00 | |||||||
15000 | $176.00 | $26,40,000.00 | ||||||||||
Sale | 2400 | $160.00 | $3,84,000.00 | 0 | $0.00 | $0.00 | 11000 | $176.00 | $19,36,000.00 | 2400 | $160.00 | $3,84,000.00 |
4000 | $168.00 | $6,72,000.00 | 4000 | $168.00 | $6,72,000.00 | |||||||
15000 | $176.00 | $26,40,000.00 | 4000 | $176.00 | $7,04,000.00 | |||||||
Ending Inventory | 10400 | $17,60,000.00 |