In: Accounting
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows:
| Cost | Retail | |||||
| Gross purchases | $ | 224,310 | $ | 450,000 | ||
| Purchase returns | 6,100 | 24,000 | ||||
| Purchase discounts | 4,600 | |||||
| Gross sales | 408,500 | |||||
| Sales returns | 5,000 | |||||
| Employee discounts | 5,500 | |||||
| Freight-in | 27,500 | |||||
| Net markups | 21,000 | |||||
| Net markdowns | 24,000 | |||||
Sales to employees are recorded net of discounts.
1. Estimate ending inventory for 2019 using the
conventional retail method. (Amounts to be deducted should
be indicated with a minus sign.)
2. Estimate ending inventory for 2019 assuming
Raleigh Department Store used the LIFO retail method.
(Amounts to be deducted should be indicated with a minus
sign.)
3. Assume Raleigh Department Store adopts the
dollar-value LIFO retail method on January 1, 2020. Estimating
ending inventory for 2020 and 2021.
| 1. Estimate ending inventory for 2019 using the conventional retail method. | |||
| Particulars | Cost | Retail | Cost to retail ratio |
| Beginning inventory | $32,170 | $41,000 | |
| Add: Purchases | $224,310 | $450,000 | |
| Freight in | $27,500 | ||
| Less: Purchase Return | -$6,100 | -$24,000 | |
| Purchase Discounts | -$4,600 | ||
| Add: Net Markups | $21,000 | ||
| Less: Net Markdowns | -$24,000 | ||
| Goods Available For Sale | $273,280 | $464,000 | |
| Cost to retail percentage | 56% | ||
| ($273,280 / ($464,000 + $24,000) | |||
| Less: Net Sales | |||
| Sales | $408,500 | ||
| Sales returns | -$5,000 | ||
| Employee Discounts | -$5,500 | ||
| $398,000 | |||
| Estimated Ending inventory at retail ($464,000 - $398,000) | $66,000 | ||
| Estimated Ending inventory at Cost ($66,000 * 56%) | $36,960 |
| 2. Estimate ending inventory for 2019 using the LIFO retail method. | |||
| Particulars | Cost | Retail | Cost to retail ratio |
| Beginning inventory | $32,170 | $41,000 | |
| Add: Purchases | $224,310 | $450,000 | |
| Freight in | $27,500 | ||
| Less: Purchase Return | -$6,100 | -$24,000 | |
| Purchase Discounts | -$4,600 | ||
| Add: Net Markups | $21,000 | ||
| Less: Net Markdowns | -$24,000 | ||
| Goods Available For Sale (Excluding Beginning Inventory) | $241,110 | $423,000 | |
| Goods Available For Sale (Including Beginning Inventory) | $273,280 | $464,000 | |
| Cost to retail percentage | 57% | ||
| ($241,110 / ($423,000) *100 | |||
| Less: Net Sales | |||
| Sales | $408,500 | ||
| Sales returns | -$5,000 | ||
| Employee Discounts | -$5,500 | ||
| $398,000 | |||
| Estimated Ending inventory at retail ($423,000 - $398,000) | $25,000 | ||
| Estimated Ending inventory at Cost ($25,000 * 57%) | $14,250 |
| 3. Estimate ending inventory dollar value for 2020 and 2021 | Cost | Retail |
| A. 2020 | ||
| Ending Inventory at Retail | $59,800 | |
| Ending Inventory Deflated ($59,800 / 1.04) | $57,500 | |
| Beginning Inventory | $14,250 | $25,000 |
| Add: Layer ($32,500 * 74% * 1.04) | $25,012 | $32,500 |
| Ending Inventory at Cost | $39,262 | |
| B. 2021 | ||
| Ending Inventory at Retail | $47,080 | |
| Ending Inventory Deflated ($47,080 / 1.07) | $44,000 | |
| Beginning Inventory | $25,012 | $57,500 |
| Add: Layer ($13,500 * 73% * 1.07) | -$10,545 | -$13,500 |
| Ending Inventory at Cost | $14,467 |