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

question 6

Multiple Choice

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.

---

Definitions:

Pooled Standard Deviation

A method to estimate the standard deviation across different samples or groups by combining their variances, assuming they have the same variance.

Control Limit

The upper and lower bounds on a control chart in statistical process control that signal when a process might be out of control or requires investigation.

Sample Means

The average values obtained from multiple subsets of a population.

Pooled Standard Deviation

A method used to estimate the standard deviation of several different populations when the mean of each population may differ but the true standard deviation of each population is assumed to be the same.