Question

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

Retail Method; Gross Profit Method

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



wrfm12h_ch06_pr6_7a.gif

1. Determine the estimated cost of the merchandise inventory of Celebrity Tan Co. on August 31 by the retail method.

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

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

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

Retail Mathod

1

Beginning inventory

$300,000

(At cost)

Add:Purchases

$2,149,000

(At cost)

Goods available for sale

$2,449,000

Sales

$3,250,000

Less: Sales Return

$80,000

Net Sale

$1,965,400

($3170000*.38)

Ending inventory

$483,600

2a

Gross Profit Mathod

Cost of Beginning Inventory

$880,000

Add : Net Purchase at cost

$9,500,000

Cost of goods available for sale

$10,380,000

Sales

$15,900,000

Less: Sales Return

$100,000

Net Sale

$15,800,000

Less: Estimated Gross Profit 38%

$6,004,000

Estimated Cost of Goods Sold

$9,796,000

Estimated Cost of Ending Inventory

$584,000

2b

Closing Invetory of Ranchworks company

$584,000

Less: Physical inventory available

$369,750

Inventory due to theft or damaged

$214,250

Note :

1- Assuming Gross Profit Rate is same in both companies

2-Assuming Opening Inventory and purchase of inventory at cost price

Add a comment
Know the answer?
Add Answer to:
Retail Method; Gross Profit Method Selected data on merchandise inventory, purchases, and sales for Celebrity Tan...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Selected data on merchandise inventory, purchases, and sales for Celebrity Tan and Ranchworks Co. are as...

    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 $223,000 $328,000 Transactions during August: Purchases (net) 2,565,000 3,772,000 Sales 3,880,000 Ranchworks Co. Merchandise inventory, March 1 $234,000 Transactions during March through November: Purchases (net) 3,104,000 Sales 4,705,000 Estimated gross profit rate 33% Required: 1. Determine the estimated cost of the merchandise inventory of Celebrity Tan on August 28 by the retail method, presenting details...

  • 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 $ 260,000 $ 595,000 Transa...

    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 $ 260,000 $ 595,000 Transactions during August: Purchases (net) 2,263,400 3,475,000 Sales 3,275,000 Ranchworks Co. Inventory, March 1 $870,000 Transactions during March through November: Purchases (net) 9,260,000 Sales 15,050,000 Estimated gross profit rate 40% Required: 1. Determine the estimated cost of the inventory of Celebrity Tan Co. on August 31 by the retail method.* Enter...

  • 2a. Estimate the cast of the inventory of Ranchworks Co. an Navember 30 by the gross...

    2a. Estimate the cast of the inventory of Ranchworks Co. an Navember 30 by the gross profit method, presenting details of the computations. Far those boxes sign which yau must enter subtracted or negative numbers use a minus Ranchworks Co. Estimated Cost Inventory November 30 Csl 2b. Assume that Ranchworks Co. took a physical inventory on November 30 and discovered that $369,750 of inventory was on hand. What was the estimated loss of inventory due to theft or damage during...

  • 2a. Estimate the cost of the inventory of Ranchworks Co. on November 30 by the gross...

    2a. Estimate the cost of the inventory of Ranchworks Co. on November 30 by the gross profit method, presenting details of the computations. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Ranchworks Co. Estimated Cost of Inventory November 30 Cost Inventory, March 1 880,000 Net purchases 9,500,000 Merchandise available for sale 10,380,000 Sales 15,800,000 Estimated gross profit 6,004,000 Estimated cost of goods sold 9,796,000 x Estimated inventory, November 30 584,000 Retail method;...

  • Gross Profit Method Royal Gorge Company uses the gross profit method to estimate ending inventory and...

    Gross Profit Method 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 $58500. The following information for the month of November was available from company records: Purchases of $110,000 Freight-in of $3,000 Sales of $180,000 Sales Returns of $5,000 Purchase Returns of $4,000 In addition, the controller is aware of $8,000 of inventory that...

  • 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,400. The following information for the month of November was available from company records: Purchases $ 119,000 Freight-in 3,900 Sales 225,000 Sales returns 9,500 Purchases returns 8,500 In addition, the controller is aware of $12,500 of inventory that was stolen during November from one of...

  • Gross Profit Method Based on the following data, estimate the cost of the ending inventory: Sales...

    Gross Profit Method Based on the following data, estimate the cost of the ending inventory: Sales $4,200,000 Estimated gross profit rate 42% Beginning inventory Purchases (net) $2,420,000 245,000 Merchandise available for sale $2,665,000 Estimated Cost of Ending Inventory dropdown

  • On the basis of the following data, estimate the cost of the merchandise inventory at June...

    On the basis of the following data, estimate the cost of the merchandise inventory at June 30 by the retail method: Cost Retail June 1 Merchandise Inventory $ 170,000 $ 266,000 June 1-30 Purchases (net) 2,357,740 3,811,000 June 1-30 Sales 3,540,000 Estimated cost of merchandise sold Less estimated gross profit Merchandise available for sale Merchandise inventory, June 1 Merchandise inventory, June 30, at estimated cost Merchandise inventory, June 30, at retail Purchases in June (net) Ratio of cost to retail...

  • Gross Profit Method Based on the following data, estimate the cost of the ending inventory: Sales...

    Gross Profit Method Based on the following data, estimate the cost of the ending inventory: Sales $9,250,000 Estimated gross profit rate 36% Beginning inventory $180,000 Purchases (net) 5,945,000 Merchandise available for sale $6,125,000

  • E. Gross Profit Method An inventory taken by Peace Hall Company the morning of November 01...

    E. Gross Profit Method An inventory taken by Peace Hall Company the morning of November 01 after a large theft discloses $10,000 of goods on hand. The to goods on hand. The following additional data is available from the books: Inventory on hand, October 01 Purchases received from October 01 to 31 Sales (delivered to customers) October 01 to 31 $ 30,000 90,000 100,000 Past records indicate that the gross profit is 25% of sales. Estimate the inventory of goods...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT