This is study qustion for my quative business class. We are using solver on excel to solve the problems. could you do the work in excel and attach the flie with all the work with it when you send the answer. I appreatie it a lot it helping me study for an upcoming exam.

QUESTION $11$

By runing the problem again and comparing with the sensitivity report $($so you learn how it works$)$ answer the following:

What is the new minimum cost of transportation if we increase the demand of distributor $B$ to be $2600?$

QUESTION $12$

By runing the problem again and comparing with the sensitivity report $($so you learn how it works$)$ answer the following:

The cost of transportation from Plant $1$ to distributor $B$ increases to $0\mathrm{.}70.$ Given this new cost, will the optimal solution of units shipped between plants and distributors change? Answer yes or no

Calculate the new cost if applicable $($

$,$ otherwise write no applicable.

QUESTION $13$

Does the following linear programming problem exhibit infeasibility, unboundedness, or alternate optimal solutions?

Min $1x+1Y$

s$.$t$.5x+3Y30$

$3x+4Y36$

$Y7$

$x,Y0$

The problem is "infeasible", "unbounded" or has "multiple solutions"