I managed to find the average inventory amount. I need help with the rest now. Please help.

Assuming that all net sales figures are at retail and all cost of goods sold figures are at cost, calculate the average inventory and inventory turnover for the following. If the actual turnover is less than the published rate, calculate the target average inventory necessary to come up to industry standards. Enter "above" (without the quotes) for the target inventory if it is more than the published rate. Round inventories to the nearest dollar and inventory turnover to the nearest tenth. Cost of Beginning Ending Average Inventory Published Target Average Net Sales Goods Sold Inventory Inventory Inventory Turnover Rate Inventory $317,000 $46,000 $60,000 $ 53,000 X 6.8 X