Excel's Solver Tool Has Been Used in the Spreadsheet Below $\ge$

question 25

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 $\ge$ constraints. $\text { Input Section }$
$\begin{array}{l}\text { Objective Function Coefficients }\\\begin{array}{c|c}\hline X & Y \\\hline 5 & 4\end{array}\end{array}$

$\begin{array}{|c|c|c|c|}\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}{|l|c|c|c|}\hline \text { Variables } & 9.6 & 7.2 & \\\hline \text { Profit } & 48 & 28.8 & 76.8 \\\hline\end{array}$

$\begin{array}{|c|c|c|}\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\end{array}$
a. Give the original linear programming problem.
b. Give the complete optimal solution.

---

Definitions:

Flyers Mailed

Marketing material sent through postal mail to target consumers in an attempt to advertise products or services.

Votes

Expressions of choice or preference made by individuals or groups in a decision-making process, typically within an electoral context.

Making Speeches

Making speeches involves delivering oral presentations to an audience, aiming to inform, persuade, or entertain through spoken communication.

Priceless Moments

Experiences or events that hold immense emotional value, considered irreplaceable and beyond monetary worth.