The Solver solution Variables Final Reduced Objective Allowable Allowable From To Value Cost Coefficient Increase Decrease Location 1 Location3 0 2600 5400 1E+30 2600 Location 1 Location4 10 0 1700 500 1E+30 Location 1 Location5 2 0 2300 200 500 Location 1 Location6 4 0 3000 500 200 Location 2 Location3 10 0 2400 200 1E+30 Location 2 Location4 0 500 1800 1E+30 500 Location 2 Location5 8 0 1900 500 200 Location 2 Location6 O 500 3100 1E+30 500 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Const1 Location3 Receives 10 -200 10 4 2 Const2 Location4 Receives 10 -1300 10 4 6 Const3 Location5 Receives 10 -700 10 4 2 Const4 Location6 Receives 4 0 10 1E+30 6 Const5 Location 1 Ships 16 3000 16 6 4 Const6 Location 2 Ships 18 2600 18 2 4