Dollar-Value LIFO On January 1, 2018, Sato Company adopted the dollar-value LIFO method of inventory costing. Sato's ending inventory records appear as follows:
Year Current Cost Index 2018 $42,000 100
YEAR | CURRENT COST | INDEX |
2018 | $42,000 | 100 |
2019 | 56,700 | 120 |
2020 | 60,060 | 130 |
2021 | 71,540 | 140 |
Required: Compute the ending inventory for the years 2018, 2019, 2020, and 2021, using the dollar-value LIFO method. Do not round your intermediate calculations. If required, round your answers to the nearest dollar.
Solution:
Calculate ending inventory
Year | Ending Inventory |
2018 | $42,000 |
2019 | $53,340 |
2020 | $47,040 |
2021 | $53,900 |
Working:
Year | End of year price(A) | Price index(B) | base year amount (A)/(B) | Change from prior year |
2018 | $42,000 | 1.00 | $42,000 | $ |
2019 | $56,700 | 1.20 | $47,250 | $5,250 |
2020 | $60,060 | 1.30 | $46,200 | ($1,050) |
2021 | $71,540 | 1.40 | $51,100 | $4,900 |
calculation of ending inventory Dollar value LIFO method:
Year 2018 $42,000
Year 2019 $42,000 @ 1.00 = $42,000
$9,450 @1.20 = $11,340
$ 53,340
Year 2020 $42,00 @1.00 = $42,000
($5,250 - $1,050 = $4,200)@1.20 = $5,040
=$47,040
Year 2021 $42,00 @1.00 =$42,000
($5,250 - $1,050 = $4,200)@1.20 = $5,040
$4,900 @1.40 = $6,860
=$53,900
Dollar-Value LIFO On January 1, 2018, Sato Company adopted the dollar-value LIFO method of inventory costing....
Dollar-Value LIFO Belstock Company manufactures one product. On December 31, 2018, Belstock adopted the dollar-value LIFO inventory method. The inventory on that date using the dollar-value LIFO inventory method was $400,000. Inventory data for succeeding years are as follows: Inventory at Respective Price Index Year Year-End Prices (Base Year 2018) 2019 $441,000 1.05 2020 540,500 1.15 2021 552,000 1.20 Required: Compute the ending Inventory using the dollar-value LIFO method for 2019, 2020, and 2021. Do not round your intermediate calculations....
On January 1, 2018, the Haskins Company adopted the dollar-value LIFO method for its one inventory pool. The pool’s value on this date was $790,000. The 2018 and 2019 ending inventory valued at year-end costs were $832,000 and $918,000, respectively. The appropriate cost indexes are 1.04 for 2018 and 1.08 for 2019. Required: Complete the below table to calculate the inventory value at the end of 2018 and 2019 using the dollar-value LIFO method. (Round "Year end cost index" to...
On January 1, 2018, the Haskins Company adopted the dollar-value LIFO method for its one inventory pool. The pool’s value on this date was $840,000. The 2018 and 2019 ending inventory valued at year-end costs were $884,000 and $954,000, respectively. The appropriate cost indexes are 1.04 for 2018 and 1.06 for 2019. Required: Complete the below table to calculate the inventory value at the end of 2018 and 2019 using the dollar-value LIFO method. (Round "Year end cost index" to...
At the beginning of 2018, Quentin and Kopps (Q&K) adopted the dollar-value LIFO (DVL) inventory method. On that date the value of its one inventory pool was $94,000. The company uses an internally generated cost index to convert ending inventory to base year. Required: Determine the missing amounts in the inventory data for 2018 through 2021. Ending Ending Year Ended Inventory at Inventory at December 31 Year-End costs Base-Year Costs Cost Index 2018 $ 111,300 $ 106,000 1.05 2019 $...
On January 1, 2018 Avondale Lumber adopted the dollar-value LIFO inventory method. The inventory value for its one inventory pool on this date was $335.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 December 31 2018 2019 2020 2021 Inventory Year-End Costs $428.400 440, 360 495.000 533,360 Cost Index Relative to Base Year) 1.05 1.09 1.10...
Dollar-Value LIFO Retail Intella Inc. adopted the dollar-value retail LIFO method on January 1, 2018. The following data apply to the 4 subsequent years: Cost Retail $117,600 $280,000 260,000 147,200 320,000 300,000 Cost Retail 2018 Inventory, January 1 $40,000 $80,000 2020 Purchases Purchases 85,500 190,000 Sales Sales 200,000 2021 Purchases 2019 Purchases 92,000 230,000 Sales Sales 210,000 In addition, the following price indexes are available: January 1, 2018 100 December 31, 2020 December 31, 2018 105 December 31, 2021 December...
On January 1, 2018, Badger Inc. adopted the dollar-value LIFO method. The inventory cost on this date was $100,700. The ending inventory, valued at year-end costs, and the relative cost index for each of the next three years is below: Year-end Ending inventory at year-end costs Cost Index 2018 $ 128,205 1.05 2019 146,080 1.10 2020 156,540 1.20 In determining the inventory balance should Badger report in its 12/31/2019 balance sheet:
Bond Company adopted the dollar-value LIFO Inventory method on January 1, 2018. In applying the LIFO method, Bond uses internal cost Indexes and the multiple-pools approach. The following data were available for Inventory Pool No. 3 for the two years following the adoption of LIFO: Ending Inventory At Current At Base Year Cost Year Cost 1/1/2018 $300,000 $300,000 12/31/2018 345,600 320,000 12/31/2019420,000 350,000 Cost Index 1.00 1.08 1.20 Under the dollar-value LIFO method, the inventory at December 31, 2019, should...
At the beginning of 2018, Quentin and Kopps (Q&K) adopted the dollar-value LIFO (DVL) inventory method. On that date the value of its one inventory pool was $94,000. The company uses an internally generated cost index to convert ending inventory to base year. Required: Determine the missing amounts in the inventory data for 2018 through 2021 Ending Inventory at DVL cost Ending Ending Year Ended Inventory at Inventory at December 31 Year-End costs Base-Year Costs Cost Index 2018 S 111,300...
P 8-15 Dollar-value LIFO LO8-82 On January 1, 2018, Avondale Lumber adopted the dollar-value LIFO inventory method. The inventory value for its one inventory pool on this date was $260,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 Page 459 Year Ended December 31 Inventory 2018 2019 2020 2021 Year-End Costs $340,000 350,000 400,000 430,000 Cost Index (Relative...