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:

Unamortized Discount

An unamortized discount refers to the portion of a bond's initial discount that has not yet been amortized or gradually written off over the life of the bond.

Redeemed

Usually refers to the repurchase or paying off of a debt or equity security at its original value or at a predetermined value before it matures.

Effective Interest Rate Method

The effective interest rate method is a technique for calculating the actual interest rate for a financial product over its life, considering compounding.

Bonds Payable

A long-term liability account that records the face value of the bonds a company is obligated to repay at a specified future date.