Question

In: Accounting

Ivanhoe Inc. uses the conventional retail method to determine its ending inventory at cost. Assume the...

Ivanhoe Inc. uses the conventional retail method to determine its ending inventory at cost. Assume the beginning inventory at cost (retail) were $383500 ($584000), purchases during the current year at cost (retail) were $3208000 ($4993600), freight-in on these purchases totaled $149500, sales during the current year totaled $4466000, and net markups were $404000. What is the ending inventory value at cost? Hint: Round intermediate calculation to 3 decimal places, e.g. 0.635 and final answer to 0 decimal places.

Please show work


$1040688.

$947250.

$1515600.

$788188.

Solutions

Expert Solution

Answer: The correct answer is $947,250

Goods Available for Sale at Retail = Beginning Inventory + Purchases + Net Markup
Goods Available for Sale at Retail = $584,000 + $4,993,600 + $404,000
Goods Available for Sale at Retail = $5,981,600

Ending Inventory at Retail = Beginning Inventory Retail + Purchases at Retail + Net Markups – Sales
Ending Inventory at Retail = $584,000 + $4,993,600 + $404,000 - $4,466,000
Ending Inventory at Retail = $1,515,600

Goods Available for Sale at cost = Beginning Inventory at cost + Purchases at cost + Freight
Goods Available for Sale at cost = $383,500 + $3,208,000 + $149,500
Goods Available for Sale at cost = $3,741,000

Conventional Cost Ratio = Goods Available for Sale at Cost / Goods Available for Sale at Retail
Conventional Cost Ratio = $3,741,000 / $5,981,600
Conventional Cost Ratio = 0.625

Ending Inventory at Cost = Ending Inventory at Retail * Conventional Cost Ratio
Ending Inventory at Cost = $1,515,600 * 0.625
Ending Inventory at Cost = $947,250


Related Solutions

Sheridan uses the conventional retail method to determine its ending inventory at cost. Assume the beginning...
Sheridan uses the conventional retail method to determine its ending inventory at cost. Assume the beginning inventory at cost (retail) were $395000 ($599000), purchases during the current year at cost (retail) were $2155000 ($3400000), freight-in on these purchases totaled $134000, sales during the current year totaled $3100000, and net markups (markdowns) were $77000 ($113000). What is the ending inventory value at cost? Hint: Round intermediate calculation to 3 decimal places, e.g. 0.635 and final answer to 0 decimal places.
Tangor Inc. uses the conventional retail inventory method to estimate ending inventory for its monthly financial statements.
  Tangor Inc. uses the conventional retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to a single department for the month of October 2018.                                                                                 At Cost             At Retail       Inventory, 10/1/18                                             52,000             78,000       Freight in                                                          16,600       Markdowns (net)                                                                        3,600                  Markups                                                                                    9,000       Markup cancellations                                                               2,000       Purchases                                                       272,000           423,000       Sales                                                                                      385,000       Purchase returns                                                 5,600             8,000       Normal spoilage and breakage                                               10,000       Employee...
The XYZ Company uses the conventional retail inventory method to estimate ending inventory for its monthly...
The XYZ Company uses the conventional retail inventory method to estimate ending inventory for its monthly financial statements and presents the following data for one department for February 2020. Present a schedule that shows the ending inventory at cost and highlight that cell with color and a thick outside border. Label each column and row clearly so your workpaper can be used by other people in Marquette's accounting department. Present the cost to retail percentage as a percentage with two...
7. Michael Jackson's Strings uses the conventional retail method to estimate ending inventory. Cost data for...
7. Michael Jackson's Strings uses the conventional retail method to estimate ending inventory. Cost data for the most recent quarter is shown below: Cost       Retail Beginning inventory        $46,000               $63,000 Net purchases    154,000               215,000 Net markups                      22,000 Net markdowns                35,000 Net sales                            220,000 To the nearest thousand, estimated ending inventory using the conventional retail method is   A. $30,000.    B. $32,000.    C. $34,000.    D. $37,000. 8.   Mario Brothers Company adopted the dollar-value LIFO inventory method on January 1, 2015....
Determine the ending inventory under the conventional retail method for the furniture department of Bonita Department...
Determine the ending inventory under the conventional retail method for the furniture department of Bonita Department Stores from the following data. (Round ratio of cost to selling price to 2 decimal places, e.g. 15.25% and final answer to 0 decimal places, e.g. 5,125.) Cost Retail Inventory, Jan. 1 $154,200 $291,700 Purchases 1,361,600 2,249,100 Freight-in 69,200 Markups, net 92,000 Markdowns, net 48,600 Sales revenue 2,251,400 Ending inventory $
1. Determine the ending inventory under the conventional retail method for the furniture department of Tamarisk...
1. Determine the ending inventory under the conventional retail method for the furniture department of Tamarisk Department Stores from the following data. Cost Retail Inventory, Jan. 1 $152,400 $287,600 Purchases 1,426,400 2,070,000 Freight-in 70,900 Markups, net 95,900 Markdowns, net 46,500 Sales revenue 2,093,100 Ending inventory --> _______
Retail inventory method; various cost methods Sparrow Company uses the retail inventory method to estimate ending...
Retail inventory method; various cost methods Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2016 are as follows: Cost Retail Beginning Inventory $90,000 $180,000 Purchases $355,000 $581,000 Freight-in $9,000 Purchase Returns $7,000 $11,000 Net Markups $16,000 Net Markdowns $12,000 Normal Spoilage $3,000 Abnormal Spoilage $4,800 $8,000 Sales $540,000 Sales Returns $10,000 The company records sales net of employee discounts. Discounts for 2016 totaled $4,000. Required: Estimate Sparrow’s ending inventory and...
Crane Inc. uses the retail inventory method to estimate ending inventory for its monthly financial statements....
Crane Inc. uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to a single department for the month of October 2021. Inventory, October 1, 2021     At cost $50,900     At retail 78,600 Purchases (exclusive of freight and returns)     At cost 270,540     At retail 426,400 Freight-in 16,900 Purchase returns     At cost 5,700     At retail 7,900 Markups 8,900 Markup cancellations 2,000 Markdowns (net) 3,500 Normal spoilage and breakage 10,000 Sales revenue 384,700 (a) Using...
Marigold Inc. uses the retail inventory method to estimate ending inventory for its monthly financial statements....
Marigold Inc. uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to a single department for the month of October 2018. Inventory, October 1, 2018     At cost $52,000     At retail 79,300 Purchases (exclusive of freight and returns)     At cost 264,822     At retail 418,300 Freight-in 16,500 Purchase returns     At cost 5,500     At retail 8,100 Markups 9,200 Markup cancellations 2,000 Markdowns (net) 3,600 Normal spoilage and breakage 10,000 Sales revenue 395,800 (a) Using...
Novak Inc. uses the retail inventory method to estimate ending inventory for its monthly financial statements....
Novak Inc. uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to a single department for the month of October 2021. Inventory, October 1, 2021     At cost $51,800     At retail 76,700 Purchases (exclusive of freight and returns)     At cost 241,978     At retail 424,300 Freight-in 16,500 Purchase returns     At cost 5,400     At retail 8,100 Markups 8,900 Markup cancellations 2,000 Markdowns (net) 3,500 Normal spoilage and breakage 9,900 Sales revenue 392,600 (a) Using...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT