Originally Posted by
Alf
I find your problem a bit puzzling. I assume the different qualities blends linearly on a weight basis. A balanced lunch would then consist of different % of some of
the components to meet the required specification for calories, iron and so fort. This I've set up a model for on Sheet1.
The bad: With the given constraint solver can not find a solution that satisfies all given constraints.
On Sheet2 I've set up another solver solution but even if this gives a solution meeting the constraints I'm not sure the team will be able to play any basketball
after every one of them have had 3,5 pound of foodstuff for lunch. On the other hand I may be wrong. If solver assumes the dried beans to be "Mexican jumping beans"
then perhaps this will work in the teams favor.
Alf
Bookmarks