Assuming that all net sales figures are at retail and all cost of goods sold figures are at cost calculate the average inventory in $ and inventory turnover for the following. If the actual turnover is less than the published rate, calculate the target average inventory in $ necessary to come up to industry standards. If the actual turnover is greater than the published rate, enter "above" for target average inventory. Round inventories to the nearest dollar and inventory turnovers to the nearest tenth.
tableNet Sales,tableCost ofGoods SoldtableBeginningInventorytableEndingInventorytableAverageInventorytableInventoryTurnovertablePublishedRatetableTargetAverageInventory$$$$$