## Solve following nonlinear programing by solver, you should copy and paste your solver solution

Homework from Ch. 8
Q1) Solve following nonlinear programing by solver, you should copy and paste your solver
solution.
2
( 20) ( 300)
17
10
4 90
2 110
0.01 1.9 34
0.14 343
, , , 0
Max N A M B
A
B
A B
A B
N A A
M B
A B N M
  

 
 
  
  

Q2) The monthly demand for ground beef at a fast-food chain is 75 tons. The cost of placing an
order is \$1800, and the monthly holding cost for one ton of ground beef is 1.25% of its cost.
One ton of ground beef costs \$2000 for the fast-food chain.
a) How many tons should the company orders each time to minimize the inventory cost?
b) What does the total QUARTERLY inventory cost?
you should copy and paste your solver solution.
NOTE: You should solve Q2 by solver(NLP), not by using EOQ formula.
Q3) University of Maryland Medical center at Baltimore is interested in keeping its vehicle
which equipped with special tools to carry the collected blood at central location that would
minimize the distance to four major blood collection center.
Coordinator of the four centers given bellow:
Blood Collection
Centers X miles Y miles
Ellicott City 2.5 14.5
College Park 16.5 4.5
Tawson 16.0 31.5
White Marsh 20.0 26.5
a) Formulate an NLP model to determine where the vehicle should be located in order to
minimize total distance to blood centers.
b) Implement your model in a spreadsheet and solve it. Where should the vehicle service be
located if you minimize the total distances?
c) Implement your model in a spreadsheet and solve it. Where should the vehicle service be
located if you minimize the maximum distances?
you should copy and paste your solver solution.