In: Accounting
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.
| 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 | ||