Question: Include 1 19.Using Solver, which constraints should be used if you have a capital investment budget of $2,500,000, projects A and B are mutually exclusive,

Include 1 19.Using Solver, which constraints should be used if you have a capital investment budget of $2,500,000, projects A and B are mutually exclusive, and project D must be accepted? 1 Project 620 200 352.100 1.245 600 814300 6Total =SUM(B2B55052 5055) 7 Constraint 1 2,500,000 8 Constraint 2 =SUM(D2 D3) 9 Constraint 3 =D5 NPV 72 658 36,418 212,150 70 925 SUM(C2C53052 5056) SUM(O2:05) e) $D$2:$D$5-binary: SBS6 = $B$7; $D$6= 1; and $D$5 = 0 h) SAS2:$A$5 = binary and $B$6 >= $B$7 i) $D$2:$D$5 binary: SBS6 = $B$7; $D$6= 1; and $D$5 = 0 h) SAS2:$A$5 = binary and $B$6 >= $B$7 i) $D$2:$D$5 binary: SBS6
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
