Please use Excel and provide graphs a like will be given for answers thank you so much.

6. [20pts] The bookstore at State University purchases from a vendor sweatshirts emblazoned with school name and logo. The vendor sells the sweatshirts to the store for $38 apiece. The cost to the bookstore for placing an order is $120, and the carrying cost is 25% of the average annual inventory value. The bookstore manager estimates that 2,000 sweatshirts will be sold during the year. The vendor has offered the bookstore the following volume discount schedule: Order size Discount (%) 1299 0 300 -499 2 500 799 4 800 ~ 5 (a) Complete the table that shows the prices and carrying costs of the sweatshirts in different order quantities. Order size Price Carrying Cost 1299 38 300 ~499 500 799 800 ~ (b) Determine the optimal order quantity without discount (c) The total annual costs with the order quantity in (a) (d) The total annual costs with the order quantity of 300. (e) The total annual costs with the order quantity of 500. (f) The total annual costs with the order quantity of 800. (g) Based on the results in (b - e), what is the optimal order quantity given the discount schedule