Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 213
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver Help brownti via OfficeKB.com Excel Worksheet Functions 9 July 2nd 07 05:08 PM
XL Solver Baldy_Couso Excel Worksheet Functions 1 February 5th 07 02:00 PM
need help in SOLVER !! Ah NeL Excel Discussion (Misc queries) 1 December 26th 06 04:24 PM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Can solver do this? chrisrowe_cr Excel Worksheet Functions 2 July 14th 05 06:03 PM


All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"