Here are the Excel answer and sensitivity reports. Answer question b. h. based on these reports.

b. What is the total cost of the transportation plan?

c. Which of the distribution centers have slack and what quantities?

d. Which customers have a binding solution?

e. If customer A demands 10 units more, what is the impact on total cost?

f. If customer C shuts down temporarily (0 demand), what is the impact on total cost?

g. If distribution center 3 increases its supply by 20 units, what is the impact on total cost?

h. If distribution center 2 increases its supply by 20 units, what is the impact on total cost?

i. What happens when the cost to transport goods per unit on lane 1 to B is decreased to $2.75?

j. What happens when the cost to transport goods per unit on lane 3 to A is increased to $3.50?

Cell Objective Function Name Cost Original Value 309 Final Value 4450 Final Value 0 0 350 0 350 50 200 0 0 Cell Name $M$235 1 to A $N$235 1 to B $0$235 1 to C $M$236 2 to A $N$236 2 to B $0$236 2 to C $M$237 3 to A $N$237 3 to B $0$237 3 to C Reduced Cost 1 3 0 3 0 0 0 2 1 Objective Allowable Allowable Coefficient Increase Decrease 4 1E+30 1 6 1E+30 3 8 1 1 1E+30 3 2 2 1E+30 7 1 2 3 1 1E+30 5 1E+30 2 9 1E+30 1 5 Cell Name $M$238 A $N$238 B $0$238 C $P$235 1 $P$236 2 $P$237 3 Final Value 200 350 400 350 400 200 Shadow Price 3 3 8 0 -1 0 Constraint Allowable Allowable R.H. Side Increase Decrease 200 100 200 350 50 350 400 150 350 500 1E+30 150 400 350 50 300 1E+30 100