In: Accounting
Problem 8-11 Ivanhoe Company cans a variety of vegetable-type soups. Recently, the company decided to value its inventories using dollar-value LIFO pools. The clerk who accounts for inventories does not understand how to value the inventory pools using this new method, so, as a private consultant, you have been asked to teach him how this new method works. He has provided you with the following information about purchases made over a 6-year period. Date Ending Inventory (End-of-Year Prices) Price Index Dec. 31, 2013 $73,600 100 Dec. 31, 2014 128,856 118 Dec. 31, 2015 123,950 134 Dec. 31, 2016 147,022 146 Dec. 31, 2017 168,147 157 Dec. 31, 2018 199,584 162 You have already explained to him how this inventory method is maintained, but he would feel better about it if you were to leave him detailed instructions explaining how these calculations are done and why he needs to put all inventories at a base-year value. Compute the ending inventory for Richardson Company for 2013 through 2018 using dollar-value LIFO. Ending Inventory 2013 $ 2014 $ 2015 $ 2016 $ 2017 $ 2018 $
Date | Ending Inventory (End-of-Year Prices) | Price Index | Invetory at base year price | Change from Prior year | ||
Dec. 31, 2013 | $ 73,600.00 | $ 100.00 | $ 73,600.00 | $ - | ||
Dec. 31, 2014 | $ 128,856.00 | $ 118.00 | $ 109,200.00 | $ 35,600.00 | ||
Dec. 31, 2015 | $ 123,950.00 | $ 134.00 | $ 92,500.00 | $ (16,700.00) | ||
Dec. 31, 2016 | $ 147,022.00 | $ 146.00 | $ 100,700.00 | $ 8,200.00 | ||
Dec. 31, 2017 | $ 168,147.00 | $ 157.00 | $ 107,100.00 | $ 6,400.00 | ||
Dec. 31, 2018 | $ 199,584.00 | $ 162.00 | $ 123,200.00 | $ 16,100.00 | ||
Compute the $ value inventory | Rate | |||||
Dec. 31, 2013 | $ 73,600.00 | 1 | $ 73,600.00 | |||
Dec. 31, 2014 | $ 35,600.00 | 1.18 | $ 42,008.00 | |||
Total | $ 115,608.00 | |||||
Note | Dec. 31, 2015 | $ 73,600.00 | $ 73,600.00 | |||
$ 18,900.00 | 1.18 | $ 22,302.00 | ||||
Total | $ 95,902.00 | |||||
Dec. 31, 2016 | $ 73,600.00 | 1 | $ 73,600.00 | |||
$ 18,900.00 | 1.18 | $ 22,302.00 | ||||
$ 8,200.00 | 1.46 | $ 11,972.00 | ||||
Total | $ 107,874.00 | |||||
Dec. 31, 2017 | $ 73,600.00 | 1 | $ 73,600.00 | |||
$ 18,900.00 | 1.18 | $ 22,302.00 | ||||
$ 8,200.00 | 1.46 | $ 11,972.00 | ||||
$ 6,400.00 | 1.57 | $ 10,048.00 | ||||
Total | $ 117,922.00 | |||||
Dec. 31, 2018 | $ 73,600.00 | 1 | $ 73,600.00 | |||
$ 18,900.00 | 1.18 | $ 22,302.00 | ||||
$ 8,200.00 | 1.46 | $ 11,972.00 | ||||
$ 6,400.00 | 1.57 | $ 10,048.00 | ||||
$ 16,100.00 | 1.62 | $ 26,082.00 | ||||
Total | $ 144,004.00 | |||||
Note | The invetory at base year price $92500 is less then the beginning inventory base year price $ 109200 |