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:

U.K. Bills

Short-term debt instruments issued by the United Kingdom government, typically with a maturity of less than one year.

Risk-Free Rate

The theoretical return of an investment with zero risk, often represented by the yield of government bonds.

Forward Rate

The interest rate agreed upon for a loan that will start at a future date, used in the trading of financial instruments.

British Security

Refers to measures and protocols in place to ensure the safety and protection of the United Kingdom against threats, including those related to national security, cyber security, and public safety.