Answer questions within the text of the case
A. Determine the cost of average inventory, annual sales, gross margin ratioand markup percentage for each inventory item.
B. Calculate average, minimum, and maximum for cost of average inventory annual sales, gross margin ratio, and markup percentage.
C. Find maximum unit cost and sales prices, as well as minimum unit cost and sales prices.
D. Calculate total cost of average inventory, total annual gross profit, total cost of good sold, and the total annual sales.
After you finish every question by using Excel, please answer 2 more questions in this case.
Question 1: Which items have an inventory turnover greater than 12?
Question 2: Which items have days in inventory greater than 150 days?
I will upload the Excel which is need to be work.