Question

In: Accounting

On January 1, 2021, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records...

On January 1, 2021, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records provided the following information:

Cost Retail
Beginning inventory $ 43,800 $ 73,000
Net purchases 169,940 295,000
Net markups 5,000
Net markdowns 7,000
Net sales 272,000
Retail price index, end of year 1.04



During 2022, purchases at cost and retail were $191,675 and $348,500, respectively. Net markups, net markdowns, and net sales for the year were $8,000, $9,000, and $305,000, respectively. The retail price index at the end of 2022 was 1.05.

Estimate ending inventory in 2022 using the dollar-value LIFO retail method. (Round your intermediate calculations to the nearest whole dollar. Round ratio calculation to the nearest whole percent.)

Solutions

Expert Solution

Step 1: Calculate Ending Inventory at Current Year Retail Prices for 2021

The value of ending inventory at current year retail prices for 2021 is calculated as below:

Beginning Inventory 73,000
Add Net Purchases 295,000
Net Markups 5,000
Less Net Markdowns -7,000
Goods Available for Sale 366,000
Less Net Sales -272,000
Estimated Ending Inventory at Current Year Retail Prices $94,000

_____

Step 2: Calculate Ending Inventory at Cost for 2021

The value of ending inventory at cost for 2021 is determined as follows:

Ending Inventory at
Year-End Retail Prices for 20211
Ending Inventory at
Base Year Retail Prices (1)
Inventory Layers at Base Year Retail Prices (2) Inventory Layers Converted to Cost (3)
94,000 90,385 (94,000/1.04) 73,000 (Base) X 1 60% (43,800/73,000*100) 43,800 (73,000*1*60%)
17,385 (90,385 - 73,000) [2021] X 1.04 58% [169,940/(295,000+5,000-7,000)] 10,487 (17,385*1.04*58%)
Total Ending Inventory at Cost $54,287

_____

Step 3: Calculate Ending Inventory at Current Year Retail Prices for 2022

The value of ending inventory at current year retail prices for 2022 is calculated as below:

Beginning Inventory 94,000
Add Net Purchases 348,500
Net Markups 8,000
Less Net Markdowns -9,000
Goods Available for Sale 441,500
Less Net Sales -305,000
Estimated Ending Inventory at Current Year Retail Prices $136,500

_____

Step 4: Calculate Ending Inventory at Cost for 2022

The value of ending inventory at cost for 2022 is determined as below:

Ending Inventory at
Year-End Retail Prices for 2022
Ending Inventory at
Base Year Retail Prices (1)
Inventory Layers at Base Year Retail Prices (2) Inventory Layers Converted to Cost (3)
136,500 130,000 (135,000/1.05) 73,000 (Base) X 1 60% 43,800
17,385 (2021) X 1.04 58% 10,487
39,615 (130,000 - 73,000 - 17,385) [2022] X 1.05 55% [191,675/(348,500+8,000-9,000)] 22,878 (39,615*1.05*55%)
Total Ending Inventory at Cost $77,164

Answer is $77,164.

_____

Notes:

There can be a slight/minor difference in the final answer on account of rounding off values.


Related Solutions

On January 1, 2018, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records...
On January 1, 2018, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records provided the following information: Cost Retail Beginning inventory $ 60,750 $ 81,000 Net purchases 243,090 335,000 Net markups 7,000 Net markdowns 9,000 Net sales 312,000 Retail price index, end of year 1.04 Estimate ending inventory using the dollar-value LIFO retail method.
On January 1, 2021, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records provided the following information:
On January 1, 2021, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records provided the following information:  Estimate ending inventory using the dollar-value LIFO retail method and the information provided.
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 31,200 $ 48,000 Net purchases 82,720 112,000 $ 90,275 $ 118,800 Freight-in 2,400 2,900 Net markups 12,000 8,800 Net markdowns 2,400 2,600 Net sales to customers 109,815 104,960 Sales to employees (net of 20% discount) 2,900 4,640 Price Index: January...
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, 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, 2016, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions...
On January 1, 2016, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2016 and 2017 are as follows: 2016 2017 Cost Retail Cost Retail Beginning inventory $ 51,800 $ 74,000 Net purchases 101,150 125,000 $ 107,532 $ 131,700 Freight-in 3,700 4,200 Net markups 18,500 11,400 Net markdowns 3,700 3,900 Net sales to customers 125,250 118,800 Sales to employees (net of 20% discount) 3,000 6,720 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...
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 $330,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 $ 418,080 1.04 2022 429,840 1.08 2023 482,870 1.09 2024 520,240...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT