dolution

Excel Solver on the transportation problem depicted on the next slide where the objective is to have cost of shipping minimized. Then answer the additional questions. Please write a complete sentence as your answer for each part and make explanations incorporate the actual numerical values in this problem.

What amounts are shipped on each route?
Give an explanation of the range of optimality of variable x21.
If any variable has a reduced cost identify the variable and explain what the reduced cost means. Give an explanation of the range of feasibility of s2 and what the shadow price there means.
Give an explanation of the range of feasibility of d2 and what the shadow price there means. Please include your Excel file with a least a answer report and sensitivity report when you conduct your discussion.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now