Question

Rose, Inc. uses the dollar-value LIFO retail inventory method. For years ending 2015-2019 they counted the following dollar amounts for inventory at retail prices

2015 $124,000

2016 $138,600

2017 $157,500

2018 $149,240

2019 $155,700

As far as prices are concerned, the following year end price indexes were estimated as:

2015 1.00

2016 1.04

2017 1.10 (10 percent higher prices than in 2015)

2018 1.13

2019 1.15

The cost to retail percentage for those items added in each year were as follows – this means the comparison of purchases for cost versus retail has already been done and does not need to be repeated.

2015 60%

2016 61%

2017 62%

2018 63%

2019 62%

Required: Give the amounts that should be listed on the year-end balance sheet for each of the following years:

1. 2015

2. 2016

3. 2017

4. 2018

5. 2019

Answer 1

Answer :-

Step 1 :- Calculation for inventory retail price increasing ;-

A	B	C	D (B*C)	E (Previous D - Year's D)
Year	Inventory	Price index	Inventory for price index	Inventory retail price increasing
2015	$124,000	1.00	$124,000	-
2016	$138,600	1.04	$144,144	$20,144
2017	$157,500	1.10	$173,250	$29,106
2018	$149,240	1.13	$168,641	($4,609)
2019	$155,700	1.15	$179,055	$10,414

Step 2 :-  The amounts that should be listed the dollar-value LIFO retail inventory method :-

A	B	C	D	E(B*C*D)
Years	Inventory retail price increasing	Price index	Cost to retail percentage	Inventory value
2015 - 1	$124,000	1.00	60%	$74,400
2016
2015 - 1	$124,000	1.00	60%	$74,400
2016 - 2	$20,144	1.04	61%	$12,779
	Total			$87,179
2017
2015 - 1	$124,000	1.00	60%	$74,400
2016 - 2	$20,144	1.04	61%	$12,779
2017 - 3	$29,106	1.10	62%	$19,850
	Total			$107,029
2018
2015 - 1	$124,000	1.00	60%	$74,400
2016 - 2	$20,144	1.04	61%	$12,779
2017 - 3	($29,106 - $4,609) $24,497	1.10	62%	$16,571
	Total			$103,750
2019
2015 - 1	$124,000	1.00	60%	$74,400
2016 - 2	$20,144	1.04	61%	$12,779
2017 - 3	($29,106 - $4,609) $24,497	1.10	62%	$16,571
2019 - 4	$10,414	1.15	62%	$7,425
	Total			$111,175

The amounts that should be listed on the year-end balance sheet for each of the following years:

Year	Inventory value
2015	$74,400
2016	$87,179
2017	$107,029
2018	$103,750
2019	$111,175