- Home >
- Mathematics >
- State University must purchase
State University must purchase
Question Description
State University must purchase 1700 computers from three vendors. Vendor 1 charges $500 per computer with a total delivery charge of $5,000. Vendor 2 charges $350 per computer plus a total delivery charge of $4,000. Vendor 1 will see the university at most +600 and vendor 2 at most 1100. The minimum order from a vendor is 200 computers. Determine how to minimize the cost of purchasing the needed computers in Microsoft Excel Solver.
Each vendor must supply at least the minimum.
Each vendor must supply at least the minimum only if that vendor is used.
This question has not been answered.
Create a free account to get help with this and any other question!
Similar Content
The Magic Mountain
by Thomas Mann
Black Beauty
by Anna Sewell
The 5 Love Languages
by Gary Chapman
The Catcher in the Rye
by J. D. Salinger
Breakfast at Tiffanys
by Truman Capote
The Elegant Universe
by Brian Greene
Nervous Conditions
by Tsitsi Dangarembga
American Gods
by Neil Gaiman
A Passage to India
by E. M. Forster
Studypool values your privacy. Only questions posted as Public are visible on our website.
Brown University
1271 Tutors
California Institute of Technology
2131 Tutors
Carnegie Mellon University
982 Tutors
Columbia University
1256 Tutors
Dartmouth University
2113 Tutors
Emory University
2279 Tutors
Harvard University
599 Tutors
Massachusetts Institute of Technology
2319 Tutors
New York University
1645 Tutors
Notre Dam University
1911 Tutors
Oklahoma University
2122 Tutors
Pennsylvania State University
932 Tutors
Princeton University
1211 Tutors
Stanford University
983 Tutors
University of California
1282 Tutors
Oxford University
123 Tutors
Yale University
2325 Tutors