In: Accounting
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
| 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) | |||||||