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

Presented below is information related to Aaron Rodgers Corporation for the current year. Beginning inventory \( 600,000 Purchases 1,500,000 Total goods available for sale \)2,100,000 Sales revenue 2,500,000 Instructions Compute the ending inventory, assuming that (a) gross profit is 45% of sales, (b) gross profit is 60% of cost, (c) gross profit is 35% of sales, and (d) gross profit is 25% of cost.

Garcia Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and condominium complexes. The company is in the process of preparing its annual financial statements for the fiscal year ended May 31, 2017. Jim Alcide, controller for Garcia, has gathered the following data concerning inventory. At May 31, 2017, the balance in Garcia’s Raw Materials Inventory account was \(408,000, and Allowance to Reduce Inventory to NRV had a credit balance of \)27,500. Alcide summarized the relevant inventory cost and market data at May 31, 2017, in the schedule below. Alcide assigned Patricia Devereaux, an intern from a local college, the task of calculating the amount that should appear on Garcia’s May 31, 2017, financial statements for inventory under the LCNRV rule as applied to each item in inventory. Devereaux expressed concern over departing from the historical cost principle. Net Realizable Cost Sales Price Value Aluminum siding \( 70,000 \) 64,000 \( 56,000 Cedar shake siding 86,000 94,000 84,800 Louvered glass doors 112,000 186,400 168,300 Thermal windows 140,000 154,800 140,000 Total \)408,000 \(499,200 \)449,100 Instructions (a) Determine the proper balance in Allowance to Reduce Inventory to NRV at May 31, 2017. (b) For the fiscal year ended May 31, 2017, determine the amount of the gain or loss that would be recorded (using the loss method) due to the change in Allowance to Reduce Inventory to NRV. (c) Explain the rationale for the use of the LCNRV rule as it applies to inventories

Keller Company began operations on January 1, 2016, adopting the conventional retail inventory system. None of the company’s merchandise was marked down in 2016 and, because there was no beginning inventory, its ending inventory for 2016 of \(38,100 would have been the same under either the conventional retail system or the LIFO retail system. On December 31, 2017, the store management considers adopting the LIFO retail system and desires to know how the December 31, 2017, inventory would appear under both systems. All pertinent data regarding purchases, sales, markups, and markdowns are shown below. There has been no change in the price level. Cost Retail Inventory, Jan. 1, 2017 \) 38,100 $ 60,000 Markdowns (net) 13,000 Markups (net) 22,000 Purchases (net) 130,900 178,000 Sales (net) 167,000 Instructions Determine the cost of the 2017 ending inventory under both (a) the conventional retail method and (b) the LIFO retail method

Of what significance is inventory turnover to a retail store?

Question:Where there is evidence that the utility of inventory goods, as part of their disposal in the ordinary course of business, will be less than cost, what is the proper accounting treatment?

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