Set Up and Solve the Following Nonlinear Programming Problem Using

question 32

Essay

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}$$

---

Definitions:

Transmission Damage

Harm or failure in the transmission system of a vehicle, affecting its ability to change gears and efficiently transfer engine power to the wheels.

Drive Wheels

Wheels that receive power from the vehicle's engine or motor to propel the vehicle forward or backward.

Twin Countershaft Transmission

A twin countershaft transmission is a type of gearbox found in heavy-duty vehicles, featuring two parallel shafts that allow for more efficient torque distribution and gear ratios.

Input Shaft

The shaft that transfers power from an external source (like an engine) into a gearbox or transmission to be distributed to the machinery.