Answer)
Calculation of cost of ending inventory at December 31, 2021 using dollar-value LIFO method
Calculation of changes in inventory from previous year
Date |
Inventory at year end prices |
Price Index (Percentage) |
Inventory at base year prices |
Change from previous year |
December'31, 2017 |
$1,230,000 |
100 |
$1,230,000 |
- |
December'31, 2018 |
$1,554,000 |
105 |
$1,480,000 |
$250,000 |
December'31, 2019 |
$1,562,000 |
110 |
$1,420,000 |
($60,000) |
December'31, 2020 |
$1,848,600 |
117 |
$1,580,000 |
$160,000 |
Value of inventory:
December 31, 2017:
Value of ending inventory = $ 1,230,000 X 1.00
= $ 1,230,000
December 31, 2018:
Value of ending inventory = ($ 1,230,000 X 1.00) + ($ 250,000 X 1.05)
= $ 1,230,000 + $ 262,500
= $ 1,492,500
December 31, 2019:
Value of ending inventory = ($ 1,230,000 X 1.00) + ($ 190,000 X 1.05)
= $ 1,230,000 + $ 199,500 (refer note)
= $ 1,429,500
December 31, 2020:
Value of ending inventory = ($ 1,230,000 X 1.00) + ($ 190,000 X 1.05) + ($ 160,000 X 1.17)
= $ 1,230,000 + $ 199,500 + $ 187,200
= $ 1,616,700
Note: in the year ended December 31, 2019, the change of inventory value at base year prices from December 31, 2018 is negative (i.e. $ 60,000). Therefore even for the year ended December 31, 2019, year ended December 31, 2017 is taken as base year and change of inventory at base year price in 2019 vis-à-vis 2017, $ 190,000 (i.e. $ 1,420,000 - $ 1,230,000) is multiplied with price index of the year 2018.
Practice Exercise 8-04 Presented below is information related to Larkspur, Inc. Price Index Date End-of-Year Inventory...
Presented below is information related to Bonita Company. Ending Inventory (End-of-Year Prices) Date Price Index $ 78,300 100 169,936 169,128 December 31, 2017 December 31, 2018 December 31, 2019 December 31, 2020 December 31, 2021 December 31, 2022 191,457 226,345 269.220 Compute the ending inventory for Bonita Company for 2017 through 2022 using the dollar-value LIFO method. Compute the ending inventory for Bonita Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017 $ 2018 $ 2019...
Presented below is information related to Windsor Company. Ending Inventory (End-of-Year Prices) Price Index Date December 31, 2017 $ 84,700 100 December 31, 2018 164,199 147 December 31, 2019 161,112 168 December 31, 2020 181,636 182 196 December 31, 2021 218,932 December 31, 2022 258,825 203 Compute the ending inventory for Windsor Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017 $ 2018 2019 $ $ 2020 2021 2022 $ $
Presented below is information related to Metlock Company. Ending Inventory (End-of-Year Prices) Date Price Index December 31, 2017 $83,800 100 December 31, 2018 176,802 158 December 31, 2019 175,320 180 December 31, 2020 197,535 195 210 December 31, 2021 238,140 December 31, 2022 286,452 218 Compute the ending inventory for Metlock Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017 $ 2018 $ 2019 $ $ 2020 2021 2022
Presented below is information related to Wildhorse Company Date N Price Index Ending Inventory (End-of-Year Prices) $75.700 225.400 217,512 244,777 294,728 348.312 December 31, 2017 December 31, 2018 December 31, 2019 December 31, 2020 December 31, 2021 December 31, 2022 100 200 228 247 266 276 Compute the ending inventory for Wildhorse Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017 $ 2018 $ 2019 $ 2020 $ 2021 $ 2022 $
Presented below is information related to Metlock Company. Ending Inventory (End-of-Year Prices) Price Index Date December 31, 2017 $ 83,800 100 December 31, 2018 176,802 158 December 31, 2019 175,320 180 195 December 31, 2020 197,535 238,140 210 December 31, 2021 December 31, 2022 286,452 218 Compute the ending inventory for Metlock Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 83,800 230,743 2017 2018 2019 2020 2021 $ $ $ $ $ 22840 268063 353334 2022...
Presented below is information related to Bramble Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2017 $ 81,000 100 December 31, 2018 201,017 179 December 31, 2019 198,696 204 December 31, 2020 223,873 221 December 31, 2021 269,416 238 December 31, 2022 324,311 247 Compute the ending inventory for Bramble Company for 2017 through 2022 using the dollar-value LIFO method.
Presented below is information related to Splish Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2017 $ 83,600 100 December 31, 2018 261,723 231 December 31, 2019 258,456 264 December 31, 2020 292,006 286 December 31, 2021 349,580 308 December 31, 2022 421,399 319 Compute the ending inventory for Splish Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017 $enter a dollar amount 2018 $enter a dollar amount 2019 $enter a dollar amount 2020...
Presented below is information related to Splish Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2017 $ 83,600 100 December 31, 2018 261,723 231 December 31, 2019 258,456 264 December 31, 2020 292,006 286 December 31, 2021 349,580 308 December 31, 2022 421,399 319 Compute the ending inventory for Splish Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017 $enter a dollar amount 2018 $enter a dollar amount 2019 $enter a dollar amount 2020...
Presented below is information related to Tamarisk Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2017 $ 87,400 100 December 31, 2018 212,625 189 December 31, 2019 209,304 216 December 31, 2020 235,170 234 December 31, 2021 281,736 252 December 31, 2022 339,039 261 Compute the ending inventory for Tamarisk Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017 $enter a dollar amount 87400 2018 $enter a dollar amount 134839 2019 $enter a dollar...
Presented below is information related to Sheffield Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2014 $ 84,700 100 December 31, 2015 164,199 147 December 31, 2016 161,112 168 December 31, 2017 181,636 182 December 31, 2018 218,932 196 December 31, 2019 258,825 203 Your answer is partially correct. Try again. Presented below is information related to Sheffield Company. Ending Inventory (End-of-Year Price Date Prices) Index December 31, 2014 $ 84,700 100 December 31, 2015 164,199 147 December...