Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Optimization question
Dear all,
I am a novice to the solver function and would be very appreciative if someone would be able to offer me a solution utilizing solver. I need to find what is the optimal product mix of the following computer items given their respective prices, per unit: P3 450 $27.00 P3 500 $30.00 P3 533 $31.98 P3 550 $33.00 P3 600 $36.00 P3 650 $39.00 P3 667 $40.02 P3 700 $52.50 P3 733 $54.98 P3 850 $63.75 P3 866 $64.95 P3 933 $69.98 P3 1000 $75.00 P4 1.8 GHZ $410.00 P4 1.8 GHZ $420.00 P4-M 1.6 GHZ $425.00 P4 1.8 GHZ $425.00 P4/DVD 1.8 GHZ $430.00 P4/DVD 1.8 GHZ $445.00 P4-M 2.0 GHZ $460.00 P4-M/DVD 2.0 GHZ $475.00 P4-M 2.0 GHZ $480.00 P4-M 2.0 GHZ $500.00 P4-M 2.0 GHZ $510.00 P4-M 2.0 GHZ $525.00 P4-M 2.0 GHZ $535.00 P4-M 2.0 GHZ $540.00 P4-M/DVD 2.2 GHZ $550.00 P4-M 2.2 GHZ $570.00 P4-M 2.2 GHZ $575.00 P4-M 2.4 GHZ $590.00 P4-M 2.4 GHZ $610.00 P4-M 2.4 GHZ $620.00 P4-M 2.4 GHZ $625.00 P4-M 2.4 GHZ $645.00 P4-M/DVD 2.4 GHZ $650.00 Constraints a 500 units can fit a 20ft container 1100 units can fit a 40 ft container Total target price is around $25,000-$28,000 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Optimization question
I think there's a constraint missing: do you have certain quantities
for certain types of machines, or an inventory of machines that must be shipped? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is this the proper place to ask my question? | Excel Discussion (Misc queries) | |||
Finding and deleting question marks | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Benefits many people - Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) |