Set up and solve the following nonlinear programming problem using Excel:
$$\begin{array} { l }
\operatorname { Max } : \left( \mathrm { X } _ { 1 } - 5 \right) ^ { 2 } + \left( \mathrm { X } _ { 2 } - 7 \right) ^ { 2 } \
\text { Subject to } \
\mathrm { X } _ { 1 } \leq 15 \
\mathrm { X } _ { 2 } \leq 15 \
\mathrm { X } _ { 1 } + \mathrm { X } _ { 2 } \geq 10 \
\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0
\end{array}$$

Question

Set up and solve the following nonlinear programming problem using Excel:
 $$\begin{array} { l } 
\operatorname { Max } : \left( \mathrm { X } _ { 1 } - 5 \right) ^ { 2 } + \left( \mathrm { X } _ { 2 } - 7 \right) ^ { 2 } \
\text { Subject to } \
\mathrm { X } _ { 1 } \leq 15 \
\mathrm { X } _ { 2 } \leq 15 \
\mathrm { X } _ { 1 } + \mathrm { X } _ { 2 } \geq 10 \
\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0
\end{array}$$

Quizplus · Accepted Answer

The Answer of Set up and solve the following nonlinear programming problem using Excel:
 $$\begin{array} { l } 
\operatorname { Max } : \left( \mathrm { X } _ { 1 } - 5 \right) ^ { 2 } + \left( \mathrm { X } _ { 2 } - 7 \right) ^ { 2 } \
\text { Subject to } \
\mathrm { X } _ { 1 } \leq 15 \
\mathrm { X } _ { 2 } \leq 15 \
\mathrm { X } _ { 1 } + \mathrm { X } _ { 2 } \geq 10 \
\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0
\end{array}$$

Set Up and Solve the Following Nonlinear Programming Problem Using