jodane
Mechanical
- Sep 16, 2012
- 2
I'm trying to get mathcad to do some simple binary linear calculations for optimization. I can do this easily using excel's solver, but want to learn how to do this in mathcad.
For the dummy problem I'm working on (example out of an old engineering economics textbook), I've got 5 different investment options each of which have a specified Present worth and an initial cost. I'm trying to find the Maximum combined present worth while keeping the initial cost under a given value.
Here is the data:
Option 1: PW1:$4718.79 Cost1: $15000
Option 2: PW2:$2247.04 Cost2: $25000
Option 3: PW3:$92912.88 Cost3: $40000
Option 4: PW4:$1011.69 Cost4: $50000
Option 5: PW5:$7415.24 Cost5: $70000
Cost Max= $100000
Basically I'm trying to do the following.
Maximize PW1*x1 + PW2*x2 + ... + PW5*x5
Subject to Cost1*x1 + Cost2*x2 + ... + Cost5*x5
using xj=(0,1) j=(1..5)
Choosing options 3&4 maximize present worth while keeping cost below cost max.
Could someone help me get Mathcad to tell me this?
For the dummy problem I'm working on (example out of an old engineering economics textbook), I've got 5 different investment options each of which have a specified Present worth and an initial cost. I'm trying to find the Maximum combined present worth while keeping the initial cost under a given value.
Here is the data:
Option 1: PW1:$4718.79 Cost1: $15000
Option 2: PW2:$2247.04 Cost2: $25000
Option 3: PW3:$92912.88 Cost3: $40000
Option 4: PW4:$1011.69 Cost4: $50000
Option 5: PW5:$7415.24 Cost5: $70000
Cost Max= $100000
Basically I'm trying to do the following.
Maximize PW1*x1 + PW2*x2 + ... + PW5*x5
Subject to Cost1*x1 + Cost2*x2 + ... + Cost5*x5
using xj=(0,1) j=(1..5)
Choosing options 3&4 maximize present worth while keeping cost below cost max.
Could someone help me get Mathcad to tell me this?
