Please solve using excel and TC + P method.

32. The bookstore at State University purchases from a vendor sweatshirts emblazoned with the 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 1,700 sweatshirts will be sold during the year. The vendor has offered the bookstore the following volume discount schedule: Order Size 1-299 300-499 500-799 800+ Discount (%) 0 2 4 5 a. Determine the bookstore's optimal order quantity, given the foregoing quantity discount information. b. Determine the optimal order quantity of sweatshirts and total annual cost if the carrying cost is a constant $8 per sweatshirt per year