Please help me solve using excel

Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 700 valves; order cost is $13 per order; and annual inventory holding costs are $2.15 per unit. Vendor A Quantity Price 1-14 $35.00 15-24 34.75 25-99 33.55 100-199 32.35 200-399 31.15 400+ 30.75 Vendor B Quantity Price 1-24 $34.75 25-99 34.00 100-199 32.80 200-399 31.60 400+ 30.50 Vendor C Quantity Price 1-49 $34.50 50-149 33.75 150-299 32.50 300+ 31.10 Vendor D Quantity Price 1-149 $34.25 150-299 33.00 300+ 31.00 Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order units at a time from (enter your response as a whole number)