please help me do this in excel

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 $36 apiece. The cost to the bookstore for placing an order is $110, and the carrying cost is 15% of the purchase price. The bookstore manager estimates that 1,340 sweatshirts will be sold during the year. The vendor has offered the bookstore the following volume discount The bookstore manager wants to determine the bookstore's optimal order quantity, given the foregoing quantity discount information. 1. Determine carrying cost as a percentage of purchase price 2. With Quantity discounts carrying costs will vary with the the change in price if it computed as a percentage of purchase price 3. Calculate EOQ for each discount price 4. Calculate TC for each EOQ 5. What is the bookstore's optimal order quantity