Share via

Excel solver: Constraints not working

Anonymous
2020-09-05T06:01:33+00:00

The objective is to minimize the Sumproduct of the two tables.

The cells X3:X5 equal to 0 if the corresponding cell in K3:K5 equals zero. However, the solver always gives a solution where K3:K5 are zeros and V3:V5 has values.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-09-05T14:09:23+00:00

    The constraints in the yellow cells were not met since K3:K5 is zero in the output. The c(0,0,1) was typed in by hand after the solver gave a solution. My friends have tried running this in Windows and it worked properly. I'm not sure whether it's an issue with the Mac system.

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Andreas Killer 144K Reputation points Volunteer Moderator
    2020-09-05T14:18:46+00:00

    My friends have tried running this in Windows and it worked properly. I'm not sure whether it's an issue with the Mac system.

    It would have been helpful if you had given us this information in advance.

    I have a Windows machine and get this solution, no issues:

    I don't have a Mac.

    Andreas.

    0 comments
  4. Anonymous
    2020-09-05T14:27:24+00:00

    Really appreciate your help. This is the first time I raise a question here, I thought I have selected the 'Mac' category after selecting 'Excel' so I don't need to mention it again. I'll make it clearer next time! :)

    0 comments
  5. Anonymous
    2020-09-05T14:32:45+00:00

    Hi Dana,

    I don't quite understand why there are logic problems.

    The setup cells are there to force the systems to include the setup cost so that the plants can produce. If setup = 0, the plant should not have anything shipped to the warehouses.

    Lexie

    0 comments