Referring to the inventory data for Sedato Company in E9-3, assume that Sedato follows the practice of pricing its inventory at the lower-of-cost-or-market, on an individual-item basis. Item No. Quantity Cost per Unit Cost to Replace Estimated Selling Price Cost of Completion and Disposal Normal Profi t 1320 1,200 \(3.20 \)3.00 \(4.50 \)0.35 $1.25 1333 900 2.70 2.30 3.50 0.50 0.50 1426 800 4.50 3.70 5.00 0.40 1.00 1437 1,000 3.60 3.10 3.20 0.25 0.90 1510 700 2.25 2.00 3.25 0.80 0.60 1522 500 3.00 2.70 3.80 0.40 0.50 1573 3,000 1.80 1.60 2.50 0.75 0.50 1626 1,000 4.70 5.20 6.00 0.50 1.00 Instructions From the information above, determine the amount of Sedato Company inventory

Short Answer

Expert verified

The inventory value equals $24,110.

Step by step solution

01

Estimation of market value per unit

Market value per unit is shown as follows:

Item No.

Selling Price

Cost of completion and disposal

Normal profit

NRV

(Selling price-Cost of completion and disposal)

NRV less normal profit

(NRV -Normal profit)

Cost to replace

Designated Market value

1320

$4.50

$0.35

$1.25

$4.15

$2.90

$3.00

$3.00

1333

3.50

0.50

0.50

3.00

2.50

2.30

2.50

1426

5.00

0.40

1.00

4.60

3.60

3.70

3.70

1437

3.20

0.25

0.90

2.95

2.05

3.10

2.95

1510

3.25

0.80

0.60

2.45

1.85

2.00

2.00

1522

3.80

0.40

0.50

3.40

2.90

2.70

2.90

1573

2.50

0.75

0.50

1.75

1.25

1.60

1.60

1626

6.00

0.50

1.00

5.50

4.50

5.20

5.20

02

Calculation of Inventory

Inventory value is calculated as follows:

Item No.

Quantity

Cost per unit

Designated Market value

Lower of cost-or-market

Inventory

1320

1,200

$3.20

$3.00

$3.00

$3,600

1333

900

2.70

2.50

2.50

2,250

1426

800

4.50

3.70

3.70

2,960

1437

1,000

3.60

2.95

2.95

2,950

1510

700

2.25

2.00

2.00

1,400

1522

500

3.00

2.90

2.90

1,450

1573

3,000

1.80

1.60

1.60

4,800

1626

1,000

4.70

5.20

4.70

4,700

Total

$24,110

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.

You are called by Tim Duncan of Spurs Co. on July 16 and asked to prepare a claim for insurance as a result of a theft that took place the night before. You suggest that an inventory be taken immediately. The following data are available. Inventory, July 1 \( 38,000 Purchases—goods placed in stock July 1–15 85,000 Sales revenue—goods delivered to customers (gross) 116,000 Sales returns—goods returned to stock 4,000 Your client reports that the goods on hand on July 16 cost \)30,500, but you determine that this figure includes goods of $6,000 received on a consignment basis. Your past records show that sales are made at approximately 40% over cost. Duncan’s insurance covers only goods owned. Instructions Compute the claim against the insurance company.

The net realizable value of Lake Corporation’s inventory has declined below its cost. Allyn Conan, the controller, wants to use the loss method to write down inventory because it more clearly discloses the decline in the net realizable value and does not distort the cost of goods sold. His supervisor, financial vice president Bill Ortiz, prefers the costof-goods-sold method to write down inventory because it does not call attention to the decline in net realizable value. Instructions Answer the following questions. (a) What, if any, is the ethical issue involved? (b) Is any stakeholder harmed if Bill Ortiz’s preference is used? (c) What should Allyn Conan do?

The financial statements of M&S are presented in Appendix E. The company’s complete annual report, including the notes to the financial statements, is available online. Instructions Refer to M&S’s financial statements and the accompanying notes to answer the following questions. (a) How does M&S value its inventories? Which inventory costing method does M&S use as a basis for reporting its inventories? (b) How does M&S report its inventories in the statement of financial position? (c) What costs does M&S include in Inventory and Cost of Sales? (d) What was M&S’s inventory turnover in 2015? What is its gross profit percentage? Evaluate M&S’s inventory turnover and its gross profit percentage.

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

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