Question

Retail Method; Gross Profit Method Selected data on merchandise inventory, purchases, and sales for Celebrity Tan...

  1. Retail Method; Gross Profit Method

    Selected data on merchandise inventory, purchases, and sales for Celebrity Tan and Ranchworks Co. are as follows:

    Cost Retail
    Celebrity Tan
    Merchandise inventory, August 1 $404,000 $512,000
    Transactions during August:
    Purchases (net) 4,652,000 5,888,000
    Sales 6,057,000
    Ranchworks Co.
    Merchandise inventory, March 1 $267,000
    Transactions during March through November:
    Purchases (net) 3,544,000
    Sales 5,454,000
    Estimated gross profit rate 34%

    Required:

    1. Determine the estimated cost of the merchandise inventory of Celebrity Tan on August 28 by the retail method, presenting details of the computations.

    Celebrity Tan
    Cost of the Merchandise Inventory
    August 31
    Cost Retail
    $ $
    $ $
    Ratio of cost to retail price: %
    $
    $

    2a. Estimate the cost of the merchandise inventory of Ranchworks Co. on November 30 by the gross profit method, presenting details of the computations.

    Ranchworks Co.
    Cost of the Merchandise Inventory
    November 30
    Cost
    $
    $
    $
    $

    2b. Assume that Ranchworks Co. took a physical inventory on November 30 and discovered that $198,700 of merchandise was on hand. What was the estimated loss of inventory due to theft or damage during March thru November?
    $

Homework Answers

Answer #1
  • Requirement 1

Celebrity Tan

Cost of the Merchandise Inventory

Aug-31

Cost

Retail

Merchandise Inventory Aug 1

$404,000

$512,000

Purchases (net)

$4,652,000

$5,888,000

Ratio of cost to retail price:

79%

$5,056,000

$6,400,000

Less: Sales

$6,057,000

Ending Inventory at Retail

$343,000

Ending Inventory at Cost

[$343000 x 79%]

$270,970

  • Requirement 2A

Ranchworks Co.

Cost of the Merchandise Inventory

Nov-30

Cost

Merchandise Inventory Mar 1

$267,000

Purchases (net)

$3,544,000

Cost of Goods available for sale

$3,811,000

Sales

$5,454,000

Less: Gross Profits at 34%

$1,854,360

Cost of Goods Sold

$3,599,640

Merchandise Inventory Nov 30

$211,360

  • Requirement 2B

Estimated loss of inventory = $ 211360 – 198700
= $ 12,660

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Selected data on inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as...
Selected data on inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as follows: Cost Retail Celebrity Tan Co. Inventory, August 1 $ 300,000 $ 575,000 Transactions during August: Purchases (net) 2,021,900 3,170,000 Sales 3,250,000 Ranchworks Co. Inventory, March 1 $880,000 Transactions during March through November: Purchases (net) 9,500,000 Sales 15,800,000 Estimated gross profit rate 38% Required: 1. Determine the estimated cost of the inventory of Celebrity Tan Co. on August 31 by the retail method.* Enter...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 60 $300 $18,000 8 Purchase 120 360 43,200 11 Sale 80 1,000 80,000 30 Sale 50 1,000 50,000 May 8 Purchase 100 400 40,000 10 Sale 60 1,000 60,000 19 Sale 30 1,000 30,000 28 Purchase 100 440 44,000 June 5 Sale 60 1,050 63,000...
Exercise 2 (Darnell): Darnell Company uses the gross profit method to estimate ending inventory and cost...
Exercise 2 (Darnell): Darnell Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly financial statements required by its bank. Inventory on hand at the end of July was $127,000. They estimate a gross profit percentage of 30%. The following information for the month of August was available from company records: Purchases $228,000 Freight-in 6,100 Sales 359,000 Sales returns 9,900 Purchases returns 5,200 In addition, the controller is aware of $10,000 of...
Henderson Company uses the gross profit method to estimate ending inventory and cost of goods sold...
Henderson Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly financial statements required by its bank. Inventory on hand at the end of July was $122,000. The following information for the month of August was available from company records: Purchases $ 218,000 Freight-in 5,100 Sales 349,000 Sales returns 8,900 Purchases returns 4,200 In addition, the controller is aware of $12,000 of inventory that was stolen during August from one of the...
Henderson Company uses the gross profit method to estimate ending inventory and cost of goods sold...
Henderson Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly financial statements required by its bank. Inventory on hand at the end of July was $123,500. The following information for the month of August was available from company records: Purchases $ 221,000 Freight-in 5,400 Sales 352,000 Sales returns 9,200 Purchases returns 4,500 In addition, the controller is aware of $12,000 of inventory that was stolen during August from one of the...
Royal Gorge Company uses the gross profit method to estimate ending inventory and cost of goods...
Royal Gorge Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly financial statements required by its bank. Inventory on hand at the end of October was $59,500. The following information for the month of November was available from company records: Purchases $ 120,000 Freight-in 4,000 Sales 230,000 Sales returns 10,000 Purchases returns 9,000 In addition, the controller is aware of $13,000 of inventory that was stolen during November from one of...
Royal Gorge Company uses the gross profit method to estimate ending inventory and cost of goods...
Royal Gorge Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly financial statements required by its bank. Inventory on hand at the end of October was $59,900. The following information for the month of November was available from company records: Purchases $ 124,000 Freight-in 4,400 Sales 250,000 Sales returns 19,000 Purchases returns 5,500 In addition, the controller is aware of $6,500 of inventory that was stolen during November from one of...
P9-4B (Gross Profit Method) Higgs Company lost most of its inventory in a fire in November...
P9-4B (Gross Profit Method) Higgs Company lost most of its inventory in a fire in November just before the year-end physical inventory was taken. Corporate records disclose the following. Inventory (beginning) $186,000 Sales $863,000 Purchases 667,000 Sales returns 64,000 Purchase returns 46,000 Gross profit % based on net selling price 25% Merchandise with a selling price of $65,000 remained undamaged after the fire, and damaged merchandise has a salvage value of $26,400. The company does not carry fire insurance on...
Using the Gross profit method, compute estimated inventory loss based on the following information: Sales: 660,000...
Using the Gross profit method, compute estimated inventory loss based on the following information: Sales: 660,000 Purchases: 425,000 Freight in: 25,000 Beginning Inventory: 130,000 Gross Margin%: 30%
Given the following, calculate the estimated cost of ending inventory using the gross profit method: Gross...
Given the following, calculate the estimated cost of ending inventory using the gross profit method: Gross profit on sales 30% Beginning inventory, January 1, 2017 $30,000.00 Net purchases $8,000.00 Net sales at retail for January $16,000.00 Complete this partial comparative balance sheet by vertical analysis. Round percents to the nearest hundredth. Column1 Column2 Column3 Column4 Column5 2016 2017 Assets amount percent amount percent Current assets: a. Cash $38,000 $35,000 b. Accounts receivable $19,000 $18,000 c.merchandise inventory $16,000 $11,000 d. prepaid...