In: Accounting
|
|
|
(a)
2020 | 2021 | |||||
Particulars | Product A | Product B | POOL | Product A | Product B | POOL |
Unit (A) | 18810 | 10260 | 14820 | 11400 | ||
Unit Cost ($) (B) | 30 | 25 | 36 | 26 | ||
Extended cost of Inventory @ Base years price i.e. 1st January(C= A*B) | 564300 | 256500 | 820800 | 533520 | 296400 | 829920 |
Extended cost of Inventory @ recent years price i.e. 31st December | 677160 | 266760 | 943920 | 592800 | 364800 | 957600 |
Price Index | 120 | 104 | 115 | 111 | 123 | 115 |
Price index for 2020 = 115
Price Index for 2021 = 115
(b)
Date | Ending inventory @ current year cost | Conversion factor | Ending inventoy at base year cost | Increase | Inventoy layers | Conversion factor (base ---- added year) | Inventory layer at added year cost | Dollar value LIFO value |
01-01-2020 | 598500 | 100 | 598500 | - | 598500 | 100 | 598500 | 598500 |
31-12-2020 | 943920 | 115 | 820800 | 123120 | 598500 | 100 | 598500 | |
123120 | 115 | 141588 | 740088 | |||||
31-12-2021 | 957600 | 115 | 829920 | 127680 | 598500 | 100 | 598500 | |
123120 | 115 | 141588 | ||||||
127680 | 115 | 146832 | 886920 |
Therefore Inventory value as per Dollar value LIFO method is :-
31.12.2020 - $ 740088
31.12.2021 - $ 886920