Projects 2 and 4 are mutually exclusive

QUESTION

Example Data (all in millions)

Number
Investment
PW(25%)

1
$96
$72

2
$117

$21

3
$431

$1,278

4
$146

$213

5
$171

$509

6
$405

$543

7
$178

$401

8
$381

$186

MARR
25%

Other Constraints
Projects 2 and 4 are mutually exclusive

Project 3 cannot be accepted unless Project 8
is accepted

Budget
Take digits of your birthday (MMDD) and
multiply by 1.5
Example:
If your birthday is March 17, the budget is
0317*1.5 = $475.5 million

This
is millions.

If your birthday is October 9, the budget is
1009*1.5 = $1513.5 million

If your birthday is December 31, the budget is
1231*1.5 = $1846.5 million

Answer the following:

1. What is the best portfolio using Solve? Provide
spreadsheet and solution.

2. Can you provide a better portfolio? If yes, do
so.

ANSWER:

REQUEST HELP FROM A TUTOR