Question

In: Accounting

Simmons Company has the following information about its ending inventory. It values its inventory on an...

Simmons Company has the following information about its ending inventory. It values its inventory on an individual-item basis. Determine the value of the ending inventory. Show your work.

Item

Quantity

Cost

Estimated Selling Price

Cost to Complete and Sell

A

700

$2.25

$3.25

$1.40

B

500

3.00

3.90

0.80

C

3,000

1.80

2.50

1.20

D

1,000

4.70

6.00

1.50

Solutions

Expert Solution

Solution:

Ending Inventories are valued at cost or realizable value whichever is lower.

Here, Cost is the cost at which inventories are purchased originally.

Net Realizable Value = Estimated Selling Price – Cost to complete and sell the product

Item

Quantity

Cost per unit

Net Realizable Value per unit (Selling Price - Cost to complete and sell)

Lower of Cost or Net Realizable Value

Value of Ending Inventory

(X)

(P)

(X*P)

A

700

$2.25

$1.85

$1.85

$1,295

B

500

$3.00

$3.10

$3.00

$1,500

C

3000

$1.80

$1.30

$1.30

$3,900

D

1000

$4.70

$4.50

$4.50

$4,500

$11,195

Value of Ending Inventory = $11,195

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you


Related Solutions

Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year 2018 operations is as follows: January 1, 2018, beginning inventory had a cost of $240,000 and a retail value of $290,000. Purchases during 2018 cost $2,076,000 with an original retail value of $3,360,000. Freight costs were $24,000 for incoming merchandise. Net additional markups were $250,000 and net markdowns were $610,000. Based on prior experience, shrinkage due to shoplifting was estimated to be $29,000 of...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year 2021 operations is as follows: January 1, 2021, beginning inventory had a cost of $100,000 and a retail value of $150,000. Purchases during 2021 cost $1,387,500 with an original retail value of $2,000,000. Freight costs were $10,000 for incoming merchandise. Net additional markups were $300,000 and net markdowns were $150,000. Based on prior experience, shrinkage due to shoplifting was estimated to be $15,000 of...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year 2018 operations is as follows: January 1, 2018, beginning inventory had a cost of $120,000 and a retail value of $170,000. Purchases during 2018 cost $1,332,000 with an original retail value of $2,170,000. Freight costs were $12,000 for incoming merchandise. Net additional markups were $100,000 and net markdowns were $170,000. Based on prior experience, shrinkage due to shoplifting was estimated to be $17,000 of...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year 2018 operations is as follows: January 1, 2018, beginning inventory had a cost of $162,000 and a retail value of $210,000. Purchases during 2018 cost $1,502,000 with an original retail value of $2,380,000. Freight costs were $16,000 for incoming merchandise. Net additional markups were $210,000 and net markdowns were $390,000. Based on prior experience, shrinkage due to shoplifting was estimated to be $21,000 of...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year 2018 operations is as follows: January 1, 2018, beginning inventory had a cost of $160,000 and a retail value of $220,000. Purchases during 2018 cost $1,663,000 with an original retail value of $2,440,000. Freight costs were $17,000 for incoming merchandise. Net additional markups were $215,000 and net markdowns were $255,000. Based on prior experience, shrinkage due to shoplifting was estimated to be $22,000 of...
A company has the following information related to its ending inventory: FIFO LIFO 12/31/2020 $ 230,000...
A company has the following information related to its ending inventory: FIFO LIFO 12/31/2020 $ 230,000 $ 200,000 12/31/2021 280,000 260,000 The company’s accountant informs the CEO that because the company reports using LIFO instead of FIFO, gross profit will be lower in 2021. Which of the following statements is correct? A. The accountant is incorrect because the LIFO reserve has increased in the current year. B. The accountant is correct. C. The accountant is incorrect because the choice of...
Tatum Company has four products in its inventory. Information about December 31, 2018, inventory is as...
Tatum Company has four products in its inventory. Information about December 31, 2018, inventory is as follows: Product Inventory Tatum Company Product Total Cost Total Net Realizable Value 101 120,000.00 100,00.00 102 90,000.00 110,000.00 103 60,000.00 50,000.00 104 30,000.00 50,000.00 Assignment: Determine the carrying value of inventory at December 31, 2018, assuming the lower of cost or net realizable value (LCNRV) rule is applied to individual products. Assuming that inventory write-downs are common for Tatum Company, record any necessary year-end...
Tatum Company has four products in its inventory. Information about the December 31, 2018, inventory is...
Tatum Company has four products in its inventory. Information about the December 31, 2018, inventory is as follows: Product Total Cost Total Net Realizable Value 101 $ 154,000 $ 117,000 102 111,000 127,000 103 77,000 67,000 104 47,000 67,000 Required: 1. Determine the carrying value of inventory at December 31, 2018, assuming the lower of cost or net realizable value (LCNRV) rule is applied to individual products. 2. Assuming that inventory write-downs are common for Tatum Company, record any necessary...
4.   Dutch Company has the following products in its ending inventory. Compute the lower of cost...
4.   Dutch Company has the following products in its ending inventory. Compute the lower of cost or market for inventory (a) as a whole and (b) applied separately to each product. Per Unit Product Quantity Cost Market Wooden Shoes 25 $ 65 $ 50 Cheese Rounds 20 40 45 Granny Bikes 40 85 80     5. On the date of the balance sheet, Armani Co. had $10,000 of inventory in transit to Saks Company via a public carrier. A) Should...
Noa Corporations uses the retail inventory method to estimate its ending inventory. The following information relates...
Noa Corporations uses the retail inventory method to estimate its ending inventory. The following information relates to Noa Corporation’s inventory at both cost and retail for the current year. Description Cost Retail Beginning Inventory $55,000 $78,500 Purchases 250,000 325,000 Purchase discount 10,000 Freight-In 5,000 Additional markups 24,000 Markup cancellations 7,000 Markdowns 12,000 Markdown cancellations 3,500 Sales 400,000 Instructions: Answer each of the following questions. What is the ending inventory at retail? If the ending inventory is to be valued at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT