Dan34

This sounds interesting/fun... I am going to do some research and see if I can use the method you described above. I will let you know if I find a reason why that would not work.

Thank you, that is a very good way to get a great answer. I would be interested in a formula that can accomodate consumption, and subscription offering changes (although I can do this using the below formulas in excel). I previously tryed to come up with it for fun and it has stumped me Now I want to know how/if other people solve it Sorry, as you have already shown, I am making it more complicated than it needs to be.

Hello, Here is a problem that I think should be solvable but I am not sure how. You need to have 450 subscriptions, each subscription gives a certain amount of cookies/year. You want to recieve 1,600,000 (+/- 10,000) cookies for the lowest cost. Here are your subscription options: 0 cookies for $300 4000 cookies for $500 9000 cookies for $900 20000 cookies for $1800 Having a hard goal with some variance (1,600,000 +/-10,000) that is not a minimum or max, and a required amount of subscriptions adds complexity that I do not know how to deal with (outside of programming something to try them all). If you are able to solve this mathmatically please let me know how.