Suppose a gift shop in Myrtle Beach has an annual demand for 15,000 units for a souvenir kitchen magnet that it buys for $0.50 per unit. Assume it costs $10 to place an order and the inventory carrying cost is 25% of the items unit cost. Use Solver to determine the optimal order quantity if the company wants to minimize the total cost of procuring this item. a. What is the optimal order quantity? b. What is the total cost associated with this order quantity? c. What are the annual order and annual inventory holding costs for this solution? Using NLP not EOQ formulas. Please use excel to answer the questions and include screenshots.