Dollar-value LIFO retail
• LO9–5
This exercise is a continuation of BE 9–11. During 2019, purchases at cost and retail were $168,000 and $301,000, respectively. Net markups, net markdowns, and net sales for the year were $3,000, $4,000, and $280,000, respectively. The retail price index at the end of 2019 was 1.06. Estimating ending inventory in 2019 using the dollar-value LIFO retail method.
Dollar-Value-LIFO: This method shows all the inventory figures at dollar price rather than units. Under this inventory method, the units that are purchased last, are sold first. Thus, it starts from the selling of the units recently purchased and ending with the beginning inventory.
To Estimate: the ending inventory in 2019 using dollar-value LIFO retail method.
Explanation of Solution
Calculate the amount of estimated ending inventory at retail.
Details | Cost ($) | Retail ($) |
Beginning inventory | 50,451 | 86,000 |
Add: Net purchase | 168,000 | 301,000 |
Net markups | 3,000 | |
Less: Net markdowns | (4,000) | |
Goods available for sale – Excluding beginning inventory | 168,000 | 300,000 |
Goods available for sale – Including beginning inventory | 218,451 | 386,000 |
Less: Net sales | (280,000) | |
Estimated ending inventory at current year retail prices | 106,000 | |
Estimated ending inventory at cost | (59,762) | |
Estimated cost of goods sold | 158,689 |
Table (1)
Working notes:
Calculate base layer cost-to retail percentage.
Calculate current year layer (2018) cost-to retail percentage.
Calculate current year layer (2019) cost-to retail percentage.
Calculate the amount of estimated ending inventory at cost.
Ending inventory at dollar-value LIFO retail cost | ||||
Step 1 | Step 2 | Step 3 | ||
Ending inventory at year-end retail prices ($) | Ending inventory at base year retail prices ($) | Inventory layers at base year retail prices ($) | Inventory layers converted to cost ($) | |
106,000 (refer Table 1) | 100,000(4) | 68,000 (Base) (5) | 40,800 (8) | |
16,314 (2016) (6) | 9,651(9) | |||
15,686 (2017) (7) | 9,311(10) | |||
Total ending inventory at dollar-value LIFO retail cost | $59,762 |
Table (2)
Calculate the amount of ending inventory at base year retail prices.
Calculate the amount of inventory layers at base year retail prices.
Calculate the amount of inventory layers at current year retail prices.
Calculate the amount of inventory layers at current year retail prices.
Calculate the amount of inventory layers converted to cost (Base).
Calculate the amount of inventory layers converted to cost (2018).
Calculate the amount of inventory layers converted to cost (2019).
Therefore, the ending inventory in 2019 using dollar-value LIFO retail method is $59,762.
Want to see more full solutions like this?
Chapter 9 Solutions
INTERMEDIATE ACCOUNTING(LL)-W/CONNECT
- ending inventory price date end of year prices index dec 31 2016 69400 100 dec 31 2017 102080 116 dec 31 2018 110208 128 dec 31 2019 123816 132 dec 31 2020 116058 138 Using the dollar-value LIFO method, compute the ending inentory for 2020arrow_forwardExercise 9-19 (Static) Dollar-value LIFO retall [LO9-5] On January 1, 2024, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2024: Beginning inventory Net purchases Net markups Net markdowns Net sales Retail price index, 12/31/2024 Cost $ 71,280 Retail $ 132,000 112,500 255,000 6,000 11,000 232,000 1.04 Required: Calculate the estimated ending inventory and cost of goods sold for 2024 using the information provided. Note: Do not round intermediate calculations. Ending inventory at retail $ 150,000 Ending inventory at cost Cost of goods sold $ 106,776arrow_forwardEnding Inventory Price Date (End-of-Year Prices) Index December 31, 2022 $181,000 100 December 31, 2023 254,760 120 December 31, 2024 258,463 131 December 31, 2025 287,716 143 December 31, 2026 328,174 154 December 31, 2027 369,920 160 Compute the ending inventory for Bramble Company for 2022 through 2027 using the dollar-value LIFO method. Ending Inventory 2022 $ +A 2023 EA $ 2024 2025 2026 A +A $ 2027 $ +Aarrow_forward
- Exercise 9-19 (Algo) Dollar-value LIFO retall [LO9-5) On January 1, 2024, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2024: Beginning inventory Net purchases Net markups Net markdowns Net sales Retail price index, 12/31/2024 Cost $ 73,500 106, 400 Ending inventory at retail Ending inventory at cost Cost of goods sold Retail $147,000 271,000 5,000 10,000 245,000 1.05 Required: Calculate the estimated ending inventory and cost of goods sold for 2024 using the information provided. Note: Do not round intermediate calculations.arrow_forward2 The following figures are for the year 2020: Inventory 1.1.2020 $4000 Inventory 31.12.2020 6000 Purchases 52,000 A uniform rate of markup of 20% is applied. Required: Calculate the gross profit and the sales figures using the income statement approach.arrow_forwardExercise 8-27 (Algo) Dollar-value LIFO [LO8-8] Mercury Company has only one inventory pool. On December 31, 2021, Mercury adopted the dollar-value LIFO inventory method. The inventory on that date using the dollar-value LIFO method was $201,000. Inventory data are as fpllows: Ending Inventory at Year-End Costs Ending Inventory at Year Base Year Costs 2022 $233,100 302,450 $222,000 263,000 253,000 2023 2024 303,600 Required: Compute the inventory at December 31, 2022, 2023, and 2024, using the dollar-value LIFO method. (Round "Year end cost index" to 2 decimal places.) O Answer is not complete. Inventory DVL Cost Inventory Layers Converted to Base Year Cost Inventory Layers Converted to Cost Year- Inventory Layers at Base Year Cost Inventory Layers at Base Year Cost Year- Inventory at Year-End Cost End Cost Index End Cost Index Inventory Layers Converted to Cost Date 12/31/2021 201,000 1 IS 201.000 Base 2$ 201,000 1 %3D 24 201,000 $ 201,000 %3D 12/31/2022 233,100 1.05 2$ 222,000 Base IS…arrow_forward
- Exercise 8-26 (Algo) Dollar-value LIFO [LO8-8] On January 1, 2024, a Company adopted the dollar-value LIFO method for its one inventory pool. The pool's value on this date was $670,000. The 2024 and 2025 ending inventory valued at year-end costs were $714,000 and $795,000, respectively. The appropriate cost indexes are 1.05 for 2024 and 1.06 for 2025. Required: Complete the below table to calculate the inventory value at the end of 2024 and 2025 using the dollar-value LIFO method. Note: Round "Year end cost index" to 2 decimal places. Round other final answer values to the nearest whole dollars. Date 01/01/2024 12/31/2024 12/31/2025 Inventory Layers Converted to Base Year Cost Inventory at Year-End Cost Year-End Cost Index = = = Inventory Layers at Base Year Cost Base Base 2024 Base 2024 2025 Inventory Layers Converted to Cost Inventory Layers at Base Year Cost Year-End Cost Index = = = = = Inventory Layers Converted to Cost Inventory DVL Cost S S S 0 0 0arrow_forwardProblem 13-9 (IAA) Fairy Company provided the following information: 2019 2020 Sales Beginning inventory Purchases Freight in Purchase discounts Purchase returns Purchase allowances Ending inventory 7,500,000 1,260,000 6,450,000 350,000 90,000 120,000 20,000 2,355,000 4,500,000 3,180,000 220,000 45,000 40,000 15,000 What is the inventory on December 31, 2020? a. 2,370,000 b. 2,025,000 c. 3,285,000 d. 2,505,000arrow_forwardNet Sales Cost of goods sold Average accounts receivable for the year Accounts receivable at year-end Average inventory for the year Inventory at year-end $1,095,000 657,000 44,250 18,000 226,000 158,400 Required: a. Calculate the inventory turnover for 2019.arrow_forward
- =6 Billingsly Products uses the conventional retail method to estimate its ending inventories. The following data has been summarized for the year 2024: Inventory, January 1 Purchases Net markups Net markdowns Net sales Cost $ 53,000 322,360 Retail $ 78,000 466,000 8,000 16,700 392,000 Required: Estimate the ending inventory as of December 31, 2024. Estimated ending inventory at retail Estimated ending inventory at cost Karrow_forward2. Date The following information relates to the Windsor Company. Ending Inventory Price (End-of-Year Prices) Index December 31, 2023 $ 60,500 100 December 31, 2024 78,000 103 December 31, 2025 90,400 106 December 31, 2026 99,750 108 December 31, 2027 115,680 111 Use the dollar-value LIFO method to compute the ending inventory for Windsor Company for 2023 through 2027.arrow_forward9. The Tam Company uses the retail inventory method and the average cost flow assumption for preparation of its interim reports. Information about Tam's inventory in the second quarter of 2020 is shown below: Cost Retail $ 600 Beginning inventory Purchases $400 800 1,480 Net markups Net markdowns 160 (240) Sales 1,200 What is the estimated cost of Tam's inventory on June 30, 2020? a. $464 b. $480 c. $428 d. $520arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning