Question

In: Accounting

Umni Company manufactures one product. Beginning in 2013, Umni adopted the dollar-value LIFO inventory method. Required:...


Umni Company manufactures one product. Beginning in 2013, Umni adopted the dollar-value LIFO inventory method.

Required: Please show all calculations

Inventory data for the years following the base-year are:

Inventory at Price index
Year year-end prices (base year 2013)
2013 $180,000 1.00

2014 252,000 1.05

2015 264,500 1.15

2016 387,500 1.25


a) Compute the ending inventory at December 31, 2013, 2014, 2015, and 2016, using the dollar-value LIFO method for each year. Clearly indicate the inventory amount that will be reported on the Balance Sheet at 12/31/13, 12/31/14, 12/31/15, and 12/31/16.

b) Write the needed adjusting entry for 12/31/14.

c) What is the LIFO Reserve amount for 12/31/15? What is the LIFO effect for 12/31/15? Write the needed adjusting entry for 12/31/15.

Solutions

Expert Solution

a. Computation of ending inventory at December 31st 2013, 2014, 2015 and 2016 using Dollar-Value LIFO Method for each year

Inventory at the end of 2014

Comparing the year end inventory value of 2013 and 2014 at base year price , the change would be $60,000

Restating the change in price as per the year 2014 i.e 60,000*1.05 = $63,000

Inventory at the end of 2015

Comparing the base year value of 2014 and 2015, there is a decrease of $10,000

If there is a decrease in value, then it will be adjusted against the most recent layer. In the given case, the second layer was added for year 2014 is $60,000 at base year prices. After adjusting the decrease the adjusted amount will be (60,000-10,000)=$50,000. The amount shall restated the change as per 2014 price i.e 1.05 not on 1.15

Note : No layer is added when the inventory decreased. New layer is added only if ending inventory at base year price is more than respective year's beginning inventory at base year prices.

Inventory at the end of 2016

Comparing the base year values of 2014 and 2015, there is an increase of $80,000

As the ending inventory at base year price level is more than 2014 inventory, new layer will be added with the value of $80,000. This will be restated using 2016 price index 1.25 and the price will be $80000*1.25 = $100,000

Amounts to be reported in Balance sheet for each year as follows:

b. Needed adjustment in 2014

c. LIFO Reserve amount, the LIFO effect and the needed entry for 2015

LIFO Reserve amount = FIFO Inventory Cost - LIFO Inventory Cost

LIFO Effect

2014 LIFO Reserve $9,000

2015 closing LIFO Reserve $32,000

Therefore the LIFO Effect will be $32,000-$9,000 = $23,000

Needed Entry


Related Solutions

Aber Company manufactures one product. On December 31, 2016, Aber adopted the dollar-value LIFO inventory method....
Aber Company manufactures one product. On December 31, 2016, Aber adopted the dollar-value LIFO inventory method. The inventory on that date using the dollar-value LIFO inventory method was $900,000. Inventory data are as follows: Year Inventory at year-end prices Price index (base year 2016) 2017 $1,260,000 1.05 2018 1,840,000 1.15 2019 1,900,000 1.25 Compute the inventory at December 31, 2017, 2018, and 2019, using the dollar-value LIFO method for each year. Inventory at December 31, 2017 $ Inventory at December...
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...
Eastman Corporation manufactures one product. On December 31, 2018, Eastman adopted the dollar-value LIFO inventory method....
Eastman Corporation manufactures one product. On December 31, 2018, Eastman adopted the dollar-value LIFO inventory method. The inventory on that date using the dollar-value LIFO inventory method was $850,000. Inventory data are as follows:                 Year                       Inventory @ Year-End Prices                       Price Index (base year 2018                 2019                       $1,180,000                                                                           1.05                 2020                       $1,940,000                                                                           1.15                 2021                       $1,800,000                                                                           1.25 1. Compute the inventory at December 31, 2019, 2020 and 2021, using the dollar-value LIFO method for each year, including the LIFO Reserve....
Dollar-Value LIFO Belstock Company manufactures one product. On December 31, 2015, Belstock adopted the dollar-value LIFO...
Dollar-Value LIFO Belstock Company manufactures one product. On December 31, 2015, Belstock adopted the dollar-value LIFO inventory method. The inventory on that date using the dollar-value LIFO inventory method was $200,000. Inventory data for succeeding years are as follows: Year Inventory at Respective Year-End Prices Price Index (Base Year 2015) 2016 $231,000 1.05 2017    299,000 1.15 2018    300,000 1.20 Required: Compute the ending inventory using the dollar-value LIFO method for 2016, 2017, and 2018. Do not round your intermediate calculations....
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...
On January 1, 2018, the Haskins Company adopted the dollar-value LIFO method for its one inventory...
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 $850,000. The 2018 and 2019 ending inventory valued at year-end costs were $897,000 and $972,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...
At the beginning of 2018, Quentin and Kopps (Q&K) adopted the dollar-value LIFO (DVL) inventory method....
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 $81,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. Year Ended Ending Inventory At Ending Inventory At Ending Inventory At 31-Dec Year-End Costs Base Year Costs Cost Index DVL Cost 2018 $                     95,550.00...
On Jan 1, 2010, the Michael-book Company adopted the dollar-value LIFO method for its one inventory...
On Jan 1, 2010, the Michael-book Company adopted the dollar-value LIFO method for its one inventory pool. The pool's value on this date was $600,000. The 2010 and 2011 ending inventory valued at year-end costs were $690,000 and 714,960 respectively. The appropriate cost indexes are 1.04 for 2010 and 1.08 for 2011. 1. Calculate the ending inventory balance that Michael-book will report on its Dec 31, 2010 balance sheet. 2. Calculate the ending inventory balance that Michael-book will report on...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT