The following information related to ABC Inc.
Date Ending Inventory Price Index
December 31, 2013 $ 66,600 100
December 31, 2014 111,104 124
December 31, 2015 119,875 137
December 31, 2016 136,178 142
December 31, 2017 126,244 148
Use the dollar-value LIFO method to compute the ending inventory for ABC.
Ending Inventory:
2013 -
2014 -
2015 -
2016 -
2017 -
Solution:
Computation of inventory at base year prices and change from prior year -ABC Inc. | ||||
Year | Inventory at end of year prices | Price index | Inventory at base year prices | Change from Prior Years |
2013 | $66,600.00 | 100 | $66,600.00 | $0.00 |
2014 | $111,104.00 | 124 | $89,600.00 | $23,000.00 |
2015 | $119,875.00 | 137 | $87,500.00 | -$2,100.00 |
2016 | $136,178.00 | 142 | $95,900.00 | $8,400.00 |
2017 | $126,244.00 | 148 | $85,300.00 | -$10,600.00 |
Computation of dollar value inventory - LIFO | |
Particulars | Amount |
December 31, 2013: | |
$66,600*$1 | $66,600 |
Inventory at Dec 31, 2013 | $66,600 |
December 31, 2014: | |
$66,600*$1 | $66,600 |
$23,000*$1.24 | $28,520 |
Inventory at Dec 31, 2014 | $95,120 |
December 31, 2015: | |
$66,600*$1 | $66,600 |
$20,900*$1.24 | $25,916 |
Inventory at Dec 31, 2015 | $92,516 |
December 31, 2016: | |
$66,600*$1 | $66,600 |
$20,900*$1.24 | $25,916 |
$8,400*1.42 | $11,928 |
Inventory at Dec 31, 2016 | $104,444 |
December 31, 2017: | |
$66,600*$1 | $66,600 |
$18,700*$1.24 | $23,188 |
Inventory at Dec 31, 2017 | $89,788 |
The following information related to ABC Inc. Date Ending Inventory Price Index December 31, 2013...
The following information relates to the Pina Company. Date December 31, 2013 December 31, 2014 December 31, 2015 December 31, 2016 December 31, 2017 Ending Inventory (End-of-Year Prices) $ 65,400 107,690 115,976 130,410 121,104 Price Index 100 121 133 138 144 Use the dollar-value LIFO method to compute the ending inventory for Pina Company for 2013 through 2017. Ending Inventory 2013 2014 2015 2016 2017
The following information relates to the Tamarisk Company. Ending Inventory Price (End-of-Year Prices) Index Date December 31, 2013 December 31, 2014 December 31, 2015 December 31, 2016 December 31, 2017 $ 66,100 119,210 129,050 145,200 134,316 100 131 145 150 156 Use the dollar-value LIFO method to compute the ending inventory for Tamarisk Company for 2013 through 2017
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...
Presented below is information related to Bramble Company. Date Price Index 100 126 December 31, 2014 December 31, 2015 December 31, 2016 December 31, 2017 December 31, 2018 December 31, 2019 Ending Inventory (End-of-Year Prices) $ 77,100 140,238 138,528 155,844 185,808 223,590 156 168 174 Compute the ending inventory for Bramble Company for 2014 through 2019 using the dollar-value LIFO method. Ending Inventory 2014 2015 2017 2018 2019
8. (10 points) The following information relates to the Windsor Company. Ending Inventory Price Date (End-of-Year Prices) Index December 31, 2013 $ 63,500 100 December 31, 2014 105,434 119 December 31, 2015 113,446 December 31, 2016 128,792 December 31, 2017 118,158 141 Use the dollar-value LIFO method to compute the ending inventory for Windsor Company for 2013 through 2017.
Assignment CALCULATOR FULL SCRER CHS Price Index 100 Ending Inventory (End-of-Year Prices) $ 87,400 152,755 148,824 168,493 200,018 238,140 Date December 31, 2014 December 31, 2015 December 31, 2016 December 31, 2017 December 31, 2018 December 31, 2019 137 156 169 182 189 Compute the ending Inventory for Company for 2014 through 2019 using the dollar value LIFO method. Ending Inventory 2014 2015 2016 2017 2018 2019
The following information relates to the Steven Garcia Company. Ending Inventory Price Date (End-of-Year Prices) Index December 31, 2016 $68,900 100 December 31, 2017 115,712 128 December 31, 2018 125,386 142 December 31, 2019 139,722 146 December 31, 2020 131,121 153 Use the dollar-value LIFO method to compute the ending inventory for Garcia Company for 2016 through 2020. Ending Inventory 2016 2017 2018 $ $ $ 2019 to 2020 to
8. (10 points) The following information relates to the Windsor Company.DateEnding Inventory(End-of-Year Prices)PriceIndexDecember 31, 2013$ 63,500100December 31, 2014105,434119December 31, 2015113,446131December 31, 2016128,792136December 31, 2017118,158141Use the dollar-value LIFO method to compute the ending inventory for Windsor Company for 2013 through 2017. 8. (10 points) The following information relates to the Windsor Company. Date December 31, 2013 December 31, 2014 December 31, 2015 December 31, 2016 December 31, 2017 Ending Inventory Price (End-of-Year Prices) Index $ 63,500 100 105,434 119 113,446 131...
8. (10 points) The following information relates to the Windsor Company.DateEnding Inventory(End-of-Year Prices)PriceIndexDecember 31, 2013$ 63,500100December 31, 2014105,434119December 31, 2015113,446131December 31, 2016128,792136December 31, 2017118,158141Use the dollar-value LIFO method to compute the ending inventory for Windsor Company for 2013 through 2017. 8. (10 points) The following information relates to the Windsor Company Ending Inventory (End-of-Year Prices) Index Price Date $63,500 December 31, 2013 100 December 31, 2014 105,434 119 December 31, 2015 113,446 131 December 31, 2016 128,792 136 141 December...
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...