In: Accounting
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows:
Cost | Retail | |||||
Gross purchases | $ | 333,900 | $ | 540,000 | ||
Purchase returns | 6,400 | 15,000 | ||||
Purchase discounts | 5,500 | |||||
Gross sales | 500,000 | |||||
Sales returns | 8,000 | |||||
Employee discounts | 5,500 | |||||
Freight-in | 29,000 | |||||
Net markups | 30,000 | |||||
Net markdowns | 15,000 | |||||
Sales to employees are recorded net of discounts.
Required:
3. Assume Raleigh Department Store adopts the dollar-value
LIFO retail method on January 1, 2020. Estimating ending inventory
for 2020 and 2021.
|
Solution:
LIFO Retail Method | |||
Cost | Retail | Cost to Retail ratio | |
Beginning Inventory | 36200 | 50000 | |
Add: Purchases | 333900 | 540000 | |
Add: Freight In | 29000 | ||
Less: Purchase Return | -6400 | -15000 | |
less: Purchase Discounts | -5500 | ||
Add: Net Markups | 30000 | ||
Less: Net Markdowns | -15000 | ||
Goods Available for Sale (excluding beginning inventory) | 351000 | 540000 | |
Goods Available for Sale (including beginning inventory) | 387200 | 590000 | |
Cost-to-retail Percentage ($351000/540000) | 65% | ||
Less: net sales | -4,92,000.00 | ||
Less: Employee Discounts | -5500 | ||
Estimated Ending Inventory at Retail | 92,500 | ||
Estimated Ending Inventory at Cost | 63825 | ||
Estimated Ending Inventory at Cost (Working): | |||
Retail | Cost | ||
Beginning Inventory | 50000 | 36200 | |
Current Period's Layer | 42,500 | 27625 | |
Total | 92500 | 63825 |
Raleigh Department Store | |||
Dollar-Value LIFO Retail Method | |||
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 |
Year 2020 | |||
104325 | 97500 | 92,500.00 | 63825 |
5,000.00 | 3745 | ||
Total Ending Inventory at dollar-value LIFO retail Cost | 67570 | ||
Year 2021 | |||
53350 | 48500 | 48500 | 33465 |
Total Ending Inventory at dollar-value LIFO retail Cost | 33465 |