Monelle, it a few days since you asked this and there's been no responses, if you are still in need of a suggestion have a look at this similar question asked a few years ago on another forum with a solution that uses the Excel solver add-in.
http://superuser.com/questions/20492...-a-given-total
Bookmarks