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 | $ | 73,150 | $ | 133,000 |
| Net purchases | 113,400 | 257,000 | ||
| Net markups | 8,000 | |||
| Net markdowns | 13,000 | |||
| Net sales | 224,000 | |||
| Retail price index, 12/31/18 | 1.12 | |||
Required:
Calculate the estimated ending inventory and cost of goods sold for
2018.
1.Ending inventory at retail-
2.Ending inventory at cost-
3.Cost of goods sold-
| Calculation of Inventory at retail | Cost | Retail | |
| Beginning | 73,150.00 | 1,33,000.00 | |
| ADD: Net purchase | 1,13,400.00 | 2,57,000.00 | |
| ADD: Markup | 8,000.00 | ||
| Less: Markdown | -13,000.00 | ||
| Goods Available for sale Excluding beginning | 1,13,400.00 | 2,52,000.00 | |
| Goods Available for sale Inluding beginning | 1,86,550.00 | 3,85,000.00 | |
| Base year cost to retail percentage | 55.00% | ||
| Current year cost to retail percentage | 45.00% | ||
| Less: Net sales | -2,24,000.00 | ||
| Estimated ending inventory at current year retail prices | 1,61,000.00 | ||
| Ending Inventory AT year end at retail Price | Layers at retial price | Cost to retail Prices | |
| 1,61,000.00 | 1,33,000.00 | 73,150.00 | |
| 28,000.00 | 12,600.00 | ||
| Total | |||
| 1,61,000.00 | 1,61,000.00 | 85,750.00 | |
| A) | Ending Inventory at retail | 161000 | |
| B | Ending Inventory at cost | 85,750.00 | |
| C | Cost of Goods Sold | 1,00,800.00 | (186550-85750) |