Transportation model, linear programming and Solver

Hi,

Can you attached your sample file here.

Here it is. Instead of doing the process 3 times in different sheets, I would like to do it in one step.

Thank you.

Hi

ExampleLE.xlsx
I really don't know what you what. Can you illustrate the desired out you want, I guess it would be better if you illustrate in your attachment before and after.

And may be we could use what if analysis in your file.

Please do not for get to click add reputation, if this post helps you. Just click star lower left below my post.

Thanks a lot for your response. I think that you have really understood what I wanted, and I totally agree with what you have done. My only issue now is that when I change the initial values for the variables and run Solver again, it gives me a different (less optimal) solution. Does that also happen to you?

Hi,

What variables you are speaking? Is it the demand? Can you show me the computation/solution for linear programming you are using?

Thanks,

Reimar_rem

Hi GregDP

Instead of doing the process 3 times in different sheets, I would like to do it in one step

Not excatly what you asked for but since your setup in every sheet is the same except for the cost part (New1 to New3) you could set up a macro to loop through the sheets and running solver on each sheet.

Please Login or Register  to view this content.

To get this to work you must also set a reference to Solver in "Visual Basic". Open the "Visual Basic" window, select "Tools", then "References" and "tick" box marked "Solver"

To run Solver 3times on the same sheet perhaps someting like this. A bit more clumsy if I may say so.

Please Login or Register  to view this content.

Will change the "cost" row and copy values from the solver run to A12, A24 and A36. As before you must have set a reference to solver if you use a macro.

Alf