Randy -

I could help if (1) you get permission from your instructor or (2) you
convince me this is not a homework assignment.

- Mike
http://www.MikeMiddleton.com



"Randy" wrote in message
...
Can anyone help me with this problem???

Problem:
My supervisor wants me to create a worksheet . C.C computers, sell
Pentiums
PC's each costs $1,450 and retails for $1,900

Power PC's costs $1,750 and retail for
$2,150.
Teh box for the pentium takes up to 6 square feet; the box for the Powe
Pc
takes up to 4 square feet ..... Te stockroom for the PC's is 130 Sq Ft....
The store sells about twice as many Pentiums to Power PC's , so no matter
how many boxes she can fit in the storeroom, the ratio of Pentium to Power
PC's must be at least 2:1 and not greater than 3:1 . So, using the Solver,
she wants me to determine how many boxes of each brand should I order to
maximize profits while still meeting the constraints of the problem. I has
to
show my final solution and the answer report .

Thank you and look forward to hearing from you soon