Good day, I was hoping someone would be able to help with this problem I have. I have.
For the example I have pasted below, I want to optimize the number of "nutrition points" for a specific allotment of food that is being placed in a food basket.
The required allotment of food types is constrained by the values in the upper right area, as well as a maximum amount of total calories allowed in the basket.
I tried setting it up several ways in solver, but either it isn't made for this type of problem or I don't know what the hell I'm doing.
Any input would be appreciated.
Here, have some boobies while you think.
For the example I have pasted below, I want to optimize the number of "nutrition points" for a specific allotment of food that is being placed in a food basket.
The required allotment of food types is constrained by the values in the upper right area, as well as a maximum amount of total calories allowed in the basket.
I tried setting it up several ways in solver, but either it isn't made for this type of problem or I don't know what the hell I'm doing.
Any input would be appreciated.
Here, have some boobies while you think.