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 $10$

Three plants P$1,$ P$2,$ and P$3$ of a gas corporation supply gasoline to three of their distributors in the city located at A$,$ B$,$ and C locations. The plants' daily capacities are $4500,3000,$ and $5000,$

gallons respectively, while the distributors' daily requirements are $5500,2500,$ and $4200$ gallons. The per$-$gallon transportation costs $($in $ $)$ are provided in the table below:

What is the optimal minimized cost?

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.