Excel's Solver Tool Has Been Used in the Spreadsheet Below $\text { Input Section }$

question 5

Essay

Excel's Solver tool has been used in the spreadsheet below to solve a linear programming problem with a minimization objective function and all  constraints. $\text { Input Section }$

$\text { Objective Function Coefficients }$
$\begin{array}{|c|c|c|c|c|}\hline && x & y & \\\hline && 5 & 4 & \\\hline &&&&\\\hline &\text { Constraints } & & & \text { Req'd } \\\hline &\# 1 & 4 & 3 & 60 \\\hline &\# 2 & 2 & 5 & 50 \\\hline &\# 3 & 9 & 8 & 144 \\\hline\end{array}$

$\text { Output Section }$
$\begin{array}{|c|c|c|c|c|}\hline &&&&\\\hline &\text { Variables } & 9.6 & 7.2 & \\\hline &\text { Profit } & 48 & 28.8 & 76.8 \\\hline &&&&\\\hline &\text { Constraint } & \text { Usage } & \text { Slack } \\\hline &\# 1 & 60 & 1.35 \mathrm{E}-11 \\\hline &\# 2 & 55.2 & -5.2 \\\hline &\# 3 & 144 & -2.62 \mathrm{E}-11 \\\hline &&&&\\\hline\end{array}$
a.Give the original linear programming problem.
b.Give the complete optimal solution.

---

Definitions:

Menopause

The time in a woman's life when her menstrual periods permanently stop and she is no longer able to bear children, typically occurring between the ages of 45 and 55.

Intellectual Productivity

The capacity to generate, develop, and bring to fruition new ideas, inventions, or creative works.

Processing Information

The act of taking in, interpreting, and making sense of information, which is a fundamental aspect of cognitive functioning.

Trust Versus Mistrust

A stage in Erik Erikson's theory of psychological development where an infant learns to trust or mistrust their caregivers and environment.