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

GROUPWORK (Retail, LIFO Retail, and Inventory Shortage) Late in 2014, Joan Seceda and four other investors took the chain of Becker Department Stores private, and the company has just completed its third year of operations under the ownership of the investment group. Andrea Selig, controller of Becker Department Stores, is in the process of preparing the year-end financial statements. Based on the preliminary financial statements, Seceda has expressed concern over inventory shortages, and she has asked Selig to determine whether an abnormal amount of theft and breakage has occurred. The accounting records of Becker Department Stores contain the following amounts on November 30, 2017, the end of the fiscal year. Cost Retail Beginning inventory \( 68,000 \)100,000 Purchases 255,000 400,000 Net markups 50,000 Net markdowns 110,000 Sales revenue 320,000 According to the November 30, 2017, physical inventory, the actual inventory at retail is $115,000. Instructions (a) Describe the circumstances under which the retail inventory method would be applied and the advantages of using the retail inventory method. (b) Assuming that prices have been stable, calculate the value, at cost, of Becker Department Stores’ ending inventory using the last-in, first-out (LIFO) retail method. Be sure to furnish supporting calculations. Problems 487 488 Chapter 9 Inventories: Additional Valuation Issues (c) Estimate the amount of shortage, at retail, that has occurred at Becker Department Stores during the year ended November 30, 2017. (d) Complications in the retail method can be caused by such items as (1) freight-in costs, (2) purchase returns and allowances, (3) sales returns and allowances, and (4) employee discounts. Explain how each of these four special items is handled in the retail inventory method.

Question:At December 31, 2017, Ashley Co. has outstanding purchase commitments for 150,000 gallons, at \(6.20 per gallon, of a raw material to be used in its manufacturing process. The company prices its raw material inventory at cost or market, whichever is lower. Assuming that the market price as of December 31, 2017, is \)5.90, how would you treat this situation in the accounts?

Presented below is information related to Knight Enterprises. Jan. 31 Feb. 28 Mar. 31 Apr. 30 Inventory at cost \(15,000 \)15,100 \(17,000 \)14,000 Inventory at LCNRV 14,500 12,600 15,600 13,300 Purchases for the month 17,000 24,000 26,500 Sales for the month 29,000 35,000 40,000 Instructions (a) From the information, prepare (as far as the data permit) monthly income statements in columnar form for February, March, and April. The inventory is to be shown in the statement at cost; the gain or loss due to market fluctuations is to be shown separately (using a valuation account). (b) Prepare the journal entry required to establish the valuation account at January 31 and entries to adjust it monthly thereafter. E9-6 (L01) (LCNR

Deere and Company reported inventory in its balance sheet as follows. Inventories $1,999,100,000 What additional disclosures might be necessary to present the inventory fairly?

Malone Company determined its ending inventory at cost and at LCNRV at December 31, 2017, December 31, 2018, and December 31, 2019, as shown below. Cost NRV 12/31/17 \(650,000 \)650,000 12/31/18 780,000 712,000 12/31/19 905,000 830,000 Instructions (a) Prepare the journal entries required at December 31, 2018, and at December 31, 2019, assuming that a perpetual inventory system and the cost-of-goods-sold method of adjusting to LCNRV is used. (b) Prepare the journal entries required at December 31, 2018, and at December 31, 2019, assuming that a perpetual inventory is recorded at cost and reduced to LCNRV using the loss 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