Question

In: Accounting

Selected data on inventory, purchases, and sales for Jaffe Co. and Coronado Co. are as follows:...

Selected data on inventory, purchases, and sales for Jaffe Co. and Coronado Co. are as follows:

Cost Retail
Jaffe Co.
Inventory, February 1 $400,000 $615,000
Transactions during February:
Purchases (net) 4,055,000 5,325,000
Sales 5,100,000
Coronado Co.
Inventory, May 1 $400,000
Transactions during May through October:
Purchases (net) 3,150,000
Sales 4,750,000
Estimated gross profit rate 35%

Required:

1. Determine the estimated cost of the inventory of Jaffe Co. on February 28 by the retail method, presenting details of the computations.

Jaffe Co.
Estimated Cost of Inventory
February 28
Cost Retail
$ $
$ $
Ratio of cost to retail price: %
$
$

2a. Estimate the cost of the inventory of Coronado Co. on October 31 by the gross profit method, presenting details of the computations.

Coronado Co.
Estimated Cost of Inventory
October 31
Cost
$
$
$
$

2b. Assume that Coronado Co. took a physical inventory on October 31 and discovered that $366,500 of merchandise was on hand. What was the estimated loss of inventory due to theft or damage during May through October?
$

Check My Work

Solutions

Expert Solution

1 Estimated cost of the Inventory of Jaffe co on Feb 28 by the retail method
Cost ($) Retail ($)
Inventory - Feb 1 400000 615000
Add: Purchases 4055000 5325000
Cost of goods available for sale 4455000 5940000
Ratio of cost to retail price 0.75
(4455000/5940000)
Cost of goods available for sale 4455000 5940000
Less Sales 5100000
Inventory - Feb 28 (A) 840000
Ratio of cost to retail price (B) 0.75
Cost of ending Inventory (A) x (B) 630000
2a Estimated cost of the inventory of Coranado Co on October 31 by the Gross Profit Method
Cost ($)
Inventory - May 1 400000
Add Purchases 3150000
Cost of goods available 3550000
Less: Cost of goods sold 3087500
(4750000 x 65%)
Estimated cost of inventory October 31 462500
2b If the merchandise on hand on October 31 was $366500, then estimated loss of inventory is $ 96000
i.e.(462500-366500)

Related Solutions

Beginning inventory, purchases, and sales data for tennis rackets are as follows:
Beginning inventory, purchases, and sales data for tennis rackets are as follows:April 3 Inventory 20 units @ $15.0011 Purchase 18 units @ $14.0014 Sale 11 units21 Purchase 10 units @ $22.0025 Sale 12 unitsAssuming the business maintains a perpetual inventory system, calculate the cost of goods sold and ending inventory using FIFO.Select the correct answer.a)cost of goods sold $772.00 ending inventory $430.00b)cost of goods sold $430.00 ending inventory $342.00c)cost of goods sold $342.00 ending inventory $772.00d)cost of goods sold $342.00...
beginning inventory, purchases and sales data for the month of august are as follows beginning inventory...
beginning inventory, purchases and sales data for the month of august are as follows beginning inventory 10 units @ 25 august 5 sale 5 units august 10 purchase 18 units @ 27 august 12 sale 13 units August 27 purchase 10 units @ 30 assuming the business maintains a perpetual inventory system, calculate the cost of goods sold and Ending inventory using FIFO, LIFO , Weighted Average
Retail Method; Gross Profit Method Selected data on inventory, purchases, and sales for Celebrity Tan Co....
Retail Method; Gross Profit Method 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 $216,000 $328,000 Transactions during August Purchases (net) 2,490,000 3,772,000 Sales 3,880,000 Ranchworks Co. Inventory, March 1 $278,000 Transactions during March through November: Purchases (net) 3,698,000 Sales 6,057,000 Estimated gross profit rate 38% Required: 1. Determine the estimated cost of the inventory of Celebrity Tan Co. on August 31 by the...
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 84 $375 $31,500 8 Purchase 168 450 75,600 11 Sale 113 1,250 141,250 30 Sale 71 1,250 88,750 May 8 Purchase 140 500 70,000 10 Sale 84 1,250 105,000 19 Sale 42 1,250 52,500 28 Purchase 140 550 77,000 June 5 Sale 84 1,315 110,460...
The beginning inventory of merchandise at Rhodes Co. and data on purchases and sales for a...
The beginning inventory of merchandise at Rhodes 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 $375 $22,500 8 Purchase 120 450 54,000 11 Sale 80 1,250 100,000 30 Sale 50 1,250 62,500 May 8 Purchase 100 500 50,000 10 Sale 60 1,250 75,000 19 Sale 30 1,250 37,500 28 Purchase 100 550 55,000 June 5 Sale 60 1,315 78,900...
The beginning inventory of merchandise at Rhodes Co. and data on purchases and sales for a...
The beginning inventory of merchandise at Rhodes 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 90 $600 $54,000 8 Purchase 180 720 129,600 11 Sale 120 2,000 240,000 30 Sale 75 2,000 150,000 May 8 Purchase 150 800 120,000 10 Sale 90 2,000 180,000 19 Sale 45 2,000 90,000 28 Purchase 150 880 132,000 June 5 Sale 90 2,100 189,000...
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 25 $1,200 $30,000 8 Purchase 75 1,240 93,000 11 Sale 40 2,000 80,000 30 Sale 30 2,000 60,000 May 8 Purchase 60 1,260 75,600 10 Sale 50 2,000 100,000 19 Sale 20 2,000 40,000 28 Purchase 80 1,260 100,800 June 5 Sale 40 2,250 90,000...
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, 2016, are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 25 $1,200 $30,000 8 Purchase 75 1,240 93,000 11 Sale 40 2,000 80,000 30 Sale 30 2,000 60,000 May 8 Purchase 60 1,260 75,600 10 Sale 50 2,000 100,000 19 Sale 20 2,000 40,000 28 Purchase 80 1,260 100,800 June 5 Sale 40 2,250...
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 72 $225 $16,200 8 Purchase 144 270 38,880 11 Sale 96 750 72,000 30 Sale 60 750 45,000 May 8 Purchase 120 300 36,000 10 Sale 72 750 54,000 19 Sale 36 750 27,000 28 Purchase 120 330 39,600 June 5 Sale 72 790 56,880...
LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...
LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 78 $300 $23,400 8 Purchase 156 360 56,160 11 Sale 105 1,000 105,000 30 Sale 66 1,000 66,000 May 8 Purchase 130 400 52,000 10 Sale 78 1,000 78,000 19 Sale 39 1,000 39,000 28 Purchase 130 440 57,200 June 5 Sale 78 1,050 81,900 16 Sale...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT