In: Accounting
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows:
Cost | Retail | |||||
Gross purchases | $ | 154,950 | $ | 390,000 | ||
Purchase returns | 5,500 | 30,000 | ||||
Purchase discounts | 4,000 | |||||
Gross sales | 341,000 | |||||
Sales returns | 5,000 | |||||
Employee discounts | 4,000 | |||||
Freight-in | 30,500 | |||||
Net markups | 15,000 | |||||
Net markdowns | 30,000 | |||||
Sales to employees are recorded net of discounts.
Question: Assume Raleigh Department Store adopts the dollar-value LIFO retail method on January 1, 2020. Estimating ending inventory for 2020 and 2021.
LIFO retail method
Cost | Retail | |
Beginning Inventory | $29,050 | $35,000 |
Add: Purchases | $154,950 | $390,000 |
Freight in | $30,500 | |
Less: Purchase returns | ($5,500) | ($30,000) |
Purchase discounts | ($4,000) | |
Add: Net markups | $15,000 | |
Less: Net markdowns | ($30,000) | |
Goods available for sale ( Excluding beginning inventory) | $175,950 | $345,000 |
Goods available for sale ( Including beginning inventory) | $205,000 | $345,000 |
Cost to retail ratio($175,950/$345,000=51%) | ||
Less: Net sales($341,009-$5,000) | ($336,000) | |
Employee discounts | ($4,000) | |
Estimated Ending inventory at retail | $40,000 | |
Estimated Ending inventory at cost | $31,600 |
Ending inventory at cost
Retail | Cost | |
Beginning Inventory | $35,000 | $29,050 |
Current period layers | $5,000 | $2,550($5,000×51%} |
Total | $40,000 | $31,600 |
Dollar value LIFO method for 2020
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 |
$46,800 | $45,000($46,800/1.04) | $40,000 | $31,600 |
$5,000 | $4,160($5,000×1.04×80%) | ||
Ending inventory at dollar value LIFO retail cost | $35,760 |
Dollar value LIFO method for 2021
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 |
$40,660 | $38,000($40,660/1.07) | $38,000 | $30,020 |
Ending inventory at dollar value LIFO retail cost | $30,020 |