In: Accounting
Pharoah Inc. had beginning inventory of $12,017 at cost and $19,700 at retail. Net purchases were $112,000 at cost and $174,400 at retail. Net markups were $9,100, net markdowns were $7,400, and sales revenue was $160,500. Assume the price level increased from 100 at the beginning of the year to 105 at year-end. Compute ending inventory at cost using the dollar-value LIFO retail method. (Round ratios for computational purposes to 1 decimal place, e.g. 78.7% and final answer to 0 decimal places, e.g. 28,987.)
Ending inventory using the dollar-value LIFO retail method $
Answer
Ending inventory using the dollar-value LIFO retail method $ 21,312
--Working
Cost |
Retail |
Cost to retail % |
|
Beginning Inventory |
$12,017 |
$19,700 |
61.000% |
Net Purchases |
$112,000 |
$174,400 |
|
Net Mark ups |
$9,100 |
||
Net Mark downs |
($7,400) |
||
Purchases |
$112,000 |
$176,100 |
63.600% |
Goods available for sale |
$124,017 |
$195,800 |
|
Net Sales |
($160,500) |
||
Ending Inventory at Retail |
$35,300 [Go to Step 1] |
||
Ending Inventory at Cost |
($21,312) [Come back from Step 3] |
||
Cost of Goods Sold |
$102,705 |
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 |
|
$35,300 |
$33,619 |
$19,700 |
$12,017 |
[19700 x 61% x 1.0] |
[ 35300 / 1.05 ] |
$13,919 |
$9,295 |
[13919 x 63.6% x 1.05] |
|
Total ending Inventory at dollar value LIFO retail cost |
$21,312 |