Linear programming using solver in Excel 2000

[pincivma]

Hi there

I found an example on the internet on how to solve a linear programming problem using Excel 2000 Solver. I have attached a workbook with all the information you will need to solve the linear programming problem. I must be doing something wrong because my solution is different from the example I found on the internet. Here is the link to the internet example

http://www.ateneonline.it/chase2e/studenti/tn/6184-7_supA.pdf

[p45cal]

missing some formulae on your sheet:

Cell Formula
D4 =SUM(B4:C4)
D5 =B4*B5+C4*C5
D9 =$B$4*B9+$C$4*C9
D10 =$B$4*B10+$C$4*C10
D11 =$B$4*B11+$C$4*C11

…and tell people when you cross post!:
https://forums.techguy.org/threads/linear-programming-in-excel-2000-using-the-solver-menu.1165348/

read: http://www.excelguru.ca/content.php?184

[pincivma]

Hi p45cal

Thank you for replying back to me. Sorry about not telling about other forums that I posted on. Anyway, I did put in your formulas and ran the solver but I still get the wrong answers and the pop up that says the program does not converge. Try opening the attachment and putting in the formulas and run the solver and see if you get the same error that I get.

[p45cal]

Try opening the attachment and putting in the formulas and run the solverI did; that's how I got to the formulae.




and see if you get the same error that I get.I got the correct answer using Solver. Explore the options in Solver, make sure you're using Simplex LP method and explore the other settings in Solver to see they're correct.

[pincivma]

OK, I'll try

Can you send me the workbook that you worked on to see where I went wrong?? This is the first time that I'm using solver

[p45cal]

Attached

[pincivma]

GREAT!! THANK YOU SO MUCH!! I found my mistake. I forgot to put B4 abd C4 >=0. This omission caused the problem. It now works great.:yes