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 are:
500 units can fit a 20ft container
1100 units can fit a 40 ft container

Total target price is around $25,000-$28,000

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?

You should check out the tutorials included with Solver and/or visit the web
site www.solver.com

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> 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 are:
> 500 units can fit a 20ft container
> 1100 units can fit a 40 ft container
>
> Total target price is around $25,000-$28,000
>