Ending inventory = cost of goods available for sale less the cost of goods sold. There's no way around it, you have to find the cost of goods sold!