I'm just starting to explore linear programming in Excel and have hit a VERY newbie problem I'm sure.
I'm using it to optimise a "diet" plan with a few ingredients. The problem I've hit is as follows.
What I'd like to do somehow is limit the number of possible servings as well. I can't imaging anyone wanting to eat 500 servings of mushrooms and nothing else.
Just to be clear I'm trying to achieve a minimise CP100 (Calories per 100g) while maintaining a decent desire (tasty) level.
Any ideas? I've Googled, but come up short so far...