Concept explainers
Dollar-value LIFO retail
• LO9–5
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018:
Cost | Retail | |
Beginning inventory | $ 71,280 | $ 132,000 |
Net purchases | 112,500 | 255,000 |
Net mark-ups | 6,000 | |
Net markdowns | 11,000 | |
Net sales | 232,000 | |
Retail price index, 12/31/2018 | 1.04 |
Required:
Calculate the estimated ending inventory and cost of goods sold for 2018.
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 and cost of goods sold for 2018.
Explanation of Solution
Calculate the amount of estimated ending inventory and cost of goods sold for 2018.
Details | Cost ($) | Retail ($) |
Beginning inventory | 71,280 | 132,000 |
Add: Net purchases | 112,500 | 255,000 |
Net markups | 6,000 | |
Less: Net markdowns | (11,000) | |
Goods available for sale – Excluding beginning inventory | 112,500 | 250,000 |
Goods available for sale – Including beginning inventory | 183,780 | 382,000 |
Less: Net sales | (232,000) | |
Estimated ending inventory at current year retail prices | 150,000 | |
Estimated ending inventory at cost | (77,004) | |
Estimated cost of goods sold | 106,776 |
Table (1)
Working notes:
Calculate base layer cost-to retail percentage.
Calculate current year layer (2018) 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 ($) | |
150,000 (refer Table 1) | 144,231(3) | 132,000 (Base) (4) | 71,280 (6) | |
12,231 (2018) (5) | 5,724(7) | |||
Total ending inventory at dollar-value LIFO retail cost | $77,004 |
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 converted to cost (Base).
Calculate the amount of inventory layers converted to cost (2018).
Therefore, the ending inventory and cost of goods sold for 2018 using dollar-value LIFO retail method are $77,004 and $106,776 respectively.
Want to see more full solutions like this?
Chapter 9 Solutions
INTERMEDIATE ACCOUNTING RMU 9TH EDITION
- ( Appendix 6B) Inventory Costing Methods Jet Black Products uses a periodic inventory system. For 2018 and 2019, Jet Black has the following data: All purchases and sales are for cash. Required: 1. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using FIFO. 2. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using LIFO. 3. Compute cost of goods sold, the cost of ending inventory, and gross margin for each year using the average cost method. ( Note: Use four decimal places for per unit calculations and round all other numbers to the nearest dollar.) 4. CONCEPTUAL CONNECTION Which method would result in the lowest amount paid for taxes? 5. CONCEPTUAL CONNECTION Which method produces the most realistic amount for income? For inventory? Explain your answer. 6. CONCEPTUAL CONNECTION What is the effect of purchases made later in the year on the gross margin when LIFO is employed? When FIFO is employed? Be sure to explain why any differences occur. 7. CONCEPTUAL CONNECTION If you worked Problem 6-68A, compare your answers. What are the differences? Be sure to explain why any differences occurred.arrow_forwardRequired information Problem 9-13 (Algo) Retail inventory method; various applications [LO9-3, 9-4, 9-5] [The following information applies to the questions displayed below.] On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: Beginning inventory Purchases Purchase returns Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 20% discount) Normal spoilage Price Index: January 1, 2021 December 31, 2021 December 31, 2022 Problem 9-13 (Algo) Part 3 X Answer is complete but not entirely correct. Conventional Retail Method Estimated ending inventory at retail Estimated ending inventory at cost Estimated cost of goods sold $ $ $ 2021 950,400 X 725,191 X 725,191 x Cost Retail $105,400 $170,000 430,000 622,000 4,000 2,900 6,200 1.00 1.04 1.20 5,150 4,150 500,000 14,400 1,900 Cost 2022 Required: 3. Estimate the 2021 ending inventory and…arrow_forwardRequired information Problem 9-13 (Algo) Retail inventory method; various applications [LO9-3, 9-4, 9-5] [The following information applies to the questions displayed below.] On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: Beginning inventory Purchases Purchase returns Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 20% discount) Normal spoilage Price Index: January 1, 2021 December 31, 2021 December 31, 2022 Problem 9-13 (Algo) Part 1 Estimated ending inventory at retail Estimated ending inventory at cost Estimated cost of goods sold 2021 2021 2022 Cost Retail $105,400 $170,000 430,000 622,000 2,900 4,000 6,200 1.00 1.04 1.20 5,150 4,150 500,000 14,400 1,900 Cost 2022 Retail $630,000 $792,000 2,600 2,450 6,000 Required: 1. Estimate the 2021 and 2022 ending inventory and cost of goods sold using the dollar-value LIFO…arrow_forward
- Exercise 9-19 (Algo) Dollar-value LIFO retail [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 $ 84,560 127,000 Ending inventory at retail Ending inventory at cost Cost of goods sold Retail $ 151,000 260,000 9,000 15,000 237,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_forwardProblem 9-13 (Algo) Retail inventory method; various applications [LO9-3, 9-4, 9-5] [The following information applies to the questions displayed below.] On January 1, 2024, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2024 and 2025 are as follows: Beginning inventory Purchases Purchase returns Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 20% discount) Normal spoilage Price Index: January 1, 2024 December 31, 2024 December 31, 2025 Problem 9-13 (Algo) Part 1 Estimated ending inventory at retail Estimated ending inventory at cost Estimated cost of goods sold $ $ $ 2024 2024 Cost Retail $ 150,500 $ 215,000 640,000 852,000 2,700 6,800 5,650 474,400 $ 354,756 $ (579,600) $ 1.00 1.25 1.25 2025 Required: 1. Estimate the 2024 and 2025 ending inventory and cost of goods sold using the dollar-value LIFO retail method. Note: Round your cost-to-retail percentage calculation…arrow_forwardExercise 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_forward
- Problem 9-13 (Algo) Retail inventory method; various applications [LO9-3, 9-4, 9-5] [The following information applies to the questions displayed below.] On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2022 Retail 2021 Cost Retail Cost Beginning inventory Purchases $105,400 $170,000 430,000 2,900 6,200 $630,000 $792,000 2,600 6,000 622,000 4,000 Purchase returns 2,450 Freight-in Net markups Net markdowns 8,600 6,400 690,000 14,400 5,300 5,150 4,150 500,000 14,400 1,900 Net sales to customers Sales to employees (net of 20% discount) Normal spoilage Price Index: January 1, 2021 December 31, 2021 December 31, 2022 1.00 1.04 1.20 Problem 9-13 (Algo) Part 1 Required: 1. Estimate the 2021 and 2022 ending inventory and cost of goods sold using the dollar-value LIFO retail method. X Answer is complete but not entirely correct. 2021 2022 Estimatedending inventory at…arrow_forwardProblem 14-12 (IAA) Flame Company adopted the FIFO approach of inventory pricing in connection with the use of the retail inventory method. The retail records showed the following: 2020 Cost Retail Beginning inventory Purchases Net markup Net markdown Sales 556,800 4,576,000 928,000 7,028,000 42,000 30,000 6,840,000 2021 4,760,000 Purchases Net markup Net markdown Sales 6,812,000 56,000 68,000 6,928,000 Required: Determine the estimated cost of inventory on December 31, 2020 and 2021 applying the FIFO retail approach.arrow_forwardRequired information Problem 9-13 (Algo) Retail inventory method; various applications [LO9-3, 9-4, 9-5) [The following information applies to the questions displayed below.] On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 Cost 2022 Retail $156,000 $240,000 510,000 752, e00 6,200 6,200 Cost Retail Beginning inventory Purchases Purchase returns Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 30% discount) Normal spoilage Price Index: January 1, 2021 December 31, 2021 December 31, 2022 $725,000 $1, 123,000 4,000 7,000 3,650 6,600 6,250 4,600 500, 000 21,000 6,200 11,400 7,800 718,000 21,000 3,000 1.00 1.25 1.50 Problem 9-13 (Algo) Part 1 Reauired: ( Prev 2. 3 4 of 4 Next > Problem 9-13 (Algo) Part 1 Required: 1. Estimate the 2021 and 2022 ending inventory and cost of goods sold using the dollar-value LIFO retail…arrow_forward
- DATE DETAILS UNITS COST PER UNIT 1 OPENING INVENTORY 20 R85 7 Purchases 23 R90 16 Purchases 33 R95 25 Purchases 18 R100 31 Sales for the month 69 Calculate the value of closing inventory using the Weighted average cost inventory valuationmethod.arrow_forwardMC42 The following data is available for Corona Trading: Cost P 47,075 213,327 3,400 Retail P 70,025 306,375 Inventory, January 1 Purchases (net) Freight in Sales Additional markups Cancellation of additional markups 320,500 18,900 7,800 10,640 Markdowns Physical inventory, December 31, at retail 39,390 Corona Trading uses the average retail method. What is the cost of goods sold before loss on inventory shortage? P248,355 P231,798 P225,175 P224,350 a. b. с. d.arrow_forwardView Policies Current Attempt in Progress Sheffield Limited uses the average cost formula in a perpetual inventory system. Fill in the missing amounts for items [1] to [13]in the following perpetual inventory schedule. (Round per unit cost and total cost to 2 decimal places, e.g. 15.23.) Purchases Date Units Cost Total Units Cost April 1 6 29 [1] $ $5,742 26 [5] $ 14 [10] $201 $2,211 eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answerarrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning