Question
In: Accounting
On January 1, 2021, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records...
On January 1, 2021, Sanderson Variety Store adopted the
dollar-value LIFO retail inventory method. Accounting records
provided the following information:
| Cost | Retail | |||||
| Beginning inventory | $ | 43,800 | $ | 73,000 | ||
| Net purchases | 169,940 | 295,000 | ||||
| Net markups | 5,000 | |||||
| Net markdowns | 7,000 | |||||
| Net sales | 272,000 | |||||
| Retail price index, end of year | 1.04 | |||||
During 2022, purchases at cost and retail were $191,675 and
$348,500, respectively. Net markups, net markdowns, and net sales
for the year were $8,000, $9,000, and $305,000, respectively. The
retail price index at the end of 2022 was 1.05.
Estimate ending inventory in 2022 using the dollar-value LIFO
retail method. (Round your intermediate calculations to the
nearest whole dollar. Round ratio calculation to the nearest whole
percent.)
Solutions
Expert Solution
Step 1: Calculate Ending Inventory at Current Year Retail Prices for 2021
The value of ending inventory at current year retail prices for 2021 is calculated as below:
| Beginning Inventory | 73,000 |
| Add Net Purchases | 295,000 |
| Net Markups | 5,000 |
| Less Net Markdowns | -7,000 |
| Goods Available for Sale | 366,000 |
| Less Net Sales | -272,000 |
| Estimated Ending Inventory at Current Year Retail Prices | $94,000 |
_____
Step 2: Calculate Ending Inventory at Cost for 2021
The value of ending inventory at cost for 2021 is determined as follows:
|
Ending Inventory at Year-End Retail Prices for 20211 |
Ending Inventory at Base Year Retail Prices (1) |
Inventory Layers at Base Year Retail Prices (2) | Inventory Layers Converted to Cost (3) | |||
| 94,000 | 90,385 (94,000/1.04) | 73,000 (Base) | X | 1 | 60% (43,800/73,000*100) | 43,800 (73,000*1*60%) |
| 17,385 (90,385 - 73,000) [2021] | X | 1.04 | 58% [169,940/(295,000+5,000-7,000)] | 10,487 (17,385*1.04*58%) | ||
| Total Ending Inventory at Cost | $54,287 | |||||
_____
Step 3: Calculate Ending Inventory at Current Year Retail Prices for 2022
The value of ending inventory at current year retail prices for 2022 is calculated as below:
| Beginning Inventory | 94,000 |
| Add Net Purchases | 348,500 |
| Net Markups | 8,000 |
| Less Net Markdowns | -9,000 |
| Goods Available for Sale | 441,500 |
| Less Net Sales | -305,000 |
| Estimated Ending Inventory at Current Year Retail Prices | $136,500 |
_____
Step 4: Calculate Ending Inventory at Cost for 2022
The value of ending inventory at cost for 2022 is determined as below:
|
Ending Inventory at Year-End Retail Prices for 2022 |
Ending Inventory at Base Year Retail Prices (1) |
Inventory Layers at Base Year Retail Prices (2) | Inventory Layers Converted to Cost (3) | |||
| 136,500 | 130,000 (135,000/1.05) | 73,000 (Base) | X | 1 | 60% | 43,800 |
| 17,385 (2021) | X | 1.04 | 58% | 10,487 | ||
| 39,615 (130,000 - 73,000 - 17,385) [2022] | X | 1.05 | 55% [191,675/(348,500+8,000-9,000)] | 22,878 (39,615*1.05*55%) | ||
| Total Ending Inventory at Cost | $77,164 | |||||
Answer is $77,164.
_____
Notes:
There can be a slight/minor difference in the final answer on account of rounding off values.
ekkarill92 answered 10 months agoRelated Solutions
On January 1, 2018, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records...
On January 1, 2018, Sanderson Variety Store adopted the
dollar-value LIFO retail inventory method. Accounting records
provided the following information: Cost Retail Beginning inventory
$ 60,750 $ 81,000 Net purchases 243,090 335,000 Net markups 7,000
Net markdowns 9,000 Net sales 312,000 Retail price index, end of
year 1.04 Estimate ending inventory using the dollar-value LIFO
retail method.
On January 1, 2021, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records provided the following information:
On January 1, 2021, Sanderson Variety Store adopted the dollar-value LIFO retail inventory method. Accounting records provided the following information:
Estimate ending inventory using the dollar-value LIFO retail method and the information provided.
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, 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, 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, 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...
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, 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, Avondale Lumber adopted the dollar-value LIFO inventory method. The inventory value for...
On January 1, 2021, Avondale Lumber adopted the dollar-value
LIFO inventory method. The inventory value for its one inventory
pool on this date was $275,000. An internally generated cost index
is used to convert ending inventory to base year. Year-end
inventories at year-end costs and cost indexes for its one
inventory pool were as follows:
Year Ended
Inventory
Cost Index
December 31
Year-End Costs
(Relative to Base Year)
2021
$
364,350
1.05
2022
374,960
1.09
2023
424,600
1.10
2024
454,260...
On January 1, 2021, Avondale Lumber adopted the dollar-value LIFO inventory method. The inventory value for...
On January 1, 2021, Avondale Lumber adopted the dollar-value
LIFO inventory method. The inventory value for its one inventory
pool on this date was $330,000. An internally generated cost index
is used to convert ending inventory to base year. Year-end
inventories at year-end costs and cost indexes for its one
inventory pool were as follows:
Year Ended
Inventory
Cost Index
December 31
Year-End Costs
(Relative to Base Year)
2021
$
418,080
1.04
2022
429,840
1.08
2023
482,870
1.09
2024
520,240...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Neuro Case Study Mrs. Greene is a 92-year-old woman who presents to the emergency room with...
- Question text Scenario: Company X recently hired two employees to fill the newly designed role of...
- Knowing that at 0 oC and an oxygen pressure of 1.00 atm, the aqueous solubility of...
- Mercer Asbestos Removal Company removes potentially toxic asbestos insulation and related products from buildings. There has...
- What is a financial intermediation issue that you think is particularly important today? Please explain the...
- Think about the significant physical, cognitive, and psychosocial milestones that occur during Adulthood (18-65 years), as...
- Description of biochemical tests for gram positive cocci chart micrococcus luteus micrococcus roseus staphlyococcus aureus staphlyococcus...
ADVERTISEMENT