In: Accounting
On January 1, 2021, the Brunswick Hat Company adopted the
dollar-value LIFO retail method. The following data are available
for 2021:
| Cost | Retail | |||
| Beginning inventory | $ | 81,760 | $ | 146,000 |
| Net purchases | 123,360 | 265,000 | ||
| Net markups | 4,000 | |||
| Net markdowns | 12,000 | |||
| Net sales | 238,000 | |||
| Retail price index, 12/31/2021 | 1.10 | |||
Required:
Calculate the estimated ending inventory and cost of goods sold for
2021 using the information provided. (Do not round
intermediate calculations.)
|
|||||||||
| Ending Inventory at Retail | $165,000 |
| Ending Inventory at Cost | $83,872 |
| Cost of Goods Sold | $121,248 |
| --Working | |||
| Cost | Retail | Cost to retail % | |
| Beginning Inventory | 81,760 | 1,46,000 | 56% |
| Net Purchases | 1,23,360 | 2,65,000 | |
| Net Mark ups | 4,000 | ||
| Net Mark downs | -12,000 | ||
| Purchases | 1,23,360 | 2,57,000 | 48% |
| Goods available for sale | 2,05,120 | 4,03,000 | |
| Net Sales | -2,38,000 | ||
| Ending Inventory at Retail | 1,65,000 | ||
| Ending Inventory at Cost | 83,872 | ||
| Cost of Goods Sold | 1,21,248 | ||
| Step 1 | Step 2 | Step 3 | ||
| Ending Inventory at Year end retail prices | Ending Inventory at Year end BASE YEAR retail prices | Inventory Layer at base year retail prices | Inventory Layers converted to cost | |
| 1,65,000 | 1,50,000 | 1,46,000 | 81,760 | [146000 x 56% x 1.00] |
| [ 165000 / 1.10 ] | 4,000 | 2,112 | [4000 x 48% x 1.10] | |
| Total ending Inventory at dollar value LIFO retail cost | 83,872 | |||