Question

Kindly use excel solver to solve the following linear programming problem.

Solve the following model:
Min X^2 - 10 X + Y^2 - 6 Y + 34

subject to only non-negativity constraints.

	X	Y		Objective Function Value
			=

Solve the model again with the additional constraints:
X^2 - 8 X + Y^2 - 3 Y + 1020 <= 1111 (Constraint #1)
2X + 5 Y <= 15 (Constraint #2)

together with non-negativity constraints.

	X	Y		Objective Function Value
			=

		LHS		RHS
Constraint #1
Constraint #2

Answer 1

Since ,it is a minimization problem, with only non-negativity constraints ,we get the following excel output

With additional constraints:

The solution is the same as in the first case.