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

question 30

Essay

Excel's Solver tool has been used in the spreadsheet below to solve a linear programming problem with a maximization objective function and all $\le$ constraints. Input Section
$\begin{array}{l}\text { Objective Function Coefficients }\\ X & Y \\ 4 & 6\end{array}$

$\begin{array}{|c|c|c|c|}\hline \text { Constraints } & & & \text { Avail. } \\\hline \# 1 & 3 & 5 & 60 \\\hline \# 2 & 3 & 2 & 48 \\\hline \# 3 & 1 & 1 & 20 \\\hline\end{array}$
$\text { Output Section }$
$\begin{array}{|l|c|c|c|}\hline \text { Variables } & 13.333333 & 4 & \\\hline \text { Profit } & 53.333333 & 24 & 77.333333 \\\hline\end{array}$

$\begin{array}{|c|c|c|}\hline \text { Constraint } & \text { Usage } & \text { Slack } \\\hline \# 1 & 60 & 1.789 \mathrm{E}-11 \\\hline \# 2 & 48 & -2.69 \mathrm{E}-11 \\\hline \# 3 & 17.333333 & 2.6666667 \\\hline\end{array}$
a.Give the original linear programming problem.
b.Give the complete optimal solution.

---

Definitions:

Polar Bears

Large carnivorous bears found primarily in the Arctic Circle, known for their thick white fur and dependence on sea ice for hunting seals.

Competitive Economic Environment

Refers to a market scenario where multiple businesses are vying for the same customer base, leading to innovations, better pricing, and quality of products or services.

Marketing

The action or business of promoting and selling products or services, including market research and advertising.

Business World

A term referring to the global commercial environment, encompassing all aspects of professional work, enterprises, and economic activities.