Question

In: Accounting

Kingston Company uses the dollar-value LIFO method of computing inventory. An external price index is used...

Kingston Company uses the dollar-value LIFO method of computing inventory. An external price index is used to convert ending inventory to base year. The company began operations on January 1, 2021, with an inventory of $201,000. Year-end inventories at year-end costs and cost indexes for its one inventory pool were as follows: Year Ended Ending Inventory Cost Index December 31 at Year-End Costs (Relative to Base Year) 2021 $ 291,600 1.08 2022 376,420 1.18 2023 355,350 1.15 2024 349,650 1.11 Required: Calculate inventory amounts at the end of each year. (Round intermediate calculations and final answers to the nearest whole dollars.)

Inventory Layers Converted to Base Year Cost Inventory Layers Converted to Cost Inventory DVL Cost
Date Inventory at Year-End Cost Year-End Cost Index Inventory Layers at Base Year Cost Inventory Layers at Base Year Cost Year-End Cost Index = Inventory Layers Converted to Cost
01/01/2021 = Base = $0
12/31/2021 = Base =
2021 = $0
12/31/2022 = Base =
2021 =
2022 = $0
12/31/2023 = Base =
2021 =
2022 =
2023 = $0
12/31/2024 = Base =
2021 =
2022 =
2023 =
2024 = $0

Solutions

Expert Solution

Solution:

Calculate inventory amounts at the end of each year

Inventory Layers Converted to Base Year Cost Inventory Layers Converted to Cost Inventory DVL Cost
Date Inventory at Year-End Cost Year-End Cost Index Inventory Layers at Base Year Cost Inventory Layers at Base Year Cost Year-End Cost Index = Inventory Layers Converted to Cost
01/01/2021 $201,000 / 1 = $201,000 Base $201,000 * 1 = $201,000
12/31/2021 $291,600 / 1.08 = $270,000 Base $201,000 * 1 = $201,000
2021 $69,000 * 1.08 = $74,520 $275,520
12/31/2022 $376,420 / 1.18 = $319,000 Base $201,000 * 1 = $201,000
2021 $69,000 * 1.08 = $74,520
2022 $49,000 * 1.18 = $57,820 $333,340
12/31/2023 $355,350 / 1.15 = $309,000 Base $201,000 * 1 = $201,000
2021 $69,000 * 1.08 = $74,520
2022 $39,000 * 1.18 = $46,020 $321,540
2023 =
12/31/2024 $349,650 / 1.11 = $315,000 Base $201,000 * 1 = $201,000
2021 $69,000 * 1.08 = $74,520
2022 $39,000 * 1.18 = $46,020
2023 0 * 0 = 0
2024 $6,000 * 1.11 = $6,660 $328,200

Please rate positive and comment in case of any doubt. I would be happy to help you further.


Related Solutions

Ann Co. uses the dollar-value LIFO retail method. The beginning inventory, purchased when the price index...
Ann Co. uses the dollar-value LIFO retail method. The beginning inventory, purchased when the price index was 100, had a retail value of $4,000 and a cost of $3,600. During the period, purchases amounted to $60,000 at retail ($52,800 at cost). Sales amounted to $56,300. The year-end price index was 110. What is the cost of ending inventory?
A) Whispering, Inc. uses the dollar-value LIFO method of computing its inventory. Data for the past...
A) Whispering, Inc. uses the dollar-value LIFO method of computing its inventory. Data for the past 3 years follow. Year Ended December 31 Inventory at Current-Year Cost Price Index 2019 $21,500 100 2020 23,532 106 2021 27,664 112 Compute the value of the 2020 and 2021 inventories using the dollar-value LIFO method. 2020 2021 Inventory under LIFO $enter a dollar amount $enter a dollar amount B) The following is a record of Sheffield Company’s transactions for Boston Teapots for the...
Faucci Industries, Inc. uses the dollar-value LIFO method of computing its inventory cost with December 31,...
Faucci Industries, Inc. uses the dollar-value LIFO method of computing its inventory cost with December 31, 2015 representing the base cost. Data for the past five years follows: Year Ended December 31, Inventory at FIFO Index 2015 $       85,000 100 2016           92,400 105 2017         102,120 111 2018         102,600 114 2019         110,200 116 Required: Determine the inventory valuation for 2016 through 2019 using the dollar-value LIFO technique.
Company ABC uses the last-in, first-out (LIFO) dollar value retail inventory method. It adopted this method...
Company ABC uses the last-in, first-out (LIFO) dollar value retail inventory method. It adopted this method at the beginning of this year. The cost index for the year was 1.12. Below is information for the first year. Cost Retail BI 1082.0 1542.0 Net purchases 3462.4 5088.6 Net Sales 0.0 4579.7 Ending inventory at retail is: Answer The cost to retail conversion for beginning inventory is (round to at least 3 decimal points): Answer The cost to retail conversion for the...
what is the dollar-value method of LIFO inventory valuation? What advantage does the dollar-value method have...
what is the dollar-value method of LIFO inventory valuation? What advantage does the dollar-value method have over the specific goods approach of LIFO inventory valuation? Why will the traditional LIFO inventory costing method and the dollar-value LIFO inventory costing method produce different inventory valuations if the composition of the inventory base changes
what is the dollar-value method of LIFO inventory valuation? What advantage does the dollar-value method have...
what is the dollar-value method of LIFO inventory valuation? What advantage does the dollar-value method have over the specific goods approach of LIFO inventory valuation? Why will the traditional LIFO inventory costing method and the dollar-value LIFO inventory costing method produce different inventory valuations if the composition of the inventory base changes
Olson Company adopted the dollar-value LIFO method for inventory valuation at the beginning of 2015. The...
Olson Company adopted the dollar-value LIFO method for inventory valuation at the beginning of 2015. The following information about the inventory at the end of each year is available from Olson's records: Year Current Costs Index 2014 $50,000 100 2015 60,000 108 2016 70,000 115 2017 73,000 125 2018 78,000 135 Required: 1. Calculate the dollar-value LIFO inventory at the end of each year. Do not round your intermediate calculations. Round final answers to the nearest dollar. 2015 2016 2017...
Kingston Company starts the business in Year 1. Kingston uses FIFO as their inventory costing method....
Kingston Company starts the business in Year 1. Kingston uses FIFO as their inventory costing method. They purchase inventory as follows: 8/5/Year1: 1000 units at $30 each 11/6/Year1: 3000 units at $36 each Assume Kingston signs a sales contract for 3,800 units for $380,000 ($100 each) on 11/1/Year1. This is the only sale for the year. The customer is within a 30-mile delivery radius (Goods are delivered by a van.) 1. Assume the items are delivered on 11/15/Year1. The customer...
Kingston Company starts the business in Year 1. Kingston uses FIFO as their inventory costing method....
Kingston Company starts the business in Year 1. Kingston uses FIFO as their inventory costing method. They purchase inventory as follows: 8/5/Year1: 1000 units at $30 each 11/6/Year1: 3000 units at $36 each Assume Kingston signs a sales contract for 3,800 units for $380,000 ($100 each) on 11/1/Year1. This is the only sale for the year. The customer is within a 30-mile delivery radius (Goods are delivered by a van.) 1. Assume the items are delivered on 11/15/Year1. The customer...
Rose, Inc. uses the dollar-value LIFO retail inventory method. For years ending 2015-2019 they counted the...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT