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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Solver
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Solver
You didn't say how often the order for replacements is put in.
Randy wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Solver
Hi. Don't know what kind of help you need for Solver.
The only thing I might offer that may not be discussed in the book is the following: When you add a constraint like x/y <= 3, there is a chance Solver will error out with Div/0 error. I find it best to make it linear by rewriting as x <= 3*y then x - 3*y <= 0 Now...your variables are on the left, constant value on Right, and no chance for Div/0 error. You may prefer to multiply by -1 -x + 3*y = 0 The box for the Pentium takes up to 6 square feet; Yep. This standard Chapter 1 intro problem is starting to show it's age. :) Good luck. = = = = = = = HTH Dana DeLouis On 9/29/09 9:10 PM, Randy wrote: 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 |
Reply |
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 |