In: Accounting
Lance-Hefner Specialty Shoppes decided to use the dollar-value LIFO retail method to value its inventory. Accounting records provide the following information:
Cost | Retail | |||||
Merchandise inventory, January 1, 2018 | $ | 192,000 | $ | 320,000 | ||
Net purchases | 371,200 | 575,000 | ||||
Net markups | 14,000 | |||||
Net markdowns | 9,000 | |||||
Net sales | 460,000 | |||||
Related retail price indexes are as follows:
January 1, 2018 | 1.00 |
December 31, 2018 | 1.10 |
Required:
Ending inventory at retail:____
Ending inventory at cost:____
Cost of Goods sold:____
Ending Inventory at Retail |
$440,000 |
Ending Inventory at Cost |
$248,320 |
Cost of Goods Sold |
$314,880 |
--Working
Cost |
Retail |
Cost to retail % |
|
Beginning Inventory |
$192,000 |
$320,000 |
60.000% |
Net Purchases |
$371,200 |
$575,000 |
|
Net Mark ups |
$14,000 |
||
Net Mark downs |
($9,000) |
||
Purchases |
$371,200 |
$580,000 |
64.000% |
Goods available for sale |
$563,200 |
$900,000 |
|
Net Sales |
($460,000) |
||
Ending Inventory at Retail |
$440,000 |
||
Ending Inventory at Cost |
($248,320) |
||
Cost of Goods Sold |
$314,880 |
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 |
|
$440,000 |
$400,000 |
$320,000 |
$192,000 |
[320000 x 60% x 1.0] |
[ 440000 / 1.1 ] |
$80,000 |
$56,320 |
[80000 x 64% x 1.10] |
|
Total ending Inventory at dollar value LIFO retail cost |
$248,320 |