Using Excel's Solver add-in, find the optimal solution for the following problem?
Maximize P = 8x + 3y
subject to $2 x + 4 y \leq 20$
$6 x + 3 y \leq 18$
$and\quad x \geq 0 , y \geq 0$
A) (x, y) = (3, 0)
B) (x, y) = (0, 3)
C) (x, y) = (0, 0)
D) (x, y) = (0, 5)
E) None of the answer choices are correct.

Question

Using Excel's Solver add-in, find the optimal solution for the following problem?
Maximize P = 8x + 3y
subject to $2 x + 4 y \leq 20$ 
$6 x + 3 y \leq 18$ 
$and\quad x \geq 0 , y \geq 0$
A) (x, y) = (3, 0)
B) (x, y) = (0, 3)
C) (x, y) = (0, 0)
D) (x, y) = (0, 5)
E) None of the answer choices are correct.

Quizplus · Accepted Answer

The optimal solution is (x, y) = (3, 0) which maximizes P = 8(3) + 3(0) = 24, satisfying all constraints.

Using Excel's Solver Add-In, Find the Optimal Solution for the Following