Need help with this problem
 

Hello,

I need a hand with the following problem as I have not used Excel for
quite a while.

--------There are 4 categories of goods - A,B,C,D
--------Each category has 100 goods/supplies that range in price from
$4.00 -$26.00(cents are inclusive: ie - one particular item in category
A costs $15.41)
--------A certain # of goods must be chosen from each category as
follows:
A - 3
B - 4
C - 3
D - ONLY 1 ITEM IS NEEDED FROM THIS CATEGORY.

HERE IS THE TRICKY PART:

A buyer must select the exact number of goods required from each
category and
the total cost of all 11 chosen goods cannot exceed $100.00 nor can it
be below $99.00.

So is there a way to get excel to do this and display what goods were
chosen?
I also figure that there will be more than one set of 11 goods that can
fit the answer,(maybe 100s of answers) so is there also a way of showing
all possible combinations?

Thanks in advance to all of you who respond my email is


And before you ask. I am not in Algebra class trying to get other
people to do my homework.


--
stioffan
------------------------------------------------------------------------
stioffan's Profile: http://www.excelforum.com/member.php...o&userid=26070
View this thread: http://www.excelforum.com/showthread...hreadid=394204