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 ACCTING CONNECT ACCESS >I<
- Q.9 KARA Corporation's CFO uses this equation, which was developed by regressing inventories on sales over the past 5 years, to forecast inventory requirements: Inventories = P22.0 + 0.125(Sales). The company expects sales of P300 million during the current year, and it expects sales to grow by 25% next year. What is the inventory forecast for next year?arrow_forward55.XXX Company uses the average cost retail method to estimate its inventory. Data relating to the inventory at December 31, 2020 are: Cost Retail Inventory, January 1 P 2,000,000 P3,000,000 Purchases 10,600,000 14,000,000 Net markups 1,600,000 Net markdowns 600,000 Sales 12,000,000 Estimated normal shoplifting losses 400,000 Estimated normal shrinkage is 5% of sales Trinidad’s cost of goods sold for the year ended December 31, 2019 isarrow_forward61 2021 2020 Sales P2,080,000 P2,000,000 Cost of sales 1,755,000 1,500,000 Gross margin 325,000 500,000 Unit selling price decreased 20% at the start of 2019. The net change in gross profit in 2021 due to quantity factor is: Group of answer choices P600,000 increase P150,000 increase P400,000 increase P80,000 increasearrow_forward
- 37.The Blueberry Company values its inventory by using the FIFO retail method.. The following information is available for the year 2020: Cost RetailBeg. invy 809,000 1,400,000Purchases 2,970,000 4,200,000Freight-in 40,000 Net markups 130,000Net markdowns 30,000Sales 4,000,000Sales discount 75,000At what amount would Blueberry Company report as its estimated cost of goods sold under the FIFO retail method? a. 1,134,000 b. 1,700,000 c. 2,680,000 d. 2,800,000arrow_forwardE9.23 (LO 6 ) (Analysis of Inventories) The financial statements of ConAgra Foods, Inc.'s 2017 annual report disclose the following information. (in millions) 2017 2016 2015 Year-end inventories $934.2 $1,044.1 $1,642.6 Fiscal Year 2017 2016 Net sales $7,826.9 $8,664.1 Cost of goods sold 5,484.8 6,234.9 Net income 648.0 (665.9) Instructions Compute ConAgra's (a) inventory turnover and (b) the average days to sell inventory for 2017 and 2016.arrow_forward(Appendix 8.1) Inventory Write-Down Frost Companys inventory records tor the years 2019 and 2020 reveal the cost and market of the January 1, 2019, inventory to be 125,000. On December 31, 2019, the cost of inventory was 130,000, while the market value was only 128,000. The December 31, 2020, market value of inventory was 140,000, and the cost was only 135,000. Frost uses a periodic inventory system. Purchases for 2019 were 100,000 and for 2020 were 110,000. Required: 1. Assume the inventory that existed at the end of 2019 was sold in 2020. Prepare the journal entries at the end of 2019 and 2020 to record the lower of cost or net realizable value under the (a) allowance method and (b) direct method. 2. Prepare the cost of goods sold section of the income statement and show how the company would record the inventory on its balance sheet for 2019 and 2020 under the (a) allowance method and (b) direct method. 3. Next Level Refer to your answer for P8-3. How does the use of a periodic inventory system versus a perpetual inventory system affect the valuation of inventory and the amount reported as income?arrow_forward
- E8.12 (LO 3) (FIFO, LIFO, Average-Cost Inventory) Shania Twain Company was formed onDecember 1, 2019. The following information is available from Twain’s inventory records for Product BAP. Units Unit CostJanuary 1, 2020 (beginning inventory) 600 $ 8.00Purchases:January 5, 2020 1,200 9.00January 25, 2020 1,300 10.00February 16, 2020 800 11.00March 26, 2020 600 12.00 A physical inventory on March 31, 2020, shows 1,600 units on hand.InstructionsPrepare schedules to compute the ending inventory at March 31, 2020, under each of the following inventory methods.a. FIFO b. LIFO. c. Weighted-average (round unit costs to two decimal places)arrow_forwardMay I ask for an explanation and solution to the question for a better understanding. Thank you! 5. Pierce Corporation has the following gross profits for 2018 and 2019: Sales = 2019 - P810,000; 2018 - P792,000. Cost of sales = 2019 - 480,000; 2018 - 464,000. Gross profit = 2019 - P330,000; 2018 - P328,000. Sales price was 10% lower during 2019. The increase (decrease) in quantity sold must be: a. (7.95%) b. 12.00% c. 13.33% d. 13.64%arrow_forwardEA5. EA5. LO 10.2Akira Company had the following transactions for the month.Chart showing Beginning Inventory of 150 units at $10 per unit, Purchase of March 31 of 160 units at $12 each, Purchase of October 15 of 130 units at $15 each, and ending inventory of 50 units at a cost of ? each.Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. first-in, first-out (FIFO)last-in, first-out (LIFO)weighted average (AVG)arrow_forward
- May I ask for an explanation and solution to the question for a better understanding. Thank you! 8. Pierce Corporation has the following gross profits for 2018 and 2019: Sales = 2019 - P810,000; 2018 - P792,000. Cost of sales = 2019 - 480,000; 2018 - 464,000. Gross profit = 2019 - P330,000; 2018 - P328,000. Sales price was 10% lower during 2019. The percent of increase (decrease) in cost price must be: a. 8.97% b(8.97%) c. 9.85% d. (9.85%)arrow_forwardQuestion 98 Using Financial Statements for 2020, average daily sales for the year 2020 is 1,452.05. TRUE OR FALSE?arrow_forwardending 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_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning