Question
In: Accounting
Dollar-Value LIFO Retail Johns Company adopts the dollar-value LIFO retail inventory method on January 1, 2016....
Dollar-Value LIFO Retail
Johns Company adopts the dollar-value LIFO retail inventory method on January 1, 2016. The following information for 2016 is obtained from Johns' records:
| Cost | Retail | |
|---|---|---|
| Inventory, January 1, 2016 | $20,000 | $29,000 |
| Purchases | 60,000 | 92,000 |
| Net additional markups | — | 1,000 |
| Net markdowns | — | 3,000 |
| Sales | — | 75,000 |
The price index on January 1, 2016, was 100, and on December 31, 2016, it was 110.
Required:
Compute the cost of the inventory on December 31, 2016. Round the cost-to-retail ratio to three decimal places.
| JOHNS COMPANY | ||
| Calculation of cost of inventory using Dollar-Value LIFO | ||
| December 31, 2016 | ||
| Cost | Retail | |
| Beginning inventory | $20,000 | $29,000 |
| Purchases | 60,000 | $92,000 |
| Add: Markups (net) | 1,000 | |
| Less: Markdowns (net) | (3000) | |
| $90,000 | ||
| Goods available for sale | $80,000 | $119,000 |
| Less: Sales | 75,000 | |
| Ending inventory at retail | $44,000 | |
| Ending inventory at cost | $ ? | |
Solutions
Expert Solution
- Complete answer
|
OHNS COMPANY |
||
|
Calculation of cost of inventory using Dollar-Value LIFO |
||
|
December 31, 2016 |
||
|
Cost |
Retail |
|
|
Beginning inventory |
$20,000 |
$29,000 |
|
Purchases |
60,000 |
$92,000 |
|
Add: Markups (net) |
1,000 |
|
|
Less: Markdowns (net) |
(3000) |
|
|
$90,000 |
||
|
Goods available for sale |
$80,000 |
$119,000 |
|
Less: Sales |
75,000 |
|
|
Ending inventory at retail |
$44,000 |
|
|
Ending inventory at cost |
$ 28,067 [see Step 3 below] |
|
- Workings
|
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 |
|
|
$44,000 [correctly calculated by you above] |
$40,000 |
$29,000 |
$20,000 |
[29000 x 1.00 x 68.966%] |
|
[ 44000 / 1.1 ] |
$11,000 |
$8,067 |
[11000 x 1.10 x 66.667%] |
|
|
Total ending Inventory at dollar value LIFO retail cost |
$28,067 |
|||
--Cost to Retail %
|
Cost |
Retail |
Cost to retail % |
|
|
Beginning Inventory |
$20,000 |
$29,000 |
68.966% |
|
Net Purchases |
$60,000 |
$92,000 |
|
|
Net Mark ups |
$1,000 |
||
|
Net Mark downs |
($3,000) |
||
|
Purchases |
$60,000 |
$90,000 |
66.667% |
ekkarill92 answered 1 month agoRelated Solutions
Kingbird Corporation adopted the dollar-value LIFO retail inventory method on January 1, 2016. At that time...
Kingbird Corporation adopted the dollar-value LIFO retail
inventory method on January 1, 2016. At that time the inventory had
a cost of $57,000 and a retail price of $100,000. The following
information is available. Year-End Inventory at Retail Current Year
Cost—Retail % Year End Price Index 2016 $133,560 56% 106 2017
146,520 59% 111 2018 124,120 60% 116 2019 168,750 57% 125 The price
index at January 1, 2016, is 100. Compute the ending inventory at
December 31 of the...
On January 1, 2016, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions...
On January 1, 2016, HGC Camera Store adopted the dollar-value
LIFO retail inventory method. Inventory transactions at both cost
and retail, and cost indexes for 2016 and 2017 are as follows: 2016
2017 Cost Retail Cost Retail Beginning inventory $ 51,800 $ 74,000
Net purchases 101,150 125,000 $ 107,532 $ 131,700 Freight-in 3,700
4,200 Net markups 18,500 11,400 Net markdowns 3,700 3,900 Net sales
to customers 125,250 118,800 Sales to employees (net of 20%
discount) 3,000 6,720 Price Index: January...
On January 1, 2016, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following...
On January 1, 2016, the Brunswick Hat Company adopted the
dollar-value LIFO retail method. The following data are available
for 2016: Cost Retail Beginning inventory $ 81,000 $ 150,000 Net
purchases 121,500 278,000 Net markups 8,000 Net markdowns 16,000
Net sales 228,000 Retail price index, 12/31/16 1.20 Required:
Calculate the estimated ending inventory and cost of goods sold for
2016.
On January 1, 2016, Badger Inc. adopted the dollar-value LIFO method. The inventory cost on this...
On January 1, 2016, Badger Inc. adopted the dollar-value LIFO
method. The inventory cost on this date was $114,000. The 2016
ending inventory, valued at year-end costs, was $165,000. The
relative cost index for this inventory in 2016 was 1.20.
Suppose that Badger's 2017 ending inventory, valued at year-end
costs, was $176,400 and that the relative cost index for this
inventory in 2017 was 1.26. In determining the inventory balance
should Badger report in its 12/31/17 balance sheet:
On January 1, 2021, the Coldstone Corporation adopted the dollar-value LIFO retail inventory method. Beginning inventory...
On January 1, 2021, the Coldstone Corporation adopted the
dollar-value LIFO retail inventory method. Beginning inventory at
cost and at retail were $180,000 and $282,000, respectively. Net
purchases during the year at cost and at retail were $604,500 and
$920,000, respectively. Markups during the year were $10,000. There
were no markdowns. Net sales for 2021 were $900,000. The retail
price index at the end of 2021 was 1.04. What is the inventory
balance that Coldstone would report in its 12/31/2021...
On January 1, 2018, the Coldstone Corporation adopted the dollar-value LIFO retail inventory method. Beginning inventory...
On January 1, 2018, the Coldstone Corporation adopted the
dollar-value LIFO retail inventory method. Beginning inventory at
cost and at retail were $180,000 and $292,950, respectively. Net
purchases during the year at cost and at retail were $736,000 and
$911,000, respectively. Markups during the year were $9,000. There
were no markdowns. Net sales for 2018 were $878,000. The retail
price index at the end of 2018 was 1.05. What is the inventory
balance that Coldstone would report in its 12/31/2018...
Marin Corporation adopted the dollar-value LIFO retail inventory method on January 1, 2019. At that time...
Marin Corporation adopted the dollar-value LIFO retail inventory
method on January 1, 2019. At that time the inventory had a cost of
$52,000 and a retail price of $100,000. The following information
is available.
Year-End
Inventory at Retail
Current Year
Cost—Retail %
Year End
Price Index
2019
$119,780
60%
106
2020
147,400
63%
110
2021
124,260
64%
114
2022
148,750
61%
125
The price index at January 1, 2019, is 100.
Compute the ending inventory at December 31 of the...
On January 1, 2018, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions...
On January 1, 2018, HGC Camera Store adopted the dollar-value
LIFO retail inventory method. Inventory transactions at both cost
and retail, and cost indexes for 2018 and 2019 are as follows: 2018
2019 Cost Retail Cost Retail Beginning inventory $ 42,000 $ 60,000
Net purchases 94,500 118,000 $ 108,108 $ 133,200 Freight-in 3,000
3,500 Net markups 15,000 10,000 Net markdowns 3,000 3,200 Net sales
to customers 117,360 119,890 Sales to employees (net of 10%
discount) 3,600 6,300 Price Index: January...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions...
On January 1, 2021, HGC Camera Store adopted the dollar-value
LIFO retail inventory method. Inventory transactions at both cost
and retail, and cost indexes for 2021 and 2022 are as
follows:
2021
2022
Cost
Retail
Cost
Retail
Beginning inventory
$
31,200
$
48,000
Net purchases
82,720
112,000
$
90,275
$
118,800
Freight-in
2,400
2,900
Net markups
12,000
8,800
Net markdowns
2,400
2,600
Net sales to customers
109,815
104,960
Sales to employees (net of 20% discount)
2,900
4,640
Price Index:
January...
On January 1, 2018, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions...
On January 1, 2018, HGC Camera Store adopted the dollar-value
LIFO retail inventory method. Inventory transactions at both cost
and retail, and cost indexes for 2018 and 2019 are as
follows:
2018
2019
Cost
Retail
Cost
Retail
Beginning
inventory
$
58,500
$
78,000
Net purchases
110,180
127,000
$
115,808
$
133,100
Freight-in
3,900
4,400
Net markups
19,500
11,800
Net markdowns
3,900
4,100
Net sales to customers
125,380
119,140
Sales to employees (net of 20%
discount)
3,600
6,000
Price Index:
January...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- An investor is considering purchasing a Treasury bond with a 20 year maturity, an 8% coupon...
- Write a program that copies the contents of one file to a destination file. This program...
- how to conduct a marketing mix for 3d crest white strips
- Is big data analytics used for service innovation at Amazon? If so, please write a brief...
- A shrink-fit process has been used to enhance the pressure carrying capacity of a cylinder. During...
- Ten-year zero coupon bonds issued by the U.S. Treasury have a face value of $1,000 and...
- The Blossom Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a...
ADVERTISEMENT