In: Accounting
Marin Corporation adopted the dollar-value LIFO retail inventory
method on January 1, 2019. At that time the inventory had a cost of
$52,000 and a retail price of $100,000. The following information
is available.
|
Year-End |
Current Year |
Year End |
|||||
| 2019 | $119,780 | 60% | 106 | ||||
| 2020 | 147,400 | 63% | 110 | ||||
| 2021 | 124,260 | 64% | 114 | ||||
| 2022 | 148,750 | 61% | 125 | ||||
The price index at January 1, 2019, is 100.
Compute the ending inventory at December 31 of the years
2019–2022.
| YEAR 2019 | ||
| S. No. | Amount | |
| 1 | Ending Year Inventory at retail (Current Index) | 119780 |
| 2 | Ending Year Inventory at retail (Base Index ) (119780/1.06) | 113000 |
| 3 | Beginning inventory at retail, base | 100000 |
| 4 | Increase at retail (base index) (2-3) | 13000 |
| 5 | Increase at retail (Current index) (13000*1.06) | 13780 |
| 6 | Increase at cost (Current index) 13780*60% | 8268 |
| 7 | Beginning inventory cost | 52000 |
| 8 | Dollar Value Retail LIFO ending inventory (6+7) | 60268 |
| YEAR 2020 | ||
| S. No. | Amount | |
| 1 | Ending Year Inventory at retail (Current Index) | 147400 |
| 2 | Ending Year Inventory at retail (Base Index ) (147400/1.10) | 134000 |
| 3 | Beginning inventory at retail, base | 113000 |
| 4 | Increase at retail (base index) (2-3) | 21000 |
| 5 | Increase at retail (Current index) (21000*1.10) | 23100 |
| 6 | Increase at cost (Current index) 23100*63% | 14553 |
| 7 | Beginning inventory cost | 52000 |
| 8 | Dollar Value Retail LIFO ending inventory (6+7) | 66553 |
| YEAR 2021 | ||
| S. No. | Amount | |
| 1 | Ending Year Inventory at retail (Current Index) | 124260 |
| 2 | Ending Year Inventory at retail (Base Index ) (124260/1.14) | 109000 |
| 3 | Beginning inventory at retail, base | 134000 |
| 4 | Increase at retail (base index) (2-3) | -25000 |
| 5 | Increase at retail (Current index) (-25000*1.14) | -28500 |
| 6 | Increase at cost (Current index) 28500*64% | -18240 |
| 7 | Beginning inventory cost | 66553 |
| 8 | Dollar Value Retail LIFO ending inventory (6+7) | 48313 |
| YEAR 2022 | ||
| S. No. | Amount | |
| 1 | Ending Year Inventory at retail (Current Index) | 148750 |
| 2 | Ending Year Inventory at retail (Base Index ) (148750/1.25) | 119000 |
| 3 | Beginning inventory at retail, base | 109000 |
| 4 | Increase at retail (base index) (2-3) | 10000 |
| 5 | Increase at retail (Current index) (10000*1.25) | 12500 |
| 6 | Increase at cost (Current index) 12500*61% | 7625 |
| 7 | Beginning inventory cost | 48313 |
| 8 | Dollar Value Retail LIFO ending inventory (6+7) | 55938 |