Question

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 all ratios as percents, rounded to one decimal place. 2. a. Estimate the cost of the inventory of Ranchworks Co. on November 30 by the gross profit method.* b. 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 March through November? * Refer to the list of Amount Descriptions provided for the exact wording of the answer choices for text entries.

Homework Answers

Answer #1
Cost Retail
Beginning inventory 300000 575000
Purchases 2021900 3170000
Cost of Goods available for sale 2321900 3745000
Cost to Retail ratio=2321900/3745000 0.62
Cost of Goods available for sale 2321900 3745000
Less sales 3250000
Ending Inventory 495000
Cost to Retail ratio 0.62
Ending Inventory 306900
Ans 2(a)
Opening balance of mercandise Inventory 880000
Add: Purchases 9500000
Add
Gross Profit 38%*15800000 6004000
Total 16384000
Less: sales 15800000
Ending Inventory 584000
Estmated Loss
365750-584000 - 218250
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
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 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 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...
question 10 ABC Co. uses a periodic approach to accounting for inventory. On December 31, 20X7,...
question 10 ABC Co. uses a periodic approach to accounting for inventory. On December 31, 20X7, an inventory count was performed resulting in a determination that the year-end inventory balance was $700,000. December 31, 20X7 year-end account balances before considering the inventory count were as follows: Sales…………………………………………….$5,800,000 Inventory………………………………………….$620,000 Purchases…………………………………..……$3,400,000 What is the gross profit for the year ended December 31, 20X7? a. $3,320,000 b. $2,480,000 c. $2,420,000 d. $2,320,000 question 11 ABC Co. uses a periodic approach to accounting for...
FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...
FIFO Perpetual Inventory The beginning inventory 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 72 $300 $21,600 8 Purchase 144 360 51,840 11 Sale 96 1,000 96,000 30 Sale 60 1,000 60,000 May 8 Purchase 120 400 48,000 10 Sale 72 1,000 72,000 19 Sale 36 1,000 36,000 28 Purchase 120 440 52,800 June 5 Sale 72 1,050...
Tudor Co. uses the retail inventory method to estimate its inventory for interim statement purposes. Data...
Tudor Co. uses the retail inventory method to estimate its inventory for interim statement purposes. Data relating to the computation of the inventory at July 31, 2020, are as follows: Cost Retail Inventory, 2/1/20 $ 1,200,000 $ 1,580,000 Purchases 5,800,000 7,650,000 Markups, net 770,000 Sales 8,150,000 Estimated normal shoplifting losses 90,000 Markdowns, net 300,000 Under the lower-of-cost-or-market method, Tudor's estimated inventory at July 31, 2020 is $____________.
On December 31, 2018 Mystic Morning Co. inventory burned. Sales and purchases for the year had...
On December 31, 2018 Mystic Morning Co. inventory burned. Sales and purchases for the year had been $1,500,000 and $980,000, respectively. The beginning inventory (Jan. 1, 2018) was $170,000; in the past Mystic’s gross profit has averaged 30% of selling price. Instructions (18pts) Compute the estimated cost of inventory burned, and give entries as of December 31, 2018 to close merchandise accounts.
The beginning inventory for Midnight Supplies and data on purchases and sales for a three month...
The beginning inventory for Midnight Supplies and data on purchases and sales for a three month period are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $ 75.00 $ 562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar. 5 Purchase 45,000 89.50 4,027,500 14 Sale...
Stanojev Co. uses a periodic inventory system and the retail inventory method to estimate ending inventory...
Stanojev Co. uses a periodic inventory system and the retail inventory method to estimate ending inventory and COGS. The following data are available for the month of April 2020: Cost                 Retail             Beginning inventory      $35,000            $89,000             Net purchases                 21,000 51,000             Net sales 52,000 What is the estimated cost of ending inventory for April?
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...