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) |