Concept explainers
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:
In addition, the following price indexes are available:
Required:
Compute the inventory at the end of each of the 4 years. Round the cost-to-retail ratio to 3 decimal places.
Calculate the cost of ending inventory for 2018, 2019, 2020, and 2021 years by using dollar-value LIFO retail method.
Explanation of Solution
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.
Calculate the cost of ending inventory for 2018, 2019, 2020, and 2021 years by using dollar-value LIFO retail method:
For the year 2018:
Step 1: Calculate the amount of estimated ending inventory at retail.
I Incorporation | ||
Ending Inventory Under DVL Retail Method | ||
For the Year 2018 | ||
Details | Cost ($) | Retail ($) |
Beginning inventory | 40,000 | 80,000 |
Add: Net purchase | 85,500 | 190,000 |
Goods available for sale – Excluding beginning inventory | 85,500 | 190,000 |
Goods available for sale – Including beginning inventory | 125,500 | 270,000 |
Less: Net sales | (200,000) | |
Estimated ending inventory at retail for 2018 | $70,000 |
Table (1)
Step 2: Calculate ending inventory at retail at base-year prices.
Step 3: Calculate inventory change at retail at base year prices.
Step 4: Calculate the change at retail at relevant current costs.
Step 5: Calculate the change at relevant current costs.
Step 6: Calculate ending inventory at cost.
Hence, the ending inventory at cost for 2018 is $33,333.
Working note 1:
Calculate cost-to-retail ratio.
Working note 2:
Calculate cost-to-retail ratio.
For the year 2019:
Step 1: Calculate the amount of estimated ending inventory at retail.
I Incorporation | ||
Ending Inventory Under DVL Retail Method | ||
For the Year 2019 | ||
Details | Cost ($) | Retail ($) |
Beginning inventory | 33,333 | 70,000 |
Add: Net purchase | 92,000 | 230,000 |
Goods available for sale – Excluding beginning inventory | 92,000 | 230,000 |
Goods available for sale – Including beginning inventory | 125,333 | 300,000 |
Less: Net sales | (210,000) | |
Estimated ending inventory at retail for 2019 | $90,000 |
Table (1)
Step 2: Calculate ending inventory at retail at base-year prices.
Step 3: Calculate inventory change at retail at base year prices.
Step 4: Calculate the change at retail at relevant current costs.
Step 5: Calculate the change at relevant current costs.
Step 6: Calculate ending inventory at cost.
Hence, the ending inventory at cost for 2019 is $39,999.
Working note 1:
Calculate cost-to-retail ratio.
For the year 2020:
Step 1: Calculate the amount of estimated ending inventory at retail.
I Incorporation | ||
Ending Inventory Under DVL Retail Method | ||
For the Year 2020 | ||
Details | Cost ($) | Retail ($) |
Beginning inventory | 39,999 | 90,000 |
Add: Net purchase | 117,600 | 280,000 |
Goods available for sale – Excluding beginning inventory | 117,600 | 280,000 |
Goods available for sale – Including beginning inventory | 157,599 | 370,000 |
Less: Net sales | (260,000) | |
Estimated ending inventory at retail for 2020 | $110,000 |
Table (3)
Step 2: Calculate ending inventory at retail at base-year prices.
Step 3: Calculate inventory change at retail at base year prices.
Step 4: Calculate the change at retail at relevant current costs.
Step 5: Calculate the change at relevant current costs.
Step 6: Calculate ending inventory at cost.
Hence, the ending inventory at cost for 2020 is $44,963.
Working note 1:
Calculate cost-to-retail ratio.
For the year 2021:
Step 1: Calculate the amount of estimated ending inventory at retail.
I Incorporation | ||
Ending Inventory Under DVL Retail Method | ||
For the Year 2021 | ||
Details | Cost ($) | Retail ($) |
Beginning inventory | 44,963 | 110,000 |
Add: Net purchase | 147,200 | 320,000 |
Goods available for sale – Excluding beginning inventory | 147,200 | 320,000 |
Goods available for sale – Including beginning inventory | 192,163 | 430,000 |
Less: Net sales | (300,000) | |
Estimated ending inventory at retail for 2021 | $130,000 |
Table (4)
Step 2: Calculate ending inventory at retail at base-year prices.
Step 3: Calculate inventory change at retail at base year prices.
Step 4: Calculate the change at retail at relevant current costs.
Step 5: Calculate the change at relevant current costs.
Step 6: Calculate ending inventory at cost.
Hence, the ending inventory at cost for 2021 is $52,054.
Working note 1:
Calculate cost-to-retail ratio.
Want to see more full solutions like this?
Chapter 8 Solutions
EBK INTERMEDIATE ACCOUNTING: REPORTING
- Financial statement data for years ending December 31 for Tango Company follow: a. Determine the inventory turnover for 20Y7 and 20Y6. b. Determine the days sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y6 to 20Y7 indicate a favorable or an unfavorable trend?arrow_forwardFinancial statement data for years ending December 31 for Holland Company follow: a. Determine the inventory turnover for 20Y4 and 20Y3. b. Determine the days sales in inventory for 20Y4 and 20Y3. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y3 to 20Y4 indicate a favorable or an unfavorable trend?arrow_forwardHurst Companys beginning inventory and purchases during the fiscal year ended December 31, 20-2, were as follows: There are 1,200 units of inventory on hand on December 31, 20-2. REQUIRED 1. Calculate the total amount to be assigned to the cost of goods sold for 20-2 and ending inventory on December 31 under each of the following periodic inventory methods: (a) FIFO (b) LIFO (c) Weighted-average (round calculations to two decimal places) 2. Assume that the market price per unit (cost to replace) of Hursts inventory on December 31 was 18. Calculate the total amount to be assigned to the ending inventory on December 31 under each of the following methods: (a) FIFO lower-of-cost-or-market (b) Weighted-average lower-of-cost-or-market 3. In addition to taking a physical inventory on December 31, Hurst decides to estimate the ending inventory and cost of goods sold. During the fiscal year ended December 31, 20-2, net sales of 100,000 were made at a normal gross profit rate of 35%. Use the gross profit method to estimate the cost of goods sold for the fiscal year ended December 31 and the inventory on December 31.arrow_forward
- At December 31, 2019, the following information was available from Crisford Companys books: Sales for the year totaled 110,600; markdowns amounted to 1,400. Under the approximate lower of average cost or market retail method, Crisfords inventory at December 31, 2019, was: a. 30,800 b. 28.000 c. 21,560 d. 19,600arrow_forwardBeginning inventory, purchases, and sales for 30xT are as follows: Assuming a perpetual inventory system and using the weighted average method, determine (a) the weighted average unit cost after the May 23 purchase, (b) the cost of the merchandise sold on May 26, and (c) the inventory on May 31.arrow_forwardHabicht Company was formed in 2018 to produce a single product. The production and sales for the next 4 years were as follows: Required: 1. Determine the gross profit for each year under each of the following periodic inventory methods: a. FIFO b. LIFO c. Average cost (Round unit costs to 3 decimal places.) 2. Next Level Explain whether the companys return on assets (net income divided by average total assets) would be higher under FIFO or LIFO.arrow_forward
- Inventory Analysis Singleton Inc. reported the following information for the current year: Required: Compute Singletons (a) gross profit ratio, (b) inventory turnover ratio, and (c) average days to sell inventory. (Note: Round all answers to two decimal places.)arrow_forwardUse the following information to complete the calculations below. Cost of goods sold $195,640 Inventory: Beginning of year 20,500 End of year 18,628 a. Compute inventory turnover. b. Compute average daily cost of goods sold using a 365 day year. c. Compute number of days' sales in inventory. Round your answer to one decimal place. daysarrow_forwardWhat should Cake report as cost of goods sold for 2022? * Cake Company sells one product which it purchases from various suppliers. The trial balance on December 31, 2022 included the following accounts: Sales (100,000 units at P150) Sales discount Purchase Purchase discount The inventory purchases during 2022 were as follows: Beginning inventory, January 1 Purchases, quarter ended March 31 Purchases, quarter ended June 30 Purchases, quarter ended Sept. 30 Purchases, quarter ended Dec. 31 Units 20,000 30,000 40,000 50,000 10,000 150,000 Unit cost 60 65 70 75 15,000,000 1,000,000 9,300,000 400,000 80 Total cost 1,200,000 1,950,000 2,800,000 3,750,000 800,000 10,500,000 Cake's accounting policy is to report inventory in its financial statements at the lower of cost or net realizable value. Cost is determined under the first-out method. Cake has determined that, on December 31, 2022, the replacement cost of its inventory was P70 per unit and the net realizable value was P72 per unit. The…arrow_forward
- A company uses the average cost retail method to estimate inventories. Data for the first six months of 2024 include beginning inventory at cost and retail were $61,500 and $121,000, net purchases at cost and retail were $313,000 and $481,000, and sales during the first six months totaled $491,000. The estimated inventory at June 30, 2024, would be: Note: Round cost-to-retail ratio to the nearest whole percentage. Multiple Choice $72,120 $55,620 $63,870arrow_forwardYou have the following information for Metlock, Inc. for the month ended October 31, 2022. Metlock uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 65 $22 Oct. 9 Purchase 140 24 Oct. 11 Sale 100 40 Oct. 17 Purchase 100 25 Oct. 22 Sale 65 45 Oct. 25 Purchase 75 27 Oct. 29 Sale 110 45 (a1) Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average cost per unit $arrow_forwardThe following data are available for Sellco for the fiscal year ended on January 31, 2023: Sales Beginning inventory Purchases, in chronological order Required: a. Calculate cost of goods sold and ending Inventory under the cost flow assumptions, FIFO, LIFO and Weighted average (using a periodic Inventory system): b. Assume that net income using the weighted-average cost flow assumption is $15,600. Calculate net Income under FIFO and LIFO. 790 units 220 units@ $4 310 units @ $5 410 units@ $6 220 units@ $7 Complete this question by entering your answers in the tabs below. Required A Required B Calculate cost of goods sold and ending inventory under the cost flow assumptions, FIFO, LIFO and Weighted average (using a periodic inventory system): Note: Round unit cost to 2 decimal places. FIFO LIFO Weighted average Cost of Goods Sold Ending Inventoryarrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningIndividual Income TaxesAccountingISBN:9780357109731Author:HoffmanPublisher:CENGAGE LEARNING - CONSIGNMENT
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning