Concept explainers
Calculate the cost of ending inventory for 2016, 2017, and 2018 using the dollar-value LIFO retail inventory 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 2016, 2017, and 2018 using the dollar-value LIFO retail inventory method:
For the year 2016:
Step 1: Calculate the amount of estimated ending inventory at retail.
B Company | ||
Ending Inventory Under DVL Retail Method | ||
For the Year 2016 | ||
Details | Cost ($) | Retail ($) |
Beginning inventory | 50,000 | 100,000 |
Add: Net purchase | 200,000 | 420,000 |
Net additional markups | 20,000 | |
Less: Net markdowns | 0 | (10,000) |
Goods available for sale – Excluding beginning inventory | 200,000 | 430,000 |
Goods available for sale – Including beginning inventory | 250,000 | 530,000 |
Less: Net sales | (400,000) | |
Estimated ending inventory at retail for 2016 | $130,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 relevant current costs.
Step 5: Calculate ending inventory at cost.
Hence, the ending inventory at cost for 2016is $60,230.
Working note 1:
Calculate cost-to-retail ratio.
Working note 2:
Calculate cost-to-retail ratio.
For the year 2017:
Step 1: Calculate the amount of estimated ending inventory at retail.
B Company | ||
Ending Inventory Under DVL Retail Method | ||
For the Year 2017 | ||
Details | Cost ($) | Retail ($) |
Beginning inventory | 60,230 | 130,000 |
Add: Net purchase | 250,000 | 550,000 |
Net additional markups | 30,000 | |
Less: Net markdowns | 0 | (40,000) |
Goods available for sale – Excluding beginning inventory | 250,000 | 540,000 |
Goods available for sale – Including beginning inventory | 310,230 | 670,000 |
Less: Net sales | (600,000) | |
Estimated ending inventory at retail for 2017 | $70,000 |
Table (2)
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 total change at relevant current costs.
(i)
Calculate the change at relevant current costs for 2016 (2016 layer):
(ii)
Calculate the change at relevant current costs for 2017(base-year layer):
(iii)
Calculate the total change at relevant current costs.
Step 5: Calculate ending inventory at cost.
Hence, the ending inventory at cost for 2017 is $30,435.
Working note 1:
Calculate cost-to-retail ratio for 2016.
Working note 2:
Calculate cost-to-retail ratio.
For the year 2018:
Step 1: Calculate the amount of estimated ending inventory at retail.
B Company | ||
Ending Inventory Under DVL Retail Method | ||
For the Year 2018 | ||
Details | Cost ($) | Retail ($) |
Beginning inventory | 30,435 | 70,000 |
Add: Net purchase | 240,000 | 500,000 |
Net additional markups | 10,000 | |
Less: Net markdowns | 0 | (20,000) |
Goods available for sale – Excluding beginning inventory | 240,000 | 490,000 |
Goods available for sale – Including beginning inventory | 270,435 | 560,000 |
Less: Net sales | (450,000) | |
Estimated ending inventory at retail for 2018 | $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 relevant current costs.
Step 5: Calculate ending inventory at cost.
Hence, the ending inventory at cost for 2018 is$48,544.
Working note 1:
Calculate cost-to-retail ratio.
Want to see more full solutions like this?
Chapter 8 Solutions
Cengagenowv2, 1 Term Printed Access Card For Wahlen/jones/pagach’s Intermediate Accounting: Reporting And Analysis, 2017 Update, 2nd
- 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_forwardDollar-Value LIFO Kwestel 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 Kwestels records: Required: Calculate the dollar-value LIFO inventory at the end of each year. Round to the nearest dollar.arrow_forwardRetail Inventory Method The following data were available from Hegge Department Stores records for the year ended December 31, 2019: Required: Using the retail method, what is the estimate of the merchandise inventory at December 31, 2019, valued at the lower of cost or market: Round the cost-to-retail ratio to 3 decimal places.arrow_forward
- Calculate the cost of goods sold dollar value for A65 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO).arrow_forwardCalculate the cost of goods sold dollar value for A67 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for weighted average (AVG).arrow_forwardAlternative Inventory Methods Park Companys perpetual inventory records indicate the following transactions in the month of June: Required: 1. Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: a. FIFO b. LIFO c. Average cost (Round unit costs to 3 decimal places and other amounts to the nearest dollar.) 2. Next Level Why are the cost of goods sold and ending inventory amounts different for each of the three methods? What do these amounts tell us about the purchase price of inventory during the year? 3. Next Level Which method produces the most realistic amount for net income? For inventory? Explain your answer. 4. Next Level If Park uses IFRS, which of the previous alternatives would be acceptable and why?arrow_forward
- Calculate the cost of goods sold dollar value for B74 Company for the sale on November 20, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average (AVG).arrow_forwardCalculate the cost of goods sold dollar value for A74 Company for the sale on March 11, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average (AVG).arrow_forwardJessie Stores uses the periodic system of calculating inventory. The following information is available for December of the current year when Jessie sold 500 units of inventory. Using the FIFO method, calculate Jessies inventory on December 31 and its cost of goods sold for December. RE7-11 Using the information from RE7-10, calculate Jessie Storess inventory on December 31 and its cost of goods sold for December using the LIFO method.arrow_forward
- Hurst 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_forwardData on the physical inventory of Katus Products Co. as of December 31 follow: Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are summarized as follows: Instructions Determine the inventory at cost as well as at the lower of cost or market, using the first-in, first-out method. Record the appropriate unit costs on the inventory sheet and complete the pricing of the inventory. When there are two different unit costs applicable to an item: 1. Draw a line through the quantity and insert the quantity and unit cost of the last purchase. 2. On the following line, insert the quantity and unit cost of the next-to-the-last purchase. 3. Total the cost and market columns and insert the lower of the two totals in the LCM column. The first item on the inventory sheet has been completed as an example.arrow_forwardInventory Pools Stone Shoe Company adopted dollar-value LIFO on January 1, 2019. The company produces four products and uses a single inventory pool. The companys beginning inventory consists of the following: During 2019, the company has the following purchases and sales: Required: 1. Compute the dollar-value LIFO cost of the ending inventory. Round the cost index to 4 decimal places and all other amounts to the nearest dollar. 2. Next Level By how much would the companys gross profit differ if it had used four pools instead of a single pool?arrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,