Question: please work out in excel with solver! :) A real-estate development film is considering five possible development projects. Using units of millions of dollars, the
please work out in excel with solver! :)
A real-estate development film is considering five possible development projects. Using units of millions of dollars, the following table shows the estimated long-run profit (net present value) that each project would generate, as well as the amount of investment required to undertake the project 1 $22 Development Project 2 3 22.8 22.6 4 21.8 5 2214 Estimated profit (millions) Capital required million) $39 31 29 23 27 The owners of the firm have raised $135 million of investment capital for these projects. They want to select the combination of projects that will maximize their total estimated long-run profit (net present value) without investing more than $135 million a Formulate the model mathematically b. Use Solver to solve for the optimal solution
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
