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 $ 72,900 $ 135,000 Net purchases 102,150 232,000 Net markups 5,000 Net markdowns 10,000 Net sales 200,000 Retail price index, 12/31/18 1.08
Required: Calculate the estimated ending inventory at retail and ending inventory at cost and cost of goods sold for 2018.
| Cost | Retail | |
| Beginning inventory | $ 72,900 | $ 135,000 |
| Plus: Net Purchases | $ 102,150 | $ 232,000 |
| Net Markup | $ 5,000 | |
| Less: Mark Down | $ (10,000) | |
| Goods Available For Sale (Excluding Beginning Inventory) | $ 102,150 | $ 227,000 |
| Goods Available For Sale (Including Beginning Inventory) | $ 175,050 | $ 362,000 |
| Base year cost-to retail % (72900/135000) | 54% | |
| 2011 cost-to retail %(102150/227000) | 45% | |
| Less Net Sales | $ (200,000) | |
| Estimated Ending Inventory at current year retail Prices | $ 162,000 | |
| Estimated Ending Inventory at Cost | $ 79,650 | |
| Estimated Cost of Goods Sold | $ 95,400 |
| Step1 | Step 2 | Step 3 | |
| Estimated Ending Inventory at year end retail price | Estimated Ending Inventory at base year Retail price | Inventory Layers At Base Year Retail Prices | Inventory Layers converted to cost |
| $ 162,000 | $ 150,000.00 | 135000 (Base) | $ 72,900 |
| (162000/1.08) | 15000( 2018) | $ 6,750 | |
| Total Ending Inventory | $ 79,650 | ||