Set Up and Solve the Following Nonlinear Programming Problem Using

question 35

Essay

Set up and solve the following nonlinear programming problem using Excel:
$$\begin{array} { l } \text { Max: } 10 \mathrm { X } _ { 1 } + 15 \mathrm { X } _ { 2 } + 5 \mathrm { X } _ { 3 } + 2 \mathrm { X } _ { 3 } 3 \\\text { Subject to } \\\mathrm { X } _ { 1 } + \mathrm { X } _ { 2 } + \mathrm { X } _ { 3 } \leq 50 \\2 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } \leq 150 \\\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } , \mathrm { X } _ { 3 } \geq 0\end{array}$$

---

Definitions:

Labor Laws

Regulations governing the relationship between employers and employees, including rights, obligations, and working conditions.

Union Representation

The act of a labor union representing the interests of its members, including bargaining for better wages, benefits, and working conditions.

First-Line Supervisors

Managers who are directly responsible for overseeing the work of entry-level or non-managerial employees.

Middle Managers

Employees occupying positions between entry-level and top management, responsible for implementing organizational policies and overseeing junior staff.