Excel

Insert Discount

Rate Reduction

Here:

Total Approved NPV:

$ $2,077$

Part I: Project Selection

Julie Kavoli, Manager for Project Development at Bluejay Natural Gas, would now like to find the optimal set of project proposals to approve.

The solution should maximize the total NPV from the approved projects. It also must satisfy the constraints imposed by CEO Cordelia Kareeni and the three functional areas:

Capital expenditures over the three years should not exceed $$10$ billion.

Capital expenditures in any single year should not exceed $$4$ billion.

At least one project must be approved for each functional area.

Which projects should be approved? Select all that apply.

Project $1$

Project $2$

Project $3$

Project $4$

Project $5$

Project $6$

Project $7$

Project $8$

Project $9$

Project $10$

Project $11$

Project $12$

$2.$

Question $2$

Manager for Project $1$

Status: $[$object Object$]$

$1$ point

$3.$

Question $3$

Manager for Project $2$

Status: $[$object Object$]$

$1$ point

$4.$

Question $4$

Manager for Project $3$

Status: $[$object Object$]$

$1$ point

$5.$

Question $5$

Manager for Project $4$

Status: $[$object Object$]$

$1$ point

$6.$

Question $6$

Manager for Project $5$

Status: $[$object Object$]$

$1$ point

$7.$

Question $7$

Manager for Project $6$

Status: $[$object Object$]$

$1$ point

$8.$

Question $8$

Manager for Project $7$

Status: $[$object Object$]$

$1$ point

$9.$

Question $9$

Manager for Project $8$

Status: $[$object Object$]$

$1$ point

$10.$

Question $10$

Manager for Project $9$

Status: $[$object Object$]$

$1$ point

$11.$

Question $11$

Manager for Project $10$

Status: $[$object Object$]$

$1$ point

$12.$

Question $12$

Manager for Project $11$

Status: $[$object Object$]$

$1$ point

$13.$

Question $13$

Manager for Project $12$