Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Chapter 9: Question E9-29 (page 482)

(Dollar-Value LIFO Retail) You assemble the following information for Seneca Department Store, which computes its inventory under the dollar-value LIFO method. Cost Retail Inventory on January 1, 2017 \(216,000 \)300,000 Purchases 364,800 480,000 Increase in price level for year 9% Instructions Compute the cost of the inventory on December 31, 2017, assuming that the inventory at retail is (a) \(294,300 and (b) \)365,150.

Short Answer

Expert verified

The ending inventory for year 2016-2019 equals $61,250.40, $69,908.40, $59,437.80 and $74,662.80, respectively.

Step by step solution

01

Calculation of cost to retail ratio of beginning inventory

The cost-to-retail ratio of beginning inventory is calculated as follows:

CosttoRetailRatioofBeginningInventory=BeginningInventoryatCostBeginningInventoryatRetail=$54,000$100,000=54%

02

Calculation of ending inventory at base year retail prices

The cost of ending inventory at base year retail price for 2016 is calculated as follows:

EndingInventoryatBaseYearRetailPrice=EndingInventoryatRetailPriceIndex=$118,720106%=$112,000

03

Calculation of ending inventory under dollar-value-LIFO retail method in 2016

Ending inventory is calculated as follows:

Ending Inventory at Base Year Retail Prices
Layers at Base Year Retail Prices

Price Index (Percentage)

Cost-to-Retail (Percentage)

Ending Inventory at LIFO Cost

$112,000

2015

$100,000

x

100%

x

54%

=

$54,000

2016

12,000

x

106%

x

57%

=

7,250.40

$61,250.40

04

Calculation of ending inventory at base year retail prices for the year 2017

The cost of ending inventory at base year retail price for 2017 is calculated as follows:

EndingInventoryatBaseYearRetailPrice=EndingInventoryatRetailPriceIndex=$138,750111%=$125,000

05

Calculation of ending inventory under dollar-value-LIFO retail method in 2017

Ending inventory is calculated as follows:

Ending Inventory at Base Year Retail Prices

Layers at Base Year Retail Prices

Price Index (Percentage)

Cost-to-Retail (Percentage)

Ending Inventory at LIFO Cost

$125,000

2015

$100,000

x

100%

x

54%

=

$54,000

2016

12,000

x

106%

x

57%

=

7,250.40

2017

13,000

x

111%

x

60%

=

8,658

$69,908.40

06

Calculation of ending inventory at base year retail prices for the year 2018

The cost of ending inventory at base year retail price for 2018 is calculated as follows:

EndingInventoryatBaseYearRetailPrice=EndingInventoryatRetailPriceIndex=$125,350115%=$109,000

07

Calculation of ending inventory under dollar-value-LIFO retail method in 2018

Ending inventory is calculated as follows:

Ending Inventory at Base Year Retail Prices

Layers at Base Year Retail Prices

Price Index (Percentage)

Cost-to-Retail (Percentage)

Ending Inventory at LIFO Cost

$125,000

2015

$100,000

x

100%

x

54%

=

$54,000

2016

9,000

x

106%

x

57%

=

5,437.80

$59,437.80

08

Calculation of ending inventory at base year retail prices for the year 2019

The cost of ending inventory at base year retail price for 2019 is calculated as follows:

EndingInventoryatBaseYearRetailPrice=EndingInventoryatRetailPriceIndex=$162,500125%$130,000

09

Calculation of ending inventory under dollar-value-LIFO retail method in 2019

Ending inventory is calculated as follows:

Ending Inventory at Base Year Retail Prices

Layers at Base Year Retail Prices

Price Index (Percentage)

Cost-to-Retail (Percentage)

Ending Inventory at LIFO Cost

$125,000

2015

$100,000

x

100%

x

54%

=

$54,000

2016

9,000

x

106%

x

57%

=

5,437.80

2017

21,000

x

125%

x

58%

=

15,225

$74,662.80

Thus, inventory for year 2016, 2017, 2018, and 2019 equals $61,250.40, $69,908.40, $59,437.80, and $74,662.80, respectively.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Maddox Specialty Company, a division of Lost World Inc., manufactures three models of gear shift components for bicycles that are sold to bicycle manufacturers, retailers, and catalog outlets. Since beginning operations in 1993, Maddox has used normal absorption costing and has assumed a first-in, first-out cost flow in its perpetual inventory system. The balances of the inventory accounts at the end of Maddox’s fiscal year, November 30, 2017, are shown below. The inventories are stated at cost before any year-end adjustments. Finished goods \(647,000 Work in process 112,500 Raw materials 264,000 Factory supplies 69,000 The following information relates to Maddox’s inventory and operations. 1. The finished goods inventory consists of the items analyzed below. Cost NRV Down tube shifter Standard model \) 67,500 \( 67,000 Click adjustment model 94,500 89,000 Deluxe model 108,000 110,000 Total down tube shifters 270,000 266,000 Bar end shifter Standard model 83,000 90,050 Click adjustment model 99,000 97,550 Total bar end shifters 182,000 187,600 Head tube shifter Standard model 78,000 77,650 Click adjustment model 117,000 119,300 Total head tube shifters 195,000 196,950 Total fi nished goods \)647,000 \(650,550 2. One-half of the head tube shifter finished goods inventory is held by catalog outlets on consignment. 3. Three-quarters of the bar end shifter finished goods inventory has been pledged as collateral for a bank loan. 4. One-half of the raw materials balance represents derailleurs acquired at a contracted price 20% above the current market price. The NRV of the rest of the raw materials is \)127,400. 5. The total NRV of the work in process inventory is \(108,700. 6. Included in the cost of factory supplies are obsolete items with an historical cost of \)4,200. The market value of the remaining factory supplies is $65,900. 7. Maddox applies the LCNRV method to each of the three types of shifters in finished goods inventory. For each of the other three inventory accounts, Maddox applies the LCNRV method to the total of each inventory account. 8. Consider all amounts presented above to be material in relation to Maddox’s financial statements taken as a whole. Instructions (a) Prepare the inventory section of Maddox’s balance sheet as of November 30, 2017, including any required note(s). (b) Without prejudice to your answer to (a), assume that the NRV of Maddox’s inventories is less than cost. Explain how this decline would be presented in Maddox’s income statement for the fiscal year ended November 30, 2017. (c) Assume that Maddox has a firm purchase commitment for the same type of derailleur included in the raw materials inventory as of November 30, 2017, and that the purchase commitment is at a contracted price 15% greater than the current market price. These derailleurs are to be delivered to Maddox after November 30, 2017. Discuss the impact, if any, that this purchase commitment would have on Maddox’s financial statements prepared for the fiscal year ended November 30, 2017.

Robots, Inc. Robots, Inc. reported the following information regarding 2016–2017 inventory. Robots, Inc. 2017 2016 Current assets Cash \( 153,010 \) 538,489 Accounts receivable, net of allowance for doubtful accounts of \(46,000 in 2017 and \)160,000 in 2016 1,627,980 2,596,291 Inventories (Note 2) 1,340,494 1,734,873 Other current assets 123,388 90,592 Assets of discontinued operations — 32,815 Total current assets 3,244,872 4,993,060 Notes to Consolidated Financial Statements Note 1 (in part): Nature of Business and Significant Accounting Policies Inventories—Inventories are stated at the lower-of-cost-or-market. Cost is determined by the last-in, first-out (LIFO) method. Note 2: Inventories consist of the following. 2017 2016 Raw materials \(1,264,646 \)2,321,178 Work in process 240,988 171,222 Finished goods and display units 129,406 711,252 Total inventories 1,635,040 3,203,652 Less: Amount classified as long-term 294,546 1,468,779 Current portion \(1,340,494 \)1,734,873 Inventories are stated at the lower of cost determined by the LIFO method or market for Robots, Inc. If the FIFO method had been used for the entire consolidated group, inventories after an adjustment to the lower-of-cost-ormarket would have been approximately \(2,000,000 and \)3,800,000 at October 31, 2017 and 2016, respectively. Inventory has been written down to estimated net realizable value, and results of operations for 2017, 2016, and 2015 include a corresponding charge of approximately \(868,000, \)960,000, and \(273,000, respectively, which represents the excess of LIFO cost over market. Inventory of \)294,546 and \(1,468,779 at October 31, 2017 and 2016, respectively, shown on the balance sheet as a noncurrent asset represents that portion of the inventory that is not expected to be sold currently. Reduction in inventory quantities during the years ended October 31, 2017, 2016, and 2015 resulted in liquidation of LIFO inventory quantities carried at a lower cost prevailing in prior years as compared with the cost of fiscal 2014 purchases. The effect of these reductions was to decrease the net loss by approximately \)24,000, \(157,000, and \)90,000 at October 31, 2017, 2016, and 2015, respectively. Instructions (a) Comment on why Robots, Inc., might disclose how its LIFO inventories would be valued under FIFO. (b) Why does the LIFO liquidation reduce operating costs? (c) Comment on whether Robots, Inc. would report more or less income if it had been on a FIFO basis for all its inventory

Dover Company began operations in 2017 and determined its ending inventory at cost and at LCNRV at December 31, 2017, and December 31, 2018. This information is presented below. Cost Net Realizable Value 12/31/17 \(346,000 \)322,000 12/31/18 410,000 390,000Prepare the journal entries required at December 31, 2017, and December 31, 2018, assuming that the inventory is recorded at LCNRV and a perpetual inventory system using the cost-of-goods-sold method is used. (b) Prepare journal entries required at December 31, 2017, and December 31, 2018, assuming that the inventory is recorded at cost and a perpetual system using the loss method is used. (c) Which of the two methods above provides the higher net income in each year?

Dover Company began operations in 2017 and determined its ending inventory at cost and at LCNRV at December 31, 2017, and December 31, 2018. This information is presented below. Cost Net Realizable Value 12/31/17 \(346,000 \)322,000 12/31/18 410,000 390,000 Instructions (a) Prepare the journal entries required at December 31, 2017, and December 31, 2018, assuming inventory is recorded at LCNRV and a perpetual inventory system using the cost-of-goods-sold method. (b) Prepare journal entries required at December 31, 2017, and December 31, 2018, assuming inventory is recorded at LCNRV and a perpetual system using the loss method. (c) Which of the two methods above provides the higher net income in each year?

The records of Ellen’s Boutique report the following data for the month of April. Sales revenue \(99,000 Purchases (at cost) \)48,000 Sales returns 2,000 Purchases (at sales price) 88,000 Markups 10,000 Purchase returns (at cost) 2,000 Markup cancellations 1,500 Purchase returns (at sales price) 3,000 Markdowns 9,300 Beginning inventory (at cost) 30,000 Markdown cancellations 2,800 Beginning inventory (at sales price) 46,500 Freight on purchases 2,400 Instructions Compute the ending inventory by the conventional retail inventory method

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free