I will appreciate if the question below can be solved with solver in excel. Time is against me and I will appreciate if you can help asap.

Nevex University must purchase 1100 computer screens from three vendors. Vendor 1 charges $500 per screen plus a delivery charge of $5000. Vendor 2 charges $350 per screen plus a delivery charge of $4000. Vendor 3 charges $250 per screen plus a delivery charge of $6000. The delivery charges are independent of the delivery size. Vendor 1 will sell the university at most 500 screens, vendor 2 at most 900, and vendor 3 at most 400. The minimum order from any vendor is 200 screens. The University wants to minimize the cost of purchasing the needed computers. Formulate and solve a linear spreadsheet model to help this company solve its problem. Describe your findings to the University.