Question

In: Accounting

On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following...

On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018:

Cost Retail
Beginning inventory $ 81,000 $ 150,000
Net purchases 121,500 278,000
Net markups 8,000
Net markdowns 16,000
Net sales 228,000
Retail price index, 12/31/18 1.20


Required:
Calculate the estimated ending inventory and cost of goods sold for 2018.

Solutions

Expert Solution

Ans. Particulars Cost Retail
Beginning inventory 81000 150000
Add: Net purchases 121500 278000
Add: net markups 8000
Less: net markdowns -16000
Goods available for sale (excluding beginning inventory) 121500 270000
Goods available for sale (including beginning inventory) 202500 420000
Less: net sales -228000
Estimated ending inventory at current year retail prices 192000
Estimated ending inventory at cost 86400
Estimated cost of goods sold   (202500 - 86400) 116100
Base year cost-to-retail percentage                  =                     81000 / 150000 * 100
54%
2018 cost-to-retail percentage                             =                    121500 / 270000 * 100
45%
*Calculation of estimated ending inventory at cost:
Ending inventory at retail price   =   192000
Ending inventory at base year retail price   =   Ending inventory at retail / price index
192000 / 1.20
160000
Inventory layers at base year retail prices: (converted to cost)
150000 * 1 * 54% 81000
(160000-150000) * 1.20 * 45% 5400
Total ending inventory at cost 86400

Related Solutions

On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following...
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018: Cost Retail Beginning inventory $ 72,420 $ 142,000 Net purchases 107,100 264,000 Net markups 6,000 Net markdowns 15,000 Net sales 229,000 Retail price index, 12/31/18 1.05 Required: Calculate the estimated ending inventory and cost of goods sold for 2018.
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following...
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018: Cost Retail Beginning inventory $ 84,600 $ 141,000 Net purchases 129,500 264,000 Net markups 5,000 Net markdowns 10,000 Net sales 229,000 Retail price index, 12/31/18 1.20 Required: Calculate the estimated ending inventory and cost of goods sold for 2018. 171000 Ending inventory at retail Ending inventory at cost Cost of goods sold
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following...
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018: Cost Retail Beginning inventory $ 73,150 $ 133,000 Net purchases 113,400 257,000 Net markups 8,000 Net markdowns 13,000 Net sales 224,000 Retail price index, 12/31/18 1.12 Required: Calculate the estimated ending inventory and cost of goods sold for 2018. 1.Ending inventory at retail- 2.Ending inventory at cost- 3.Cost of goods sold-
On January 1, 2021, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following...
On January 1, 2021, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2021: Cost Retail Beginning inventory $ 78,880 $ 136,000 Net purchases 119,040 256,000 Net markups 6,000 Net markdowns 14,000 Net sales 230,000 Retail price index, 12/31/2021 1.10 Required: Calculate the estimated ending inventory and cost of goods sold for 2021 using the information provided. (Do not round intermediate calculations.) Ending inventory at retail 154000 ending inventory at cost ? cost...
On January 1, 2021, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following...
On January 1, 2021, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2021: Cost Retail Beginning inventory $ 81,760 $ 146,000 Net purchases 123,360 265,000 Net markups 4,000 Net markdowns 12,000 Net sales 238,000 Retail price index, 12/31/2021 1.10 Required: Calculate the estimated ending inventory and cost of goods sold for 2021 using the information provided. (Do not round intermediate calculations.) Ending inventory at retail   _____ Ending inventory at cost _____ Cost...
On January 1, 2016, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following...
On January 1, 2016, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2016: Cost Retail Beginning inventory $ 81,000 $ 150,000 Net purchases 121,500 278,000 Net markups 8,000 Net markdowns 16,000 Net sales 228,000 Retail price index, 12/31/16 1.20 Required: Calculate the estimated ending inventory and cost of goods sold for 2016.
On January 1, 2018, the Brunswick Hat Company adopted thedollar-value LIFO retail method. The following...
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018: Cost Retail Beginning inventory $ 72,900 $ 135,000 Net purchases 102,150 232,000 Net markups 5,000 Net markdowns 10,000 Net sales 200,000 Retail price index, 12/31/18 1.08Required: Calculate the estimated ending inventory at retail and ending inventory at cost and cost of goods sold for 2018.
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, 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, 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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT