The Chief Financial Officer of Eaton Medical Devices has determined that the firm’s capital investment budget will be $5,000,000 for the upcoming year. Unfortunately, this amount is not sufficient to cover all of the positive NPV projects available to the firm
You have been asked to choose which investments, of those listed in the table, should be made.
a. Using the Solver, determine which of the above projects should be included in the budget if the firm’s goal is to maximize shareholder wealth. (Note: Set the Solver to use the Simplex LP method, turn on Use Automatic Scaling, and turn off the Ignore Integer Constraints setting.)
b. Now assume that the CFO has informed you that projects A and B are mutually exclusive, but one of them must be selected. Change your Solver constraints to account for this new information and find the new solution. (Use the same options as in part a.)
c. Ignore the constraints from part b. The CFO has now informed you that Project I is of great strategic importance to the survival of the firm. For this reason it must be accepted. Change your Solver constraints to account for this new information and find the new solution. (Use the same options as in part a.)
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here