Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Solver
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver Help | Excel Worksheet Functions | |||
XL Solver | Excel Worksheet Functions | |||
need help in SOLVER !! | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Can solver do this? | Excel Worksheet Functions |