In: Accounting
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.
Sanderson Variety | ||||
For 2021 | Cost | Retail | ||
Beginning Inventory | $40,800 | $68,000 | ||
Plus: Net Purchases | 155,440 | 270,000 | ||
Net Markups | 6,000 | |||
Less: Net Markdowns | (8,000) | |||
Goods available for sale (excluding Beginning Inventory) | 155,440 | 268,000 | ||
Goods available for sale (including Beginning Inventory) | 196,240 | 336,000 | ||
Less: Net sales | 250,000 | |||
Estimated Ending Inventory at current year Retail Prices | 86,000 | |||
Estimated Ending Inventory at cost (calculated below) | 50,262 | |||
Estimated Cost of goods sold | 145,978 | |||
Ending Inventory at Year end Retail Prices | Ending Inventory at Base Year Retail Prices | Inventory layers at Base Year Retail Prices | Inventory layers converted to cost | |
86,000 | 86,000/1.02= 84,314 | 68,000 | 68,000*1*60%= | 40,800 |
16,314(84,314-68,000) | 16,314*1*58%= | 9,462 | ||
Total ending inventory at dollar value retail method | 50,262 | |||
Base layer cost to retail percentage | 40,800/68,000=60% | |||
Current layer cost to retail percentage | 155,440/268,000=58% | |||
Sanderson Variety | ||||
For 2022 | Cost | Retail | ||
Beginning Inventory | 50,262 | 86,000 | ||
Plus: Net Purchases | 168,000 | 301,000 | ||
Net Markups | 3,000 | |||
Less: Net Markdowns | (4,000) | |||
Goods available for sale (excluding Beginning Inventory) | 168,000 | 300,000 | ||
Goods available for sale (including Beginning Inventory) | 218,262 | 386,000 | ||
Less: Net sales | 280,000 | |||
Estimated Ending Inventory at current year Retail Prices | 106,000 | |||
Estimated Ending Inventory at cost (calculated below) | 58,098 | |||
Estimated Cost of goods sold | 160,164 | |||
Ending Inventory at Year end Retail Prices | Ending Inventory at Base Year Retail Prices | Inventory layers at Base Year Retail Prices | Inventory layers converted to cost | |
106,000 | 106,000/1,06=100,000 | 86,000 | 86,000*1*58.44%= | 50,258 |
14,000 | 14,000*1*56%= | 7,840 | ||
Total ending inventory at dollar value retail method | 58,098 | |||
Base layer cost to retail percentage | 50,262/86,000= 58.44% | |||
Current layer cost to retail percentage | 168,000/300,000= 56% |
Sanderson Variety | ||||
For 2021 | Cost | Retail | ||
Beginning Inventory | $40,800 | $68,000 | ||
Plus: Net Purchases | 155,440 | 270,000 | ||
Net Markups | 6,000 |