Question

In: Accounting

At the beginning of 2018, Quentin and Kopps (Q&K) adopted the dollar-value LIFO (DVL) inventory method....

At the beginning of 2018, Quentin and Kopps (Q&K) adopted the dollar-value LIFO (DVL) inventory method. On that date the value of its one inventory pool was $81,000. The company uses an internally generated cost index to convert ending inventory to base year.


Required:
Determine the missing amounts in the inventory data for 2018 through 2021.

Year Ended Ending Inventory At Ending Inventory At Ending Inventory At
31-Dec Year-End Costs Base Year Costs Cost Index DVL Cost
2018 $                     95,550.00 $                     91,000.00 1.05
2019 $                   134,520.00 1.10
2020 $                   146,640.00 $                   122,200.00
2021 1.25 $                    130,820.00

Solutions

Expert Solution

Determine the missing amounts in the inventory data for 2018 through 2021.

Year Ended Ending Inventory At Ending Inventory At Ending Inventory At
31-Dec Year-End Costs Base Year Costs Cost Index DVL Cost
2018 $                     95,550.00 $                     91,000.00 1.05 (81000+10000*1.05) = 91500
2019 $                   134,520.00 134520/1.1 = 122290 1.10 (91500+34420) = 125920
2020 $                   146,640.00 $                   122,200.00 1.20 (91500+31200*1.1) = 125820
2021 157750 122200+4000 = 126200 1.25 $                    130,820.00

Related Solutions

On January 1, 2018, the Coldstone Corporation adopted the dollar-value LIFO retail inventory method. Beginning inventory...
On January 1, 2018, the Coldstone Corporation adopted the dollar-value LIFO retail inventory method. Beginning inventory at cost and at retail were $180,000 and $292,950, respectively. Net purchases during the year at cost and at retail were $736,000 and $911,000, respectively. Markups during the year were $9,000. There were no markdowns. Net sales for 2018 were $878,000. The retail price index at the end of 2018 was 1.05. What is the inventory balance that Coldstone would report in its 12/31/2018...
On January 1, 2018, Avondale Lumber adopted the dollar-value LIFO inventory method. The inventory value for...
On January 1, 2018, Avondale Lumber adopted the dollar-value LIFO inventory method. The inventory value for its one inventory pool on this date was $350,000. An internally generated cost index is used to convert ending inventory to base year. Year-end inventories at year-end costs and cost indexes for its one inventory pool were as follows: Year Ended Inventory Cost Index December 31 Year-End Costs (Relative to Base Year) 2018 $ 438,780 1.03 2019 451,540 1.07 2020 508,680 1.08 2021 548,895...
Olson Company adopted the dollar-value LIFO method for inventory valuation at the beginning of 2015. The...
Olson Company adopted the dollar-value LIFO method for inventory valuation at the beginning of 2015. The following information about the inventory at the end of each year is available from Olson's records: Year Current Costs Index 2014 $50,000 100 2015 60,000 108 2016 70,000 115 2017 73,000 125 2018 78,000 135 Required: 1. Calculate the dollar-value LIFO inventory at the end of each year. Do not round your intermediate calculations. Round final answers to the nearest dollar. 2015 2016 2017...
On January 1, 2021, the Coldstone Corporation adopted the dollar-value LIFO retail inventory method. Beginning inventory...
On January 1, 2021, the Coldstone Corporation adopted the dollar-value LIFO retail inventory method. Beginning inventory at cost and at retail were $180,000 and $282,000, respectively. Net purchases during the year at cost and at retail were $604,500 and $920,000, respectively. Markups during the year were $10,000. There were no markdowns. Net sales for 2021 were $900,000. The retail price index at the end of 2021 was 1.04. What is the inventory balance that Coldstone would report in its 12/31/2021...
On January 1, 2018, the Haskins Company adopted the dollar-value LIFO method for its one inventory...
On January 1, 2018, the Haskins Company adopted the dollar-value LIFO method for its one inventory pool. The pool’s value on this date was $850,000. The 2018 and 2019 ending inventory valued at year-end costs were $897,000 and $972,000, respectively. The appropriate cost indexes are 1.04 for 2018 and 1.08 for 2019. Required: Complete the below table to calculate the inventory value at the end of 2018 and 2019 using the dollar-value LIFO method. (Round "Year end cost index" to...
1/ On January 1, 2018, Badger Inc. adopted the dollar-value LIFO method. The inventory cost on...
1/ On January 1, 2018, Badger Inc. adopted the dollar-value LIFO method. The inventory cost on this date was $100,300. The ending inventory, valued at year-end costs, and the relative cost index for each of the next three years is below: Year-end Ending inventory at year-end costs Cost Index 2018 $ 126,945 1.05 2019 144,320 1.10 2020 154,860 1.20 In determining the inventory balance should Badger report in its 12/31/2019 balance sheet: Multiple Choice An additional layer of $23,330 is...
On January 1, 2018, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions...
On January 1, 2018, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2018 and 2019 are as follows: 2018 2019 Cost Retail Cost Retail Beginning inventory $ 42,000 $ 60,000 Net purchases 94,500 118,000 $ 108,108 $ 133,200 Freight-in 3,000 3,500 Net markups 15,000 10,000 Net markdowns 3,000 3,200 Net sales to customers 117,360 119,890 Sales to employees (net of 10% discount) 3,600 6,300 Price Index: January...
On January 1, 2018, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions...
On January 1, 2018, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2018 and 2019 are as follows: 2018 2019 Cost Retail Cost Retail Beginning inventory $ 58,500 $ 78,000 Net purchases 110,180 127,000 $ 115,808 $ 133,100 Freight-in 3,900 4,400 Net markups 19,500 11,800 Net markdowns 3,900 4,100 Net sales to customers 125,380 119,140 Sales to employees (net of 20% discount) 3,600 6,000 Price Index: January...
On January 1, 2018, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions...
On January 1, 2018, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2018 and 2019 are as follows: 2018 2019 Cost Retail Cost Retail Beginning inventory $ 42,000 $ 60,000 Net purchases 94,500 118,000 $ 108,108 $ 133,200 Freight-in 3,000 3,500 Net markups 15,000 10,000 Net markdowns 3,000 3,200 Net sales to customers 117,360 119,890 Sales to employees (net of 10% discount) 3,600 6,300 Price Index: January...
On January 1, 2021, Avondale Lumber adopted the dollar-value LIFO inventory method. The inventory value for...
On January 1, 2021, Avondale Lumber adopted the dollar-value LIFO inventory method. The inventory value for its one inventory pool on this date was $275,000. An internally generated cost index is used to convert ending inventory to base year. Year-end inventories at year-end costs and cost indexes for its one inventory pool were as follows: Year Ended Inventory Cost Index December 31 Year-End Costs (Relative to Base Year) 2021 $ 364,350 1.05 2022 374,960 1.09 2023 424,600 1.10 2024 454,260...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT