Hi Ms. Taba Al-Mehdar,
I hope you are doing well and here is my explanation,
First we need to understand the question what they are asking the company's cost of goods available for sale? Not Cost of goods sold
Cost of Goods sold formula COGS =( beginning inventory + Purchases - ending inventory) there are two methods for calculating cost of goods available for sale? we are using Gross profit method.
Goods available for sale = Beginning inventory + Purchases
But we don't have both beginning inventory and purchase to get Cost of goods available for sales but they given Ending inventory $ 200,000.
we need to understand the logic behind this ending inventory before they are calculating ending inventory they already deducted Beginning inventory and purchases to get ending inventory that's why they are not given in question.
1st Example:
Goods available for sale = Beginning inventory + Purchases
Goods available for sale = 18,000 + 65,000
Goods available for sale = 83,000
But without Beginning inventory and purchases we can't get the value of cost of goods available to sale. ?
Calculate the Ending Inventory at Cost
Finally, the ending inventory at cost can be estimated using the following formula:
Ending inventory = Cost of goods available for sale - Cost of goods sold
In our example, the ending inventory at cost is calculated as follows:
Ending inventory = Cost of goods available for sale - Cost of goods sold
Ending inventory = 83,000 - 60,000
Ending inventory = 23,000
As same example above we need to add 23,000 + 60,000 = 83,000 to get the value of cost of goods available to sale u just look the above 1st example.
As same All this thing we need to take here:
Cost of goods sold = Revenue x (1 - Gross profit %)
Cost of goods sold = 900,000 x (1 - 40%)
Cost of goods sold = 540,000
Ending inventory = Cost of goods available for sale - Cost of goods sold
In our example, the ending inventory at cost is calculated as follows:
Ending inventory = Cost of goods available for sale - Cost of goods sold
Ending inventory = 740,000 - 540,000
Ending inventory = 200,000