Need help with this problem

S

stioffan

Hello,

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

--------There are 4 categories of goods - A,B,C,D
--------Each category has 100 goods/supplies that range in price fro
$4.00 -$26.00(cents are inclusive: ie - one particular item in categor
A costs $15.41)
--------A certain # of goods must be chosen from each category a
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 eac
category and
the total cost of all 11 chosen goods cannot exceed $100.00 nor can i
be below $99.00.

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

Thanks in advance to all of you who respond my email i
[email protected]

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