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

question 52

Multiple Choice

Using Excel's Solver add-in, find the optimal solution for the following problem?
Maximize P = 3x + 8y
Ssubject to $2 x + 4 y \leq 20$
$\begin{array} { c } 6 x + 3 y \leq 18 \\and~~x \geq 0 , y \geq 0 .\end{array}$

• A) (x, y) = (2, 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:

Molecular Data

Information at a molecular level, including DNA, RNA, and protein sequences, used in various scientific studies.

Apes and Humans

A reference to the biological and evolutionary connections between humans and other members of the Hominidae family, such as gorillas and chimpanzees.

Split Occurred

A phrase indicating that a division or separation took place, often used to describe evolutionary divergences or social and organizational splits.

Endothermic

Refers to a process or reaction that absorbs energy from its surroundings, usually in the form of heat.