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.

cost$?$

QUESTION $9$

Based on the transportation problem:

What is the optimal value for the route Pittsburg to Indianapolis, that is how many units should be sent from Pittsburg to Indianapolis in order to minimize the total

transportation cost?

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