View Full Version : Linear programming using solver in Excel 2000
pincivma
02-02-2016, 07:20 PM
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
02-03-2016, 05:59 AM
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
02-03-2016, 08:09 AM
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
02-03-2016, 08:33 AM
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
02-03-2016, 08:59 AM
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
02-03-2016, 10:50 AM
Attached
pincivma
02-03-2016, 11:20 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.