I am testing the solver by using the example from Excel-Easy at http://www.excel-easy.com/data-analysis/solver.html
However, it is not working.
I have attached the spreadsheet.
I am testing the solver by using the example from Excel-Easy at http://www.excel-easy.com/data-analysis/solver.html
However, it is not working.
I have attached the spreadsheet.
The Sumproduct means 100*0+300*0+50*0, which equals 0... if you put numbers in the order size it will work.
You need to add some constraints so I've set up the model for you. You should also check what changes I made to the solver setting i.e. Simplex LP and production is defined as intgers.
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks