Please do in excel and show the excel sheet with formula because we need excel part $,$ answer is already on website..You have two products, Alpha, and Beta. For every unit of Alpha, you make a $$3$ profit

and for every unit of Beta you make a $$2$ profit. There are $10$ kilograms of steel available.

Each unit of Alpha requires $1$ kilogram, and each unit of Beta requires $1$ kilogram of

steel. There are $24$ kilograms of aluminum available. Each unit of Alpha requires $3$

kilograms, and each unit of Beta requires $1$ kilogram of aluminum. There are $16$

kilograms of copper available. Each unit of Alpha requires $1$ kilogram, and each unit of

Beta requires $2$ kilograms of copper. You prepare the following linear program:

Max $3$A $+$ $$2$B

Subject to: $1$A $+1$B $<10$ Steel

$3$A $+1$B $<24$ Aluminum

$1$A $+2$B $<16$ Copper

A$,$ B $>0$

Required: Solve the following problem. Print the Solver Sensitivity report.

a$)$ Calculate the optimal solution in quantities of the two products and total dollar profit.

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

b$)$ Which of the three constraints are binding?

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

c$)$ Assume that the profit per unit of Alpha increases from $$3$ to $$5.$ The profit per unit of

Beta is unchanged. Does the optimal solution change? Find the optimal solution in

number of units and total profit?

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

d$)$ Assume that the unit profit for Alpha remains $$3$ but the unit profit for Beta increases

from $$2$ to $$4.$ Does the optimal solution change? Find the optimal solution in number of

units and total profit?

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

d$)$ If the quantity of steel is increased from $10$ to $11$ kilograms, what is the effect $($if any$)$

of this change on overall profit?

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Attach the Solver sensitivity report this sheet

pl